-- ############################################
-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
,x_count TEXT
,holding_code TEXT
,shelving_location TEXT
+ ,org_unit TEXT
,circ_mod TEXT
,alert TEXT
,alert_message TEXT
((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'x_count')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'holding_code')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'shelving_location')
+ ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'org_unit')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'circ_mod')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert')
,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Holdings Code'),'alert_message')