From 24c16b3d1ff730c79a754cdfb6b8a4761c47f557 Mon Sep 17 00:00:00 2001
From: Mike Rylander <mrylander@gmail.com>
Date: Sat, 16 Jul 2011 08:41:50 -0400
Subject: [PATCH] Stamping upgrade script for "INDB Circ Matrix + Checkout
Overrides Fix"
Signed-off-by: Mike Rylander <mrylander@gmail.com>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
..._overrides.sql => 0579.schema.fix_checkout_overrides.sql} | 12 ++++++++++++
2 files changed, 13 insertions(+), 1 deletion(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fix_checkout_overrides.sql => 0579.schema.fix_checkout_overrides.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 d2d283661d..df635b83a8 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 ('0578', :eg_version); -- tsbere via miker
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0579', :eg_version); -- tsbere via miker
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_checkout_overrides.sql b/Open-ILS/src/sql/Pg/upgrade/0579.schema.fix_checkout_overrides.sql
similarity index 97%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.fix_checkout_overrides.sql
rename to Open-ILS/src/sql/Pg/upgrade/0579.schema.fix_checkout_overrides.sql
index e01a7cb3f8..0584512a68 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.fix_checkout_overrides.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/0579.schema.fix_checkout_overrides.sql
@@ -1,3 +1,12 @@
+-- Evergreen DB patch 0579.schema.fix_checkout_overrides.sql
+--
+--
+BEGIN;
+
+
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('0579', :eg_version);
+
CREATE OR REPLACE FUNCTION action.item_user_circ_test( circ_ou INT, match_item BIGINT, match_user INT, renewal BOOL ) RETURNS SETOF action.circ_matrix_test_result AS $func$
DECLARE
user_object actor.usr%ROWTYPE;
@@ -189,3 +198,6 @@ BEGIN
RETURN;
END;
$func$ LANGUAGE plpgsql;
+
+
+COMMIT;
--
2.11.0