src/main/resources/db/schema-changes-0.2-0.3.sql
changeset 98 eac38214183d
child 99 49eb72a46208
--- /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");