diff -r f6bdff1c40ed -r eac38214183d src/main/resources/db/schema-changes-0.2-0.3.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/src/main/resources/db/schema-changes-0.2-0.3.sql Wed May 09 22:53:03 2012 +0200 @@ -0,0 +1,10 @@ +-- DATABASE SCHEMA CHANGES BETWEEN 0.2 -> 0.3 VERSION + +-- project_location +create table "project_location" ( + "location" bigint not null, + "project" bigint not null + ); +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; +alter table "project_location" add unique("project","location");