revision = '4851d15bc437'

down_revision = '151b4a4e8c48'

branch_labels = None

depends_on = None

import sqlalchemy as sa

from alembic import op

def upgrade():

    pass

    # The following upgrade step turned out to be a bad idea. A later step

    # "d7ec25b66e47_ssh_drop_usk_public_key_idx_again" will remove the index

    # again if it exists ... but we shouldn't even try to create it.

    #meta = sa.MetaData()

    #meta.reflect(bind=op.get_bind())

    #if not any(i.name == 'usk_public_key_idx' for i in meta.tables['user_ssh_keys'].indexes):

    #    with op.batch_alter_table('user_ssh_keys', schema=None) as batch_op:

    #        batch_op.create_index('usk_public_key_idx', ['public_key'], unique=False)

def downgrade():

    if any(i.name == 'usk_public_key_idx' for i in meta.tables['user_ssh_keys'].indexes):

        with op.batch_alter_table('user_ssh_keys', schema=None) as batch_op:

            batch_op.drop_index('usk_public_key_idx')