adding x_migrate flag and changing reference to text for defensive input munging

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