diff options
| author | lpsolit%gmail.com <> | 2005-03-23 05:54:07 +0100 |
|---|---|---|
| committer | lpsolit%gmail.com <> | 2005-03-23 05:54:07 +0100 |
| commit | 4271efa047ab1474a1d056ea1a1c7cb7fdf5378b (patch) | |
| tree | cc252c3ac429815e31406c8462b50a875a2b37e7 /checksetup.pl | |
| parent | d9c182c4301459f433bc8537efda462b3baad316 (diff) | |
| download | bugzilla-4271efa047ab1474a1d056ea1a1c7cb7fdf5378b.tar.gz bugzilla-4271efa047ab1474a1d056ea1a1c7cb7fdf5378b.tar.xz | |
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
Diffstat (limited to 'checksetup.pl')
| -rwxr-xr-x | checksetup.pl | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/checksetup.pl b/checksetup.pl index 07367f0c3..7533b8dd8 100755 --- a/checksetup.pl +++ b/checksetup.pl @@ -3868,6 +3868,14 @@ if (!$dbh->bz_get_field_def('bugs', 'qa_contact')->[2]) { # if it's NOT NULL WHERE initialqacontact = 0"); } +# 2005-03-17 Add more indices for bugs_activity -- Bug 286625 +print "Adding more indexes for bugs_activity table.\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)"); + + } # END LEGACY CHECKS |