From 429384ac1f7a7904bb23dabe52586db66b30611c Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 9 Aug 2011 13:26:17 -0400 Subject: [PATCH] Stamped upgrade scripts for LP#797409 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql} | 2 +- ..._status_date_changed.sql => 0594.schema.acp_status_date_changed.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql => 0593.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.schema.acp_status_date_changed.sql => 0594.schema.acp_status_date_changed.sql} (94%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 950947e05a..a8c2e9fff3 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 ('0592', :eg_version); -- mrperters-isl/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0594', :eg_version); -- phasefx/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql b/Open-ILS/src/sql/Pg/upgrade/0593.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql rename to Open-ILS/src/sql/Pg/upgrade/0593.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql index 0a68459842..d8a121d6c7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0593.data.org-setting-circ.offline.skip_foo_if_newer_status_changed_time.sql @@ -7,7 +7,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0593', :eg_version); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype ) VALUES ( diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acp_status_date_changed.sql b/Open-ILS/src/sql/Pg/upgrade/0594.schema.acp_status_date_changed.sql similarity index 94% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acp_status_date_changed.sql rename to Open-ILS/src/sql/Pg/upgrade/0594.schema.acp_status_date_changed.sql index 34715d1011..c55abd8d43 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acp_status_date_changed.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0594.schema.acp_status_date_changed.sql @@ -11,7 +11,7 @@ -- upgrade script is doing so much. -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('YYYY', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0594', :eg_version); CREATE OR REPLACE FUNCTION asset.acp_status_changed() RETURNS TRIGGER AS $$ -- 2.11.0