adjusted universal files to no longer need fields from tracked tables that were dropped

[migration-tools.git] / mig-sql / init / 010-gsheet_tracked_table.sql

diff --git a/mig-sql/init/010-gsheet_tracked_table.sql b/mig-sql/init/010-gsheet_tracked_table.sql
index 7661cc2..42244fb 100644 (file)
--- a/mig-sql/init/010-gsheet_tracked_table.sql
+++ b/mig-sql/init/010-gsheet_tracked_table.sql
@@ -1,10 +1,10 @@
 CREATE TABLE gsheet_tracked_table (
-    id                          SERIAL
-    ,worksheet_name             TEXT NOT NULL
-    ,worksheet_key              TEXT
+    id                          SERIAL PRIMARY KEY
     ,table_name                 TEXT NOT NULL
     ,tab_name                   TEXT
     ,created                    TIMESTAMP
     ,last_pulled                TIMESTAMP
+    ,last_pushed                TIMESTAMP
+    ,UNIQUE(table_name,tab_name)
 );