From e0cc6b00362e08fae684680c44a13f249368b05c Mon Sep 17 00:00:00 2001 From: Nicole Engard Date: Wed, 23 Sep 2009 10:23:02 -0400 Subject: [PATCH] Bug 3670 Fix capitalization of Item Due Notice 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 5d1ecb6..81172fc 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), (3, 'Upcoming Events', 1), (4, 'Hold Filled', 0), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 41cadca..722408b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2695,6 +2695,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"); + print "Upgrade to $DBversion done ( fix capitalization in message type )\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 1.5.6.5