From d46585ed0e2816cd641242bfb292f0869f01950c Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 19 Apr 2013 16:19:11 -0400 Subject: [PATCH] Stamping best-hold-order update script Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...onal-approx.sql => 0793.data.best-hold-order-traditional-approx.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.best-hold-order-traditional-approx.sql => 0793.data.best-hold-order-traditional-approx.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 b9068db060..5a955d4866 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0791', :eg_version); -- senator/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0793', :eg_version); -- senator/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.best-hold-order-traditional-approx.sql b/Open-ILS/src/sql/Pg/upgrade/0793.data.best-hold-order-traditional-approx.sql similarity index 94% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.best-hold-order-traditional-approx.sql rename to Open-ILS/src/sql/Pg/upgrade/0793.data.best-hold-order-traditional-approx.sql index ddd525d551..01db9973cf 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.best-hold-order-traditional-approx.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0793.data.best-hold-order-traditional-approx.sql @@ -1,6 +1,6 @@ BEGIN; --- INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); +SELECT evergreen.upgrade_deps_block_check('0792', :eg_version); UPDATE config.best_hold_order SET -- 2.11.0