From b42fa9068868c55b744cf9141627955ea90773d4 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 11 Mar 2013 17:40:11 -0400 Subject: [PATCH 1/1] Stamping upgrade for relaxing rank_ou sorting Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...X.schema.relax_rank_ou.sql => 0768.schema.relax_rank_ou.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.relax_rank_ou.sql => 0768.schema.relax_rank_ou.sql} (92%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ea34dd52cb..9ad2ba51f7 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('0767', :eg_version); -- senator/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0768', :eg_version); -- berick/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.relax_rank_ou.sql b/Open-ILS/src/sql/Pg/upgrade/0768.schema.relax_rank_ou.sql similarity index 92% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.relax_rank_ou.sql rename to Open-ILS/src/sql/Pg/upgrade/0768.schema.relax_rank_ou.sql index 626d40b869..afb2d8a04c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.relax_rank_ou.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0768.schema.relax_rank_ou.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0768', :eg_version); + CREATE OR REPLACE FUNCTION evergreen.rank_ou(lib INT, search_lib INT, pref_lib INT DEFAULT NULL) RETURNS INTEGER AS $$ SELECT COALESCE( -- 2.43.2