From 6d890f591bd94668677eb40bcac8d5a62dfb53d9 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 24 May 2019 15:06:24 -0400 Subject: [PATCH] LP1817332 Stamping ugprade: timezone examples Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../1166.data.update_timezone_OUS_description.sql | 16 ++++++++++++++++ .../XXXX.data.update_timezone_OUS_description.sql | 16 ---------------- 3 files changed, 17 insertions(+), 17 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1166.data.update_timezone_OUS_description.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 3b96c9f..f50ff9c 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1165', :eg_version); -- jboyer/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1166', :eg_version); -- remingtron/gmcharlt/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1166.data.update_timezone_OUS_description.sql b/Open-ILS/src/sql/Pg/upgrade/1166.data.update_timezone_OUS_description.sql new file mode 100644 index 0000000..5f79d9a --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1166.data.update_timezone_OUS_description.sql @@ -0,0 +1,16 @@ +BEGIN; + +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'; + +COMMIT; + + 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 deleted file mode 100644 index 60f7931..0000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_timezone_OUS_description.sql +++ /dev/null @@ -1,16 +0,0 @@ -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/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'; - -COMMIT; - - -- 1.7.2.5