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

   1 -- CRM-12151
   2 ALTER TABLE civicrm_option_value
   3   DROP INDEX index_option_group_id_value,
   4   ADD INDEX index_option_group_id_value (value(128), option_group_id),
   5   DROP INDEX index_option_group_id_name,
   6   ADD INDEX index_option_group_id_name (option_group_id, name(128));
   7
   8 -- CRM-12127
   9 UPDATE civicrm_membership_type cmt
  10 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cmt.id
  11 LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id
  12 LEFT JOIN civicrm_price_set cps ON cps.id = cpf.price_set_id
  13 SET
  14 cpfv.financial_type_id = cmt.financial_type_id,
  15 {if !$multilingual}
  16   cpfv.label = cmt.name,
  17   cpfv.description = cmt.description,
  18 {else}
  19   {foreach from=$locales item=locale}
  20     cpfv.label_{$locale} = cmt.name_{$locale},
  21     cpfv.description_{$locale} = cmt.description_{$locale},
  22   {/foreach}
  23 {/if}
  24 cpfv.amount = IFNULL(cmt.minimum_fee, 0.00)
  25 WHERE cps.is_quick_config = 1 AND cpfv.membership_type_id IS NOT NULL;