From b8ddd5fdd2cd05616f337a5b7ea9e57f015fe4e8 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 23 Aug 2011 14:32:17 -0400 Subject: [PATCH] master-stamped upgrade script for LP#816131 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rce_order.sql => 0607.schema.oua_force_order.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.oua_force_order.sql => 0607.schema.oua_force_order.sql} (74%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index f4528b62f1..623af3d8b3 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 ('0606', :eg_version); -- phasefx/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0607', :eg_version); -- phasefx/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.oua_force_order.sql b/Open-ILS/src/sql/Pg/upgrade/0607.schema.oua_force_order.sql similarity index 74% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.oua_force_order.sql rename to Open-ILS/src/sql/Pg/upgrade/0607.schema.oua_force_order.sql index 9e146395cd..53905f4db1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.oua_force_order.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0607.schema.oua_force_order.sql @@ -1,3 +1,12 @@ +-- Evergreen DB patch 0607.schema.oua_force_order.sql +-- +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0607', :eg_version); + CREATE OR REPLACE FUNCTION actor.org_unit_ancestors( INT ) RETURNS SETOF actor.org_unit AS $$ WITH RECURSIVE org_unit_ancestors_distance(id, distance) AS ( SELECT $1, 0 @@ -9,3 +18,6 @@ CREATE OR REPLACE FUNCTION actor.org_unit_ancestors( INT ) RETURNS SETOF actor.o SELECT ou.* FROM actor.org_unit ou JOIN org_unit_ancestors_distance ouad USING (id) ORDER BY ouad.distance DESC; $$ LANGUAGE SQL ROWS 1; + + +COMMIT; -- 2.43.2