From 4309de39d4c8be73a9638cf484cd13d4667e8407 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 22 Aug 2013 11:26:20 -0400 Subject: [PATCH] Stamping upgrade script for series title normalizer improvement Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ta.series_normalizer.sql => 0820.data.series_normalizer.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{xxxx.data.series_normalizer.sql => 0820.data.series_normalizer.sql} (92%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 61ea65b3bb..62e2eddb11 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0819', :eg_version); -- phasefx/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0820', :eg_version); -- callender/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql b/Open-ILS/src/sql/Pg/upgrade/0820.data.series_normalizer.sql similarity index 92% rename from Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql rename to Open-ILS/src/sql/Pg/upgrade/0820.data.series_normalizer.sql index 1249a63a29..12e9e1de08 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.data.series_normalizer.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0820.data.series_normalizer.sql @@ -3,7 +3,7 @@ BEGIN; -- Remove [ and ] characters from seriestitle. -- Those characters don't play well when searching. -SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); -- Callender +SELECT evergreen.upgrade_deps_block_check('0820', :eg_version); -- Callender INSERT INTO config.metabib_field_index_norm_map (field,norm,params, pos) SELECT m.id, -- 2.43.2