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 /Bugzilla/DB | |
| 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 'Bugzilla/DB')
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 15 |
1 files changed, 11 insertions, 4 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index 801f353d7..610ba4c99 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -224,10 +224,17 @@ use constant ABSTRACT_SCHEMA => { removed => {TYPE => 'TINYTEXT'}, ], INDEXES => [ - bugs_activity_bugid_idx => ['bug_id'], - bugs_activity_who_idx => ['who'], - bugs_activity_bugwhen_idx => ['bug_when'], - bugs_activity_fieldid_idx => ['fieldid'], + bugs_activity_bugid_idx => ['bug_id'], + bugs_activity_who_idx => ['who'], + bugs_activity_bugwhen_idx => ['bug_when'], + bugs_activity_fieldid_idx => ['fieldid'], + bugs_activity_bug_field_idx => [qw(bug_id fieldid)], + bugs_activity_added_idx => {FIELDS => ['added'], + TYPE => 'FULLTEXT'}, + bugs_activity_removed_idx => {FIELDS => ['removed'], + TYPE => 'FULLTEXT'}, + bugs_activity_added_removed_idx => {FIELDS => [qw(added removed)], + TYPE => 'FULLTEXT'}, ], }, |