X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F010-gsheet_tracked_table.sql;h=842d320cd95c2213530a95f4d9a51faae5863dba;hp=7661cc274370aeaaad7065dd72b4400d65427d64;hb=b3711d1d18c13519cb7354803b6dbc0b08d1753b;hpb=917e54c40ee7d85bf58ca6f5805d89d1647efbf4

diff --git a/mig-sql/init/010-gsheet_tracked_table.sql b/mig-sql/init/010-gsheet_tracked_table.sql
index 7661cc2..842d320 100644
--- a/mig-sql/init/010-gsheet_tracked_table.sql
+++ b/mig-sql/init/010-gsheet_tracked_table.sql
@@ -1,10 +1,11 @@
 CREATE TABLE gsheet_tracked_table (
-    id                          SERIAL
+    id                          SERIAL PRIMARY KEY
     ,worksheet_name             TEXT NOT NULL
     ,worksheet_key              TEXT
     ,table_name                 TEXT NOT NULL
     ,tab_name                   TEXT
     ,created                    TIMESTAMP
     ,last_pulled                TIMESTAMP
+    ,UNIQUE(worksheet_name,tab_name)
 );