projects
/
migration-tools.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
made loadbibs able to load any table
[migration-tools.git]
/
mig-sql
/
init
/
000-tracked_column.sql
1
DROP TABLE IF EXISTS tracked_column;
2
CREATE TABLE tracked_column (
3
id serial
4
,base_filename TEXT
5
,parent_table TEXT
6
,staged_table TEXT
7
,staged_column TEXT
8
,comment TEXT
9
,target_table TEXT
10
,target_column TEXT
11
,transform TEXT
12
,summarize BOOLEAN
13
);
14
CREATE INDEX ON tracked_column(target_table,target_column);
15
CREATE INDEX ON tracked_column(base_filename);