Allow bodies to span multiple area IDs, and areas can be covered by more than one body.

1 files changed, 6 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);