From b8914c02d71a66f151f45d7b1ba07fc6988163a6 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 15 Jul 2011 20:08:35 -0400 Subject: [PATCH] Stamping upgrade script for "Fix part holds in reporter.hold_request_record" Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ..._bib_report.sql => 0578.schema.part_holds_bib_report.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.part_holds_bib_report.sql => 0578.schema.part_holds_bib_report.sql} (78%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7757c97bea..d2d283661d 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 ('0577', :eg_version); -- berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0578', :eg_version); -- tsbere via miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.part_holds_bib_report.sql b/Open-ILS/src/sql/Pg/upgrade/0578.schema.part_holds_bib_report.sql similarity index 78% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.part_holds_bib_report.sql rename to Open-ILS/src/sql/Pg/upgrade/0578.schema.part_holds_bib_report.sql index 763bb0142f..9d4469d8c4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.part_holds_bib_report.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0578.schema.part_holds_bib_report.sql @@ -1,3 +1,13 @@ +-- Evergreen DB patch 0578.schema.part_holds_bib_report.sql +-- +-- Fix part holds in reporter.hold_request_record +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0578', :eg_version); + CREATE OR REPLACE VIEW reporter.hold_request_record AS SELECT id, target, @@ -18,3 +28,5 @@ SELECT id, END AS bib_record FROM action.hold_request ahr; +COMMIT; + -- 2.11.0