| changeset 98 | eac38214183d |
| child 99 | 49eb72a46208 |
| 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"); |