← Back to branch summary

~azzar1/unity/add-show-desktop-key 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

BEGIN;

ALTER TABLE semester RENAME COLUMN semester TO url_name;
ALTER TABLE semester ADD COLUMN display_name TEXT;
ALTER TABLE semester ADD COLUMN code TEXT;
ALTER TABLE semester ADD CONSTRAINT semester_year_key1
    UNIQUE (year, code);

UPDATE semester SET code = UPPER(url_name);
UPDATE semester SET display_name = 'semester ' || code;

ALTER TABLE semester ALTER COLUMN display_name SET NOT NULL;
ALTER TABLE semester ALTER COLUMN code SET NOT NULL;

COMMIT;