From: Rogan Hamby <rhamby@esilibrary.com>
Date: Fri, 2 Mar 2018 21:10:20 +0000 (-0500)
Subject: adding legacy value column to stat cats table
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=40b8cebbf765f5c874576b1e8b5c9678a9088bfd

adding legacy value column to stat cats table
---

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index d1caa54..bef2599 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -270,6 +270,7 @@ CREATE TABLE map_tlc_stat_cat (
     id                  SERIAL
     ,x_count            TEXT            
     ,tlc_stat_cat       TEXT
+    ,tlc_stat_cat_value TEXT
     ,stat_cat           TEXT
     ,stat_cat_entry     TEXT
     ,show               TEXT
@@ -290,6 +291,7 @@ INSERT INTO gsheet_tracked_column
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'x_count')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'tlc_stat_cat_value')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'stat_cat_entry')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Stat Cats'),'show')