From 14504ab4e9f534776ab373c9bd69938fa97a5392 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Sat, 16 Jul 2011 10:25:44 -0400 Subject: [PATCH] Stamping upgrade script for "Opac Renewal at original circ library" Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...c_lib.sql => 0581.schema.opac_renewal_reuse_circ_lib.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.opac_renewal_reuse_circ_lib.sql => 0581.schema.opac_renewal_reuse_circ_lib.sql} (65%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 5adb85517f..da9bebb4b0 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 ('0580', :eg_version); -- tsbere via miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0581', :eg_version); -- tsbere via miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.opac_renewal_reuse_circ_lib.sql b/Open-ILS/src/sql/Pg/upgrade/0581.schema.opac_renewal_reuse_circ_lib.sql similarity index 65% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.opac_renewal_reuse_circ_lib.sql rename to Open-ILS/src/sql/Pg/upgrade/0581.schema.opac_renewal_reuse_circ_lib.sql index 92f859293b..d05998efce 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.opac_renewal_reuse_circ_lib.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0581.schema.opac_renewal_reuse_circ_lib.sql @@ -1,3 +1,12 @@ +-- Evergreen DB patch 0581.schema.opac_renewal_reuse_circ_lib.sql +-- +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0581', :eg_version); + INSERT INTO config.global_flag (name, label, enabled) VALUES ( 'circ.opac_renewal.use_original_circ_lib', @@ -9,3 +18,6 @@ INSERT INTO config.global_flag (name, label, enabled) ), FALSE ); + + +COMMIT; -- 2.11.0