From ac80568834a7954046d6dcaed98d9460b3d34b09 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
Date: Tue, 30 Jan 2018 22:18:06 -0500
Subject: Bug 1433833 - Add index to email_rates.message_ts

---
 Bugzilla/Install/DB.pm | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'Bugzilla/Install')

diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 3b1836c26..e6a7a3be0 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -218,6 +218,10 @@ sub update_table_definitions {
         $dbh->bz_add_column('profiles', 'emailflags', {TYPE => 'MEDIUMTEXT'});
     }
 
+    if (!$dbh->bz_index_info('email_rates', 'email_rates_message_ts_idx')) {
+        $dbh->bz_add_index( 'email_rates', 'email_rates_message_ts_idx', ['message_ts'] );
+    }
+
     $dbh->bz_add_column('groups', 'isactive',
                         {TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'TRUE'});
 
-- 
cgit v1.2.3-24-g4f1b