projects
/
migration-tools.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
adding x_migrate flag and changing reference to text for defensive input munging
[migration-tools.git]
/
mig-sql
/
system
/
tlc
/
030_tlc_mapping_tables.sql
diff --git
a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index
739642f
..
210cc73
100644
(file)
--- a/
mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/
mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@
-245,10
+245,11
@@
CREATE TABLE map_tlc_holding_code (
,alert_message TEXT
,dnm TEXT
,note TEXT
- ,reference BOOLEAN DEFAULT FALSE
+ ,reference TEXT
,item_status TEXT
,stat_cat_title TEXT
,stat_cat_entry TEXT
+ ,x_migrate TEXT
);
INSERT INTO gsheet_tracked_table