crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/CRM/Upgrade/Incremental/sql/4.3.beta3.mysql.tpl

   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%';