From 07b9125861c2d57f787f3bd3d598dcbd652b030b Mon Sep 17 00:00:00 2001 From: Nicole Engard Date: Fri, 11 Mar 2011 11:14:49 +0100 Subject: [PATCH] Bug 3670: change 'Item DUE' to 'Item Due' in English dbs Signed-off-by: Julian Maurice Signed-off-by: Chris Cormack --- .../data/mysql/en/optional/sample_notices_message_attributes.sql | 2 +- installer/data/mysql/updatedatabase.pl | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) 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 1834063bec..6dab837258 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 4612a0694e..4a927b2ad5 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -4083,6 +4083,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) -- 2.11.0