From 722e91ea874551fd00856241d3083da23fffd534 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Fri, 16 Dec 2011 14:00:24 -0500 Subject: [PATCH] LP# 902667 - Wrap upgrade script for Dewey sorting Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...{xxxx.dewey-sort-fix.sql => 0658.schema.acn_dewey_sort_fix.sql} | 7 ++++++- 2 files changed, 7 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{xxxx.dewey-sort-fix.sql => 0658.schema.acn_dewey_sort_fix.sql} (83%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 15a1cae9ae..1573edb5d0 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0657', :eg_version); -- berick/tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0658', :eg_version); -- jamesrf/dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.dewey-sort-fix.sql b/Open-ILS/src/sql/Pg/upgrade/0658.schema.acn_dewey_sort_fix.sql similarity index 83% rename from Open-ILS/src/sql/Pg/upgrade/xxxx.dewey-sort-fix.sql rename to Open-ILS/src/sql/Pg/upgrade/0658.schema.acn_dewey_sort_fix.sql index 310bb2f16e..21ca1e2a4b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.dewey-sort-fix.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0658.schema.acn_dewey_sort_fix.sql @@ -1,6 +1,11 @@ +-- Evergreen DB patch 0658.schema.acn_dewey_sort_fix.sql +-- +-- Fixes Dewey call number sorting (per LP# 902667) +-- BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('xxxx'); +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0658', :eg_version); CREATE OR REPLACE FUNCTION asset.label_normalizer_dewey(TEXT) RETURNS TEXT AS $func$ # Derived from the Koha C4::ClassSortRoutine::Dewey module -- 2.11.0