From c8253525a3c6d919b36ac142e35c5bb1cf9d1f57 Mon Sep 17 00:00:00 2001 From: Samuel Vanhove Date: Mon, 27 Apr 2015 10:31:43 -0400 Subject: [PATCH] CRM-16176 - Upgrader --- CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl index 3113f5e766..917cec748c 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.alpha1.mysql.tpl @@ -48,3 +48,18 @@ UPDATE civicrm_state_province SET name = 'Northern Ostrobothnia' WHERE name = 'N UPDATE civicrm_option_group SET title = '{ts escape="sql"}Payment Methods{/ts}' WHERE name = 'payment_instrument'; UPDATE civicrm_navigation SET label = '{ts escape="sql"}Payment Methods{/ts}' WHERE name = 'Payment Instruments'; +{if $multilingual} + {foreach from=$locales item=locale} + ALTER TABLE civicrm_relationship_type ADD label_a_b_{$locale} varchar(64); + ALTER TABLE civicrm_relationship_type ADD label_b_a_{$locale} varchar(64); + ALTER TABLE civicrm_relationship_type ADD description_{$locale} varchar(255); + + UPDATE civicrm_relationship_type SET label_a_b_{$locale} = label_a_b; + UPDATE civicrm_relationship_type SET label_b_a_{$locale} = label_b_a; + UPDATE civicrm_relationship_type SET description_{$locale} = description; + {/foreach} + + ALTER TABLE civicrm_relationship_type DROP label_a_b; + ALTER TABLE civicrm_relationship_type DROP label_b_a; + ALTER TABLE civicrm_relationship_type DROP description; +{/if} -- 2.25.1