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