projects
/
migration-tools.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
first cuts of kmig-*iconv
[migration-tools.git]
/
emig.d
/
sql
/
init
/
010_gsheet_tracking.sql
1
CREATE TABLE gsheet_tracked_table (
2
id SERIAL PRIMARY KEY
3
,sheet_name TEXT NOT NULL
4
,table_name TEXT NOT NULL
5
,tab_name TEXT
6
,created TIMESTAMP
7
,last_pulled TIMESTAMP
8
,last_pushed TIMESTAMP
9
);
10
11
CREATE TABLE gsheet_tracked_column (
12
id SERIAL
13
,table_id INTEGER REFERENCES gsheet_tracked_table (id)
14
,column_name TEXT NOT NULL
15
);