From 51e77bd99e9415be1b5dc6df3d8186bf13088cb5 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 16 Feb 2018 16:25:37 -0500 Subject: [PATCH] consolidating tracking tables for gsheet --- mig-sql/init/010-gsheet_tracked_column.sql | 5 ----- mig-sql/init/010-gsheet_tracked_table.sql | 10 ---------- mig-sql/init/010_gsheet_tracking.sql | 14 ++++++++++++++ 3 files changed, 14 insertions(+), 15 deletions(-) delete mode 100644 mig-sql/init/010-gsheet_tracked_column.sql delete mode 100644 mig-sql/init/010-gsheet_tracked_table.sql create mode 100644 mig-sql/init/010_gsheet_tracking.sql 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_tracked_table.sql deleted file mode 100644 index 42244fb..0000000 --- a/mig-sql/init/010-gsheet_tracked_table.sql +++ /dev/null @@ -1,10 +0,0 @@ -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 - ,UNIQUE(table_name,tab_name) -); - diff --git a/mig-sql/init/010_gsheet_tracking.sql b/mig-sql/init/010_gsheet_tracking.sql new file mode 100644 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 +); -- 1.7.2.5