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
index a798009..42244fb 100644 (file)
@@ -1,12 +1,10 @@
 CREATE TABLE gsheet_tracked_table (
     id                          SERIAL PRIMARY KEY
-    ,worksheet_name             TEXT NOT NULL
-    ,worksheet_key              TEXT
     ,table_name                 TEXT NOT NULL
     ,tab_name                   TEXT
     ,created                    TIMESTAMP
     ,last_pulled                TIMESTAMP
     ,last_pushed                TIMESTAMP
-    ,UNIQUE(worksheet_name,tab_name)
+    ,UNIQUE(table_name,tab_name)
 );