2nd part of bug 99215: Adding missing DB index when upgrading - Patch by me, r=mkanat

1 files changed, 4 insertions, 0 deletions

diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index 485c771b1..9342959cf 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -2924,6 +2924,10 @@ sub _fix_attachment_modification_date {
                                  WHERE attach_id = ?');
         $sth->execute($_->[1], $_->[0]) foreach (@$attachments);
     }
+    # We add this here to be sure to have the index being added, due to the original
+    # patch omitting it.
+    $dbh->bz_add_index('attachments', 'attachments_modification_time_idx',
+                       [qw(modification_time)]);
 }
 
 1;