From 9916f57f9b56b50aaa82cdfa8fdd6a0c2d46f5d2 Mon Sep 17 00:00:00 2001 From: Dylan William Hardison Date: Thu, 12 Jun 2014 17:24:30 -0400 Subject: Bug 1022923 - Add index to bug_user_last_visit.last_visit_ts --- Bugzilla/DB/Schema.pm | 3 ++- Bugzilla/Install/DB.pm | 5 +++++ 2 files changed, 7 insertions(+), 1 deletion(-) (limited to 'Bugzilla') diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index cbcb5b26c..be392c105 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -1730,7 +1730,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 7ab533198..4fb1f1c83 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -706,6 +706,11 @@ sub update_table_definitions { # 2013-08-16 glob@mozilla.com - Bug 905925 $dbh->bz_add_index('attachments', 'attachments_ispatch_idx', ['ispatch']); + # 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 # ################################################################ -- cgit v1.2.3-24-g4f1b