From: Rogan Hamby <rhamby@esilibrary.com>
Date: Mon, 29 Jan 2018 20:54:13 +0000 (-0500)
Subject: Merge branch 'master' of git.esilibrary.com:migration-tools
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=d19f73d7bf3ebb19a7fd6a54b941f5c21068d90d;hp=27ef2d024e990d181bdfba6f8ec13711ba1463ad

Merge branch 'master' of git.esilibrary.com:migration-tools
---

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
+);
+