67 alter table "project_attachment" add foreign key ("attachment") references "attachment"("id") on delete cascade; |
67 alter table "project_attachment" add foreign key ("attachment") references "attachment"("id") on delete cascade; |
68 alter table "task_attachment" add foreign key ("task") references "task"("id") on delete cascade; |
68 alter table "task_attachment" add foreign key ("task") references "task"("id") on delete cascade; |
69 alter table "task_attachment" add foreign key ("attachment") references "attachment"("id") on delete cascade; |
69 alter table "task_attachment" add foreign key ("attachment") references "attachment"("id") on delete cascade; |
70 alter table "project_attachment" add unique("project","attachment"); |
70 alter table "project_attachment" add unique("project","attachment"); |
71 alter table "task_attachment" add unique("task","attachment"); |
71 alter table "task_attachment" add unique("task","attachment"); |
|
72 |
|
73 -- task number |
|
74 create sequence task_2012; |
|
75 create sequence task_2013; |
|
76 create sequence task_2014; |
|
77 create sequence task_2015; |
|
78 create sequence task_2016; |
|
79 create sequence task_2017; |
|
80 create sequence task_2018; |
|
81 create sequence task_2019; |
|
82 create sequence task_2020; |
|
83 ALTER TABLE task ADD num integer; |
|
84 CREATE VIEW vtask AS SELECT * FROM task ORDER BY id; |
|
85 CREATE RULE rtask AS ON UPDATE TO vtask DO INSTEAD UPDATE task SET num = NEW.num WHERE id = NEW.id; |
|
86 UPDATE vtask SET num = nextval('task_2012'); |
|
87 DROP RULE rtask ON vtask; |
|
88 DROP VIEW vtask; |
|
89 ALTER TABLE task ALTER COLUMN num SET NOT NULL; |