consolidating tracking tables for gsheet

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

diff --git a/mig-sql/init/010-gsheet_tracked_table.sql b/mig-sql/init/010_gsheet_tracking.sql
similarity index 63%
rename from mig-sql/init/010-gsheet_tracked_table.sql
rename to mig-sql/init/010_gsheet_tracking.sql
index 42244fb..6d740db 100644 (file)
--- a/mig-sql/init/010-gsheet_tracked_table.sql
+++ b/mig-sql/init/010_gsheet_tracking.sql
@@ -5,6 +5,10 @@ CREATE TABLE gsheet_tracked_table (
     ,created                    TIMESTAMP
     ,last_pulled                TIMESTAMP
     ,last_pushed                TIMESTAMP
-    ,UNIQUE(table_name,tab_name)
 );
 
+CREATE TABLE gsheet_tracked_column (
+    id               SERIAL
+    ,table_id        INTEGER REFERENCES gsheet_tracked_table (id)
+    ,column_name     TEXT NOT NULL  
+);