From 30edf988192a0498c98f36dfe22eac1042348fcd Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 2 Aug 2011 11:26:19 -0400 Subject: [PATCH] Stamped upgrade script for user/miker/replace_field_fix Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...fault-value.sql => 0588.schema.replace_field-default-value.sql} | 7 +------ 2 files changed, 2 insertions(+), 7 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.replace_field-default-value.sql => 0588.schema.replace_field-default-value.sql} (84%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9b11ed685f..3fd9e180fe 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -57,7 +57,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0587'); -- dbs/berick +INSERT INTO config.upgrade_log (version) VALUES ('0588'); -- miker/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.replace_field-default-value.sql b/Open-ILS/src/sql/Pg/upgrade/0588.schema.replace_field-default-value.sql similarity index 84% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.replace_field-default-value.sql rename to Open-ILS/src/sql/Pg/upgrade/0588.schema.replace_field-default-value.sql index f8e5b28617..77320a42a1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.replace_field-default-value.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0588.schema.replace_field-default-value.sql @@ -1,11 +1,6 @@ --- Evergreen DB patch XXXX.schema.replace_field-default-value.sql --- --- Return the input XML when no replace rule is provided --- BEGIN; --- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +INSERT INTO config.upgrade_log (version) VALUES ('0588'); CREATE OR REPLACE FUNCTION vandelay.replace_field ( target_xml TEXT, source_xml TEXT, field TEXT ) RETURNS TEXT AS $_$ DECLARE -- 2.11.0