"""fix

Revision ID: 854eab3a823b
Revises: ecc8471fb4f4
Create Date: 2022-06-17 10:47:11.203598

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '854eab3a823b'
down_revision = 'ecc8471fb4f4'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_document_history',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('cmf_deleted', sa.Boolean(), nullable=False),
    sa.Column('cmf_version', sa.BIGINT(), nullable=True),
    sa.Column('name', sa.String(length=256), nullable=True),
    sa.Column('code', sa.String(length=64), nullable=True),
    sa.Column('system', sa.Boolean(), nullable=False),
    sa.Column('text', sa.TEXT(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('approved', sa.Boolean(), nullable=False),
    sa.Column('reason', sa.String(), nullable=True),
    sa.Column('approved_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('approved_version', sa.Integer(), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('approved_by_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['approved_by_id'], ['cmf_person.id'], ),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_document_history_approved_by_id'), 'cmf_document_history', ['approved_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_author_id'), 'cmf_document_history', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_created_at'), 'cmf_document_history', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_deleted'), 'cmf_document_history', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_import_id'), 'cmf_document_history', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_locked_at'), 'cmf_document_history', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_locked_by_id'), 'cmf_document_history', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_modified_at'), 'cmf_document_history', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_modified_by_id'), 'cmf_document_history', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_owner_assistant_id'), 'cmf_document_history', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_owner_id'), 'cmf_document_history', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_version'), 'cmf_document_history', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_viewed_at'), 'cmf_document_history', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_code'), 'cmf_document_history', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_document_history_name'), 'cmf_document_history', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_orderno'), 'cmf_document_history', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_parent_id'), 'cmf_document_history', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_tree_parent_id'), 'cmf_document_history', ['tree_parent_id'], unique=False)
    op.create_table('cmf_person_sign',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False),
    sa.Column('sign', sa.String(), nullable=True),
    sa.Column('person_id', sa.String(length=64), nullable=False),
    sa.Column('document_id', sa.String(length=64), nullable=False),
    sa.ForeignKeyConstraint(['person_id'], ['cmf_person.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_person_sign_cmf_created_at'), 'cmf_person_sign', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_document_id'), 'cmf_person_sign', ['document_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_person_id'), 'cmf_person_sign', ['person_id'], unique=False)
    op.create_table('cmf_shadow_link',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('place', sa.String(length=64), nullable=True),
    sa.Column('pinned', sa.Boolean(), nullable=True),
    sa.Column('task_id', sa.String(length=64), nullable=True),
    sa.Column('person_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['person_id'], ['cmf_person.id'], ),
    sa.ForeignKeyConstraint(['task_id'], ['cmf_task.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_shadow_link_person_id'), 'cmf_shadow_link', ['person_id'], unique=False)
    op.create_index(op.f('ix_cmf_shadow_link_place'), 'cmf_shadow_link', ['place'], unique=False)
    op.create_index(op.f('ix_cmf_shadow_link_task_id'), 'cmf_shadow_link', ['task_id'], unique=False)
    op.create_table('cmf_task_cmf_task',
    sa.Column('id', sa.String(length=64), nullable=False),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('root_id', sa.String(length=64), nullable=True),
    sa.Column('description', sa.String(length=4096), nullable=True),
    sa.Column('left_id', sa.String(length=64), nullable=True),
    sa.Column('right_id', sa.String(length=64), nullable=True),
    sa.Column('left_name_cache', sa.String(length=256), nullable=True),
    sa.Column('right_name_cache', sa.String(length=256), nullable=True),
    sa.ForeignKeyConstraint(['left_id'], ['cmf_task.id'], ),
    sa.ForeignKeyConstraint(['right_id'], ['cmf_task.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_task_cmf_task_left_id'), 'cmf_task_cmf_task', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_cmf_task_parent_id'), 'cmf_task_cmf_task', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_cmf_task_right_id'), 'cmf_task_cmf_task', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_cmf_task_root_id'), 'cmf_task_cmf_task', ['root_id'], unique=False)
    op.add_column('cmf_comment', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_comment', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_comment', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_comment', sa.Column('orderno', sa.Integer(), nullable=True))
    op.alter_column('cmf_comment', 'likes',
               existing_type=sa.TEXT(),
               nullable=False)
    op.create_index(op.f('ix_cmf_comment_orderno'), 'cmf_comment', ['orderno'], unique=False)
    op.drop_column('cmf_comment', 'cache_last_comments')
    op.add_column('cmf_document', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_document', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_document', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_document', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_document', sa.Column('need_approve', sa.Boolean(), nullable=False))
    op.add_column('cmf_document', sa.Column('approved', sa.Boolean(), nullable=False))
    op.add_column('cmf_document', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_document_orderno'), 'cmf_document', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_document_tree_parent_id'), 'cmf_document', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_document', 'cache_last_comments')
    op.add_column('cmf_filter', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_filter', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_filter', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_filter', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_filter', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=True)
    op.create_index(op.f('ix_cmf_filter_tree_parent_id'), 'cmf_filter', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_filter', 'cache_last_comments')
    op.add_column('cmf_import', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_import', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_import', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_import', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_import', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_import_orderno'), 'cmf_import', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_import_tree_parent_id'), 'cmf_import', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_import', 'cache_last_comments')
    op.add_column('cmf_link', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_link', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_link', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_link', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_link', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_link_orderno'), 'cmf_link', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_link_tree_parent_id'), 'cmf_link', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_link', 'cache_last_comments')
    op.add_column('cmf_notify', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_notify', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_notify', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_notify', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_notify', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_notify_orderno'), 'cmf_notify', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_notify_tree_parent_id'), 'cmf_notify', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_notify', 'cache_last_comments')
    op.add_column('cmf_person', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_person', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_person', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_person', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_person', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_person_orderno'), 'cmf_person', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_person_tree_parent_id'), 'cmf_person', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_person', 'cache_last_comments')
    op.add_column('cmf_person_var', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_person_var', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_person_var', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_person_var', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_person_var', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_person_var_orderno'), 'cmf_person_var', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_person_var_tree_parent_id'), 'cmf_person_var', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_person_var', 'cache_last_comments')
    op.add_column('cmf_plugin', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_plugin', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_orderno'), 'cmf_plugin', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_tree_parent_id'), 'cmf_plugin', ['tree_parent_id'], unique=False)
    op.drop_column('cmf_plugin', 'cache_last_comments')
    op.add_column('cmf_task', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_task', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_task', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_task', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_task', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_task', sa.Column('parent_task_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_task_orderno'), 'cmf_task', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_task_parent_task_id'), 'cmf_task', ['parent_task_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_tree_parent_id'), 'cmf_task', ['tree_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_task', 'cmf_task', ['parent_task_id'], ['id'])
    op.drop_column('cmf_task', 'cache_last_comments')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_task', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_constraint(None, 'cmf_task', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_task_tree_parent_id'), table_name='cmf_task')
    op.drop_index(op.f('ix_cmf_task_parent_task_id'), table_name='cmf_task')
    op.drop_index(op.f('ix_cmf_task_orderno'), table_name='cmf_task')
    op.drop_column('cmf_task', 'parent_task_id')
    op.drop_column('cmf_task', 'tree_parent_id')
    op.drop_column('cmf_task', 'orderno')
    op.drop_column('cmf_task', 'tree_hidden')
    op.drop_column('cmf_task', 'tree_node_is_branch')
    op.drop_column('cmf_task', 'has_tree_nodes')
    op.add_column('cmf_plugin', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_plugin_tree_parent_id'), table_name='cmf_plugin')
    op.drop_index(op.f('ix_cmf_plugin_orderno'), table_name='cmf_plugin')
    op.drop_column('cmf_plugin', 'tree_parent_id')
    op.drop_column('cmf_plugin', 'orderno')
    op.drop_column('cmf_plugin', 'tree_hidden')
    op.drop_column('cmf_plugin', 'tree_node_is_branch')
    op.drop_column('cmf_plugin', 'has_tree_nodes')
    op.add_column('cmf_person_var', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_person_var_tree_parent_id'), table_name='cmf_person_var')
    op.drop_index(op.f('ix_cmf_person_var_orderno'), table_name='cmf_person_var')
    op.drop_column('cmf_person_var', 'tree_parent_id')
    op.drop_column('cmf_person_var', 'orderno')
    op.drop_column('cmf_person_var', 'tree_hidden')
    op.drop_column('cmf_person_var', 'tree_node_is_branch')
    op.drop_column('cmf_person_var', 'has_tree_nodes')
    op.add_column('cmf_person', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_person_tree_parent_id'), table_name='cmf_person')
    op.drop_index(op.f('ix_cmf_person_orderno'), table_name='cmf_person')
    op.drop_column('cmf_person', 'tree_parent_id')
    op.drop_column('cmf_person', 'orderno')
    op.drop_column('cmf_person', 'tree_hidden')
    op.drop_column('cmf_person', 'tree_node_is_branch')
    op.drop_column('cmf_person', 'has_tree_nodes')
    op.add_column('cmf_notify', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_notify_tree_parent_id'), table_name='cmf_notify')
    op.drop_index(op.f('ix_cmf_notify_orderno'), table_name='cmf_notify')
    op.drop_column('cmf_notify', 'tree_parent_id')
    op.drop_column('cmf_notify', 'orderno')
    op.drop_column('cmf_notify', 'tree_hidden')
    op.drop_column('cmf_notify', 'tree_node_is_branch')
    op.drop_column('cmf_notify', 'has_tree_nodes')
    op.add_column('cmf_link', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_link_tree_parent_id'), table_name='cmf_link')
    op.drop_index(op.f('ix_cmf_link_orderno'), table_name='cmf_link')
    op.drop_column('cmf_link', 'tree_parent_id')
    op.drop_column('cmf_link', 'orderno')
    op.drop_column('cmf_link', 'tree_hidden')
    op.drop_column('cmf_link', 'tree_node_is_branch')
    op.drop_column('cmf_link', 'has_tree_nodes')
    op.add_column('cmf_import', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_import_tree_parent_id'), table_name='cmf_import')
    op.drop_index(op.f('ix_cmf_import_orderno'), table_name='cmf_import')
    op.drop_column('cmf_import', 'tree_parent_id')
    op.drop_column('cmf_import', 'orderno')
    op.drop_column('cmf_import', 'tree_hidden')
    op.drop_column('cmf_import', 'tree_node_is_branch')
    op.drop_column('cmf_import', 'has_tree_nodes')
    op.add_column('cmf_filter', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_filter_tree_parent_id'), table_name='cmf_filter')
    op.alter_column('cmf_filter', 'orderno',
               existing_type=sa.INTEGER(),
               nullable=False)
    op.drop_column('cmf_filter', 'tree_parent_id')
    op.drop_column('cmf_filter', 'tree_hidden')
    op.drop_column('cmf_filter', 'tree_node_is_branch')
    op.drop_column('cmf_filter', 'has_tree_nodes')
    op.add_column('cmf_document', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_document_tree_parent_id'), table_name='cmf_document')
    op.drop_index(op.f('ix_cmf_document_orderno'), table_name='cmf_document')
    op.drop_column('cmf_document', 'tree_parent_id')
    op.drop_column('cmf_document', 'approved')
    op.drop_column('cmf_document', 'need_approve')
    op.drop_column('cmf_document', 'orderno')
    op.drop_column('cmf_document', 'tree_hidden')
    op.drop_column('cmf_document', 'tree_node_is_branch')
    op.drop_column('cmf_document', 'has_tree_nodes')
    op.add_column('cmf_comment', sa.Column('cache_last_comments', sa.TEXT(), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_comment_orderno'), table_name='cmf_comment')
    op.alter_column('cmf_comment', 'likes',
               existing_type=sa.TEXT(),
               nullable=True)
    op.drop_column('cmf_comment', 'orderno')
    op.drop_column('cmf_comment', 'tree_hidden')
    op.drop_column('cmf_comment', 'tree_node_is_branch')
    op.drop_column('cmf_comment', 'has_tree_nodes')
    op.drop_index(op.f('ix_cmf_task_cmf_task_root_id'), table_name='cmf_task_cmf_task')
    op.drop_index(op.f('ix_cmf_task_cmf_task_right_id'), table_name='cmf_task_cmf_task')
    op.drop_index(op.f('ix_cmf_task_cmf_task_parent_id'), table_name='cmf_task_cmf_task')
    op.drop_index(op.f('ix_cmf_task_cmf_task_left_id'), table_name='cmf_task_cmf_task')
    op.drop_table('cmf_task_cmf_task')
    op.drop_index(op.f('ix_cmf_shadow_link_task_id'), table_name='cmf_shadow_link')
    op.drop_index(op.f('ix_cmf_shadow_link_place'), table_name='cmf_shadow_link')
    op.drop_index(op.f('ix_cmf_shadow_link_person_id'), table_name='cmf_shadow_link')
    op.drop_table('cmf_shadow_link')
    op.drop_index(op.f('ix_cmf_person_sign_person_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_document_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_created_at'), table_name='cmf_person_sign')
    op.drop_table('cmf_person_sign')
    op.drop_index(op.f('ix_cmf_document_history_tree_parent_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_parent_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_orderno'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_name'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_code'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_viewed_at'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_version'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_owner_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_owner_assistant_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_modified_by_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_modified_at'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_locked_by_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_locked_at'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_import_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_deleted'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_created_at'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_cmf_author_id'), table_name='cmf_document_history')
    op.drop_index(op.f('ix_cmf_document_history_approved_by_id'), table_name='cmf_document_history')
    op.drop_table('cmf_document_history')
    # ### end Alembic commands ###