|
1104
by William Grant
Replace Semester.active with Semester.state, allowing more useful state |
1 |
BEGIN; |
2 |
DROP TRIGGER deactivate_semester_enrolments ON semester; |
|
3 |
DROP FUNCTION deactivate_semester_enrolments_update(); |
|
4 |
DROP TRIGGER confirm_active_semester ON enrolment; |
|
5 |
DROP FUNCTION confirm_active_semester_insertupdate(); |
|
6 |
||
7 |
ALTER TABLE semester ADD COLUMN state TEXT NOT NULL DEFAULT 'current'; |
|
8 |
ALTER TABLE semester ADD CONSTRAINT semester_state_check CHECK (state IN ('disabled', 'past', 'current', 'future')); |
|
9 |
UPDATE semester SET state='past' WHERE active='false'; |
|
10 |
ALTER TABLE semester DROP COLUMN active; |
|
11 |
COMMIT; |