aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema_0033-body-areas-many-many.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema_0033-body-areas-many-many.sql')
-rw-r--r--db/schema_0033-body-areas-many-many.sql15
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;
-