|
1822.1.1
by William Grant
Replace semester.semester with semester.{code,url_name,display_name}. |
1 |
BEGIN; |
2 |
||
3 |
ALTER TABLE semester RENAME COLUMN semester TO url_name; |
|
4 |
ALTER TABLE semester ADD COLUMN display_name TEXT; |
|
5 |
ALTER TABLE semester ADD COLUMN code TEXT; |
|
|
1822.1.2
by William Grant
Update schema, add missing UNIQUE constraint, and update sample data. |
6 |
ALTER TABLE semester ADD CONSTRAINT semester_year_key1 |
7 |
UNIQUE (year, code); |
|
|
1822.1.1
by William Grant
Replace semester.semester with semester.{code,url_name,display_name}. |
8 |
|
9 |
UPDATE semester SET code = UPPER(url_name); |
|
10 |
UPDATE semester SET display_name = 'semester ' || code; |
|
11 |
||
12 |
ALTER TABLE semester ALTER COLUMN display_name SET NOT NULL; |
|
13 |
ALTER TABLE semester ALTER COLUMN code SET NOT NULL; |
|
14 |
||
15 |
COMMIT; |