diff -r f6bdff1c40ed -r eac38214183d src/main/resources/db/db-schema.sql --- a/src/main/resources/db/db-schema.sql Thu May 03 22:31:09 2012 +0200 +++ b/src/main/resources/db/db-schema.sql Wed May 09 22:53:03 2012 +0200 @@ -206,6 +206,10 @@ "project" bigint not null, "company" bigint not null ); +create table "project_location" ( + "location" bigint not null, + "project" bigint not null + ); -- foreign key constraints : alter table "address" add foreign key ("city_id") references "city"("id"); alter table "city" add foreign key ("country_id") references "country"("id"); @@ -228,9 +232,12 @@ alter table "user_contact" add foreign key ("contact") references "contact"("id") on delete cascade; alter table "project_company" add foreign key ("project") references "project"("id") on delete cascade; alter table "project_company" add foreign key ("company") references "company"("id") on delete cascade; +alter table "project_location" add foreign key ("project") references "project"("id") on delete cascade; +alter table "project_location" add foreign key ("location") references "location"("id") on delete cascade; -- composite key indexes : alter table "company_contact" add unique("entity","contact"); alter table "user_contact" add unique("entity","contact"); alter table "project_company" add unique("project","company"); +alter table "project_location" add unique("project","location"); -- column group indexes : create index "user_deleted_active_idx" on "user" ("deleted","active");