# HG changeset patch
# User Marcin Kuzminski <marcin@rhodecode.com>
# Date 2017-07-26 05:45:42
# Node ID b63bd7fe922248a450c19cbe00d157fe92dd0620
# Parent  70ea4c96fc25c282017c16fb28cf0417208b9cb0

db: removed two redundant indexes found by never sqlalchemy

diff --git a/rhodecode/model/db.py b/rhodecode/model/db.py
--- a/rhodecode/model/db.py
+++ b/rhodecode/model/db.py
@@ -967,9 +967,8 @@ class User(Base, BaseModel):
 class UserApiKeys(Base, BaseModel):
     __tablename__ = 'user_api_keys'
     __table_args__ = (
-        Index('uak_api_key_idx', 'api_key'),
+        Index('uak_api_key_idx', 'api_key', unique=True),
         Index('uak_api_key_expires_idx', 'api_key', 'expires'),
-        UniqueConstraint('api_key'),
         {'extend_existing': True, 'mysql_engine': 'InnoDB',
          'mysql_charset': 'utf8', 'sqlite_autoincrement': True}
     )
@@ -2905,7 +2904,6 @@ class UserGroupRepoGroupToPerm(Base, Bas
 class Statistics(Base, BaseModel):
     __tablename__ = 'statistics'
     __table_args__ = (
-         UniqueConstraint('repository_id'),
          {'extend_existing': True, 'mysql_engine': 'InnoDB',
           'mysql_charset': 'utf8', 'sqlite_autoincrement': True}
     )