From f58ad303473a992b11cbefe704dafd1a8eb03ae3 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Wed, 1 Aug 2012 16:54:32 -0400 Subject: [PATCH] TPAC: Wrap "holdable copies" upgrade script Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...{XXXX.tpac_holdable_check.sql => 0734.tpac_holdable_check.sql} | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.tpac_holdable_check.sql => 0734.tpac_holdable_check.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7b86406b38..b836f97114 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,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 ('0733', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0734', :eg_version); -- tsbere/denials CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_holdable_check.sql b/Open-ILS/src/sql/Pg/upgrade/0734.tpac_holdable_check.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_holdable_check.sql rename to Open-ILS/src/sql/Pg/upgrade/0734.tpac_holdable_check.sql index 8212687ded..e43bd3b35b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.tpac_holdable_check.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0734.tpac_holdable_check.sql @@ -1,3 +1,10 @@ +-- Evergreen DB patch 0734.tpac_holdable_check.sql +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0734', :eg_version); + CREATE OR REPLACE FUNCTION asset.record_has_holdable_copy ( rid BIGINT ) RETURNS BOOL AS $f$ BEGIN PERFORM 1 @@ -135,3 +142,4 @@ RETURNS XML AS $F$ ); $F$ LANGUAGE SQL STABLE; +COMMIT; -- 2.11.0