fixing some tlc maapping table bugs

[migration-tools.git] / mig-sql / system / tlc / 030_tlc_mapping_tables.sql

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index 08418ff..144f7d6 100644 (file)
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -138,10 +138,9 @@ VALUES
 CREATE TABLE map_tlc_phone (
     id                  SERIAL
     ,x_count            TEXT            
+    ,legacy_phone       TEXT
+    ,evergreen_phone    TEXT
     ,note               TEXT
-    ,migrate_available  TEXT
-    ,fill_in_method     TEXT
-    ,static_value       TEXT
 );
 
 INSERT INTO gsheet_tracked_table 
@@ -194,9 +193,11 @@ VALUES
 CREATE TABLE map_tlc_patron_gender (
     id                  SERIAL
     ,x_count            TEXT            
-    ,tlc_block_status   TEXT
-    ,block              TEXT
-    ,bar                TEXT
+    ,gender             TEXT
+    ,stat_cat           TEXT
+    ,stat_cat_entry     TEXT
+    ,show               TEXT
+    ,required           TEXT
     ,dnm                TEXT
     ,note               TEXT
 );
@@ -211,9 +212,11 @@ INSERT INTO gsheet_tracked_column
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'x_count')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'tlc_block_status')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'block')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'bar')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'gender')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'stat_cat_entry')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'show')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'required')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'dnm')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patrons by Gender'),'note')
 ;
@@ -298,11 +301,11 @@ VALUES
 CREATE TABLE map_tlc_patron_note (
     id                  SERIAL
     ,x_count            TEXT            
-    ,legacy_mnote_type  TEXT
-    ,exception          TEXT
+    ,note_type          TEXT
+    ,subset_values      TEXT
+    ,matching_text      TEXT
     ,action             TEXT
     ,note               TEXT
-    ,circulate          TEXT
 );
 
 INSERT INTO gsheet_tracked_table