From b3711d1d18c13519cb7354803b6dbc0b08d1753b Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 30 Jan 2018 09:23:34 -0500 Subject: [PATCH] add unique constraint for worksheet and tab name in ghseet tracked table --- mig-sql/init/010-gsheet_tracked_table.sql | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/mig-sql/init/010-gsheet_tracked_table.sql b/mig-sql/init/010-gsheet_tracked_table.sql index 29404fd..842d320 100644 --- a/mig-sql/init/010-gsheet_tracked_table.sql +++ b/mig-sql/init/010-gsheet_tracked_table.sql @@ -6,5 +6,6 @@ CREATE TABLE gsheet_tracked_table ( ,tab_name TEXT ,created TIMESTAMP ,last_pulled TIMESTAMP + ,UNIQUE(worksheet_name,tab_name) ); -- 1.7.2.5