From 3078e8424d7e99eaa732b8015fc577f84a7d1a14 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Sat, 16 Jul 2011 08:44:25 -0400 Subject: [PATCH] Stamping upgrade script for "INDB Circ Matrix + Checkout Overrides Fix" Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...eckout_overrides.sql => 0579.schema.fix_checkout_overrides.sql} | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fix_checkout_overrides.sql => 0579.schema.fix_checkout_overrides.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index da2f0066fb..34feeaaed1 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -57,7 +57,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0578'); -- tsbere via miker +INSERT INTO config.upgrade_log (version) VALUES ('0579'); -- 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 98% 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..80953fede7 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,7 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0579'); -- tsbere via miker + 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 +193,6 @@ BEGIN RETURN; END; $func$ LANGUAGE plpgsql; + +COMMIT; + -- 2.11.0