--- a/src/main/resources/db/schema-changes-0.2-0.3.sql	Tue Jun 05 15:40:44 2012 +0200
+++ b/src/main/resources/db/schema-changes-0.2-0.3.sql	Tue Jun 05 15:40:45 2012 +0200
@@ -87,3 +87,17 @@
 DROP RULE rtask ON vtask;
 DROP VIEW vtask;
 ALTER TABLE task ALTER COLUMN num SET NOT NULL;
+
+-- project extensions
+UPDATE code_list_item SET s1 = 'closed', i1 = 0 WHERE code_list = 'project_state' AND i1 = 1;
+UPDATE code_list_item SET s1 = 'assigned' WHERE code_list = 'project_state' AND name LIKE '%assigned';
+ALTER TABLE project ADD COLUMN phase bigint;
+alter table "project" add foreign key ("phase") references "code_list_item"("id");
+UPDATE project SET phase = (select id from code_list_item where name = 'project.phase.offer');
+ALTER TABLE project ALTER COLUMN phase SET NOT NULL;
+ALTER TABLE project ADD COLUMN "location_a" varchar(1024);
+ALTER TABLE project ADD COLUMN "location_b" varchar(1024);
+UPDATE project SET location_a = '', location_b = '';
+ALTER TABLE project ALTER COLUMN "location_a" SET NOT NULL ;
+ALTER TABLE project ALTER COLUMN "location_b" SET NOT NULL ;
+