TPAC: Wrap "holdable copies" upgrade script

Signed-off-by: Dan Scott <dscott@laurentian.ca>

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 7b86406..b836f97 100644 (file)
--- 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 8212687..e43bd3b 100644 (file)
--- 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;