From 675bf44a644c886467aa59563019b564777d2f51 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 16 Aug 2011 09:04:09 -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 f698180905..9d51a0df49 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 ('0592'); -- mrpeters-isl/miker +INSERT INTO config.upgrade_log (version) VALUES ('0601'); -- 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..ad539be2e2 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); +INSERT INTO config.upgrade_log (version) VALUES ('0600'); 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..9ab83f3af3 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); +INSERT INTO config.upgrade_log (version) VALUES ('0601'); -- 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