From e69391d4f309f6268440632585bbddf3a2a5bd60 Mon Sep 17 00:00:00 2001
From: Matthew Lemon <y@yulqen.org>
Date: Wed, 10 Apr 2024 19:33:21 +0100
Subject: First introduction of migrations using golang-migrate

---
 migrations/dbasik.sql | 32 --------------------------------
 1 file changed, 32 deletions(-)
 delete mode 100644 migrations/dbasik.sql

(limited to 'migrations/dbasik.sql')

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");
-- 
cgit v1.2.3

