CREATE TABLE map_hold_policies ( l_user_home_ou TEXT ,l_request_ou TEXT ,l_item_owning_ou TEXT ,l_item_circ_ou TEXT ,l_requestor_grp TEXT ,l_circ_modifier TEXT ,l_active TEXT ,l_holdable TEXT ,l_max_holds TEXT ,l_includes_frozen_holds TEXT ,l_distance_is_from_owner TEXT ,l_transit_range TEXT ,l_usr_grp TEXT ,x_user_home_ou INTEGER ,x_request_ou INTEGER ,x_item_owning_ou INTEGER ,x_item_circ_ou INTEGER ,x_requestor_grp INTEGER ,x_circ_modifier TEXT ,x_active BOOLEAN ,x_holdable BOOLEAN ,x_max_holds INTEGER ,x_includes_frozen_holds BOOLEAN ,x_distance_is_from_owner BOOLEAN ,x_transit_range INTEGER ,x_usr_grp INTEGER ,x_migrate BOOLEAN DEFAULT TRUE ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_hold_policies','Hold Policies',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_user_home_ou') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_request_ou') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_owning_ou') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_circ_ou') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_requestor_grp') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_circ_modifier') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_active') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_holdable') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_max_holds') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_includes_frozen_holds') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_distance_is_from_owner') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_transit_range') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_usr_grp') ; CREATE TABLE map_circ_policies ( l_org_unit TEXT ,l_user_group TEXT ,l_copy_owning_lib TEXT ,l_user_home_lib TEXT ,l_circ_mod TEXT ,l_copy_location TEXT ,l_circulate TEXT ,l_circ_limit_set TEXT ,l_duration_rule TEXT ,l_fine_rule TEXT ,l_grace_override TEXT ,l_max_fine TEXT ,l_notes TEXT ,x_org_unit INTEGER ,x_user_group INTEGER ,x_copy_owning_lib INTEGER ,x_user_home_lib INTEGER ,x_circ_mod TEXT ,x_copy_location INTEGER ,x_circulate BOOLEAN ,x_circ_limit_set INTEGER ,x_duration_rule INTEGER ,x_fine_rule INTEGER ,x_grace_override INTERVAL ,x_max_fine INTEGER ,x_circ_limit_quantity INTEGER ,x_circ_limit_parts INTEGER ,x_circ_limit_ou_name TEXT ,x_circ_limit_ou_id INTEGER ,x_circ_limit_id INTEGER ,x_migrate BOOLEAN DEFAULT FALSE ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_circ_policies','Circ Policies',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes') ; CREATE TABLE map_circ_limit_sets ( l_owning_lib TEXT ,l_name TEXT ,l_items_out TEXT ,l_depth TEXT ,l_global TEXT ,l_description TEXT ,l_circ_mod TEXT ,l_copy_loc TEXT ,x_owning_lib INTEGER ,x_name TEXT ,x_items_out INTEGER ,x_global BOOLEAN ,x_depth INTEGER ,x_description TEXT ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_circ_limit_sets','Circ Limit Sets',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc') ; CREATE TABLE map_create_shelving_location ( l_id SERIAL ,l_owning_lib TEXT ,l_copy_location TEXT ,l_opac_visible TEXT ,l_checkin_alert TEXT ,l_holdable TEXT ,l_circulate TEXT ,l_note TEXT ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE ,x_shelf INTEGER ) INHERITS (asset_copy_location); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_create_shelving_location','New Copy Locations',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_circulate') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_note') ; CREATE TABLE map_create_account ( l_id SERIAL ,l_barcode TEXT ,l_usrname TEXT ,l_first_name TEXT ,l_family_name TEXT ,l_email TEXT ,l_password TEXT ,l_home_library TEXT ,l_profile1 TEXT ,l_profile2 TEXT ,l_profile3 TEXT ,l_work_ou1 TEXT ,l_work_ou2 TEXT ,l_work_ou3 TEXT ,l_work_ou4 TEXT ,l_work_ou5 TEXT ,l_work_ou6 TEXT ,l_work_ou7 TEXT ,l_work_ou8 TEXT ,l_work_ou9 TEXT ,l_work_ou10 TEXT ,l_work_ou11 TEXT ,l_work_ou12 TEXT ,l_work_ou13 TEXT ,l_note TEXT ,x_migrate BOOLEAN NOT NULL DEFAULT TRUE ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_create_account','New Accounts',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_usrname') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_barcode') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_first_name') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_family_name') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_email') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_password') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_home_library') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile1') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile2') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_profile3') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou1') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou2') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou3') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou4') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou5') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou6') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou7') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou8') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou9') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou10') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou11') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou12') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_work_ou13') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Accounts'),'l_note') ; CREATE TABLE map_threshold ( id SERIAL ,library TEXT ,profile TEXT ,checkout_threshold TEXT ,fine_threshold TEXT ,overdue_threshold TEXT ,note TEXT ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_threshold','Patron Thresholds',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'library') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'note') ; CREATE TABLE map_misc ( id SERIAL ,count TEXT ,option TEXT ,choice TEXT ,value TEXT ,note TEXT ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_misc','Miscellaneous Options',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'count') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'option') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'Choice') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'value') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Miscellaneous Options'),'note') ; CREATE TABLE map_org_setting ( l_id SERIAL ,l_name TEXT ,l_label TEXT ,l_entry_type TEXT ,l_org_unit TEXT ,l_value TEXT ,l_note TEXT ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_org_setting','Org Settings',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_name') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_label') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_entry_type') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_org_unit') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note') ; CREATE TABLE map_bib_manipulations ( id SERIAL ,action TEXT ,field TEXT ,subfield TEXT ,matching_value TEXT ,target_value TEXT ,note TEXT ); INSERT INTO gsheet_tracked_table (sheet_name,table_name,tab_name,created) VALUES ((SELECT SPLIT_PART(reset_val,',',1) FROM pg_settings WHERE name = 'search_path'),'map_bib_manipulations','Bib Records',NOW()) ; INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note') ;