First introduction of migrations using golang-migrate

1 files changed, 15 insertions, 0 deletions

diff --git a/migrations/000001_create_datamaps_datamap_line_tables.up.sql b/migrations/000001_create_datamaps_datamap_line_tables.up.sql
new file mode 100644
index 0000000..be96b96
--- /dev/null
+++ b/migrations/000001_create_datamaps_datamap_line_tables.up.sql
@@ -0,0 +1,15 @@
+CREATE TABLE IF NOT EXISTS datamaps (
+  id bigserial PRIMARY KEY,
+  name text,
+  description text,
+  created timestamp(0) with time zone NOT NULL DEFAULT NOW()
+);
+
+CREATE TABLE IF NOT EXISTS datamap_lines (
+  datamap_line_id bigserial PRIMARY KEY,
+  datamap_id bigserial REFERENCES datamaps ON DELETE CASCADE,
+  key text,
+  sheet text,
+  data_type text,
+  cellref text
+);