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