CRM-12151

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.3.beta4.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
index 7f93e23161fd2614eda8fb0b448ad4b42a9e4149..e8fbb154a9b4d1f15e160e7811154a5ff4c88582 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.3.beta4.mysql.tpl
@@ -1,5 +1,15 @@
 -- CRM-12142
 {if !$multilingual}
-  ALTER TABLE `civicrm_premiums` 
-    ADD COLUMN premiums_nothankyou_label varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Label displayed for No Thank-you option in premiums block (e.g. No thank you)';
-{/if}
\ No newline at end of file
+  ALTER TABLE `civicrm_premiums`
+    ADD COLUMN premiums_nothankyou_label varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Label displayed for No Thank-you
+ option in premiums block (e.g. No thank you)';
+{/if}
+
+-- CRM-12151
+ALTER TABLE civicrm_option_value
+  DROP INDEX index_option_group_id_value,
+  ADD INDEX index_option_group_id_value (value(128), option_group_id),
+  DROP INDEX index_option_group_id_name,
+  ADD INDEX index_option_group_id_name (option_group_id, name(128));
+
+