[Koha-patches] Bug 3682: change message_attributes.message_name from varchar(20) to varchar(40)

[Katrin Fischer]

 From bf82c3e3ed9fcb5e145fca53a7f9812db6b780f2 Mon Sep 17 00:00:00 2001
From: Katrin Fischer <Katrin.Fischer.83 at web.de>
Date: Fri, 4 Jun 2010 22:06:52 +0200
Subject: [PATCH] Bug 3682: change message_attributes.message_name from 
varchar(20) to varchar(40)
Content-Type: text/plain; charset="utf-8"

---
  installer/data/mysql/kohastructure.sql |    2 +-
  installer/data/mysql/updatedatabase.pl |    7 +++++++
  kohaversion.pl                         |    2 +-
  3 files changed, 9 insertions(+), 2 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql 
b/installer/data/mysql/kohastructure.sql
index db5b372..f09ff11 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -2130,7 +2130,7 @@ CREATE TABLE `message_transport_types` (
  DROP TABLE IF EXISTS `message_attributes`;
  CREATE TABLE `message_attributes` (
    `message_attribute_id` int(11) NOT NULL auto_increment,
-  `message_name` varchar(20) NOT NULL default '',
+  `message_name` varchar(40) NOT NULL default '',
    `takes_days` tinyint(1) NOT NULL default '0',
    PRIMARY KEY  (`message_attribute_id`),
    UNIQUE KEY `message_name` (`message_name`)
diff --git a/installer/data/mysql/updatedatabase.pl 
b/installer/data/mysql/updatedatabase.pl
index 1d90656..6865de2 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -3624,6 +3624,13 @@ INSERT INTO permissions (module_bit, code, 
description) VALUES
      SetVersion ($DBversion);
  }

+$DBversion = '3.01.00.XXX';
+if (C4::Context->preference('Version') < TransformToNum($DBversion)){
+    $dbh->do("ALTER TABLE message_attributes CHANGE message_name 
message_name varchar(40);");
+    print "Upgrade to $DBversion done (bug 3682: change message_name 
from varchar(20) to varchar(40))\n";
+    SetVersion ($DBversion);
+}
+

  =item DropAllForeignKeys($table)

diff --git a/kohaversion.pl b/kohaversion.pl
index 3fa5030..ce483ee 100644
--- a/kohaversion.pl
+++ b/kohaversion.pl
@@ -10,7 +10,7 @@
  use strict;

  sub kohaversion {
-    our $VERSION = '3.01.00.136';
+    our $VERSION = '3.01.00.XXX';
      # version needs to be set this way
      # so that it can be picked up by Makefile.PL
      # during install
-- 
1.6.3.3