From 001ef6a6b0f4da8ea5a3606c415a9bbfe0a6a9d8 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 22 Mar 2012 12:53:13 -0400 Subject: [PATCH] Wrap upgrade script for CSV circ history export Thanks, Bill! Signed-off-by: Dan Scott --- ...port_csv.sql => 0688.data.circ_history_export_csv.sql} | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.circ_history_export_csv.sql => 0688.data.circ_history_export_csv.sql} (82%) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_history_export_csv.sql b/Open-ILS/src/sql/Pg/upgrade/0688.data.circ_history_export_csv.sql similarity index 82% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_history_export_csv.sql rename to Open-ILS/src/sql/Pg/upgrade/0688.data.circ_history_export_csv.sql index 47cad2cdb5..25e451bb8c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.circ_history_export_csv.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0688.data.circ_history_export_csv.sql @@ -1,6 +1,12 @@ - +-- Evergreen DB patch 0688.data.circ_history_export_csv.sql +-- +-- FIXME: insert description of change, if needed +-- BEGIN; +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0688', :eg_version); + INSERT INTO action_trigger.hook (key, core_type, description, passive) VALUES ( 'circ.format.history.csv', @@ -46,10 +52,3 @@ INSERT INTO action_trigger.environment (event_def, path) ); COMMIT; - -/* UNDO -DELETE FROM action_trigger.event WHERE event_def = ( - SELECT id FROM action_trigger.event_definition WHERE hook = 'circ.format.history.csv'); -DELETE FROM action_trigger.event_definition WHERE hook = 'circ.format.history.csv'); -DELETE FROM action_trigger.hook WHERE key = 'circ.format.history.csv'; -*/ -- 2.11.0