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");