"""add_auth_method_to_ix_person_username

Revision ID: 0daec5f8135f
Revises: 6368515778c5
Create Date: 2022-12-22 18:35:59.609013

"""
import sqlalchemy as sa  # noqa: F401
from alembic import op

# revision identifiers, used by Alembic.
revision = "0daec5f8135f"
down_revision = "6368515778c5"
branch_labels = None
depends_on = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index("ix_person_username", table_name="person")
    op.create_index("ix_person_username", "person", ["api_client_id", "username", "auth_method"], unique=True)
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index("ix_person_username", table_name="person")
    op.create_index("ix_person_username", "person", ["api_client_id", "username"], unique=False)
    # ### end Alembic commands ###

c57155c8e2602f80a8a839ed47ab3284cb0c31d4
<mask token>


def upgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username', 'auth_method'], unique=True)


<mask token>

<mask token>


def upgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username', 'auth_method'], unique=True)


def downgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username'], unique=False)

<mask token>
revision = '0daec5f8135f'
down_revision = '6368515778c5'
branch_labels = None
depends_on = None


def upgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username', 'auth_method'], unique=True)


def downgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username'], unique=False)

<mask token>
import sqlalchemy as sa
from alembic import op
revision = '0daec5f8135f'
down_revision = '6368515778c5'
branch_labels = None
depends_on = None


def upgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username', 'auth_method'], unique=True)


def downgrade() ->None:
    op.drop_index('ix_person_username', table_name='person')
    op.create_index('ix_person_username', 'person', ['api_client_id',
        'username'], unique=False)

"""add_auth_method_to_ix_person_username

Revision ID: 0daec5f8135f
Revises: 6368515778c5
Create Date: 2022-12-22 18:35:59.609013

"""
import sqlalchemy as sa  # noqa: F401
from alembic import op

# revision identifiers, used by Alembic.
revision = "0daec5f8135f"
down_revision = "6368515778c5"
branch_labels = None
depends_on = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index("ix_person_username", table_name="person")
    op.create_index("ix_person_username", "person", ["api_client_id", "username", "auth_method"], unique=True)
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index("ix_person_username", table_name="person")
    op.create_index("ix_person_username", "person", ["api_client_id", "username"], unique=False)
    # ### end Alembic commands ###
