[Koha-patches] [PATCH] Bug 3670 Fix capitalization of Item Due Notice

[Nicole Engard]

>From e0cc6b00362e08fae684680c44a13f249368b05c Mon Sep 17 00:00:00 2001
From: Nicole Engard <nengard at gmail.com>
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0005-Bug-3670-Fix-capitalization-of-Item-Due-Notice.patch
Type: application/octet-stream
Size: 1756 bytes
Desc: not available
URL: </pipermail/koha-patches/attachments/20090925/d95c4600/attachment-0001.obj>