From 917e54c40ee7d85bf58ca6f5805d89d1647efbf4 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Mon, 29 Jan 2018 15:53:54 -0500 Subject: [PATCH] gsheet blobs for mig init directory --- mig-sql/init/010-gsheet_tracked_column.sql | 5 +++++ mig-sql/init/010-gsheet_tracked_table.sql | 10 ++++++++++ 2 files changed, 15 insertions(+), 0 deletions(-) create mode 100644 mig-sql/init/010-gsheet_tracked_column.sql create mode 100644 mig-sql/init/010-gsheet_tracked_table.sql diff --git a/mig-sql/init/010-gsheet_tracked_column.sql b/mig-sql/init/010-gsheet_tracked_column.sql new file mode 100644 index 0000000..08b307d --- /dev/null +++ b/mig-sql/init/010-gsheet_tracked_column.sql @@ -0,0 +1,5 @@ +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 new file mode 100644 index 0000000..7661cc2 --- /dev/null +++ b/mig-sql/init/010-gsheet_tracked_table.sql @@ -0,0 +1,10 @@ +CREATE TABLE gsheet_tracked_table ( + id SERIAL + ,worksheet_name TEXT NOT NULL + ,worksheet_key TEXT + ,table_name TEXT NOT NULL + ,tab_name TEXT + ,created TIMESTAMP + ,last_pulled TIMESTAMP +); + -- 1.7.2.5