From 4336a9b3c2327970e0dacfc5861fa35668585449 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 16 Jul 2019 11:46:32 -0400 Subject: [PATCH] adding x_migrate flag and changing reference to text for defensive input munging --- mig-sql/system/tlc/030_tlc_mapping_tables.sql | 3 ++- 1 files changed, 2 insertions(+), 1 deletions(-) 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 -- 1.7.2.5