From 40b8cebbf765f5c874576b1e8b5c9678a9088bfd Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 2 Mar 2018 16:10:20 -0500 Subject: [PATCH 1/1] adding legacy value column to stat cats table --- mig-sql/system/tlc/030_tlc_mapping_tables.sql | 2 ++ 1 files changed, 2 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 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') -- 1.7.2.5