First introduction of migrations using golang-migrate

4 files changed, 19 insertions, 0 deletions

diff --git a/migrations/000001_create_datamaps_datamap_line_tables.down.sql b/migrations/000001_create_datamaps_datamap_line_tables.down.sql
new file mode 100644
index 0000000..86f243c
--- /dev/null
+++ b/migrations/000001_create_datamaps_datamap_line_tables.down.sql
@@ -0,0 +1,2 @@
+DROP TABLE IF EXISTS datamaps;
+DROP TABLE IF EXISTS datamap_lines;
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
+);
diff --git a/migrations/dbasik.sql b/resources/dbasik.sql
index b5bb6f9..b5bb6f9 100644
--- a/migrations/dbasik.sql
+++ b/resources/dbasik.sql
diff --git a/migrations/setup.sql b/resources/setup.sql
index 3d95044..dac150f 100644
--- a/migrations/setup.sql
+++ b/resources/setup.sql
@@ -3,4 +3,6 @@ CREATE DATABASE dbasik;
 \c dbasik
 
 CREATE ROLE 'dbasik' WITH LOGIN PASSWORD 'dbasik';
+GRANT ALL PRIVILEGES ON DATABASE 'dbasik' TO 'dbasik';
+ALTER DATABASE 'dbasik' OWNER TO 'dbasik';
 CREATE EXTENSION IF NOT EXISTS citext;