From 3f74457aedc2a92f2762ee19e25d3617335729eb Mon Sep 17 00:00:00 2001 From: Nicole Engard Date: Tue, 18 Jan 2011 10:33:06 -0500 Subject: [PATCH] Bug 3670: change 'Item DUE' to 'Item Due' in English dbs Content-Type: text/plain; charset="utf-8" --- .../optional/sample_notices_message_attributes.sql | 2 +- installer/data/mysql/updatedatabase.pl | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql index 1834063..6dab837 100644 --- a/installer/data/mysql/en/optional/sample_notices_message_attributes.sql +++ b/installer/data/mysql/en/optional/sample_notices_message_attributes.sql @@ -1,7 +1,7 @@ insert into `message_attributes` (`message_attribute_id`, message_name, `takes_days`) values -(1, 'Item DUE', 0), +(1, 'Item Due', 0), (2, 'Advance Notice', 1), (4, 'Hold Filled', 0), (5, 'Item Check-in', 0), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 5f3310b..0718f7c 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3944,6 +3944,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = 'XXX'; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("UPDATE `message_attributes` SET message_name='Item Due' WHERE message_attribute_id=1 AND message_name LIKE 'Item DUE'"); + print "Upgrade to $DBversion done ( fix capitalization in message type )\n"; + SetVersion ($DBversion); +} + =head1 FUNCTIONS =head2 DropAllForeignKeys($table) -- 1.5.6.5