From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 30 Jan 2018 14:23:34 +0000 (-0500)
Subject: add unique constraint for worksheet and tab name in ghseet tracked table
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=b3711d1d18c13519cb7354803b6dbc0b08d1753b

add unique constraint for worksheet and tab name in ghseet tracked table
---

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