From 7131b3c0557a00e41ef5dcd5960685352d5a6e3f Mon Sep 17 00:00:00 2001 From: Seamus Lee Date: Mon, 6 Jun 2016 11:55:15 +1000 Subject: [PATCH] Add in mulyilingual handiling in upgrade script --- CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl | 17 +++++++++++++---- 1 file changed, 13 insertions(+), 4 deletions(-) diff --git a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl index e553d8fcfc..b149b9e433 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl @@ -55,7 +55,16 @@ VALUES ('civicrm_financial_type', @financial_type_id_md, @option_value_rel_id_dr, @financial_account_id_drmd); --CRM-12252 Add in help_pre and help_post colmns to price field value table -ALTER TABLE `civicrm_price_field_value` -ADD `help_pre` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'; -ALTER TABLE `civicrm_price_field_value` -ADD `help_post` text COLLATE utf8_unicode_ci COMMENT 'Price field option post field help.'; +{if $multilingual} + {foreach from=$locales item=locale} + ALTER TABLE `civicrm_price_field_value` + ADD COLUMN `help_pre_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'; + ALTER TABLE `civicrm_price_field_value` + ADD `help_post_{$locale}` text COLLATE utf8_unicode_ci COMMENT 'Price field option post field help.'; + {/foreach} +{else} + ALTER TABLE `civicrm_price_field_value` + ADD COLUMN `help_pre` text COLLATE utf8_unicode_ci COMMENT 'Price field option pre help text.'; + ALTER TABLE `civicrm_price_field_value` + ADD `help_post` text COLLATE utf8_unicode_ci COMMENT 'Price field option post field help.'; +{/if} -- 2.25.1