CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl

   1 -- CRM-12142
   2 {if !$multilingual}
   3   ALTER TABLE `civicrm_premiums`
   4     ADD COLUMN premiums_nothankyou_label varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Label displayed for No Thank-you
   5  option in premiums block (e.g. No thank you)';
   6 {/if}
   7
   8 -- Also need to populate default text for premiums_nothankyou_label
   9 UPDATE `civicrm_premiums` SET {localize field='premiums_nothankyou_label'}premiums_nothankyou_label{/localize} = {localize}'{ts escape="sql"}No thank-you{/ts}'{/localize};
  10
  11 -- CRM-12151
  12 ALTER TABLE civicrm_option_value
  13   DROP INDEX index_option_group_id_value,
  14   ADD INDEX index_option_group_id_value (value(128), option_group_id),
  15   DROP INDEX index_option_group_id_name,
  16   ADD INDEX index_option_group_id_name (option_group_id, name(128));
  17
  18 -- CRM-12127
  19 UPDATE civicrm_membership_type cmt
  20 LEFT JOIN civicrm_price_field_value cpfv ON cpfv.membership_type_id = cmt.id
  21 LEFT JOIN civicrm_price_field cpf ON cpf.id = cpfv.price_field_id
  22 LEFT JOIN civicrm_price_set cps ON cps.id = cpf.price_set_id
  23 SET
  24 cpfv.financial_type_id = cmt.financial_type_id,
  25 {if !$multilingual}
  26   cpfv.label = cmt.name,
  27   cpfv.description = cmt.description,
  28 {else}
  29   {foreach from=$locales item=locale}
  30     cpfv.label_{$locale} = cmt.name_{$locale},
  31     cpfv.description_{$locale} = cmt.description_{$locale},
  32   {/foreach}
  33 {/if}
  34 cpfv.amount = cmt.minimum_fee
  35 WHERE cps.is_quick_config = 1 AND cpfv.membership_type_id IS NOT NULL;