From 87846cfc29f7aa3de474ee31db41eafd7918fad0 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Tue, 27 Feb 2018 16:29:51 -0500 Subject: [PATCH 1/1] LP#1733695: Stamping upgrade scripts for multilingual search Also, fixed a small typo in the 1094 upgrade script. Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...le_sources.sql => 1092.schema.ingest_multiple_sources.sql} | 2 +- ...language_search.sql => 1093.data.multiple_language_search} | 2 +- ..._search.sql => 1094.reingest.multiple_language_search.sql} | 4 ++-- 4 files changed, 5 insertions(+), 5 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.ingest_multiple_sources.sql => 1092.schema.ingest_multiple_sources.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.multiple_language_search.sql => 1093.data.multiple_language_search} (65%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.reingest.multiple_language_search.sql => 1094.reingest.multiple_language_search.sql} (70%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index b230584993..2a72ffe582 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 ('1091', :eg_version); -- jboyer/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1094', :eg_version); -- miker/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.ingest_multiple_sources.sql b/Open-ILS/src/sql/Pg/upgrade/1092.schema.ingest_multiple_sources.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.ingest_multiple_sources.sql rename to Open-ILS/src/sql/Pg/upgrade/1092.schema.ingest_multiple_sources.sql index f9e4e0964b..79f442e112 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.ingest_multiple_sources.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1092.schema.ingest_multiple_sources.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1092', :eg_version); CREATE OR REPLACE FUNCTION metabib.reingest_record_attributes (rid BIGINT, pattr_list TEXT[] DEFAULT NULL, prmarc TEXT DEFAULT NULL, rdeleted BOOL DEFAULT TRUE) RETURNS VOID AS $func$ DECLARE diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.multiple_language_search.sql b/Open-ILS/src/sql/Pg/upgrade/1093.data.multiple_language_search similarity index 65% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.multiple_language_search.sql rename to Open-ILS/src/sql/Pg/upgrade/1093.data.multiple_language_search index 94e7496a2c..c2712cec88 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.multiple_language_search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1093.data.multiple_language_search @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('YYYY', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1093', :eg_version); UPDATE config.record_attr_definition SET tag = '041', sf_list = 'abdefgm' where name = 'item_lang'; diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.reingest.multiple_language_search.sql b/Open-ILS/src/sql/Pg/upgrade/1094.reingest.multiple_language_search.sql similarity index 70% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.reingest.multiple_language_search.sql rename to Open-ILS/src/sql/Pg/upgrade/1094.reingest.multiple_language_search.sql index 0ea186937f..14fc9bebb0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.reingest.multiple_language_search.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1094.reingest.multiple_language_search.sql @@ -1,9 +1,9 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('ZZZZ', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1094', :eg_version); SELECT metabib.reingest_record_attributes (record, '{item_lang}'::TEXT[]) - FROM (SELECT DINSTINCT record + FROM (SELECT DISTINCT record FROM metabib.real_full_rec WHERE tag = '041' AND subfield IN ('a','b','d','e','f','g','m') -- 2.43.2