X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Fsystem%2Ftlc%2F030_tlc_mapping_tables.sql;h=9fddeafefbee755c779f5bd2a141c9b225cc9aa5;hp=d1caa54d8c5dcfaa2330b8e9270d2be6d494c323;hb=709fe65478a6acded9bab3f66fa1283ab619d62b;hpb=af66e5408e31e25bc6fed62b99cc39be95d480ef

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index d1caa54..9fddeaf 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -113,6 +113,7 @@ VALUES
 CREATE TABLE map_tlc_billing_type (
     id                  SERIAL
     ,x_count            TEXT            
+    ,tlc_code           TEXT
     ,billing_type       TEXT
     ,dnm                TEXT
     ,note               TEXT
@@ -128,6 +129,7 @@ INSERT INTO gsheet_tracked_column
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'x_count')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'tlc_code')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'billing_type')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'dnm')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Migrating Bills by Bill Type'),'note')
@@ -270,6 +272,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 +293,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')