"""Fix migration

Revision ID: f5b3fd09accd
Revises: 5aba0338fe03
Create Date: 2022-08-23 09:29:58.469239

"""
from alembic import op
import sqlalchemy as sa


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


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_sign',
    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('object_cmf_version', sa.BIGINT(), nullable=True),
    sa.Column('sign', sa.String(), 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('signed_object_id', sa.String(length=64), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_sign_cmf_author_id'), 'cmf_sign', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_created_at'), 'cmf_sign', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_deleted'), 'cmf_sign', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_locked_at'), 'cmf_sign', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_locked_by_id'), 'cmf_sign', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_modified_at'), 'cmf_sign', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_modified_by_id'), 'cmf_sign', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_owner_assistant_id'), 'cmf_sign', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_owner_id'), 'cmf_sign', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_version'), 'cmf_sign', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_sign_cmf_viewed_at'), 'cmf_sign', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_sign_object_cmf_version'), 'cmf_sign', ['object_cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_sign_parent_id'), 'cmf_sign', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_sign_signed_object_id'), 'cmf_sign', ['signed_object_id'], unique=False)
    op.create_table('cmf_document_history_cmf_sign',
    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_document_history.id'], ),
    sa.ForeignKeyConstraint(['right_id'], ['cmf_sign.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_document_history_cmf_sign_left_id'), 'cmf_document_history_cmf_sign', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_sign_parent_id'), 'cmf_document_history_cmf_sign', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_sign_right_id'), 'cmf_document_history_cmf_sign', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_history_cmf_sign_root_id'), 'cmf_document_history_cmf_sign', ['root_id'], unique=False)
    op.add_column('cmf_access_list', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_access_list', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.drop_index('ix_cmf_access_list_perm_inherit_parent_id', table_name='cmf_access_list')
    op.create_index(op.f('ix_cmf_access_list_perm_parent_id'), 'cmf_access_list', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_access_list', 'policy')
    op.drop_column('cmf_access_list', 'perm_inherit_parent_id')
    op.drop_column('cmf_access_list', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_access_list', 'perm_policy_guest')
    op.drop_column('cmf_access_list', 'perm_policy')
    op.drop_column('cmf_access_list', 'perm_policy_anonymous')
    op.add_column('cmf_access_rule', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_access_rule', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.drop_index('ix_cmf_access_rule_perm_inherit_parent_id', table_name='cmf_access_rule')
    op.create_index(op.f('ix_cmf_access_rule_perm_parent_id'), 'cmf_access_rule', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_access_rule', 'perm_inherit_parent_id')
    op.drop_column('cmf_access_rule', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_access_rule', 'perm_policy_guest')
    op.drop_column('cmf_access_rule', 'perm_policy')
    op.drop_column('cmf_access_rule', 'perm_policy_anonymous')
    op.alter_column('cmf_auth', 'phone',
               existing_type=sa.VARCHAR(length=32),
               type_=sa.String(length=64),
               existing_nullable=True)
    op.add_column('cmf_comment', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_comment', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_comment', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_comment_perm_inherit_parent_id', table_name='cmf_comment')
    op.create_index(op.f('ix_cmf_comment_perm_parent_id'), 'cmf_comment', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_comment', 'perm_inherit_parent_id')
    op.drop_column('cmf_comment', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_comment', 'perm_policy_guest')
    op.drop_column('cmf_comment', 'perm_policy')
    op.drop_column('cmf_comment', 'perm_policy_anonymous')
    op.add_column('cmf_document', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_document', sa.Column('text_draft', sa.TEXT(), nullable=False))
    op.add_column('cmf_document', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_document', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_document_perm_inherit_parent_id', table_name='cmf_document')
    op.create_index(op.f('ix_cmf_document_perm_parent_id'), 'cmf_document', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_document', 'perm_inherit_parent_id')
    op.drop_column('cmf_document', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_document', 'perm_policy_guest')
    op.drop_column('cmf_document', 'perm_policy')
    op.drop_column('cmf_document', 'perm_policy_anonymous')
    op.add_column('cmf_document_history', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_document_history', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.drop_index('ix_cmf_document_history_perm_inherit_parent_id', table_name='cmf_document_history')
    op.create_index(op.f('ix_cmf_document_history_perm_parent_id'), 'cmf_document_history', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_document_history', 'perm_inherit_parent_id')
    op.drop_column('cmf_document_history', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_document_history', 'perm_policy_guest')
    op.drop_column('cmf_document_history', 'perm_policy')
    op.drop_column('cmf_document_history', 'perm_policy_anonymous')
    op.add_column('cmf_filter', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_filter', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_filter', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_filter_perm_inherit_parent_id', table_name='cmf_filter')
    op.create_index(op.f('ix_cmf_filter_perm_parent_id'), 'cmf_filter', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_filter', 'perm_inherit_parent_id')
    op.drop_column('cmf_filter', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_filter', 'perm_policy_guest')
    op.drop_column('cmf_filter', 'perm_policy')
    op.drop_column('cmf_filter', 'perm_policy_anonymous')
    op.add_column('cmf_global_settings', sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False))
    op.add_column('cmf_global_settings', sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False))
    op.add_column('cmf_global_settings', sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_deleted', sa.Boolean(), nullable=False))
    op.add_column('cmf_global_settings', sa.Column('cmf_version', sa.BIGINT(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('name', sa.String(length=256), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('system', sa.Boolean(), nullable=False))
    op.add_column('cmf_global_settings', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('app_key', sa.String(length=32), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_author_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_global_settings', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_global_settings_cmf_author_id'), 'cmf_global_settings', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_created_at'), 'cmf_global_settings', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_deleted'), 'cmf_global_settings', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_import_id'), 'cmf_global_settings', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_locked_at'), 'cmf_global_settings', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_locked_by_id'), 'cmf_global_settings', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_modified_at'), 'cmf_global_settings', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_modified_by_id'), 'cmf_global_settings', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_owner_assistant_id'), 'cmf_global_settings', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_owner_id'), 'cmf_global_settings', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_version'), 'cmf_global_settings', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_cmf_viewed_at'), 'cmf_global_settings', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_code'), 'cmf_global_settings', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_global_settings_name'), 'cmf_global_settings', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_orderno'), 'cmf_global_settings', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_parent_id'), 'cmf_global_settings', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_perm_acl_id'), 'cmf_global_settings', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_perm_parent_id'), 'cmf_global_settings', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_global_settings_tree_parent_id'), 'cmf_global_settings', ['tree_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_global_settings', 'cmf_access_list', ['perm_acl_id'], ['id'])
    op.create_foreign_key(None, 'cmf_global_settings', 'cmf_import', ['cmf_import_id'], ['id'])
    op.add_column('cmf_import', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_import', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_import', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_import_perm_inherit_parent_id', table_name='cmf_import')
    op.create_index(op.f('ix_cmf_import_perm_parent_id'), 'cmf_import', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_import', 'perm_inherit_parent_id')
    op.drop_column('cmf_import', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_import', 'perm_policy_guest')
    op.drop_column('cmf_import', 'perm_policy')
    op.drop_column('cmf_import', 'perm_policy_anonymous')
    op.add_column('cmf_link', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_link', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_link', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_link_perm_inherit_parent_id', table_name='cmf_link')
    op.create_index(op.f('ix_cmf_link_perm_parent_id'), 'cmf_link', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_link', 'perm_inherit_parent_id')
    op.drop_column('cmf_link', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_link', 'perm_policy_guest')
    op.drop_column('cmf_link', 'perm_policy')
    op.drop_column('cmf_link', 'perm_policy_anonymous')
    op.add_column('cmf_notify', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_notify', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_notify', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_notify_perm_inherit_parent_id', table_name='cmf_notify')
    op.create_index(op.f('ix_cmf_notify_perm_parent_id'), 'cmf_notify', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_notify', 'perm_inherit_parent_id')
    op.drop_column('cmf_notify', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_notify', 'perm_policy_guest')
    op.drop_column('cmf_notify', 'perm_policy')
    op.drop_column('cmf_notify', 'perm_policy_anonymous')
    op.alter_column('cmf_patch', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.add_column('cmf_person', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_person', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_person_perm_inherit_parent_id', table_name='cmf_person')
    op.create_index(op.f('ix_cmf_person_perm_parent_id'), 'cmf_person', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_person', 'perm_inherit_parent_id')
    op.drop_column('cmf_person', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person', 'perm_policy_guest')
    op.drop_column('cmf_person', 'perm_policy')
    op.drop_column('cmf_person', 'perm_policy_anonymous')
    op.add_column('cmf_person_group', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_group', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.drop_index('ix_cmf_person_group_perm_inherit_parent_id', table_name='cmf_person_group')
    op.create_index(op.f('ix_cmf_person_group_perm_parent_id'), 'cmf_person_group', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_person_group', 'perm_inherit_parent_id')
    op.drop_column('cmf_person_group', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person_group', 'perm_policy_guest')
    op.drop_column('cmf_person_group', 'perm_policy')
    op.drop_column('cmf_person_group', 'perm_policy_anonymous')
    op.add_column('cmf_person_sign', sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False))
    op.add_column('cmf_person_sign', sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_deleted', sa.Boolean(), nullable=False))
    op.add_column('cmf_person_sign', sa.Column('cmf_version', sa.BIGINT(), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('object_cmf_version', sa.BIGINT(), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_author_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_sign', sa.Column('signed_object_id', sa.String(length=64), nullable=True))
    op.drop_index('ix_cmf_person_sign_document_id', table_name='cmf_person_sign')
    op.drop_index('ix_cmf_person_sign_person_id', table_name='cmf_person_sign')
    op.create_index(op.f('ix_cmf_person_sign_cmf_author_id'), 'cmf_person_sign', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_deleted'), 'cmf_person_sign', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_locked_at'), 'cmf_person_sign', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_locked_by_id'), 'cmf_person_sign', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_modified_at'), 'cmf_person_sign', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_modified_by_id'), 'cmf_person_sign', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_owner_assistant_id'), 'cmf_person_sign', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_owner_id'), 'cmf_person_sign', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_version'), 'cmf_person_sign', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_cmf_viewed_at'), 'cmf_person_sign', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_object_cmf_version'), 'cmf_person_sign', ['object_cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_parent_id'), 'cmf_person_sign', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_person_sign_signed_object_id'), 'cmf_person_sign', ['signed_object_id'], unique=False)
    op.drop_constraint('cmf_person_sign_person_id_fkey', 'cmf_person_sign', type_='foreignkey')
    op.drop_column('cmf_person_sign', 'document_id')
    op.drop_column('cmf_person_sign', 'person_id')
    op.add_column('cmf_person_var', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_person_var', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_person_var', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_person_var_perm_inherit_parent_id', table_name='cmf_person_var')
    op.create_index(op.f('ix_cmf_person_var_perm_parent_id'), 'cmf_person_var', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_person_var', 'perm_inherit_parent_id')
    op.drop_column('cmf_person_var', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_person_var', 'perm_policy_guest')
    op.drop_column('cmf_person_var', 'perm_policy')
    op.drop_column('cmf_person_var', 'perm_policy_anonymous')
    op.add_column('cmf_plugin', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_plugin', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_plugin', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_plugin_perm_inherit_parent_id', table_name='cmf_plugin')
    op.create_index(op.f('ix_cmf_plugin_perm_parent_id'), 'cmf_plugin', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_plugin', 'perm_inherit_parent_id')
    op.drop_column('cmf_plugin', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_plugin', 'perm_policy_guest')
    op.drop_column('cmf_plugin', 'perm_policy')
    op.drop_column('cmf_plugin', 'perm_policy_anonymous')
    op.add_column('cmf_task', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_task', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.alter_column('cmf_task', 'cmf_version',
               existing_type=sa.INTEGER(),
               type_=sa.BIGINT(),
               existing_nullable=True)
    op.drop_index('ix_cmf_task_perm_inherit_parent_id', table_name='cmf_task')
    op.create_index(op.f('ix_cmf_task_perm_parent_id'), 'cmf_task', ['perm_parent_id'], unique=False)
    op.drop_column('cmf_task', 'perm_inherit_parent_id')
    op.drop_column('cmf_task', 'perm_inherit_parent_owner_id')
    op.drop_column('cmf_task', 'perm_policy_guest')
    op.drop_column('cmf_task', 'perm_policy')
    op.drop_column('cmf_task', 'perm_policy_anonymous')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_task', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_task', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_task', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_task', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_task', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_task_perm_parent_id'), table_name='cmf_task')
    op.create_index('ix_cmf_task_perm_inherit_parent_id', 'cmf_task', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_task', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_task', 'perm_parent_id')
    op.drop_column('cmf_task', 'perm_parent_owner_id')
    op.add_column('cmf_plugin', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_plugin', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_plugin', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_plugin', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_plugin', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_plugin_perm_parent_id'), table_name='cmf_plugin')
    op.create_index('ix_cmf_plugin_perm_inherit_parent_id', 'cmf_plugin', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_plugin', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_plugin', 'perm_parent_id')
    op.drop_column('cmf_plugin', 'perm_parent_owner_id')
    op.add_column('cmf_person_var', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_var', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_var', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_var', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_person_var', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_person_var_perm_parent_id'), table_name='cmf_person_var')
    op.create_index('ix_cmf_person_var_perm_inherit_parent_id', 'cmf_person_var', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_person_var', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_person_var', 'perm_parent_id')
    op.drop_column('cmf_person_var', 'perm_parent_owner_id')
    op.add_column('cmf_person_sign', sa.Column('person_id', sa.VARCHAR(length=64), autoincrement=False, nullable=False))
    op.add_column('cmf_person_sign', sa.Column('document_id', sa.VARCHAR(length=64), autoincrement=False, nullable=False))
    op.create_foreign_key('cmf_person_sign_person_id_fkey', 'cmf_person_sign', 'cmf_person', ['person_id'], ['id'])
    op.drop_index(op.f('ix_cmf_person_sign_signed_object_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_parent_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_object_cmf_version'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_viewed_at'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_version'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_owner_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_owner_assistant_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_modified_by_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_modified_at'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_locked_by_id'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_locked_at'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_deleted'), table_name='cmf_person_sign')
    op.drop_index(op.f('ix_cmf_person_sign_cmf_author_id'), table_name='cmf_person_sign')
    op.create_index('ix_cmf_person_sign_person_id', 'cmf_person_sign', ['person_id'], unique=False)
    op.create_index('ix_cmf_person_sign_document_id', 'cmf_person_sign', ['document_id'], unique=False)
    op.drop_column('cmf_person_sign', 'signed_object_id')
    op.drop_column('cmf_person_sign', 'cmf_locked_by_id')
    op.drop_column('cmf_person_sign', 'cmf_modified_by_id')
    op.drop_column('cmf_person_sign', 'parent_id')
    op.drop_column('cmf_person_sign', 'cmf_owner_assistant_id')
    op.drop_column('cmf_person_sign', 'cmf_owner_id')
    op.drop_column('cmf_person_sign', 'cmf_author_id')
    op.drop_column('cmf_person_sign', 'object_cmf_version')
    op.drop_column('cmf_person_sign', 'cmf_version')
    op.drop_column('cmf_person_sign', 'cmf_deleted')
    op.drop_column('cmf_person_sign', 'cmf_viewed_at')
    op.drop_column('cmf_person_sign', 'cmf_modified_at')
    op.drop_column('cmf_person_sign', 'cmf_locked_at')
    op.add_column('cmf_person_group', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_group', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_group', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person_group', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_person_group', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_person_group_perm_parent_id'), table_name='cmf_person_group')
    op.create_index('ix_cmf_person_group_perm_inherit_parent_id', 'cmf_person_group', ['perm_inherit_parent_id'], unique=False)
    op.drop_column('cmf_person_group', 'perm_parent_id')
    op.drop_column('cmf_person_group', 'perm_parent_owner_id')
    op.add_column('cmf_person', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_person', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_person', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_person_perm_parent_id'), table_name='cmf_person')
    op.create_index('ix_cmf_person_perm_inherit_parent_id', 'cmf_person', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_person', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_person', 'perm_parent_id')
    op.drop_column('cmf_person', 'perm_parent_owner_id')
    op.alter_column('cmf_patch', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.add_column('cmf_notify', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_notify', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_notify', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_notify', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_notify', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_notify_perm_parent_id'), table_name='cmf_notify')
    op.create_index('ix_cmf_notify_perm_inherit_parent_id', 'cmf_notify', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_notify', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_notify', 'perm_parent_id')
    op.drop_column('cmf_notify', 'perm_parent_owner_id')
    op.add_column('cmf_link', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_link', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_link', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_link', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_link', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_link_perm_parent_id'), table_name='cmf_link')
    op.create_index('ix_cmf_link_perm_inherit_parent_id', 'cmf_link', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_link', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_link', 'perm_parent_id')
    op.drop_column('cmf_link', 'perm_parent_owner_id')
    op.add_column('cmf_import', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_import', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_import', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_import', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_import', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_import_perm_parent_id'), table_name='cmf_import')
    op.create_index('ix_cmf_import_perm_inherit_parent_id', 'cmf_import', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_import', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_import', 'perm_parent_id')
    op.drop_column('cmf_import', 'perm_parent_owner_id')
    op.drop_constraint(None, 'cmf_global_settings', type_='foreignkey')
    op.drop_constraint(None, 'cmf_global_settings', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_global_settings_tree_parent_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_perm_parent_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_perm_acl_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_parent_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_orderno'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_name'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_code'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_viewed_at'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_version'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_owner_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_owner_assistant_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_modified_by_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_modified_at'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_locked_by_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_locked_at'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_import_id'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_deleted'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_created_at'), table_name='cmf_global_settings')
    op.drop_index(op.f('ix_cmf_global_settings_cmf_author_id'), table_name='cmf_global_settings')
    op.drop_column('cmf_global_settings', 'perm_parent_id')
    op.drop_column('cmf_global_settings', 'perm_acl_id')
    op.drop_column('cmf_global_settings', 'tree_parent_id')
    op.drop_column('cmf_global_settings', 'cmf_import_id')
    op.drop_column('cmf_global_settings', 'cmf_locked_by_id')
    op.drop_column('cmf_global_settings', 'cmf_modified_by_id')
    op.drop_column('cmf_global_settings', 'parent_id')
    op.drop_column('cmf_global_settings', 'cmf_owner_assistant_id')
    op.drop_column('cmf_global_settings', 'cmf_owner_id')
    op.drop_column('cmf_global_settings', 'cmf_author_id')
    op.drop_column('cmf_global_settings', 'app_key')
    op.drop_column('cmf_global_settings', 'perm_encrypt')
    op.drop_column('cmf_global_settings', 'perm_effective_acl_id')
    op.drop_column('cmf_global_settings', 'perm_inherit_acl_id')
    op.drop_column('cmf_global_settings', 'perm_parent_owner_id')
    op.drop_column('cmf_global_settings', 'perm_inherit')
    op.drop_column('cmf_global_settings', 'perm_has_acl')
    op.drop_column('cmf_global_settings', 'perm_public')
    op.drop_column('cmf_global_settings', 'orderno')
    op.drop_column('cmf_global_settings', 'tree_hidden')
    op.drop_column('cmf_global_settings', 'tree_node_is_branch')
    op.drop_column('cmf_global_settings', 'has_tree_nodes')
    op.drop_column('cmf_global_settings', 'is_favorite')
    op.drop_column('cmf_global_settings', 'text')
    op.drop_column('cmf_global_settings', 'system')
    op.drop_column('cmf_global_settings', 'code')
    op.drop_column('cmf_global_settings', 'name')
    op.drop_column('cmf_global_settings', 'cmf_version')
    op.drop_column('cmf_global_settings', 'cmf_deleted')
    op.drop_column('cmf_global_settings', 'cmf_viewed_at')
    op.drop_column('cmf_global_settings', 'cmf_modified_at')
    op.drop_column('cmf_global_settings', 'cmf_created_at')
    op.drop_column('cmf_global_settings', 'cmf_locked_at')
    op.add_column('cmf_filter', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_filter', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_filter', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_filter', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_filter', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_filter_perm_parent_id'), table_name='cmf_filter')
    op.create_index('ix_cmf_filter_perm_inherit_parent_id', 'cmf_filter', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_filter', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_filter', 'perm_parent_id')
    op.drop_column('cmf_filter', 'perm_parent_owner_id')
    op.add_column('cmf_document_history', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document_history', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_document_history', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_document_history_perm_parent_id'), table_name='cmf_document_history')
    op.create_index('ix_cmf_document_history_perm_inherit_parent_id', 'cmf_document_history', ['perm_inherit_parent_id'], unique=False)
    op.drop_column('cmf_document_history', 'perm_parent_id')
    op.drop_column('cmf_document_history', 'perm_parent_owner_id')
    op.add_column('cmf_document', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_document', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_document', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_document_perm_parent_id'), table_name='cmf_document')
    op.create_index('ix_cmf_document_perm_inherit_parent_id', 'cmf_document', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_document', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_document', 'perm_parent_id')
    op.drop_column('cmf_document', 'text_draft')
    op.drop_column('cmf_document', 'perm_parent_owner_id')
    op.add_column('cmf_comment', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_comment', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_comment', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_comment', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_comment', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_comment_perm_parent_id'), table_name='cmf_comment')
    op.create_index('ix_cmf_comment_perm_inherit_parent_id', 'cmf_comment', ['perm_inherit_parent_id'], unique=False)
    op.alter_column('cmf_comment', 'cmf_version',
               existing_type=sa.BIGINT(),
               type_=sa.INTEGER(),
               existing_nullable=True)
    op.drop_column('cmf_comment', 'perm_parent_id')
    op.drop_column('cmf_comment', 'perm_parent_owner_id')
    op.alter_column('cmf_auth', 'phone',
               existing_type=sa.String(length=64),
               type_=sa.VARCHAR(length=32),
               existing_nullable=True)
    op.add_column('cmf_access_rule', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_rule', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_rule', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_rule', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_access_rule', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.drop_index(op.f('ix_cmf_access_rule_perm_parent_id'), table_name='cmf_access_rule')
    op.create_index('ix_cmf_access_rule_perm_inherit_parent_id', 'cmf_access_rule', ['perm_inherit_parent_id'], unique=False)
    op.drop_column('cmf_access_rule', 'perm_parent_id')
    op.drop_column('cmf_access_rule', 'perm_parent_owner_id')
    op.add_column('cmf_access_list', sa.Column('perm_policy_anonymous', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_list', sa.Column('perm_policy', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_list', sa.Column('perm_policy_guest', sa.VARCHAR(length=32), autoincrement=False, nullable=False))
    op.add_column('cmf_access_list', sa.Column('perm_inherit_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_access_list', sa.Column('perm_inherit_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True))
    op.add_column('cmf_access_list', sa.Column('policy', sa.VARCHAR(length=64), autoincrement=False, nullable=False))
    op.drop_index(op.f('ix_cmf_access_list_perm_parent_id'), table_name='cmf_access_list')
    op.create_index('ix_cmf_access_list_perm_inherit_parent_id', 'cmf_access_list', ['perm_inherit_parent_id'], unique=False)
    op.drop_column('cmf_access_list', 'perm_parent_id')
    op.drop_column('cmf_access_list', 'perm_parent_owner_id')
    op.drop_index(op.f('ix_cmf_document_history_cmf_sign_root_id'), table_name='cmf_document_history_cmf_sign')
    op.drop_index(op.f('ix_cmf_document_history_cmf_sign_right_id'), table_name='cmf_document_history_cmf_sign')
    op.drop_index(op.f('ix_cmf_document_history_cmf_sign_parent_id'), table_name='cmf_document_history_cmf_sign')
    op.drop_index(op.f('ix_cmf_document_history_cmf_sign_left_id'), table_name='cmf_document_history_cmf_sign')
    op.drop_table('cmf_document_history_cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_signed_object_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_parent_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_object_cmf_version'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_viewed_at'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_version'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_owner_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_owner_assistant_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_modified_by_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_modified_at'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_locked_by_id'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_locked_at'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_deleted'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_created_at'), table_name='cmf_sign')
    op.drop_index(op.f('ix_cmf_sign_cmf_author_id'), table_name='cmf_sign')
    op.drop_table('cmf_sign')
    # ### end Alembic commands ###