From d153502f9b2b89b364742a41c0fbe9313c544ec9 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 27 Jul 2012 09:29:35 -0400 Subject: [PATCH] stamp upgrade script for lp1028514 Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...901_regex.sql => 0724.schema.fix_maintain_901_regex.sql} | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.fix_maintain_901_regex.sql => 0724.schema.fix_maintain_901_regex.sql} (95%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7a4801847d..a834191ad5 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,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 ('0723', :eg_version); -- denials/senator +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0724', :eg_version); -- denials/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_maintain_901_regex.sql b/Open-ILS/src/sql/Pg/upgrade/0724.schema.fix_maintain_901_regex.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_maintain_901_regex.sql rename to Open-ILS/src/sql/Pg/upgrade/0724.schema.fix_maintain_901_regex.sql index 334caebf62..ddf17d8b76 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_maintain_901_regex.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0724.schema.fix_maintain_901_regex.sql @@ -1,3 +1,7 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0724', :eg_version); -- denials/gmcharlt + CREATE OR REPLACE FUNCTION evergreen.maintain_901 () RETURNS TRIGGER AS $func$ use strict; use MARC::Record; @@ -97,3 +101,5 @@ $_TD->{new}{marc} = $xml; return "MODIFY"; $func$ LANGUAGE PLPERLU; + +COMMIT; -- 2.43.2