Something went wrong while fetching comments. Please try again.
Change prerequisites to have integer scale
Compare changes
In this merge request, the prerequisites in the database are changed to not be on a boolean scale, but instead on a [0,1,2] scale. The backend and rest API have been adjusted accordingly.
In order to update the existing database, please use the following script:
ALTER TABLE Prerequisites MODIFY COLUMN ta_training int NOT NULL DEFAULT 0,
MODIFY COLUMN english_test int NOT NULL DEFAULT 0,
ADD COLUMN accepted int NOT NULL DEFAULT 1;
UPDATE Prerequisites SET is_accepted = 1 WHERE is_accepted = 0;
ALTER TABLE Prerequisites DROP COLUMN is_accepted;