Commit | Line | Data |
---|---|---|
558ccc27 DL |
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 | ||
5a9c4d4a PN |
8 | -- CRM-12127 |
9 | UPDATE civicrm_membership_type cmt | |
1393e47e | 10 | LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cmt.id |
5a9c4d4a PN |
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 | |
1393e47e | 13 | SET |
5a9c4d4a PN |
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} | |
1393e47e | 24 | cpfv.amount = IFNULL(cmt.minimum_fee, 0.00) |
5a9c4d4a | 25 | WHERE cps.is_quick_config = 1 AND cpfv.membership_type_id IS NOT NULL; |