"""rename_auth0_field_to_external_id

Revision ID: cd60a16b7067
Revises: 1c077f014706
Create Date: 2021-12-10 15:12:46.928341

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'cd60a16b7067'
down_revision = '3854f6d74308'
branch_labels = None
depends_on = None


def upgrade():
    op.alter_column('User', 'auth0_id', nullable=False, new_column_name='external_id')

    op.drop_constraint('uq_User_auth0_id', 'User', type_='unique')
    op.create_unique_constraint(op.f('uq_User_external_id'), 'User', ['external_id'])


def downgrade():
    op.alter_column('User', 'external_id', nullable=False, new_column_name='auth0_id')

    op.drop_constraint(op.f('uq_User_external_id'), 'User', type_='unique')
    op.create_unique_constraint('uq_User_auth0_id', 'User', ['auth0_id'])