summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB/Schema.pm
diff options
context:
space:
mode:
Diffstat (limited to 'Bugzilla/DB/Schema.pm')
-rw-r--r--Bugzilla/DB/Schema.pm15
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'},
],
},