From 5d542dcdba53b1087826fbace9df76e90f57ec2b Mon Sep 17 00:00:00 2001 From: Mathieu Lutfy Date: Thu, 1 May 2014 20:23:24 -0400 Subject: [PATCH] CRM-14611: fix 4.5.alpha1 multi-lingual upgrade (civicrm_survey was missing some schema upgrades). --- CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl index 9fdfddd8ad..a2b62b126e 100644 --- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl @@ -354,3 +354,17 @@ ALTER TABLE civicrm_case DELETE FROM civicrm_option_value WHERE option_group_id = @option_group_id_case_type; DELETE FROM civicrm_option_group WHERE id = @option_group_id_case_type; + +-- CRM-14611 +{if $multilingual} + {foreach from=$locales item=locale} + ALTER TABLE civicrm_survey ADD title_{$locale} varchar(255); + UPDATE civicrm_survey SET title_{$locale} = title; + + ALTER TABLE civicrm_survey ADD instructions_{$locale} TEXT; + UPDATE civicrm_survey SET instructions_{$locale} = instructions; + {/foreach} + + ALTER TABLE civicrm_survey DROP title; + ALTER TABLE civicrm_survey DROP instructions; +{/if} -- 2.25.1