summaryrefslogtreecommitdiffstats
path: root/Bugzilla
diff options
context:
space:
mode:
authorDylan William Hardison <dylan@hardison.net>2014-06-12 23:21:54 +0200
committerDylan William Hardison <dylan@hardison.net>2014-06-12 23:22:31 +0200
commiteb13c383198a1c52a7858fdf3fee0248262bbaf0 (patch)
tree424cf252ff7e66934b6b2cfe80829dcde7e5a145 /Bugzilla
parent6f1a5f0a2c0abfed6839d92d71cfdce9820037b0 (diff)
downloadbugzilla-eb13c383198a1c52a7858fdf3fee0248262bbaf0.tar.gz
bugzilla-eb13c383198a1c52a7858fdf3fee0248262bbaf0.tar.xz
Bug 1022923 - Add index to bug_user_last_visit.last_visit_ts
r/a=glob
Diffstat (limited to 'Bugzilla')
-rw-r--r--Bugzilla/DB/Schema.pm3
-rw-r--r--Bugzilla/Install/DB.pm5
2 files changed, 7 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index cf404f4ca..632ab639b 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1729,7 +1729,8 @@ use constant ABSTRACT_SCHEMA => {
],
INDEXES => [
bug_user_last_visit_idx => {FIELDS => ['user_id', 'bug_id'],
- TYPE => 'UNIQUE'}
+ TYPE => 'UNIQUE'},
+ bug_user_last_visit_last_visit_ts_idx => ['last_visit_ts'],
],
},
};
diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm
index d9bc494e0..9e197a907 100644
--- a/Bugzilla/Install/DB.pm
+++ b/Bugzilla/Install/DB.pm
@@ -714,6 +714,11 @@ sub update_table_definitions {
# 2013-08-26 sgreen@redhat.com - Bug 903895
_fix_components_primary_key();
+ # 2014-06-09 dylan@mozilla.com - Bug 1022923
+ $dbh->bz_add_index('bug_user_last_visit',
+ 'bug_user_last_visit_last_visit_ts_idx',
+ ['last_visit_ts']);
+
################################################################
# New --TABLE-- changes should go *** A B O V E *** this point #
################################################################