|
915
by mattgiuca
Moved projectid from all tables using assessedid into the assessed table |
1 |
BEGIN; |
2 |
ALTER TABLE assessed ADD projectid INT4 REFERENCES project (projectid) NOT NULL; |
|
3 |
ALTER TABLE project_extension DROP projectid; |
|
4 |
ALTER TABLE project_submission DROP projectid; |
|
5 |
ALTER TABLE project_mark DROP projectid; |
|
6 |
COMMIT; |