[PATCH] Bug 3670 Fix capitalization of Item Due Notice

[Nicole Engard]

---
 .../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

--001636ed6f5d8bd8e604746fd949
Content-Type: application/octet-stream; 
	name="0005-Bug-3670-Fix-capitalization-of-Item-Due-Notice.patch"
Content-Disposition: attachment; 
	filename="0005-Bug-3670-Fix-capitalization-of-Item-Due-Notice.patch"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_g01lrc6r0

RnJvbSBlMGNjNmIwMDM2MmUwOGZhZTY4NDY4MGM0NGExM2YyNDkzNjhiMDVjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBOaWNvbGUgRW5nYXJkIDxuZW5nYXJkQGdtYWlsLmNvbT4KRGF0
ZTogV2VkLCAyMyBTZXAgMjAwOSAxMDoyMzowMiAtMDQwMApTdWJqZWN0OiBbUEFUQ0hdIEJ1ZyAz
NjcwIEZpeCBjYXBpdGFsaXphdGlvbiBvZiBJdGVtIER1ZSBOb3RpY2UKQ29udGVudC1UeXBlOiB0
ZXh0L3BsYWluOyBjaGFyc2V0PSJ1dGYtOCIKCi0tLQogLi4uL29wdGlvbmFsL3NhbXBsZV9ub3Rp
Y2VzX21lc3NhZ2VfYXR0cmlidXRlcy5zcWwgfCAgICAyICstCiBpbnN0YWxsZXIvZGF0YS9teXNx
bC91cGRhdGVkYXRhYmFzZS5wbCAgICAgICAgICAgICB8ICAgIDcgKysrKysrKwogMiBmaWxlcyBj
aGFuZ2VkLCA4IGluc2VydGlvbnMoKyksIDEgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvaW5z
dGFsbGVyL2RhdGEvbXlzcWwvZW4vb3B0aW9uYWwvc2FtcGxlX25vdGljZXNfbWVzc2FnZV9hdHRy
aWJ1dGVzLnNxbCBiL2luc3RhbGxlci9kYXRhL215c3FsL2VuL29wdGlvbmFsL3NhbXBsZV9ub3Rp
Y2VzX21lc3NhZ2VfYXR0cmlidXRlcy5zcWwKaW5kZXggNWQxZWNiNi4uODExNzJmYyAxMDA2NDQK
LS0tIGEvaW5zdGFsbGVyL2RhdGEvbXlzcWwvZW4vb3B0aW9uYWwvc2FtcGxlX25vdGljZXNfbWVz
c2FnZV9hdHRyaWJ1dGVzLnNxbAorKysgYi9pbnN0YWxsZXIvZGF0YS9teXNxbC9lbi9vcHRpb25h
bC9zYW1wbGVfbm90aWNlc19tZXNzYWdlX2F0dHJpYnV0ZXMuc3FsCkBAIC0xLDcgKzEsNyBAQAog
aW5zZXJ0IGludG8gYG1lc3NhZ2VfYXR0cmlidXRlc2AKIChgbWVzc2FnZV9hdHRyaWJ1dGVfaWRg
LCBtZXNzYWdlX25hbWUsIGB0YWtlc19kYXlzYCkKIHZhbHVlcwotKDEsICdJdGVtIERVRScsIDAp
LAorKDEsICdJdGVtIER1ZScsIDApLAogKDIsICdBZHZhbmNlIE5vdGljZScsIDEpLAogKDMsICdV
cGNvbWluZyBFdmVudHMnLCAxKSwKICg0LCAnSG9sZCBGaWxsZWQnLCAwKSwKZGlmZiAtLWdpdCBh
L2luc3RhbGxlci9kYXRhL215c3FsL3VwZGF0ZWRhdGFiYXNlLnBsIGIvaW5zdGFsbGVyL2RhdGEv
bXlzcWwvdXBkYXRlZGF0YWJhc2UucGwKaW5kZXggNDFjYWRjYS4uNzIyNDA4YiAxMDA3NTUKLS0t
IGEvaW5zdGFsbGVyL2RhdGEvbXlzcWwvdXBkYXRlZGF0YWJhc2UucGwKKysrIGIvaW5zdGFsbGVy
L2RhdGEvbXlzcWwvdXBkYXRlZGF0YWJhc2UucGwKQEAgLTI2OTUsNiArMjY5NSwxMyBAQCBpZiAo
QzQ6OkNvbnRleHQtPnByZWZlcmVuY2UoIlZlcnNpb24iKSA8IFRyYW5zZm9ybVRvTnVtKCREQnZl
cnNpb24pKSB7CiAJU2V0VmVyc2lvbiAoJERCdmVyc2lvbik7CiB9CiAKKyREQnZlcnNpb24gPSAn
WFhYJzsKK2lmIChDNDo6Q29udGV4dC0+cHJlZmVyZW5jZSgiVmVyc2lvbiIpIDwgVHJhbnNmb3Jt
VG9OdW0oJERCdmVyc2lvbikpIHsKKyAgICAkZGJoLT5kbygiVVBEQVRFIGBtZXNzYWdlX2F0dHJp
YnV0ZXNgIFNFVCBtZXNzYWdlX25hbWU9J0l0ZW0gRHVlJyBXSEVSRSBtZXNzYWdlX2F0dHJpYnV0
ZV9pZD0xIik7CisJcHJpbnQgIlVwZ3JhZGUgdG8gJERCdmVyc2lvbiBkb25lICggZml4IGNhcGl0
YWxpemF0aW9uIGluIG1lc3NhZ2UgdHlwZSApXG4iOworICAgIFNldFZlcnNpb24gKCREQnZlcnNp
b24pOworfQorCiA9aXRlbSBEcm9wQWxsRm9yZWlnbktleXMoJHRhYmxlKQogCiAgIERyb3AgYWxs
IGZvcmVpZ24ga2V5cyBvZiB0aGUgdGFibGUgJHRhYmxlCi0tIAoxLjUuNi41Cgo=
--001636ed6f5d8bd8e604746fd949--