From ac81c185f4002400f94d82e1d6af054590812f93 Mon Sep 17 00:00:00 2001
From: yashodha <yashodha.chaku@webaccessglobal.com>
Date: Fri, 1 Apr 2016 11:18:27 +0530
Subject: [PATCH] CRM-18241: Change field length of civicrm_option_value.label
 from 255 to 512

----------------------------------------
* CRM-18241: Change field length of civicrm_option_value.label from 255 to 512
  https://issues.civicrm.org/jira/browse/CRM-18241
---
 CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl | 5 ++++-
 xml/schema/Core/OptionValue.xml             | 2 +-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl
index 1023eb3b96..d746eabda9 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl
@@ -17,8 +17,11 @@ SET
   nav2.has_separator = 1,
   nav2.label = 'Extensions';
 
---CRM-18327 filter value missed on the contact deleted by merge activity --
+-- CRM-18327 filter value missed on the contact deleted by merge activity --
 UPDATE civicrm_option_value ov
 LEFT JOIN civicrm_option_group og ON og.id = ov.option_group_id
 SET filter = 1
 WHERE ov.name = 'Contact Deleted by Merge' AND og.name = 'activity_type'
+
+-- CRM-18241 Change field length of civicrm_option_value.label from 255 to 512 --
+ALTER TABLE civicrm_option_value CHANGE label label varchar( 512 ) DEFAULT NULL ;
\ No newline at end of file
diff --git a/xml/schema/Core/OptionValue.xml b/xml/schema/Core/OptionValue.xml
index 31d7fc20c3..bfc1a6da6d 100644
--- a/xml/schema/Core/OptionValue.xml
+++ b/xml/schema/Core/OptionValue.xml
@@ -46,7 +46,7 @@
     <title>Option Label</title>
     <type>varchar</type>
     <required>true</required>
-    <length>255</length>
+    <length>512</length>
     <localizable>true</localizable>
     <comment>Option string as displayed to users - e.g. the label in an HTML OPTION tag.</comment>
     <add>1.5</add>
-- 
2.25.1