| 1 | {include file='../CRM/Upgrade/4.3.beta3.msg_template/civicrm_msg_template.tpl'} |
| 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 |
| 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} |
| 16 | |
| 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'; |
| 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%'; |