diff options
Diffstat (limited to 'db/schema_0033-body-areas-many-many.sql')
-rw-r--r-- | db/schema_0033-body-areas-many-many.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/db/schema_0033-body-areas-many-many.sql b/db/schema_0033-body-areas-many-many.sql deleted file mode 100644 index e03f3fa44..000000000 --- a/db/schema_0033-body-areas-many-many.sql +++ /dev/null @@ -1,15 +0,0 @@ -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; - |