From 8227dd59af80c12740ad51ea076d7e5806b8ff62 Mon Sep 17 00:00:00 2001
From: Mike Rylander <mrylander@gmail.com>
Date: Wed, 1 Aug 2012 15:17:59 -0400
Subject: [PATCH] Stamping upgrade script for JEDI with Copies
Signed-off-by: Mike Rylander <mrylander@gmail.com>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
...XXX.data.jedi_with_copies.sql => 0733.data.jedi_with_copies.sql} | 6 +++++-
2 files changed, 6 insertions(+), 2 deletions(-)
rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.jedi_with_copies.sql => 0733.data.jedi_with_copies.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 2188d80887..7b86406b38 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -87,7 +87,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 ('0732', :eg_version); -- berick/senator
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0733', :eg_version); -- berick/miker
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.jedi_with_copies.sql b/Open-ILS/src/sql/Pg/upgrade/0733.data.jedi_with_copies.sql
similarity index 98%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.jedi_with_copies.sql
rename to Open-ILS/src/sql/Pg/upgrade/0733.data.jedi_with_copies.sql
index 21552a2b5e..99ec8bc304 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.jedi_with_copies.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/0733.data.jedi_with_copies.sql
@@ -7,6 +7,10 @@
-- updating. No env fields are removed (that aren't otherwise replaced).
--
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('0732', :eg_version);
+
UPDATE action_trigger.event_definition SET template =
$$[%- USE date -%]
[%# start JEDI document
@@ -179,5 +183,5 @@ BEGIN
END $$;
-
+COMMIT;
--
2.11.0