projects
/
migration-tools.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
6d740dbf00d42e73a9f56412bc8d291ee9ea209b
[migration-tools.git]
/
mig-sql
/
init
/
010_gsheet_tracking.sql
1
CREATE TABLE gsheet_tracked_table (
2
id SERIAL PRIMARY KEY
3
,table_name TEXT NOT NULL
4
,tab_name TEXT
5
,created TIMESTAMP
6
,last_pulled TIMESTAMP
7
,last_pushed TIMESTAMP
8
);
9
10
CREATE TABLE gsheet_tracked_column (
11
id SERIAL
12
,table_id INTEGER REFERENCES gsheet_tracked_table (id)
13
,column_name TEXT NOT NULL
14
);