From 78093899b33f07e0f0882d65ef5966d2deee523c Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 25 Oct 2022 11:51:04 -0400 Subject: [PATCH] LP#1931737: Stamping upgrade scripts Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...pdate_and_reify.sql => 1340.schema.dym_update_and_reify.sql} | 2 ++ ....dym_delayed_reify.sql => 1341.schema.dym_delayed_reify.sql} | 2 ++ 3 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{WWWW.schema.dym_update_and_reify.sql => 1340.schema.dym_update_and_reify.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.dym_delayed_reify.sql => 1341.schema.dym_delayed_reify.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 151f63fd05..c7278104d8 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 ('1339', :eg_version); -- khuckins/sandbergja/mmorgan +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1341', :eg_version); -- miker/sandbergja/dyrcona/blake CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/WWWW.schema.dym_update_and_reify.sql b/Open-ILS/src/sql/Pg/upgrade/1340.schema.dym_update_and_reify.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/WWWW.schema.dym_update_and_reify.sql rename to Open-ILS/src/sql/Pg/upgrade/1340.schema.dym_update_and_reify.sql index 8ff177232d..33f2e1f100 100644 --- a/Open-ILS/src/sql/Pg/upgrade/WWWW.schema.dym_update_and_reify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1340.schema.dym_update_and_reify.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1340', :eg_version); + -- INSERT-only table that catches dictionary updates to be reconciled CREATE UNLOGGED TABLE search.symspell_dictionary_updates ( transaction_id BIGINT, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.dym_delayed_reify.sql b/Open-ILS/src/sql/Pg/upgrade/1341.schema.dym_delayed_reify.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.dym_delayed_reify.sql rename to Open-ILS/src/sql/Pg/upgrade/1341.schema.dym_delayed_reify.sql index 5401162322..39fc9f625a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.dym_delayed_reify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1341.schema.dym_delayed_reify.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1340', :eg_version); + CREATE OR REPLACE FUNCTION search.disable_symspell_reification () RETURNS VOID AS $f$ INSERT INTO config.internal_flag (name,enabled) VALUES ('ingest.disable_symspell_reification',TRUE) -- 2.43.2