
diff -r 6a2a19785cd8 -r ef29ecada49d src/main/resources/db/db-schema.sql
--- a/src/main/resources/db/db-schema.sql	Tue Jun 05 15:40:44 2012 +0200
+++ b/src/main/resources/db/db-schema.sql	Tue Jun 05 15:40:45 2012 +0200
@@ -175,6 +175,7 @@
 create sequence "attachment_id_seq";
 create table "project" (
     "id" bigint primary key not null,
+    "phase" bigint not null,
     "name" varchar(100) not null,
     "description" varchar(40960) not null,
     "responsible" bigint not null,
@@ -182,6 +183,8 @@
     "ident_s" varchar(256) not null,
     "state" bigint not null,
     "product_line" bigint,
+    "location_a" varchar(1024) not null,
+    "location_b" varchar(1024) not null,
     "note" varchar(10240),
     "created_at" timestamp not null,
     "created_by" bigint,
@@ -266,6 +269,7 @@
 alter table "project" add foreign key ("responsible") references "user"("id");
 alter table "project" add foreign key ("product_line") references "code_list_item"("id") on delete set null;
 alter table "project" add foreign key ("state") references "code_list_item"("id");
+alter table "project" add foreign key ("phase") references "code_list_item"("id");
 alter table "task" add foreign key ("responsible") references "user"("id");
 alter table "task" add foreign key ("task_type") references "code_list_item"("id");
 alter table "task" add foreign key ("state") references "code_list_item"("id");




