# HG changeset patch
# User Mads Kiilerich <madski@unity3d.com>
# Date 2016-02-01 21:23:44
# Node ID 8d93d28adf259a8e1cee92275a2f98562f580032
# Parent  5fe9bb7acee62957dafe6551f85f7a3c1c9b4b92

db: add index on PullRequestReviewers.user_id

diff --git a/kallithea/model/db.py b/kallithea/model/db.py
--- a/kallithea/model/db.py
+++ b/kallithea/model/db.py
@@ -2357,6 +2357,7 @@ class PullRequest(Base, BaseModel):
 class PullRequestReviewers(Base, BaseModel):
     __tablename__ = 'pull_request_reviewers'
     __table_args__ = (
+        Index('pull_request_reviewers_user_id_idx', 'user_id'),
         _table_args_default_dict,
     )