aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/dbasik.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/dbasik.sql')
-rw-r--r--migrations/dbasik.sql32
1 files changed, 0 insertions, 32 deletions
diff --git a/migrations/dbasik.sql b/migrations/dbasik.sql
deleted file mode 100644
index b5bb6f9..0000000
--- a/migrations/dbasik.sql
+++ /dev/null
@@ -1,32 +0,0 @@
-CREATE TABLE "datamap" (
- "id" int PRIMARY KEY,
- "name" varchar,
- "description" varchar
-);
-
-CREATE TABLE "datamapline" (
- "id" uuid PRIMARY KEY,
- "datamap_id" uuid,
- "name" string,
- "cellref" string,
- "sheet" string,
- "data_type" string
-);
-
-CREATE TABLE "returnitem" (
- "id" uuid PRIMARY KEY,
- "datamapline_id" uuid,
- "return_id" int,
- "value" string
-);
-
-CREATE TABLE "return" (
- "id" int PRIMARY KEY,
- "name" string
-);
-
-ALTER TABLE "datamapline" ADD FOREIGN KEY ("datamap_id") REFERENCES "datamap" ("id");
-
-ALTER TABLE "returnitem" ADD FOREIGN KEY ("datamapline_id") REFERENCES "datamapline" ("id");
-
-ALTER TABLE "returnitem" ADD FOREIGN KEY ("return_id") REFERENCES "return" ("id");