From 59ccff56b61ba4bfeea682129847dd0742be00b1 Mon Sep 17 00:00:00 2001
From: Pradeep Nayak <pradpnayak@gmail.com>
Date: Mon, 15 May 2017 06:55:11 +0530
Subject: [PATCH] CRM-20576, changed length of civicrm_batch.title to 255

----------------------------------------
* CRM-20576: Increase length of civicrm_batch.title
  https://issues.civicrm.org/jira/browse/CRM-20576
---
 CRM/Batch/DAO/Batch.php                      | 6 +++---
 CRM/Upgrade/Incremental/sql/4.7.20.mysql.tpl | 9 +++++++++
 xml/schema/Batch/Batch.xml                   | 2 +-
 3 files changed, 13 insertions(+), 4 deletions(-)

diff --git a/CRM/Batch/DAO/Batch.php b/CRM/Batch/DAO/Batch.php
index d3396caf92..9adce55180 100644
--- a/CRM/Batch/DAO/Batch.php
+++ b/CRM/Batch/DAO/Batch.php
@@ -30,7 +30,7 @@
  *
  * Generated from xml/schema/CRM/Batch/Batch.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:f1b35f9cc4e12f1d4c2b026aacca7e50)
+ * (GenCodeChecksum:a9d49cd47b4a388ca88aa2af363f952d)
  */
 require_once 'CRM/Core/DAO.php';
 require_once 'CRM/Utils/Type.php';
@@ -213,8 +213,8 @@ class CRM_Batch_DAO_Batch extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_STRING,
           'title' => ts('Batch Title') ,
           'description' => 'Friendly Name.',
-          'maxlength' => 64,
-          'size' => CRM_Utils_Type::BIG,
+          'maxlength' => 255,
+          'size' => CRM_Utils_Type::HUGE,
           'table_name' => 'civicrm_batch',
           'entity' => 'Batch',
           'bao' => 'CRM_Batch_BAO_Batch',
diff --git a/CRM/Upgrade/Incremental/sql/4.7.20.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.20.mysql.tpl
index 307ad1b882..c9205fd5aa 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.20.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.20.mysql.tpl
@@ -1 +1,10 @@
 {* file to handle db changes in 4.7.20 during upgrade *}
+
+-- CRM-20576
+{if $multilingual}
+  {foreach from=$locales item=locale}
+    ALTER TABLE civicrm_batch CHANGE title_{$locale} title_{$locale} varchar(255);
+  {/foreach}
+{else}
+  ALTER TABLE civicrm_batch CHANGE title title varchar(255);
+{/if}
diff --git a/xml/schema/Batch/Batch.xml b/xml/schema/Batch/Batch.xml
index 449c6c1bc4..24fdbf4f61 100644
--- a/xml/schema/Batch/Batch.xml
+++ b/xml/schema/Batch/Batch.xml
@@ -48,7 +48,7 @@
     <name>title</name>
     <title>Batch Title</title>
     <type>varchar</type>
-    <length>64</length>
+    <length>255</length>
     <localizable>true</localizable>
     <comment>Friendly Name.</comment>
     <add>4.2</add>
-- 
2.25.1