From 65f9f8c408bd554beb139f3d5b6ee85bb06372c9 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 29 Mar 2012 13:36:46 -0400 Subject: [PATCH] Stamping upgrade script for currently unfillable holds Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...697.data.place_currently_unfillable_hold.sql | 17 +++++++++++++++++ .../Pg/upgrade/XXXX.place_unfillable_hold.sql | 3 --- Open-ILS/web/opac/locale/en-US/opac.dtd | 2 +- 4 files changed, 19 insertions(+), 5 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0697.data.place_currently_unfillable_hold.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.place_unfillable_hold.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index c2fc9a03ec..ce488be4a0 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 ('0696', :eg_version); -- tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0697', :eg_version); -- tsbere/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0697.data.place_currently_unfillable_hold.sql b/Open-ILS/src/sql/Pg/upgrade/0697.data.place_currently_unfillable_hold.sql new file mode 100644 index 0000000000..9ecad24f8f --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0697.data.place_currently_unfillable_hold.sql @@ -0,0 +1,17 @@ +-- Evergreen DB patch 0697.data.place_currently_unfillable_hold.sql +-- +-- FIXME: insert description of change, if needed +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0697', :eg_version); + +-- FIXME: add/check SQL statements to perform the upgrade +INSERT INTO permission.perm_list ( id, code, description ) VALUES + ( 524, 'PLACE_UNFILLABLE_HOLD', oils_i18n_gettext( 524, + 'Allows a user to place a hold that cannot currently be filled.', 'ppl', 'description' )); + + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.place_unfillable_hold.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.place_unfillable_hold.sql deleted file mode 100644 index 559510efeb..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.place_unfillable_hold.sql +++ /dev/null @@ -1,3 +0,0 @@ -INSERT INTO permission.perm_list ( id, code, description ) VALUES - ( 524, 'PLACE_UNFILLABLE_HOLD', oils_i18n_gettext( 524, - 'Allows a user to place a hold that cannot currently be filled.', 'ppl', 'description' )); diff --git a/Open-ILS/web/opac/locale/en-US/opac.dtd b/Open-ILS/web/opac/locale/en-US/opac.dtd index 6ac79e61e0..9b31b218da 100644 --- a/Open-ILS/web/opac/locale/en-US/opac.dtd +++ b/Open-ILS/web/opac/locale/en-US/opac.dtd @@ -620,7 +620,7 @@ We recommend that you remove this title from any bookbags it may have been added - +