From 1fe8de72aee2c77d831906985772637a8298713e Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Wed, 3 Jul 2019 11:49:47 -0400 Subject: [PATCH] Forward-port 3.3.2 upgrade script Signed-off-by: Dan Wells --- .../Pg/version-upgrade/3.3.1-3.3.2-upgrade-db.sql | 48 ++++++++++++++++++++ 1 files changed, 48 insertions(+), 0 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/3.3.1-3.3.2-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.3.1-3.3.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.3.1-3.3.2-upgrade-db.sql new file mode 100644 index 0000000..0046ea0 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.3.1-3.3.2-upgrade-db.sql @@ -0,0 +1,48 @@ +--Upgrade Script for 3.3.1 to 3.3.2 +\set eg_version '''3.3.2''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.3.2', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1164', :eg_version); + +INSERT INTO config.workstation_setting_type + (name, grp, datatype, label) +VALUES ( + 'eg.grid.circ.patron.group_members', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.circ.patron.group_members', + 'Grid Config: circ.patron.group_members', + 'cwst', 'label') +); + + +SELECT evergreen.upgrade_deps_block_check('1165', :eg_version); + +INSERT INTO config.org_unit_setting_type (name,label,grp,description,datatype) +VALUES ('ui.patron.edit.au.dob.example',oils_i18n_gettext('ui.patron.edit.au.dob.example', + 'Example dob field on patron registration', 'coust', 'label'),'gui', + oils_i18n_gettext('ui.patron.edit.au.dob.example', + 'The Example for validation on the dob field in patron registration.', 'coust', 'description'), + 'string'); + + +SELECT evergreen.upgrade_deps_block_check('1166', :eg_version); + +UPDATE config.org_unit_setting_type + SET description = +'Define the time zone in which a library physically resides. Examples: America/Toronto, ' || +'America/Chicago, America/Los_Angeles, America/Vancouver, Europe/Prague. See Wikipedia for a ' || +'complete list ' || +'(Note: Only use "canonical" timezones).' +WHERE name = 'lib.timezone' +AND description = 'Define the time zone in which a library physically resides'; + + + + +SELECT evergreen.upgrade_deps_block_check('1167', :eg_version); + +INSERT INTO config.workstation_setting_type (name,label,grp,datatype) VALUES ('eg.circ.bills.annotatepayment','Bills: Annotate Payment', 'circ', 'bool'); + + +COMMIT; -- 1.7.2.5