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 -- CRM-12151
   9 ALTER TABLE civicrm_option_value
  10   DROP INDEX index_option_group_id_value,
  11   ADD INDEX index_option_group_id_value (value(128), option_group_id),
  12   DROP INDEX index_option_group_id_name,
  13   ADD INDEX index_option_group_id_name (option_group_id, name(128));
  14
  15