diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 7 | ||||
| -rw-r--r-- | db/schema_0033-body-areas-many-many.sql | 15 |
2 files changed, 21 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index 8045ca6c4..fd0a3abd4 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -420,7 +420,6 @@ create table admin_log ( create table body ( id serial primary key, name text not null, - area_id integer not null unique, endpoint text, jurisdiction text, api_key text, @@ -430,3 +429,9 @@ create table body ( suppress_alerts boolean not null default 'f', can_be_devolved boolean not null default 'f' ); + +create table body_areas ( + body_id integer not null references body(id), + area_id integer not null +); +create unique index body_areas_body_id_area_id_idx on body_areas(body_id, area_id); diff --git a/db/schema_0033-body-areas-many-many.sql b/db/schema_0033-body-areas-many-many.sql new file mode 100644 index 000000000..e03f3fa44 --- /dev/null +++ b/db/schema_0033-body-areas-many-many.sql @@ -0,0 +1,15 @@ +begin; + +create table body_areas ( + body_id integer not null references body(id), + area_id integer not null +); +create unique index body_areas_body_id_area_id_idx on body_areas(body_id, area_id); + +INSERT INTO body_areas (body_id, area_id) + SELECT id, area_id FROM body; + +ALTER TABLE body DROP COLUMN area_id; + +commit; + |