From cd873202d14a48219ee6eaa7402c9824176875e2 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 10 Jan 2017 18:06:30 -0500 Subject: [PATCH] Adding post-upgrade file. --- .../pines-post-upgrade-2.9-2.11.sql | 26 ++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.9-2.11.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.9-2.11.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.9-2.11.sql new file mode 100644 index 0000000000..9cbb9125e5 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-upgrade-2.9-2.11.sql @@ -0,0 +1,26 @@ +-- add new hold targeter function/data +BEGIN; + +CREATE OR REPLACE FUNCTION + action.hold_request_regen_copy_maps( + hold_id INTEGER, copy_ids INTEGER[]) RETURNS VOID AS $$ + DELETE FROM action.hold_copy_map WHERE hold = $1; + INSERT INTO action.hold_copy_map (hold, target_copy) SELECT $1, UNNEST($2); +$$ LANGUAGE SQL; + +-- DATA + +INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( + 'circ.holds.retarget_interval', + oils_i18n_gettext( + 'circ.holds.retarget_interval', + 'Holds Retarget Interval', + 'cgf', + 'label' + ), + '24h', + TRUE +); + +COMMIT; + -- 2.11.0