From 5b224b425c038436cd2026e6024e47bc8f65b007 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 16 Aug 2011 09:00:43 -0400 Subject: [PATCH] Stamped upgrades for LP#825303 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...lt_class_lookup.sql => 0600.schema.fix_cat_default_class_lookup.sql} | 2 +- .../{XXXX.fix_aous_lookup.sql => 0601.schema.fix_aous_lookup.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fix_cat_default_class_lookup.sql => 0600.schema.fix_cat_default_class_lookup.sql} (93%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fix_aous_lookup.sql => 0601.schema.fix_aous_lookup.sql} (93%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 896eb6bed2..42619436af 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0599', :eg_version); -- miker/gmc +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0601', :eg_version); -- miker/gmc CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_cat_default_class_lookup.sql b/Open-ILS/src/sql/Pg/upgrade/0600.schema.fix_cat_default_class_lookup.sql similarity index 93% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.fix_cat_default_class_lookup.sql rename to Open-ILS/src/sql/Pg/upgrade/0600.schema.fix_cat_default_class_lookup.sql index 5f52d891a3..418a78fbd6 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_cat_default_class_lookup.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0600.schema.fix_cat_default_class_lookup.sql @@ -7,7 +7,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0600', :eg_version); CREATE OR REPLACE FUNCTION asset.label_normalizer() RETURNS TRIGGER AS $func$ DECLARE diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_aous_lookup.sql b/Open-ILS/src/sql/Pg/upgrade/0601.schema.fix_aous_lookup.sql similarity index 93% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.fix_aous_lookup.sql rename to Open-ILS/src/sql/Pg/upgrade/0601.schema.fix_aous_lookup.sql index dc937be484..3ca2c3b76b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_aous_lookup.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0601.schema.fix_aous_lookup.sql @@ -8,7 +8,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0601', :eg_version); -- FIXME: add/check SQL statements to perform the upgrade CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting( setting_name TEXT, org_id INT ) RETURNS SETOF actor.org_unit_setting AS $$ -- 2.11.0