X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;fp=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;h=210cc736c35b5a46eca416caba9abaa1c2f79cc5;hp=739642f894c2f44214c09ddac76a532b8393564d;hb=4336a9b3c2327970e0dacfc5861fa35668585449;hpb=0326e85ccc270ca481abe42ef8ae5d41222ec74c

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
--- 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