"""Add an index on ssh_search_key

Revision ID: 0a8f99c161e2
Revises: ba538b2648b7
Create Date: 2018-10-04 10:49:44.739141

"""

# revision identifiers, used by Alembic.
revision = '0a8f99c161e2'
down_revision = 'ba538b2648b7'

from alembic import op
import sqlalchemy as sa


def upgrade():
    """ Creates an index on ssh_search_key in the deploykeys table.
    """
    op.create_index(
        op.f("ix_deploykeys_deploykeys_ssh_search_key"),
        "deploykeys",
        ["ssh_search_key"],
        unique=True,
    )


def downgrade():
    """ Drop index on ssh_search_key in the deploykeys table.
    """
    op.drop_index(
        op.f("ix_deploykeys_deploykeys_ssh_search_key"),
        table_name="deploykeys"
    )