"""Add local_links to CmfActiveEntity

Revision ID: 2e15123892d9
Revises: c56c5e358c99
Create Date: 2023-02-10 09:30:37.004455

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '2e15123892d9'
down_revision = 'c56c5e358c99'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_chat_group_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_chat_group_local_links_left_id'), 'cmf_chat_group_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_group_local_links_parent_id'), 'cmf_chat_group_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_group_local_links_right_id'), 'cmf_chat_group_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_group_local_links_root_id'), 'cmf_chat_group_local_links', ['root_id'], unique=False)
    op.create_table('cmf_chat_topic_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_chat_topic_local_links_left_id'), 'cmf_chat_topic_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_topic_local_links_parent_id'), 'cmf_chat_topic_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_topic_local_links_right_id'), 'cmf_chat_topic_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_chat_topic_local_links_root_id'), 'cmf_chat_topic_local_links', ['root_id'], unique=False)
    op.create_table('cmf_company_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_company_local_links_left_id'), 'cmf_company_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_company_local_links_parent_id'), 'cmf_company_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_company_local_links_right_id'), 'cmf_company_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_company_local_links_root_id'), 'cmf_company_local_links', ['root_id'], unique=False)
    op.create_table('cmf_dashboard_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_dashboard_local_links_left_id'), 'cmf_dashboard_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_dashboard_local_links_parent_id'), 'cmf_dashboard_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_dashboard_local_links_right_id'), 'cmf_dashboard_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_dashboard_local_links_root_id'), 'cmf_dashboard_local_links', ['root_id'], unique=False)
    op.create_table('cmf_deal_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_deal_local_links_left_id'), 'cmf_deal_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_deal_local_links_parent_id'), 'cmf_deal_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_deal_local_links_right_id'), 'cmf_deal_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_deal_local_links_root_id'), 'cmf_deal_local_links', ['root_id'], unique=False)
    op.create_table('cmf_document_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_document_local_links_left_id'), 'cmf_document_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_local_links_parent_id'), 'cmf_document_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_local_links_right_id'), 'cmf_document_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_document_local_links_root_id'), 'cmf_document_local_links', ['root_id'], unique=False)
    op.create_table('cmf_folder_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_folder_local_links_left_id'), 'cmf_folder_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_folder_local_links_parent_id'), 'cmf_folder_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_folder_local_links_right_id'), 'cmf_folder_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_folder_local_links_root_id'), 'cmf_folder_local_links', ['root_id'], unique=False)
    op.create_table('cmf_import_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_import_local_links_left_id'), 'cmf_import_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_import_local_links_parent_id'), 'cmf_import_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_import_local_links_right_id'), 'cmf_import_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_import_local_links_root_id'), 'cmf_import_local_links', ['root_id'], unique=False)
    op.create_table('cmf_invoice_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_invoice_local_links_left_id'), 'cmf_invoice_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_invoice_local_links_parent_id'), 'cmf_invoice_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_invoice_local_links_right_id'), 'cmf_invoice_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_invoice_local_links_root_id'), 'cmf_invoice_local_links', ['root_id'], unique=False)
    op.create_table('cmf_kanban_board_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_kanban_board_local_links_left_id'), 'cmf_kanban_board_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_kanban_board_local_links_parent_id'), 'cmf_kanban_board_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_kanban_board_local_links_right_id'), 'cmf_kanban_board_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_kanban_board_local_links_root_id'), 'cmf_kanban_board_local_links', ['root_id'], unique=False)
    op.create_table('cmf_lead_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_lead_local_links_left_id'), 'cmf_lead_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_lead_local_links_parent_id'), 'cmf_lead_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_lead_local_links_right_id'), 'cmf_lead_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_lead_local_links_root_id'), 'cmf_lead_local_links', ['root_id'], unique=False)
    op.create_table('cmf_list_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_list_local_links_left_id'), 'cmf_list_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_list_local_links_parent_id'), 'cmf_list_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_list_local_links_right_id'), 'cmf_list_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_list_local_links_root_id'), 'cmf_list_local_links', ['root_id'], unique=False)
    op.create_table('cmf_mail_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_mail_local_links_left_id'), 'cmf_mail_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_mail_local_links_parent_id'), 'cmf_mail_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_mail_local_links_right_id'), 'cmf_mail_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_mail_local_links_root_id'), 'cmf_mail_local_links', ['root_id'], unique=False)
    op.create_table('cmf_payment_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_payment_local_links_left_id'), 'cmf_payment_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_payment_local_links_parent_id'), 'cmf_payment_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_payment_local_links_right_id'), 'cmf_payment_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_payment_local_links_root_id'), 'cmf_payment_local_links', ['root_id'], unique=False)
    op.create_table('cmf_pipeline_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_pipeline_local_links_left_id'), 'cmf_pipeline_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_pipeline_local_links_parent_id'), 'cmf_pipeline_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_pipeline_local_links_right_id'), 'cmf_pipeline_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_pipeline_local_links_root_id'), 'cmf_pipeline_local_links', ['root_id'], unique=False)
    op.create_table('cmf_project_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_project_local_links_left_id'), 'cmf_project_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_project_local_links_parent_id'), 'cmf_project_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_project_local_links_right_id'), 'cmf_project_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_project_local_links_root_id'), 'cmf_project_local_links', ['root_id'], unique=False)
    op.create_table('cmf_purchase_order_items_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_purchase_order_items_local_links_left_id'), 'cmf_purchase_order_items_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_items_local_links_parent_id'), 'cmf_purchase_order_items_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_items_local_links_right_id'), 'cmf_purchase_order_items_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_items_local_links_root_id'), 'cmf_purchase_order_items_local_links', ['root_id'], unique=False)
    op.create_table('cmf_purchase_order_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_purchase_order_local_links_left_id'), 'cmf_purchase_order_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_local_links_parent_id'), 'cmf_purchase_order_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_local_links_right_id'), 'cmf_purchase_order_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_purchase_order_local_links_root_id'), 'cmf_purchase_order_local_links', ['root_id'], unique=False)
    op.create_table('cmf_roadmap_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_roadmap_local_links_left_id'), 'cmf_roadmap_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_roadmap_local_links_parent_id'), 'cmf_roadmap_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_roadmap_local_links_right_id'), 'cmf_roadmap_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_roadmap_local_links_root_id'), 'cmf_roadmap_local_links', ['root_id'], unique=False)
    op.create_table('cmf_scheme_wf_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_scheme_wf_local_links_left_id'), 'cmf_scheme_wf_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_scheme_wf_local_links_parent_id'), 'cmf_scheme_wf_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_scheme_wf_local_links_right_id'), 'cmf_scheme_wf_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_scheme_wf_local_links_root_id'), 'cmf_scheme_wf_local_links', ['root_id'], unique=False)
    op.create_table('cmf_stock_incoming_order_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_stock_incoming_order_local_links_left_id'), 'cmf_stock_incoming_order_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_incoming_order_local_links_parent_id'), 'cmf_stock_incoming_order_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_incoming_order_local_links_right_id'), 'cmf_stock_incoming_order_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_incoming_order_local_links_root_id'), 'cmf_stock_incoming_order_local_links', ['root_id'], unique=False)
    op.create_table('cmf_stock_initial_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_stock_initial_local_links_left_id'), 'cmf_stock_initial_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_initial_local_links_parent_id'), 'cmf_stock_initial_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_initial_local_links_right_id'), 'cmf_stock_initial_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_initial_local_links_root_id'), 'cmf_stock_initial_local_links', ['root_id'], unique=False)
    op.create_table('cmf_stock_inventory_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_stock_inventory_local_links_left_id'), 'cmf_stock_inventory_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_inventory_local_links_parent_id'), 'cmf_stock_inventory_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_inventory_local_links_right_id'), 'cmf_stock_inventory_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_inventory_local_links_root_id'), 'cmf_stock_inventory_local_links', ['root_id'], unique=False)
    op.create_table('cmf_stock_move_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_stock_move_local_links_left_id'), 'cmf_stock_move_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_move_local_links_parent_id'), 'cmf_stock_move_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_move_local_links_right_id'), 'cmf_stock_move_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_move_local_links_root_id'), 'cmf_stock_move_local_links', ['root_id'], unique=False)
    op.create_table('cmf_stock_outcoming_order_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_stock_outcoming_order_local_links_left_id'), 'cmf_stock_outcoming_order_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_outcoming_order_local_links_parent_id'), 'cmf_stock_outcoming_order_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_outcoming_order_local_links_right_id'), 'cmf_stock_outcoming_order_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_stock_outcoming_order_local_links_root_id'), 'cmf_stock_outcoming_order_local_links', ['root_id'], unique=False)
    op.create_table('cmf_task_filter_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_task_filter_local_links_left_id'), 'cmf_task_filter_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_filter_local_links_parent_id'), 'cmf_task_filter_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_filter_local_links_right_id'), 'cmf_task_filter_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_filter_local_links_root_id'), 'cmf_task_filter_local_links', ['root_id'], unique=False)
    op.create_table('cmf_task_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_task_local_links_left_id'), 'cmf_task_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_local_links_parent_id'), 'cmf_task_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_local_links_right_id'), 'cmf_task_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_local_links_root_id'), 'cmf_task_local_links', ['root_id'], unique=False)
    op.create_table('cmf_task_report_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_task_report_local_links_left_id'), 'cmf_task_report_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_report_local_links_parent_id'), 'cmf_task_report_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_report_local_links_right_id'), 'cmf_task_report_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_task_report_local_links_root_id'), 'cmf_task_report_local_links', ['root_id'], unique=False)
    op.create_table('cmf_u_work_post_local_links',
    sa.Column('id', sa.String(length=128), 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.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_u_work_post_local_links_left_id'), 'cmf_u_work_post_local_links', ['left_id'], unique=False)
    op.create_index(op.f('ix_cmf_u_work_post_local_links_parent_id'), 'cmf_u_work_post_local_links', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_u_work_post_local_links_right_id'), 'cmf_u_work_post_local_links', ['right_id'], unique=False)
    op.create_index(op.f('ix_cmf_u_work_post_local_links_root_id'), 'cmf_u_work_post_local_links', ['root_id'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_u_work_post_local_links_root_id'), table_name='cmf_u_work_post_local_links')
    op.drop_index(op.f('ix_cmf_u_work_post_local_links_right_id'), table_name='cmf_u_work_post_local_links')
    op.drop_index(op.f('ix_cmf_u_work_post_local_links_parent_id'), table_name='cmf_u_work_post_local_links')
    op.drop_index(op.f('ix_cmf_u_work_post_local_links_left_id'), table_name='cmf_u_work_post_local_links')
    op.drop_table('cmf_u_work_post_local_links')
    op.drop_index(op.f('ix_cmf_task_report_local_links_root_id'), table_name='cmf_task_report_local_links')
    op.drop_index(op.f('ix_cmf_task_report_local_links_right_id'), table_name='cmf_task_report_local_links')
    op.drop_index(op.f('ix_cmf_task_report_local_links_parent_id'), table_name='cmf_task_report_local_links')
    op.drop_index(op.f('ix_cmf_task_report_local_links_left_id'), table_name='cmf_task_report_local_links')
    op.drop_table('cmf_task_report_local_links')
    op.drop_index(op.f('ix_cmf_task_local_links_root_id'), table_name='cmf_task_local_links')
    op.drop_index(op.f('ix_cmf_task_local_links_right_id'), table_name='cmf_task_local_links')
    op.drop_index(op.f('ix_cmf_task_local_links_parent_id'), table_name='cmf_task_local_links')
    op.drop_index(op.f('ix_cmf_task_local_links_left_id'), table_name='cmf_task_local_links')
    op.drop_table('cmf_task_local_links')
    op.drop_index(op.f('ix_cmf_task_filter_local_links_root_id'), table_name='cmf_task_filter_local_links')
    op.drop_index(op.f('ix_cmf_task_filter_local_links_right_id'), table_name='cmf_task_filter_local_links')
    op.drop_index(op.f('ix_cmf_task_filter_local_links_parent_id'), table_name='cmf_task_filter_local_links')
    op.drop_index(op.f('ix_cmf_task_filter_local_links_left_id'), table_name='cmf_task_filter_local_links')
    op.drop_table('cmf_task_filter_local_links')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_local_links_root_id'), table_name='cmf_stock_outcoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_local_links_right_id'), table_name='cmf_stock_outcoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_local_links_parent_id'), table_name='cmf_stock_outcoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_local_links_left_id'), table_name='cmf_stock_outcoming_order_local_links')
    op.drop_table('cmf_stock_outcoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_move_local_links_root_id'), table_name='cmf_stock_move_local_links')
    op.drop_index(op.f('ix_cmf_stock_move_local_links_right_id'), table_name='cmf_stock_move_local_links')
    op.drop_index(op.f('ix_cmf_stock_move_local_links_parent_id'), table_name='cmf_stock_move_local_links')
    op.drop_index(op.f('ix_cmf_stock_move_local_links_left_id'), table_name='cmf_stock_move_local_links')
    op.drop_table('cmf_stock_move_local_links')
    op.drop_index(op.f('ix_cmf_stock_inventory_local_links_root_id'), table_name='cmf_stock_inventory_local_links')
    op.drop_index(op.f('ix_cmf_stock_inventory_local_links_right_id'), table_name='cmf_stock_inventory_local_links')
    op.drop_index(op.f('ix_cmf_stock_inventory_local_links_parent_id'), table_name='cmf_stock_inventory_local_links')
    op.drop_index(op.f('ix_cmf_stock_inventory_local_links_left_id'), table_name='cmf_stock_inventory_local_links')
    op.drop_table('cmf_stock_inventory_local_links')
    op.drop_index(op.f('ix_cmf_stock_initial_local_links_root_id'), table_name='cmf_stock_initial_local_links')
    op.drop_index(op.f('ix_cmf_stock_initial_local_links_right_id'), table_name='cmf_stock_initial_local_links')
    op.drop_index(op.f('ix_cmf_stock_initial_local_links_parent_id'), table_name='cmf_stock_initial_local_links')
    op.drop_index(op.f('ix_cmf_stock_initial_local_links_left_id'), table_name='cmf_stock_initial_local_links')
    op.drop_table('cmf_stock_initial_local_links')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_local_links_root_id'), table_name='cmf_stock_incoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_local_links_right_id'), table_name='cmf_stock_incoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_local_links_parent_id'), table_name='cmf_stock_incoming_order_local_links')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_local_links_left_id'), table_name='cmf_stock_incoming_order_local_links')
    op.drop_table('cmf_stock_incoming_order_local_links')
    op.drop_index(op.f('ix_cmf_scheme_wf_local_links_root_id'), table_name='cmf_scheme_wf_local_links')
    op.drop_index(op.f('ix_cmf_scheme_wf_local_links_right_id'), table_name='cmf_scheme_wf_local_links')
    op.drop_index(op.f('ix_cmf_scheme_wf_local_links_parent_id'), table_name='cmf_scheme_wf_local_links')
    op.drop_index(op.f('ix_cmf_scheme_wf_local_links_left_id'), table_name='cmf_scheme_wf_local_links')
    op.drop_table('cmf_scheme_wf_local_links')
    op.drop_index(op.f('ix_cmf_roadmap_local_links_root_id'), table_name='cmf_roadmap_local_links')
    op.drop_index(op.f('ix_cmf_roadmap_local_links_right_id'), table_name='cmf_roadmap_local_links')
    op.drop_index(op.f('ix_cmf_roadmap_local_links_parent_id'), table_name='cmf_roadmap_local_links')
    op.drop_index(op.f('ix_cmf_roadmap_local_links_left_id'), table_name='cmf_roadmap_local_links')
    op.drop_table('cmf_roadmap_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_local_links_root_id'), table_name='cmf_purchase_order_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_local_links_right_id'), table_name='cmf_purchase_order_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_local_links_parent_id'), table_name='cmf_purchase_order_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_local_links_left_id'), table_name='cmf_purchase_order_local_links')
    op.drop_table('cmf_purchase_order_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_items_local_links_root_id'), table_name='cmf_purchase_order_items_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_items_local_links_right_id'), table_name='cmf_purchase_order_items_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_items_local_links_parent_id'), table_name='cmf_purchase_order_items_local_links')
    op.drop_index(op.f('ix_cmf_purchase_order_items_local_links_left_id'), table_name='cmf_purchase_order_items_local_links')
    op.drop_table('cmf_purchase_order_items_local_links')
    op.drop_index(op.f('ix_cmf_project_local_links_root_id'), table_name='cmf_project_local_links')
    op.drop_index(op.f('ix_cmf_project_local_links_right_id'), table_name='cmf_project_local_links')
    op.drop_index(op.f('ix_cmf_project_local_links_parent_id'), table_name='cmf_project_local_links')
    op.drop_index(op.f('ix_cmf_project_local_links_left_id'), table_name='cmf_project_local_links')
    op.drop_table('cmf_project_local_links')
    op.drop_index(op.f('ix_cmf_pipeline_local_links_root_id'), table_name='cmf_pipeline_local_links')
    op.drop_index(op.f('ix_cmf_pipeline_local_links_right_id'), table_name='cmf_pipeline_local_links')
    op.drop_index(op.f('ix_cmf_pipeline_local_links_parent_id'), table_name='cmf_pipeline_local_links')
    op.drop_index(op.f('ix_cmf_pipeline_local_links_left_id'), table_name='cmf_pipeline_local_links')
    op.drop_table('cmf_pipeline_local_links')
    op.drop_index(op.f('ix_cmf_payment_local_links_root_id'), table_name='cmf_payment_local_links')
    op.drop_index(op.f('ix_cmf_payment_local_links_right_id'), table_name='cmf_payment_local_links')
    op.drop_index(op.f('ix_cmf_payment_local_links_parent_id'), table_name='cmf_payment_local_links')
    op.drop_index(op.f('ix_cmf_payment_local_links_left_id'), table_name='cmf_payment_local_links')
    op.drop_table('cmf_payment_local_links')
    op.drop_index(op.f('ix_cmf_mail_local_links_root_id'), table_name='cmf_mail_local_links')
    op.drop_index(op.f('ix_cmf_mail_local_links_right_id'), table_name='cmf_mail_local_links')
    op.drop_index(op.f('ix_cmf_mail_local_links_parent_id'), table_name='cmf_mail_local_links')
    op.drop_index(op.f('ix_cmf_mail_local_links_left_id'), table_name='cmf_mail_local_links')
    op.drop_table('cmf_mail_local_links')
    op.drop_index(op.f('ix_cmf_list_local_links_root_id'), table_name='cmf_list_local_links')
    op.drop_index(op.f('ix_cmf_list_local_links_right_id'), table_name='cmf_list_local_links')
    op.drop_index(op.f('ix_cmf_list_local_links_parent_id'), table_name='cmf_list_local_links')
    op.drop_index(op.f('ix_cmf_list_local_links_left_id'), table_name='cmf_list_local_links')
    op.drop_table('cmf_list_local_links')
    op.drop_index(op.f('ix_cmf_lead_local_links_root_id'), table_name='cmf_lead_local_links')
    op.drop_index(op.f('ix_cmf_lead_local_links_right_id'), table_name='cmf_lead_local_links')
    op.drop_index(op.f('ix_cmf_lead_local_links_parent_id'), table_name='cmf_lead_local_links')
    op.drop_index(op.f('ix_cmf_lead_local_links_left_id'), table_name='cmf_lead_local_links')
    op.drop_table('cmf_lead_local_links')
    op.drop_index(op.f('ix_cmf_kanban_board_local_links_root_id'), table_name='cmf_kanban_board_local_links')
    op.drop_index(op.f('ix_cmf_kanban_board_local_links_right_id'), table_name='cmf_kanban_board_local_links')
    op.drop_index(op.f('ix_cmf_kanban_board_local_links_parent_id'), table_name='cmf_kanban_board_local_links')
    op.drop_index(op.f('ix_cmf_kanban_board_local_links_left_id'), table_name='cmf_kanban_board_local_links')
    op.drop_table('cmf_kanban_board_local_links')
    op.drop_index(op.f('ix_cmf_invoice_local_links_root_id'), table_name='cmf_invoice_local_links')
    op.drop_index(op.f('ix_cmf_invoice_local_links_right_id'), table_name='cmf_invoice_local_links')
    op.drop_index(op.f('ix_cmf_invoice_local_links_parent_id'), table_name='cmf_invoice_local_links')
    op.drop_index(op.f('ix_cmf_invoice_local_links_left_id'), table_name='cmf_invoice_local_links')
    op.drop_table('cmf_invoice_local_links')
    op.drop_index(op.f('ix_cmf_import_local_links_root_id'), table_name='cmf_import_local_links')
    op.drop_index(op.f('ix_cmf_import_local_links_right_id'), table_name='cmf_import_local_links')
    op.drop_index(op.f('ix_cmf_import_local_links_parent_id'), table_name='cmf_import_local_links')
    op.drop_index(op.f('ix_cmf_import_local_links_left_id'), table_name='cmf_import_local_links')
    op.drop_table('cmf_import_local_links')
    op.drop_index(op.f('ix_cmf_folder_local_links_root_id'), table_name='cmf_folder_local_links')
    op.drop_index(op.f('ix_cmf_folder_local_links_right_id'), table_name='cmf_folder_local_links')
    op.drop_index(op.f('ix_cmf_folder_local_links_parent_id'), table_name='cmf_folder_local_links')
    op.drop_index(op.f('ix_cmf_folder_local_links_left_id'), table_name='cmf_folder_local_links')
    op.drop_table('cmf_folder_local_links')
    op.drop_index(op.f('ix_cmf_document_local_links_root_id'), table_name='cmf_document_local_links')
    op.drop_index(op.f('ix_cmf_document_local_links_right_id'), table_name='cmf_document_local_links')
    op.drop_index(op.f('ix_cmf_document_local_links_parent_id'), table_name='cmf_document_local_links')
    op.drop_index(op.f('ix_cmf_document_local_links_left_id'), table_name='cmf_document_local_links')
    op.drop_table('cmf_document_local_links')
    op.drop_index(op.f('ix_cmf_deal_local_links_root_id'), table_name='cmf_deal_local_links')
    op.drop_index(op.f('ix_cmf_deal_local_links_right_id'), table_name='cmf_deal_local_links')
    op.drop_index(op.f('ix_cmf_deal_local_links_parent_id'), table_name='cmf_deal_local_links')
    op.drop_index(op.f('ix_cmf_deal_local_links_left_id'), table_name='cmf_deal_local_links')
    op.drop_table('cmf_deal_local_links')
    op.drop_index(op.f('ix_cmf_dashboard_local_links_root_id'), table_name='cmf_dashboard_local_links')
    op.drop_index(op.f('ix_cmf_dashboard_local_links_right_id'), table_name='cmf_dashboard_local_links')
    op.drop_index(op.f('ix_cmf_dashboard_local_links_parent_id'), table_name='cmf_dashboard_local_links')
    op.drop_index(op.f('ix_cmf_dashboard_local_links_left_id'), table_name='cmf_dashboard_local_links')
    op.drop_table('cmf_dashboard_local_links')
    op.drop_index(op.f('ix_cmf_company_local_links_root_id'), table_name='cmf_company_local_links')
    op.drop_index(op.f('ix_cmf_company_local_links_right_id'), table_name='cmf_company_local_links')
    op.drop_index(op.f('ix_cmf_company_local_links_parent_id'), table_name='cmf_company_local_links')
    op.drop_index(op.f('ix_cmf_company_local_links_left_id'), table_name='cmf_company_local_links')
    op.drop_table('cmf_company_local_links')
    op.drop_index(op.f('ix_cmf_chat_topic_local_links_root_id'), table_name='cmf_chat_topic_local_links')
    op.drop_index(op.f('ix_cmf_chat_topic_local_links_right_id'), table_name='cmf_chat_topic_local_links')
    op.drop_index(op.f('ix_cmf_chat_topic_local_links_parent_id'), table_name='cmf_chat_topic_local_links')
    op.drop_index(op.f('ix_cmf_chat_topic_local_links_left_id'), table_name='cmf_chat_topic_local_links')
    op.drop_table('cmf_chat_topic_local_links')
    op.drop_index(op.f('ix_cmf_chat_group_local_links_root_id'), table_name='cmf_chat_group_local_links')
    op.drop_index(op.f('ix_cmf_chat_group_local_links_right_id'), table_name='cmf_chat_group_local_links')
    op.drop_index(op.f('ix_cmf_chat_group_local_links_parent_id'), table_name='cmf_chat_group_local_links')
    op.drop_index(op.f('ix_cmf_chat_group_local_links_left_id'), table_name='cmf_chat_group_local_links')
    op.drop_table('cmf_chat_group_local_links')
    # ### end Alembic commands ###