From 9916f57f9b56b50aaa82cdfa8fdd6a0c2d46f5d2 Mon Sep 17 00:00:00 2001
From: Dylan William Hardison <dylan@hardison.net>
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 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'Bugzilla/DB')

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'],
         ],
     },
 };
-- 
cgit v1.2.3-24-g4f1b