From 547a4d487ea9445751645c4e4a3e8a548352fc9e Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 15 Jul 2011 20:13:21 -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 +- ...t_holds_bib_report.sql => 0578.schema.part_holds_bib_report.sql} | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.part_holds_bib_report.sql => 0578.schema.part_holds_bib_report.sql} (89%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ceb780fe96..da2f0066fb 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 ('0576'); -- phasefx/gmcharlt +INSERT INTO config.upgrade_log (version) VALUES ('0578'); -- 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 89% 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..221b1dc23d 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,7 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0578'); -- tsbere via miker + CREATE OR REPLACE VIEW reporter.hold_request_record AS SELECT id, target, @@ -18,3 +22,5 @@ SELECT id, END AS bib_record FROM action.hold_request ahr; +COMMIT; + -- 2.11.0