From 69f39ece703614d9439c9c1dc738f32aacb6f804 Mon Sep 17 00:00:00 2001 From: yashodha Date: Tue, 5 Apr 2016 14:18:10 +0530 Subject: [PATCH] CRM-18241:multi-lingual upgrade fix ---------------------------------------- * 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 | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl index f3b0df6b47..301ccd6185 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl @@ -24,4 +24,10 @@ 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 +{if $multilingual} + {foreach from=$locales item=loc} + ALTER TABLE civicrm_option_value CHANGE label_{$loc} label_{$loc} varchar( 512 ) DEFAULT NULL ; + {/foreach} +{else} + ALTER TABLE civicrm_option_value CHANGE label label varchar( 512 ) DEFAULT NULL ; +{/if} \ No newline at end of file -- 2.25.1