Change prerequisites to have integer scale
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;
Edited by Otto Visser