consolidating tracking tables for gsheet

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

diff --git a/mig-sql/init/010_gsheet_tracking.sql b/mig-sql/init/010_gsheet_tracking.sql
new file mode 100644 (file)
index 0000000..6d740db
--- /dev/null
+++ b/mig-sql/init/010_gsheet_tracking.sql
@@ -0,0 +1,14 @@
+CREATE TABLE gsheet_tracked_table (
+    id                          SERIAL PRIMARY KEY
+    ,table_name                 TEXT NOT NULL
+    ,tab_name                   TEXT
+    ,created                    TIMESTAMP
+    ,last_pulled                TIMESTAMP
+    ,last_pushed                TIMESTAMP
+);
+
+CREATE TABLE gsheet_tracked_column (
+    id               SERIAL
+    ,table_id        INTEGER REFERENCES gsheet_tracked_table (id)
+    ,column_name     TEXT NOT NULL  
+);