"""migrate

Revision ID: cce0a79830d6
Revises: f5b3fd09accd
Create Date: 2022-09-08 14:56:12.933696

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'cce0a79830d6'
down_revision = 'f5b3fd09accd'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_access_list', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_access_list_ext_id'), 'cmf_access_list', ['ext_id'], unique=True)
    op.add_column('cmf_access_rule', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_access_rule_ext_id'), 'cmf_access_rule', ['ext_id'], unique=True)
    op.add_column('cmf_comment', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_comment_ext_id'), 'cmf_comment', ['ext_id'], unique=True)
    op.add_column('cmf_document', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_document_ext_id'), 'cmf_document', ['ext_id'], unique=True)
    op.add_column('cmf_document_history', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_document_history_ext_id'), 'cmf_document_history', ['ext_id'], unique=True)
    op.add_column('cmf_filter', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_filter_ext_id'), 'cmf_filter', ['ext_id'], unique=True)
    op.add_column('cmf_global_settings', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_global_settings_ext_id'), 'cmf_global_settings', ['ext_id'], unique=True)
    op.add_column('cmf_import', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_import_ext_id'), 'cmf_import', ['ext_id'], unique=True)
    op.add_column('cmf_link', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_link_ext_id'), 'cmf_link', ['ext_id'], unique=True)
    op.add_column('cmf_notify', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_notify_ext_id'), 'cmf_notify', ['ext_id'], unique=True)
    op.add_column('cmf_person', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_person_ext_id'), 'cmf_person', ['ext_id'], unique=True)
    op.add_column('cmf_person_group', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_person_group_ext_id'), 'cmf_person_group', ['ext_id'], unique=True)
    op.add_column('cmf_person_var', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_person_var_ext_id'), 'cmf_person_var', ['ext_id'], unique=True)
    op.add_column('cmf_plugin', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('ext_port', sa.Integer(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('verify_ssl', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('cloud', sa.Boolean(), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_ext_id'), 'cmf_plugin', ['ext_id'], unique=True)
    op.add_column('cmf_task', sa.Column('ext_id', sa.String(), nullable=True))
    op.create_index(op.f('ix_cmf_task_ext_id'), 'cmf_task', ['ext_id'], unique=True)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_task_ext_id'), table_name='cmf_task')
    op.drop_column('cmf_task', 'ext_id')
    op.drop_index(op.f('ix_cmf_plugin_ext_id'), table_name='cmf_plugin')
    op.drop_column('cmf_plugin', 'cloud')
    op.drop_column('cmf_plugin', 'verify_ssl')
    op.drop_column('cmf_plugin', 'ext_port')
    op.drop_column('cmf_plugin', 'ext_id')
    op.drop_index(op.f('ix_cmf_person_var_ext_id'), table_name='cmf_person_var')
    op.drop_column('cmf_person_var', 'ext_id')
    op.drop_index(op.f('ix_cmf_person_group_ext_id'), table_name='cmf_person_group')
    op.drop_column('cmf_person_group', 'ext_id')
    op.drop_index(op.f('ix_cmf_person_ext_id'), table_name='cmf_person')
    op.drop_column('cmf_person', 'ext_id')
    op.drop_index(op.f('ix_cmf_notify_ext_id'), table_name='cmf_notify')
    op.drop_column('cmf_notify', 'ext_id')
    op.drop_index(op.f('ix_cmf_link_ext_id'), table_name='cmf_link')
    op.drop_column('cmf_link', 'ext_id')
    op.drop_index(op.f('ix_cmf_import_ext_id'), table_name='cmf_import')
    op.drop_column('cmf_import', 'ext_id')
    op.drop_index(op.f('ix_cmf_global_settings_ext_id'), table_name='cmf_global_settings')
    op.drop_column('cmf_global_settings', 'ext_id')
    op.drop_index(op.f('ix_cmf_filter_ext_id'), table_name='cmf_filter')
    op.drop_column('cmf_filter', 'ext_id')
    op.drop_index(op.f('ix_cmf_document_history_ext_id'), table_name='cmf_document_history')
    op.drop_column('cmf_document_history', 'ext_id')
    op.drop_index(op.f('ix_cmf_document_ext_id'), table_name='cmf_document')
    op.drop_column('cmf_document', 'ext_id')
    op.drop_index(op.f('ix_cmf_comment_ext_id'), table_name='cmf_comment')
    op.drop_column('cmf_comment', 'ext_id')
    op.drop_index(op.f('ix_cmf_access_rule_ext_id'), table_name='cmf_access_rule')
    op.drop_column('cmf_access_rule', 'ext_id')
    op.drop_index(op.f('ix_cmf_access_list_ext_id'), table_name='cmf_access_list')
    op.drop_column('cmf_access_list', 'ext_id')
    # ### end Alembic commands ###