equal
deleted
inserted
replaced
85 CREATE RULE rtask AS ON UPDATE TO vtask DO INSTEAD UPDATE task SET num = NEW.num WHERE id = NEW.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'); |
86 UPDATE vtask SET num = nextval('task_2012'); |
87 DROP RULE rtask ON vtask; |
87 DROP RULE rtask ON vtask; |
88 DROP VIEW vtask; |
88 DROP VIEW vtask; |
89 ALTER TABLE task ALTER COLUMN num SET NOT NULL; |
89 ALTER TABLE task ALTER COLUMN num SET NOT NULL; |
|
90 |
|
91 -- project extensions |
|
92 UPDATE code_list_item SET s1 = 'closed', i1 = 0 WHERE code_list = 'project_state' AND i1 = 1; |
|
93 UPDATE code_list_item SET s1 = 'assigned' WHERE code_list = 'project_state' AND name LIKE '%assigned'; |
|
94 ALTER TABLE project ADD COLUMN phase bigint; |
|
95 alter table "project" add foreign key ("phase") references "code_list_item"("id"); |
|
96 UPDATE project SET phase = (select id from code_list_item where name = 'project.phase.offer'); |
|
97 ALTER TABLE project ALTER COLUMN phase SET NOT NULL; |
|
98 ALTER TABLE project ADD COLUMN "location_a" varchar(1024); |
|
99 ALTER TABLE project ADD COLUMN "location_b" varchar(1024); |
|
100 UPDATE project SET location_a = '', location_b = ''; |
|
101 ALTER TABLE project ALTER COLUMN "location_a" SET NOT NULL ; |
|
102 ALTER TABLE project ALTER COLUMN "location_b" SET NOT NULL ; |
|
103 |