From 144c63df0725add6b672e4707b75648725b64bc6 Mon Sep 17 00:00:00 2001 From: dbs Date: Wed, 2 Mar 2011 02:53:23 +0000 Subject: [PATCH] Add example intervals to some library setting descriptions Based on a patch provided by Michael Peters in Launchpad bug 717308, provide examples of intervals in several descriptions that lacked them. git-svn-id: svn://svn.open-ils.org/ILS/trunk@19558 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 8 ++++---- .../Pg/upgrade/0493.data.interval-descriptions.sql | 21 +++++++++++++++++++++ 3 files changed, 26 insertions(+), 5 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0493.data.interval-descriptions.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 4dd05ab3bf..ee70d368f8 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -70,7 +70,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0492'); -- miker +INSERT INTO config.upgrade_log (version) VALUES ('0493'); -- dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 409656b4bb..ad5dbb2ef8 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -2252,7 +2252,7 @@ INSERT into config.org_unit_setting_type ( 'circ.hold_expire_alert_interval', oils_i18n_gettext('circ.hold_expire_alert_interval', 'Holds: Expire Alert Interval', 'coust', 'label'), - oils_i18n_gettext('circ.hold_expire_alert_interval', 'Amount of time before a hold expires at which point the patron should be alerted', 'coust', 'description'), + oils_i18n_gettext('circ.hold_expire_alert_interval', 'Amount of time before a hold expires at which point the patron should be alerted. Examples: "5 days", "1 hour"', 'coust', 'description'), 'interval'), ( 'circ.hold_expire_interval', @@ -2317,12 +2317,12 @@ INSERT into config.org_unit_setting_type ( 'circ.holds.default_estimated_wait_interval', oils_i18n_gettext('circ.holds.default_estimated_wait_interval', 'Holds: Default Estimated Wait', 'coust', 'label'), - oils_i18n_gettext('circ.holds.default_estimated_wait_interval', 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the default estimated length of time to assume an item will be checked out.', 'coust', 'description'), + oils_i18n_gettext('circ.holds.default_estimated_wait_interval', 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the default estimated length of time to assume an item will be checked out. Examples: "3 weeks", "7 days"', 'coust', 'description'), 'interval'), ( 'circ.holds.min_estimated_wait_interval', oils_i18n_gettext('circ.holds.min_estimated_wait_interval', 'Holds: Minimum Estimated Wait', 'coust', 'label'), - oils_i18n_gettext('circ.holds.min_estimated_wait_interval', 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the minimum estimated length of time to assume an item will be checked out.', 'coust', 'description'), + oils_i18n_gettext('circ.holds.min_estimated_wait_interval', 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the minimum estimated length of time to assume an item will be checked out. Examples: "2 weeks", "5 days"', 'coust', 'description'), 'interval'), ( 'circ.selfcheck.patron_login_timeout', @@ -2462,7 +2462,7 @@ INSERT into config.org_unit_setting_type ( 'circ.hold_shelf_status_delay', oils_i18n_gettext('circ.hold_shelf_status_delay', 'Hold Shelf Status Delay', 'coust', 'label'), - oils_i18n_gettext('circ.hold_shelf_status_delay', 'The purpose is to provide an interval of time after an item goes into the on-holds-shelf status before it appears to patrons that it is actually on the holds shelf. This gives staff time to process the item before it shows as ready-for-pickup.', 'coust', 'description'), + oils_i18n_gettext('circ.hold_shelf_status_delay', 'The purpose is to provide an interval of time after an item goes into the on-holds-shelf status before it appears to patrons that it is actually on the holds shelf. This gives staff time to process the item before it shows as ready-for-pickup. Examples: "5 days", "1 hour"', 'coust', 'description'), 'interval'), ( 'circ.patron_invalid_address_apply_penalty', diff --git a/Open-ILS/src/sql/Pg/upgrade/0493.data.interval-descriptions.sql b/Open-ILS/src/sql/Pg/upgrade/0493.data.interval-descriptions.sql new file mode 100644 index 0000000000..cf4ad79d61 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0493.data.interval-descriptions.sql @@ -0,0 +1,21 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0493'); -- dbs + +UPDATE config.org_unit_setting_type + SET description = 'Amount of time before a hold expires at which point the patron should be alerted. Examples: "5 days", "1 hour"' + WHERE label = 'Holds: Expire Alert Interval'; + +UPDATE config.org_unit_setting_type + SET description = 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the default estimated length of time to assume an item will be checked out. Examples: "3 weeks", "7 days"' + WHERE label = 'Holds: Default Estimated Wait'; + +UPDATE config.org_unit_setting_type + SET description = 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the minimum estimated length of time to assume an item will be checked out. Examples: "1 week", "5 days"' + WHERE label = 'Holds: Minimum Estimated Wait'; + +UPDATE config.org_unit_setting_type + SET description = 'The purpose is to provide an interval of time after an item goes into the on-holds-shelf status before it appears to patrons that it is actually on the holds shelf. This gives staff time to process the item before it shows as ready-for-pickup. Examples: "5 days", "1 hour"' + WHERE label = 'Hold Shelf Status Delay'; + +COMMIT; -- 2.11.0