From 0326e85ccc270ca481abe42ef8ae5d41222ec74c Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 16 Jul 2019 11:38:52 -0400 Subject: [PATCH] expanding columns on map_tlc_holding_code --- mig-sql/system/tlc/030_tlc_mapping_tables.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql index 25dbfef..739642f 100644 --- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql +++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql @@ -245,6 +245,10 @@ CREATE TABLE map_tlc_holding_code ( ,alert_message TEXT ,dnm TEXT ,note TEXT + ,reference BOOLEAN DEFAULT FALSE + ,item_status TEXT + ,stat_cat_title TEXT + ,stat_cat_entry TEXT ); INSERT INTO gsheet_tracked_table -- 1.7.2.5