From f511f5c8c70edfc322bc234a40be3b06b1c912a1 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 13 Dec 2011 13:14:29 -0500 Subject: [PATCH] adding circ and hold policies; correcting typos --- Open-ILS/src/sql/Pg/pines-2.1-updates.sql | 123 ++++++++++++++++++++++-------- 1 file changed, 91 insertions(+), 32 deletions(-) diff --git a/Open-ILS/src/sql/Pg/pines-2.1-updates.sql b/Open-ILS/src/sql/Pg/pines-2.1-updates.sql index 9700e5a78d..b5b39cc9a0 100644 --- a/Open-ILS/src/sql/Pg/pines-2.1-updates.sql +++ b/Open-ILS/src/sql/Pg/pines-2.1-updates.sql @@ -1,38 +1,38 @@ -- insert the PINES org_unit_settings that have been created in test environment BEGIN; -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.margin', $$0$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.height', $$9$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.width', $$8$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.family', $$"monospace"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.size', $$10$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.weight', $$"normal"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.default_classification_scheme', $$"2"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.dob.require', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.registration.require_address', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.default_country', $$"USA"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.default_ident_type', $$"1"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.staff.require_initials', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.alert_message.show', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.alias.show', $$false$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.barred.show', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.dob.calendar', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.claims_returned_count.show', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.bib.delete_on_no_copy_via_acq_lineitem_cancel', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.checkout_fills_related_hold', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.holds.expired_patron_block', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.block_renews_for_holds', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.holds.uncancel.reset_request_time', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.patron_invalid_address_apply_penalty', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.obscure_dob', $$false$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.circ.show_billing_tab_on_bills', $$true$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.email.example', $$"address@example.com"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.evening_phone.example', $$"XXX-XXX-XXXX"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.day_phone.example', $$"XXX-XXX-XXXX"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.other_phone.example', $$"XXX-XXX-XXXX"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.email.regex', $$"[^@<> ]+@[^@<> ]+\\.[^@.*<> ]{2,}"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.phone.regex', $$"\\d{3}-\\d{3}-\\d{4}"$$ ); -INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.aua.post_code.regex', $$"\\d{5}(-\\d{4})?"$$ ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.margin', '0' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.height', '9' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.spine.line.width', '8' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.family', 'monospace' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.size', '10' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.label.font.weight', 'normal' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.default_classification_scheme', '2' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.dob.require', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.registration.require_address', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.default_country', 'USA' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.default_ident_type', '1' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.staff.require_initials', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.alert_message.show', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.alias.show', 'false' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.barred.show', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.dob.calendar', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.claims_returned_count.show', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'cat.bib.delete_on_no_copy_via_acq_lineitem_cancel', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.checkout_fills_related_hold', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.holds.expired_patron_block', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.block_renews_for_holds', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.holds.uncancel.reset_request_time', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.patron_invalid_address_apply_penalty', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'circ.obscure_dob', 'false' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.circ.show_billing_tab_on_bills', 'true' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.email.example', 'address@example.com' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.evening_phone.example', 'XXX-XXX-XXXX' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.day_phone.example', 'XXX-XXX-XXXX' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.other_phone.example', 'XXX-XXX-XXXX' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.au.email.regex', '[^@<> ]+@[^@<> ]+\\.[^@.*<> ]{2,}' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.phone.regex', '\\d{3}-\\d{3}-\\d{4}' ); +INSERT INTO actor.org_unit_setting (org_unit, name, value) VALUES ( 1, 'ui.patron.edit.aua.post_code.regex', '\\d{5}(-\\d{4})?' ); COMMIT; -- insert the new permission groups and assign them their perms. @@ -215,3 +215,62 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ( 51, ( INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES ( 51, ( SELECT id FROM permission.perm_list WHERE CODE = 'VIEW_REPORT_OUTPUT' ), 0, 'f' ); COMMIT; + +-- add more circ rules... + +BEGIN; + +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 1, 'book', NULL, NULL, NULL, f, NULL, NULL, NULL, NULL, NULL, 6, 1, NULL, NULL, NULL, NULL, NULL, 66, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 1, 'book', NULL, NULL, NULL, t, NULL, NULL, NULL, NULL, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, 66, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 1, 'dvd', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 231, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 1, 'video', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 231, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 22, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 1, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, 3, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 260, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 80, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 6, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 216, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 33, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 275, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 'f', 106, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 140, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 231, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); +INSERT INTO config.circ_matrix_matchpoint ( active, org_unit, grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, is_renewal, user_age_lower_bound, user_age_upper_bound, juvenile_flag, circulate, duration_rule, recurring_fine_rule, max_fine_rule, script_test ) VALUES ( 't', 197, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); + +COMMIT; + +-- add hold policies + +BEGIN; + +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'f', NULL, NULL, 't', 'f', NULL, 50, 't', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'i', NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'g', NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, 'j', NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'audiobook', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'av', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'new-av', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'cd', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'dvd', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'dvd-long', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'dvd-mid', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'atlas', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'kit', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'magazine', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'music', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'record', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'microform', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'equip-long', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'equipment', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'video', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'video-long', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'video-mid', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'videogame', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'videogamelong', NULL, NULL, NULL, 'f', NULL, NULL, 't', 't', 2, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, 66, NULL, 1, NULL, NULL, NULL, NULL, 't', NULL, NULL, 'f', 'f', NULL, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 'f', 1, NULL, NULL, NULL, NULL, NULL, 1, 'eventpass', NULL, NULL, NULL, 'f', NULL, NULL, 'f', 't', 3, NULL, 'f', 'f', 'f', NULL ); +INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pickup_ou, item_owning_ou, item_circ_ou, usr_grp, requestor_grp, circ_modifier, marc_type, marc_form, marc_vr_format, ref_flag, juvenile_flag, age_hold_protect_rule, holdable, distance_is_from_owner, transit_range, max_holds, include_frozen_holds, stop_blocked_user, strict_ou_match, marc_bib_level ) VALUES ( 't', 1, NULL, NULL, NULL, NULL, NULL, 1, 'bestsellernh', NULL, NULL, NULL, 'f', NULL, NULL, 'f', 't', 3, NULL, 'f', 'f', 'f', NULL ); + +COMMIT; -- 2.11.0