expanding columns on map_tlc_holding_code
authorRogan Hamby <rhamby@esilibrary.com>
Tue, 16 Jul 2019 15:38:52 +0000 (11:38 -0400)
committerRogan Hamby <rhamby@esilibrary.com>
Tue, 16 Jul 2019 15:38:52 +0000 (11:38 -0400)
mig-sql/system/tlc/030_tlc_mapping_tables.sql

index 25dbfef..739642f 100644 (file)
@@ -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