From e5c6a21120694421493d1366d727a5a1ef98eb7a Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 17 Jan 2012 00:25:30 -0500 Subject: [PATCH] adding in DCPL/LEE hold sharing policies --- Open-ILS/src/sql/Pg/pines-2.1-updates.sql | 32 ++++++++++++++++++++++++++++++- 1 file changed, 31 insertions(+), 1 deletion(-) 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 9fac26b047..eb467d42f6 100644 --- a/Open-ILS/src/sql/Pg/pines-2.1-updates.sql +++ b/Open-ILS/src/sql/Pg/pines-2.1-updates.sql @@ -240,7 +240,7 @@ COMMIT; 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', 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 ); @@ -269,3 +269,33 @@ INSERT INTO config.hold_matrix_matchpoint ( active, user_home_ou, request_ou, pi 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; + +-- Adding in the LEE/DCPL hold policies +BEGIN; +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'music'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'audiobook'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'av'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'new-av'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'cd'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'dvd'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'dvd-mid'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'dvd-long'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'video'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'video-mid'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'video-long'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'videogame'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 115, 33, 1, 'videogamelong'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'music'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'audiobook'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'av'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'new-av'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'cd'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'dvd'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'dvd-mid'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'dvd-long'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'video'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'video-mid'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'video-long'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'videogame'); +INSERT INTO config.hold_matrix_matchpoint (active, pickup_ou, item_owning ou, requestor_grp, circ_modifier) VALUES (TRUE, 33, 115, 1, 'videogamelong'); +COMMIT; -- 2.11.0