From: Rogan Hamby <rhamby@esilibrary.com>
Date: Fri, 16 Feb 2018 21:25:37 +0000 (-0500)
Subject: consolidating tracking tables for gsheet
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=51e77bd99e9415be1b5dc6df3d8186bf13088cb5

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