consolidating tracking tables for gsheet

diff --git a/mig-sql/init/010-gsheet_tracked_column.sql b/mig-sql/init/010-gsheet_tracked_column.sql
deleted file mode 100644 (file)
index 08b307d..0000000
--- a/mig-sql/init/010-gsheet_tracked_column.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-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_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  
+);