From 3bade44241f9c77cf2cc6bffc4bdf78cca1ebbea Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 7 Jul 2011 14:24:45 -0400 Subject: [PATCH] Stamped DB version for hold_pull_list_template w/ parts Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...old_pull_list_template.sql => 0574.data.hold_pull_list_template.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{xxx.data.hold_pull_list_template.sql => 0574.data.hold_pull_list_template.sql} (97%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 67b34933f5..294eb0e055 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0573', :eg_version); -- miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0574', :eg_version); -- berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxx.data.hold_pull_list_template.sql b/Open-ILS/src/sql/Pg/upgrade/0574.data.hold_pull_list_template.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/xxx.data.hold_pull_list_template.sql rename to Open-ILS/src/sql/Pg/upgrade/0574.data.hold_pull_list_template.sql index 32c9460168..a0bea8cf47 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxx.data.hold_pull_list_template.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0574.data.hold_pull_list_template.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('xxxx'); +SELECT evergreen.upgrade_deps_block_check('0574', :eg_version); UPDATE action_trigger.event_definition SET template = $$ -- 2.11.0