From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 16 Jul 2019 15:38:52 +0000 (-0400)
Subject: expanding columns on map_tlc_holding_code
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=0326e85ccc270ca481abe42ef8ae5d41222ec74c

expanding columns on map_tlc_holding_code
---

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