From 599bcc3b039db43edbf49350cbcde8d52f64880c Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Fri, 30 Mar 2012 14:07:03 -0400 Subject: [PATCH] Stamping default pickup library upgrade script Signed-off-by: Thomas Berezansky --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/0698.hold_default_pickup.sql | 14 ++++++++++++++ Open-ILS/src/sql/Pg/upgrade/XXXX.hold_default_pickup.sql | 2 -- 3 files changed, 15 insertions(+), 3 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0698.hold_default_pickup.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.hold_default_pickup.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ce488be4a0..1c62469a38 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 ('0697', :eg_version); -- tsbere/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0698', :eg_version); -- tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0698.hold_default_pickup.sql b/Open-ILS/src/sql/Pg/upgrade/0698.hold_default_pickup.sql new file mode 100644 index 0000000000..ba8b80dab7 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0698.hold_default_pickup.sql @@ -0,0 +1,14 @@ +-- Evergreen DB patch 0698.hold_default_pickup.sql +-- +-- FIXME: insert description of change, if needed +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0698', :eg_version); + +INSERT INTO config.usr_setting_type (name,opac_visible,label,description,datatype) + VALUES ('opac.default_pickup_location', TRUE, 'Default Hold Pickup Location', 'Default location for holds pickup', 'integer'); + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.hold_default_pickup.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.hold_default_pickup.sql deleted file mode 100644 index 67200e8bc0..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.hold_default_pickup.sql +++ /dev/null @@ -1,2 +0,0 @@ -INSERT INTO config.usr_setting_type (name,opac_visible,label,description,datatype) - VALUES ('opac.default_pickup_location', TRUE, 'Default Hold Pickup Location', 'Default location for holds pickup', 'integer'); -- 2.11.0