From 68b4a665b2e554c80410cac1949ba48e0bc821c9 Mon Sep 17 00:00:00 2001 From: Remington Steed Date: Thu, 21 Feb 2019 14:54:19 -0500 Subject: [PATCH] LP#1817332 Add example to lib.timezone setting description This commit adds a few examples of acceptable lib.timezone values to the setting description, with the goal of using examples of existing Evergreen installations. It also includes a clickable link to the extensive list on Wikipedia. Since the settings editor is displayed within an iframe, the link needs a "target" to successfully trigger. Signed-off-by: Remington Steed Signed-off-by: Galen Charlton Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 5 ++++- .../XXXX.data.update_timezone_OUS_description.sql | 15 +++++++++++++++ 2 files changed, 19 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 7e76891eff..ea97a5b54e 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -17494,7 +17494,10 @@ INSERT into config.org_unit_setting_type 'Library time zone', 'coust', 'label'), oils_i18n_gettext('lib.timezone', - 'Define the time zone in which a library physically resides', + 'Define the time zone in which a library physically resides. Examples: America/Toronto, ' || + 'America/Chicago, America/Denver, America/Vancouver, Europe/Prague. See Wikipedia for a ' || + 'complete list ' || + '(Note: Only use "canonical" timezones).', 'coust', 'description'), 'string'); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql new file mode 100644 index 0000000000..a5e46a3efb --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql @@ -0,0 +1,15 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :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/Denver, America/Vancouver, Europe/Prague. See Wikipedia for a ' || +'complete list ' || +'(Note: Only use "canonical" timezones).' + WHERE name = 'lib.timezone'; + +COMMIT; + + -- 2.43.2