src/main/resources/db/schema-changes-0.2-0.3.sql
changeset 98 eac38214183d
child 99 49eb72a46208
equal deleted inserted replaced
97:f6bdff1c40ed 98:eac38214183d
       
     1 -- DATABASE SCHEMA CHANGES BETWEEN 0.2 -> 0.3 VERSION
       
     2 
       
     3 -- project_location
       
     4 create table "project_location" (
       
     5     "location" bigint not null,
       
     6     "project" bigint not null
       
     7   );
       
     8 alter table "project_location" add foreign key ("project") references "project"("id") on delete cascade;
       
     9 alter table "project_location" add foreign key ("location") references "location"("id") on delete cascade;
       
    10 alter table "project_location" add unique("project","location");