From 8227dd59af80c12740ad51ea076d7e5806b8ff62 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 1 Aug 2012 15:17:59 -0400 Subject: [PATCH] Stamping upgrade script for JEDI with Copies Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....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.43.2