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=8d19ad098c58762dcf274e6ae9bd44a52c4e892a;hp=d35650829a28477f280aa3857674580f725069e6;hb=7722d81c31b9036d91a174621404b134f4e25893;hpb=2d416d5e39c1f6a1b32876cf66512f99817d7ee3

diff --git a/mig-sql/system/tlc/030_tlc_mapping_tables.sql b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
index d356508..8d19ad0 100644
--- a/mig-sql/system/tlc/030_tlc_mapping_tables.sql
+++ b/mig-sql/system/tlc/030_tlc_mapping_tables.sql
@@ -135,31 +135,6 @@ VALUES
 
 -- ############################################
 
-CREATE TABLE map_tlc_phone (
-    id                  SERIAL
-    ,x_count            TEXT            
-    ,legacy_phone       TEXT
-    ,evergreen_phone    TEXT
-    ,note               TEXT
-);
-
-INSERT INTO gsheet_tracked_table 
-    (table_name,tab_name,created)
-VALUES 
-    ('map_tlc_phone','Patron Phone Numbers',NOW())
-;
-
-INSERT INTO gsheet_tracked_column 
-    (table_id,column_name) 
-VALUES 
-     ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'x_count')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'legacy_phone')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'evergreen_phone')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Phone Numbers'),'note')
-;
-
--- ############################################
-
 CREATE TABLE map_tlc_block_status (
     id                  SERIAL
     ,x_count            TEXT