+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
+ (table_name,tab_name,created)
+VALUES
+ ('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
+ (table_name,tab_name,created)
+VALUES
+ ('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
+ (table_name,tab_name,created)
+VALUES
+ ('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_desired_shelf 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
(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_desired_shelf')
+ ,((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 = '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
+ (table_name,tab_name,created)
+VALUES
+ ('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')
+;
+
+