aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/000001_create_datamaps_datamap_line_tables.up.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--migrations/000001_create_datamaps_datamap_line_tables.up.sql15
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
+);