From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 29 Jan 2018 20:53:54 +0000 (-0500)
Subject: gsheet blobs for mig init directory
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=917e54c40ee7d85bf58ca6f5805d89d1647efbf4;hp=6ade3d523bfdfe7add008ebe0a0e6d494edac88c

gsheet blobs for mig init directory
---

diff --git a/mig-sql/init/010-gsheet_tracked_column.sql b/mig-sql/init/010-gsheet_tracked_column.sql
new file mode 100644
index 0000000..08b307d
--- /dev/null
+++ b/mig-sql/init/010-gsheet_tracked_column.sql
@@ -0,0 +1,5 @@
+CREATE TABLE gsheet_tracked_column (
+    id               SERIAL
+    ,table_id        INTEGER REFERENCES gsheet_tracked_table (id)
+    ,column_name     TEXT NOT NULL  
+);
diff --git a/mig-sql/init/010-gsheet_tracked_table.sql b/mig-sql/init/010-gsheet_tracked_table.sql
new file mode 100644
index 0000000..7661cc2
--- /dev/null
+++ b/mig-sql/init/010-gsheet_tracked_table.sql
@@ -0,0 +1,10 @@
+CREATE TABLE gsheet_tracked_table (
+    id                          SERIAL
+    ,worksheet_name             TEXT NOT NULL
+    ,worksheet_key              TEXT
+    ,table_name                 TEXT NOT NULL
+    ,tab_name                   TEXT
+    ,created                    TIMESTAMP
+    ,last_pulled                TIMESTAMP
+);
+