|
922
by wagrant
userdb: Add a migration for the change before we moved to migrations. |
1 |
BEGIN; |
2 |
||
3 |
CREATE TABLE subject ( |
|
4 |
subjectid SERIAL PRIMARY KEY NOT NULL, |
|
5 |
subj_code VARCHAR UNIQUE NOT NULL, |
|
6 |
subj_name VARCHAR NOT NULL, |
|
7 |
subj_short_name VARCHAR, -- may be null |
|
8 |
url VARCHAR |
|
9 |
);
|
|
10 |
||
11 |
DELETE FROM offering; |
|
12 |
ALTER TABLE offering DROP COLUMN subj_code; |
|
13 |
ALTER TABLE offering DROP COLUMN subj_name; |
|
14 |
ALTER TABLE offering DROP COLUMN url; |
|
15 |
ALTER TABLE offering ADD COLUMN subject INT4 REFERENCES subject (subjectid) NOT NULL; |
|
16 |
||
17 |
COMMIT; |
|
18 |