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));
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
14 cpfv.financial_type_id = cmt.financial_type_id,
16 cpfv.label = cmt.name,
17 cpfv.description = cmt.description,
19 {foreach from=$locales item=locale}
20 cpfv.label_{$locale} = cmt.name_{$locale},
21 cpfv.description_{$locale} = cmt.description_{$locale},
24 cpfv.amount = IFNULL(cmt.minimum_fee, 0.00)
25 WHERE cps.is_quick_config = 1 AND cpfv.membership_type_id IS NOT NULL;