From de7b7f758220db82107f94a90bd1b1602f45426b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 31 Jul 2012 09:14:40 -0400 Subject: [PATCH] Stamping Encumbrance-only rollover DB upgrade Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...cq-function-dedup.sql => 0730.schema.acq-function-dedup.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.acq-function-dedup.sql => 0730.schema.acq-function-dedup.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 420b9150c6..a6929690a1 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 ('0729', :eg_version); -- tsbere/denials +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0730', :eg_version); -- miker/senator/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-function-dedup.sql b/Open-ILS/src/sql/Pg/upgrade/0730.schema.acq-function-dedup.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-function-dedup.sql rename to Open-ILS/src/sql/Pg/upgrade/0730.schema.acq-function-dedup.sql index 149c1ce23e..932d9845ff 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-function-dedup.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0730.schema.acq-function-dedup.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('XXXX', :eg_version); -- miker +SELECT evergreen.upgrade_deps_block_check('0730', :eg_version); DROP FUNCTION acq.propagate_funds_by_org_tree (INT, INT, INT); DROP FUNCTION acq.propagate_funds_by_org_unit (INT, INT, INT); -- 2.43.2