From cbf3c8636645af6b5831a40ff3f75c2fc5cf987f Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 27 Feb 2013 11:02:47 -0500 Subject: [PATCH] Stamping upgrade scripts for Org Unit Proximity Adjustment and Custom Best-Hold Sort Order Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...{XXXX.schema.org_prox_adjust.sql => 0759.schema.org_prox_adjust.sql} | 2 ++ ...st-hold-selection.sql => 0760.schema.custom-best-hold-selection.sql} | 2 ++ 3 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.org_prox_adjust.sql => 0759.schema.org_prox_adjust.sql} (98%) rename Open-ILS/src/sql/Pg/upgrade/{XXYY.schema.custom-best-hold-selection.sql => 0760.schema.custom-best-hold-selection.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 4f84162f23..a686ea55a7 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 ('0758', :eg_version); -- jeff davis / miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0760', :eg_version); -- senator/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_prox_adjust.sql b/Open-ILS/src/sql/Pg/upgrade/0759.schema.org_prox_adjust.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_prox_adjust.sql rename to Open-ILS/src/sql/Pg/upgrade/0759.schema.org_prox_adjust.sql index 43876d80cd..a83a844bad 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.org_prox_adjust.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0759.schema.org_prox_adjust.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0759', :eg_version); + CREATE TABLE actor.org_unit_proximity_adjustment ( id SERIAL PRIMARY KEY, item_circ_lib INT REFERENCES actor.org_unit (id), diff --git a/Open-ILS/src/sql/Pg/upgrade/XXYY.schema.custom-best-hold-selection.sql b/Open-ILS/src/sql/Pg/upgrade/0760.schema.custom-best-hold-selection.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXYY.schema.custom-best-hold-selection.sql rename to Open-ILS/src/sql/Pg/upgrade/0760.schema.custom-best-hold-selection.sql index 55e390682f..3cacb3dfc2 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXYY.schema.custom-best-hold-selection.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0760.schema.custom-best-hold-selection.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0760', :eg_version); + CREATE TABLE config.best_hold_order( id SERIAL PRIMARY KEY, -- (metadata) name TEXT UNIQUE, -- i18n (metadata) -- 2.11.0