"""copy auth

Revision ID: 5ed81ce459f7
Revises: c024798cf5cb
Create Date: 2023-04-12 15:10:36.255740

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '5ed81ce459f7'
down_revision = 'c024798cf5cb'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_auth', sa.Column('reset_password_hash', sa.String(length=256), nullable=True))
    op.add_column('cmf_auth', sa.Column('reset_password_expires', sa.Integer(), nullable=True))
    op.add_column('cmf_auth', sa.Column('reg_org_name_list', sa.TEXT(), nullable=True))
    op.add_column('cmf_auth', sa.Column('auth_options', sa.TEXT(), nullable=True))
    op.add_column('cmf_auth', sa.Column('ad_login', sa.String(length=128), nullable=True))
    op.add_column('cmf_auth', sa.Column('password_expires_must_change', sa.Integer(), nullable=True))
    op.create_index(op.f('ix_cmf_auth_ad_login'), 'cmf_auth', ['ad_login'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_auth_email'), table_name='cmf_auth')
    op.drop_index(op.f('ix_cmf_auth_ad_login'), table_name='cmf_auth')
    op.drop_column('cmf_auth', 'password_expires_must_change')
    op.drop_column('cmf_auth', 'ad_login')
    op.drop_column('cmf_auth', 'auth_options')
    op.drop_column('cmf_auth', 'reg_org_name_list')
    op.drop_column('cmf_auth', 'reset_password_expires')
    op.drop_column('cmf_auth', 'reset_password_hash')
    # ### end Alembic commands ###