X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F010_gsheet_tracking.sql;fp=mig-sql%2Finit%2F010-gsheet_tracked_table.sql;h=6d740dbf00d42e73a9f56412bc8d291ee9ea209b;hp=42244fbe03fcea048a42ac9f7d17264943580b54;hb=51e77bd99e9415be1b5dc6df3d8186bf13088cb5;hpb=7b6f5557a05fa7e4cd09f433398ea4f6368ae519

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