add unique constraint for worksheet and tab name in ghseet tracked table
[migration-tools.git] / mig-sql / init / 010-gsheet_tracked_table.sql
1 CREATE TABLE gsheet_tracked_table (
2     id                          SERIAL PRIMARY KEY
3     ,worksheet_name             TEXT NOT NULL
4     ,worksheet_key              TEXT
5     ,table_name                 TEXT NOT NULL
6     ,tab_name                   TEXT
7     ,created                    TIMESTAMP
8     ,last_pulled                TIMESTAMP
9     ,UNIQUE(worksheet_name,tab_name)
10 );
11