projects
/
migration-tools.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
bugfix to bib loading
[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
);