From b4478793ab93465c587e83c17a68b4d1da5c0a84 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Sun, 2 Dec 2007 21:22:16 +0000
Subject: 2nd part of bug 99215: Adding missing DB index when upgrading - Patch
 by me, r=mkanat

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

(limited to 'Bugzilla')

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;
-- 
cgit v1.2.1