From cc3087cbff34cdcb9da9150cb5b6bc54ffdee6fa Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Wed, 23 Mar 2005 05:01:50 +0000
Subject: [PATCH] Bug 286625: Add more indexes to bugs_activity table - Patch
 by Shane H. W. Travis <shane.h.w.travis@gmail.com> r=joel, a=justdave

---
 checksetup.pl | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

diff --git a/checksetup.pl b/checksetup.pl
index 74b718c36b..34d89e468b 100755
--- a/checksetup.pl
+++ b/checksetup.pl
@@ -1599,7 +1599,12 @@ $table{bugs_activity} =
 
     index (bug_id),
     index (bug_when),
-    index (fieldid)';
+    index (fieldid),
+    index (bug_id, fieldid),
+
+    fulltext (added),
+    fulltext (removed),
+    fulltext (added, removed)';
 
 
 $table{attachments} =
@@ -4521,6 +4526,13 @@ if ($emailflags_count) {
 }
 
 
+# 2005-03-17 Add more indices for bugs_activity -- Bug 286625
+print "Adding more indexes for bugs_activity tables.\n";
+$dbh->do("ALTER TABLE bugs_activity ADD INDEX bugs_activity_idfield (bug_id, fieldid)");
+$dbh->do("ALTER TABLE bugs_activity ADD FULLTEXT bugs_activity_added (added)");
+$dbh->do("ALTER TABLE bugs_activity ADD FULLTEXT bugs_activity_removed (removed)");
+$dbh->do("ALTER TABLE bugs_activity ADD FULLTEXT bugs_activity_added_removed (added, removed)");
+
 #
 # Final checks...
 
-- 
2.47.3