From b5f791d08b4f3b17e1f93e64d6b3555dec27ea16 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 5 Mar 2013 15:13:32 -0500 Subject: [PATCH] Stamping upgrade for truncate-to-max-fine Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 15 +++++++++++++++ ...=> 0763.data.truncate-to-max-fine-setting.sql} | 2 +- 3 files changed, 17 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.truncate-to-max-fine-setting.sql => 0763.data.truncate-to-max-fine-setting.sql} (76%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 377e4b9282..fd33d42d4f 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('0762', :eg_version); -- miker/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0763', :eg_version); -- jeff/miker 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 51d608fbd8..829dafac2f 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -12030,6 +12030,21 @@ INSERT INTO config.org_unit_setting_type 'integer' ); +INSERT INTO config.org_unit_setting_type ( + name, label, grp, datatype +) VALUES ( + 'circ.fines.truncate_to_max_fine', + oils_i18n_gettext( + 'circ.fines.truncate_to_max_fine', + 'Truncate fines to max fine amount', + 'coust', + 'label' + ), + 'circ', + 'bool' +); + + INSERT INTO config.settings_group (name, label) VALUES ( 'url_verify', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.truncate-to-max-fine-setting.sql b/Open-ILS/src/sql/Pg/upgrade/0763.data.truncate-to-max-fine-setting.sql similarity index 76% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.truncate-to-max-fine-setting.sql rename to Open-ILS/src/sql/Pg/upgrade/0763.data.truncate-to-max-fine-setting.sql index f9fd754687..6d04a42b45 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.truncate-to-max-fine-setting.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0763.data.truncate-to-max-fine-setting.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0763', :eg_version); INSERT INTO config.org_unit_setting_type ( name, label, grp, datatype -- 2.43.2