"""ad_login

Revision ID: 11a5508679ba
Revises: 3f52257bb425
Create Date: 2023-04-14 09:28:13.050890

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '11a5508679ba'
down_revision = '3f52257bb425'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_global_settings', sa.Column('auth_options_allow_sso', sa.Boolean(), nullable=True, server_default='true'))
    op.add_column('cmf_session', sa.Column('refresh_token', sa.String(length=256), nullable=True))
    op.drop_column('cmf_session', 'protocol')
    # ### end Alembic commands ###
    op.alter_column('cmf_person', 'ad_login', new_column_name='ext_login')
    # op.alter_column('cmf_auth', 'ad_login', new_column_name='ext_login')


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_session', sa.Column('protocol', sa.VARCHAR(length=256), autoincrement=False, nullable=True))
    op.drop_column('cmf_session', 'refresh_token')
    op.drop_column('cmf_global_settings', 'auth_options_allow_sso')
    # ### end Alembic commands ###