From 9f97cd102c179a194a856a69a51f55e84e71144d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 20 Dec 2012 16:48:56 -0500 Subject: [PATCH] Copy 2.3.1-2.3.2 SQL upgrade script into place Signed-off-by: Bill Erickson --- .../Pg/version-upgrade/2.3.1-2.3.2-upgrade-db.sql | 69 ++++++++++++++++++++++ 1 file changed, 69 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.3.1-2.3.2-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.3.1-2.3.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.3.1-2.3.2-upgrade-db.sql new file mode 100644 index 0000000000..106647be48 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.3.1-2.3.2-upgrade-db.sql @@ -0,0 +1,69 @@ +--Upgrade Script for 2.3.1 to 2.3.2 +\set eg_version '''2.3.2''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.3.2', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('0744', :eg_version); + +INSERT INTO config.org_unit_setting_type + (name, grp, label, description, datatype) + VALUES ( + 'circ.lost.xact_open_on_zero', + 'finance', + oils_i18n_gettext( + 'circ.lost.xact_open_on_zero', + 'Leave transaction open when lost balance equals zero', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'circ.lost.xact_open_on_zero', + 'Leave transaction open when lost balance equals zero. This leaves the lost copy on the patron record when it is paid', + 'coust', + 'description' + ), + 'bool' + ); + + +SELECT evergreen.upgrade_deps_block_check('0746', :eg_version); + +ALTER TABLE action.hold_request ALTER COLUMN email_notify SET DEFAULT 'false'; + +-- LP#1091831 - reapply config.update_coded_value_map() +-- due to broken schema version +-- + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0748', :eg_version); + +CREATE OR REPLACE FUNCTION config.update_coded_value_map(in_ctype TEXT, in_code TEXT, in_value TEXT, in_description TEXT DEFAULT NULL, in_opac_visible BOOL DEFAULT NULL, in_search_label TEXT DEFAULT NULL, in_is_simple BOOL DEFAULT NULL, add_only BOOL DEFAULT FALSE) RETURNS VOID AS $f$ +DECLARE + current_row config.coded_value_map%ROWTYPE; +BEGIN + -- Look for a current value + SELECT INTO current_row * FROM config.coded_value_map WHERE ctype = in_ctype AND code = in_code; + -- If we have one.. + IF FOUND AND NOT add_only THEN + -- Update anything we were handed + current_row.value := COALESCE(current_row.value, in_value); + current_row.description := COALESCE(current_row.description, in_description); + current_row.opac_visible := COALESCE(current_row.opac_visible, in_opac_visible); + current_row.search_label := COALESCE(current_row.search_label, in_search_label); + current_row.is_simple := COALESCE(current_row.is_simple, in_is_simple); + UPDATE config.coded_value_map + SET + value = current_row.value, + description = current_row.description, + opac_visible = current_row.opac_visible, + search_label = current_row.search_label, + is_simple = current_row.is_simple + WHERE id = current_row.id; + ELSE + INSERT INTO config.coded_value_map(ctype, code, value, description, opac_visible, search_label, is_simple) VALUES + (in_ctype, in_code, in_value, in_description, COALESCE(in_opac_visible, TRUE), in_search_label, COALESCE(in_is_simple, FALSE)); + END IF; +END; +$f$ LANGUAGE PLPGSQL; + +COMMIT; -- 2.11.0