From 9bfe43ee5ffb3c5c3f5470ba4bc08fa6cce8d5ad Mon Sep 17 00:00:00 2001
From: demeritcowboy <demeritcowboy@hotmail.com>
Date: Wed, 24 Jun 2020 08:59:07 -0400
Subject: [PATCH] remove index on medium_id

---
 CRM/Activity/DAO/Activity.php                   | 10 +---------
 CRM/Upgrade/Incremental/php/FiveTwentyEight.php |  1 +
 xml/schema/Activity/Activity.xml                |  1 +
 3 files changed, 3 insertions(+), 9 deletions(-)

diff --git a/CRM/Activity/DAO/Activity.php b/CRM/Activity/DAO/Activity.php
index f7b811d00f..f18b5de937 100644
--- a/CRM/Activity/DAO/Activity.php
+++ b/CRM/Activity/DAO/Activity.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Activity/Activity.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:bb8686f72b71e21504c9b7bc95489a0c)
+ * (GenCodeChecksum:a80e5c13f6c26348a2479ed9851d18a1)
  */
 
 /**
@@ -796,14 +796,6 @@ class CRM_Activity_DAO_Activity extends CRM_Core_DAO {
         'localizable' => FALSE,
         'sig' => 'civicrm_activity::0::status_id',
       ],
-      'index_medium_id' => [
-        'name' => 'index_medium_id',
-        'field' => [
-          0 => 'medium_id',
-        ],
-        'localizable' => FALSE,
-        'sig' => 'civicrm_activity::0::medium_id',
-      ],
       'index_is_current_revision' => [
         'name' => 'index_is_current_revision',
         'field' => [
diff --git a/CRM/Upgrade/Incremental/php/FiveTwentyEight.php b/CRM/Upgrade/Incremental/php/FiveTwentyEight.php
index bcc12a1adf..31f8b7facb 100644
--- a/CRM/Upgrade/Incremental/php/FiveTwentyEight.php
+++ b/CRM/Upgrade/Incremental/php/FiveTwentyEight.php
@@ -62,6 +62,7 @@ class CRM_Upgrade_Incremental_php_FiveTwentyEight extends CRM_Upgrade_Incrementa
     $this->addTask('Populate missing Contact Type name fields', 'populateMissingContactTypeName');
     $this->addTask('Add icon column to civicrm_custom_group', 'addColumn',
       'civicrm_custom_group', 'icon', "varchar(255) COMMENT 'crm-i icon class' DEFAULT NULL");
+    $this->addTask('Remove index on medium_id from civicrm_activity', 'dropIndex', 'civicrm_activity', 'index_medium_id');
   }
 
   public static function populateMissingContactTypeName() {
diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml
index 9fb9d52874..8a37ea3d76 100644
--- a/xml/schema/Activity/Activity.xml
+++ b/xml/schema/Activity/Activity.xml
@@ -323,6 +323,7 @@
     <name>index_medium_id</name>
     <fieldName>medium_id</fieldName>
     <add>2.2</add>
+    <drop>5.28</drop>
   </index>
   <field>
     <name>is_auto</name>
-- 
2.25.1