Commit | Line | Data |
---|---|---|
1a9f6d0d | 1 | {include file='../CRM/Upgrade/4.3.beta3.msg_template/civicrm_msg_template.tpl'} |
fefdef95 PN |
2 | -- CRM-12077 |
3 | DELETE cog, cov FROM `civicrm_option_group` cog | |
4 | LEFT JOIN civicrm_option_value cov ON cov.option_group_id = cog.id | |
df1f662a PN |
5 | WHERE cog.name = 'account_type'; |
6 | ||
7 | {if $multilingual} | |
8 | UPDATE civicrm_uf_field | |
9 | SET field_name = 'financial_type' | |
10 | WHERE field_name LIKE 'contribution_type'; | |
11 | {foreach from=$locales item=locale} | |
12 | UPDATE civicrm_uf_field | |
13 | SET label_{$locale} = 'Financial Type' | |
14 | WHERE field_name = 'financial_type' AND label_{$locale} = 'Contribution Type'; | |
15 | {/foreach} | |
10824d34 | 16 | |
df1f662a PN |
17 | {else} |
18 | UPDATE civicrm_uf_field | |
19 | SET field_name = 'financial_type', | |
20 | label = CASE | |
21 | WHEN label = 'Contribution Type' | |
22 | THEN 'Financial Type' | |
23 | ELSE label | |
24 | END | |
25 | WHERE field_name = 'contribution_type'; | |
d20145bc PN |
26 | {/if} |
27 | ||
28 | -- CRM-12065 | |
29 | UPDATE `civicrm_mapping_field` | |
30 | SET name = replace(name, 'contribution_type', 'financial_type') | |
31 | where name LIKE '%contribution_type%'; |