"""add root_parent field

Revision ID: 4ed8a3640bc2
Revises: a2d03eed99a5
Create Date: 2023-02-02 15:08:51.643650

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '4ed8a3640bc2'
down_revision = 'a2d03eed99a5'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_access_list', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_access_list_root_parent_id'), 'cmf_access_list', ['root_parent_id'], unique=False)
    op.add_column('cmf_access_rule', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_access_rule_root_parent_id'), 'cmf_access_rule', ['root_parent_id'], unique=False)
    op.add_column('cmf_active_entity_filter', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_active_entity_filter_root_parent_id'), 'cmf_active_entity_filter', ['root_parent_id'], unique=False)
    op.add_column('cmf_activity', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_activity_root_parent_id'), 'cmf_activity', ['root_parent_id'], unique=False)
    op.add_column('cmf_attachment', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_attachment_root_parent_id'), 'cmf_attachment', ['root_parent_id'], unique=False)
    op.add_column('cmf_auth_ldap_plugin', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_auth_ldap_plugin_root_parent_id'), 'cmf_auth_ldap_plugin', ['root_parent_id'], unique=False)
    op.add_column('cmf_auth_plugin_data', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_auth_plugin_data_root_parent_id'), 'cmf_auth_plugin_data', ['root_parent_id'], unique=False)
    op.add_column('cmf_automation_cron_trigger', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_automation_cron_trigger_root_parent_id'), 'cmf_automation_cron_trigger', ['root_parent_id'], unique=False)
    op.add_column('cmf_automation_crud_trigger', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_automation_crud_trigger_root_parent_id'), 'cmf_automation_crud_trigger', ['root_parent_id'], unique=False)
    op.add_column('cmf_balance', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_balance_root_parent_id'), 'cmf_balance', ['root_parent_id'], unique=False)
    op.add_column('cmf_balance_operation', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_balance_operation_root_parent_id'), 'cmf_balance_operation', ['root_parent_id'], unique=False)
    op.add_column('cmf_card', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_card_root_parent_id'), 'cmf_card', ['root_parent_id'], unique=False)
    op.add_column('cmf_chat_group', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_chat_group_root_parent_id'), 'cmf_chat_group', ['root_parent_id'], unique=False)
    op.add_column('cmf_chat_message', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_chat_message_root_parent_id'), 'cmf_chat_message', ['root_parent_id'], unique=False)
    op.add_column('cmf_chat_topic', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_chat_topic_root_parent_id'), 'cmf_chat_topic', ['root_parent_id'], unique=False)
    op.add_column('cmf_comment', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_comment_root_parent_id'), 'cmf_comment', ['root_parent_id'], unique=False)
    op.add_column('cmf_company', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_company_root_parent_id'), 'cmf_company', ['root_parent_id'], unique=False)
    op.add_column('cmf_contract', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_contract_root_parent_id'), 'cmf_contract', ['root_parent_id'], unique=False)
    op.add_column('cmf_currency', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_currency_root_parent_id'), 'cmf_currency', ['root_parent_id'], unique=False)
    op.add_column('cmf_dashboard', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_dashboard_root_parent_id'), 'cmf_dashboard', ['root_parent_id'], unique=False)
    op.add_column('cmf_deal', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_deal_root_parent_id'), 'cmf_deal', ['root_parent_id'], unique=False)
    op.add_column('cmf_deal_items', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_deal_items_root_parent_id'), 'cmf_deal_items', ['root_parent_id'], unique=False)
    op.add_column('cmf_document', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_document_root_parent_id'), 'cmf_document', ['root_parent_id'], unique=False)
    op.add_column('cmf_document_history', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_document_history_root_parent_id'), 'cmf_document_history', ['root_parent_id'], unique=False)
    op.add_column('cmf_filter', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_filter_root_parent_id'), 'cmf_filter', ['root_parent_id'], unique=False)
    op.add_column('cmf_folder', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_folder_root_parent_id'), 'cmf_folder', ['root_parent_id'], unique=False)
    op.add_column('cmf_follower', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_follower_root_parent_id'), 'cmf_follower', ['root_parent_id'], unique=False)
    op.add_column('cmf_form', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_form_root_parent_id'), 'cmf_form', ['root_parent_id'], unique=False)
    op.add_column('cmf_form_field', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_form_field_root_parent_id'), 'cmf_form_field', ['root_parent_id'], unique=False)
    op.add_column('cmf_gantt_baseline', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_gantt_baseline_root_parent_id'), 'cmf_gantt_baseline', ['root_parent_id'], unique=False)
    op.add_column('cmf_git_branch', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_git_branch_root_parent_id'), 'cmf_git_branch', ['root_parent_id'], unique=False)
    op.add_column('cmf_git_commit', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_git_commit_root_parent_id'), 'cmf_git_commit', ['root_parent_id'], unique=False)
    op.add_column('cmf_git_merge_request', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_git_merge_request_root_parent_id'), 'cmf_git_merge_request', ['root_parent_id'], unique=False)
    op.add_column('cmf_git_repo', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_git_repo_root_parent_id'), 'cmf_git_repo', ['root_parent_id'], unique=False)
    op.add_column('cmf_global_settings', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_global_settings_root_parent_id'), 'cmf_global_settings', ['root_parent_id'], unique=False)
    op.add_column('cmf_import', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_import_root_parent_id'), 'cmf_import', ['root_parent_id'], unique=False)
    op.add_column('cmf_integration', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_integration_root_parent_id'), 'cmf_integration', ['root_parent_id'], unique=False)
    op.add_column('cmf_invoice', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_invoice_root_parent_id'), 'cmf_invoice', ['root_parent_id'], unique=False)
    op.add_column('cmf_invoice_items', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_invoice_items_root_parent_id'), 'cmf_invoice_items', ['root_parent_id'], unique=False)
    op.add_column('cmf_job', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_job_root_parent_id'), 'cmf_job', ['root_parent_id'], unique=False)
    op.add_column('cmf_kanban_board', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_kanban_board_root_parent_id'), 'cmf_kanban_board', ['root_parent_id'], unique=False)
    op.add_column('cmf_kanban_board_column', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_kanban_board_column_root_parent_id'), 'cmf_kanban_board_column', ['root_parent_id'], unique=False)
    op.add_column('cmf_lead', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_lead_root_parent_id'), 'cmf_lead', ['root_parent_id'], unique=False)
    op.add_column('cmf_lead_mailbox', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_lead_mailbox_root_parent_id'), 'cmf_lead_mailbox', ['root_parent_id'], unique=False)
    op.add_column('cmf_license', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_license_root_parent_id'), 'cmf_license', ['root_parent_id'], unique=False)
    op.add_column('cmf_link', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_link_root_parent_id'), 'cmf_link', ['root_parent_id'], unique=False)
    op.add_column('cmf_list', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_list_root_parent_id'), 'cmf_list', ['root_parent_id'], unique=False)
    op.add_column('cmf_logic_type', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_logic_type_root_parent_id'), 'cmf_logic_type', ['root_parent_id'], unique=False)
    op.add_column('cmf_mail', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_mail_root_parent_id'), 'cmf_mail', ['root_parent_id'], unique=False)
    op.add_column('cmf_mail_signature', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_mail_signature_root_parent_id'), 'cmf_mail_signature', ['root_parent_id'], unique=False)
    op.add_column('cmf_mail_template', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_mail_template_root_parent_id'), 'cmf_mail_template', ['root_parent_id'], unique=False)
    op.add_column('cmf_mailbox', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_mailbox_root_parent_id'), 'cmf_mailbox', ['root_parent_id'], unique=False)
    op.add_column('cmf_menu_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_menu_item_root_parent_id'), 'cmf_menu_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_menu_tree', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_menu_tree_root_parent_id'), 'cmf_menu_tree', ['root_parent_id'], unique=False)
    op.add_column('cmf_menu_tree_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_menu_tree_item_root_parent_id'), 'cmf_menu_tree_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_notify', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_notify_root_parent_id'), 'cmf_notify', ['root_parent_id'], unique=False)
    op.add_column('cmf_org_unit', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_org_unit_root_parent_id'), 'cmf_org_unit', ['root_parent_id'], unique=False)
    op.add_column('cmf_payment', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_payment_root_parent_id'), 'cmf_payment', ['root_parent_id'], unique=False)
    op.add_column('cmf_person', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_person_root_parent_id'), 'cmf_person', ['root_parent_id'], unique=False)
    op.add_column('cmf_person_group', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_person_group_root_parent_id'), 'cmf_person_group', ['root_parent_id'], unique=False)
    op.add_column('cmf_person_var', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_person_var_root_parent_id'), 'cmf_person_var', ['root_parent_id'], unique=False)
    op.add_column('cmf_pipeline', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_pipeline_root_parent_id'), 'cmf_pipeline', ['root_parent_id'], unique=False)
    op.add_column('cmf_plan', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plan_root_parent_id'), 'cmf_plan', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_root_parent_id'), 'cmf_plugin', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_asana', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_asana_root_parent_id'), 'cmf_plugin_asana', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_confluence', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_confluence_root_parent_id'), 'cmf_plugin_confluence', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_csv', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_csv_root_parent_id'), 'cmf_plugin_csv', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_git', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_git_root_parent_id'), 'cmf_plugin_git', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_jira', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_jira_root_parent_id'), 'cmf_plugin_jira', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_mail_box', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_mail_box_root_parent_id'), 'cmf_plugin_mail_box', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_s_m_s_gate', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_s_m_s_gate_root_parent_id'), 'cmf_plugin_s_m_s_gate', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_telphin', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_telphin_root_parent_id'), 'cmf_plugin_telphin', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_trello', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_trello_root_parent_id'), 'cmf_plugin_trello', ['root_parent_id'], unique=False)
    op.add_column('cmf_plugin_zadarma', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_plugin_zadarma_root_parent_id'), 'cmf_plugin_zadarma', ['root_parent_id'], unique=False)
    op.add_column('cmf_price', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_price_root_parent_id'), 'cmf_price', ['root_parent_id'], unique=False)
    op.add_column('cmf_print_tmpl', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_print_tmpl_root_parent_id'), 'cmf_print_tmpl', ['root_parent_id'], unique=False)
    op.add_column('cmf_product', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_product_root_parent_id'), 'cmf_product', ['root_parent_id'], unique=False)
    op.add_column('cmf_project', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_root_parent_id'), 'cmf_project', ['root_parent_id'], unique=False)
    op.add_column('cmf_project_perm_permission', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_perm_permission_root_parent_id'), 'cmf_project_perm_permission', ['root_parent_id'], unique=False)
    op.add_column('cmf_project_perm_scheme', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_perm_scheme_root_parent_id'), 'cmf_project_perm_scheme', ['root_parent_id'], unique=False)
    op.add_column('cmf_project_perm_scheme_rule', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_perm_scheme_rule_root_parent_id'), 'cmf_project_perm_scheme_rule', ['root_parent_id'], unique=False)
    op.add_column('cmf_project_role', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_role_root_parent_id'), 'cmf_project_role', ['root_parent_id'], unique=False)
    op.add_column('cmf_project_role_assign', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_project_role_assign_root_parent_id'), 'cmf_project_role_assign', ['root_parent_id'], unique=False)
    op.add_column('cmf_purchase_order', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_purchase_order_root_parent_id'), 'cmf_purchase_order', ['root_parent_id'], unique=False)
    op.add_column('cmf_purchase_order_items', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_purchase_order_items_root_parent_id'), 'cmf_purchase_order_items', ['root_parent_id'], unique=False)
    op.add_column('cmf_refbook', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_refbook_root_parent_id'), 'cmf_refbook', ['root_parent_id'], unique=False)
    op.add_column('cmf_relation_option', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_relation_option_root_parent_id'), 'cmf_relation_option', ['root_parent_id'], unique=False)
    op.add_column('cmf_relation_type', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_relation_type_root_parent_id'), 'cmf_relation_type', ['root_parent_id'], unique=False)
    op.add_column('cmf_roadmap', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_roadmap_root_parent_id'), 'cmf_roadmap', ['root_parent_id'], unique=False)
    op.add_column('cmf_role', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_role_root_parent_id'), 'cmf_role', ['root_parent_id'], unique=False)
    op.add_column('cmf_sale_menu_group', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_sale_menu_group_root_parent_id'), 'cmf_sale_menu_group', ['root_parent_id'], unique=False)
    op.add_column('cmf_scheme_wf', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_scheme_wf_root_parent_id'), 'cmf_scheme_wf', ['root_parent_id'], unique=False)
    op.add_column('cmf_scheme_wf_rule', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_scheme_wf_rule_root_parent_id'), 'cmf_scheme_wf_rule', ['root_parent_id'], unique=False)
    op.add_column('cmf_staff_control_settings', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_staff_control_settings_root_parent_id'), 'cmf_staff_control_settings', ['root_parent_id'], unique=False)
    op.add_column('cmf_status', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_status_root_parent_id'), 'cmf_status', ['root_parent_id'], unique=False)
    op.add_column('cmf_status_code', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_status_code_root_parent_id'), 'cmf_status_code', ['root_parent_id'], unique=False)
    op.add_column('cmf_status_opt', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_status_opt_root_parent_id'), 'cmf_status_opt', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_root_parent_id'), 'cmf_stock', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_incoming_order', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_incoming_order_root_parent_id'), 'cmf_stock_incoming_order', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_incoming_order_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_incoming_order_item_root_parent_id'), 'cmf_stock_incoming_order_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_initial', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_initial_root_parent_id'), 'cmf_stock_initial', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_initial_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_initial_item_root_parent_id'), 'cmf_stock_initial_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_inventory', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_inventory_root_parent_id'), 'cmf_stock_inventory', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_inventory_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_inventory_item_root_parent_id'), 'cmf_stock_inventory_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_item_root_parent_id'), 'cmf_stock_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_menu_group', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_menu_group_root_parent_id'), 'cmf_stock_menu_group', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_move', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_move_root_parent_id'), 'cmf_stock_move', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_move_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_move_item_root_parent_id'), 'cmf_stock_move_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_operation', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_operation_root_parent_id'), 'cmf_stock_operation', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_operation_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_operation_item_root_parent_id'), 'cmf_stock_operation_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_outcoming_order', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_outcoming_order_root_parent_id'), 'cmf_stock_outcoming_order', ['root_parent_id'], unique=False)
    op.add_column('cmf_stock_outcoming_order_item', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_stock_outcoming_order_item_root_parent_id'), 'cmf_stock_outcoming_order_item', ['root_parent_id'], unique=False)
    op.add_column('cmf_subscription', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_subscription_root_parent_id'), 'cmf_subscription', ['root_parent_id'], unique=False)
    op.add_column('cmf_tag', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_tag_root_parent_id'), 'cmf_tag', ['root_parent_id'], unique=False)
    op.add_column('cmf_tag_category', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_tag_category_root_parent_id'), 'cmf_tag_category', ['root_parent_id'], unique=False)
    op.add_column('cmf_task', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_task_root_parent_id'), 'cmf_task', ['root_parent_id'], unique=False)
    op.add_column('cmf_task_filter', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_task_filter_root_parent_id'), 'cmf_task_filter', ['root_parent_id'], unique=False)
    op.add_column('cmf_task_report', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_task_report_root_parent_id'), 'cmf_task_report', ['root_parent_id'], unique=False)
    op.add_column('cmf_time_tracker', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_time_tracker_root_parent_id'), 'cmf_time_tracker', ['root_parent_id'], unique=False)
    op.add_column('cmf_time_tracker_history', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_time_tracker_history_root_parent_id'), 'cmf_time_tracker_history', ['root_parent_id'], unique=False)
    op.add_column('cmf_trans', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_trans_root_parent_id'), 'cmf_trans', ['root_parent_id'], unique=False)
    op.add_column('cmf_trans_action', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_trans_action_root_parent_id'), 'cmf_trans_action', ['root_parent_id'], unique=False)
    op.add_column('cmf_trans_filter', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_trans_filter_root_parent_id'), 'cmf_trans_filter', ['root_parent_id'], unique=False)
    op.add_column('cmf_trans_valid', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_trans_valid_root_parent_id'), 'cmf_trans_valid', ['root_parent_id'], unique=False)
    op.add_column('cmf_trigger', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_trigger_root_parent_id'), 'cmf_trigger', ['root_parent_id'], unique=False)
    op.add_column('cmf_u_work_post', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_u_work_post_root_parent_id'), 'cmf_u_work_post', ['root_parent_id'], unique=False)
    op.add_column('cmf_ui_form', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_ui_form_root_parent_id'), 'cmf_ui_form', ['root_parent_id'], unique=False)
    op.add_column('cmf_ui_form_scheme', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_ui_form_scheme_root_parent_id'), 'cmf_ui_form_scheme', ['root_parent_id'], unique=False)
    op.add_column('cmf_ui_form_scheme_rule', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_ui_form_scheme_rule_root_parent_id'), 'cmf_ui_form_scheme_rule', ['root_parent_id'], unique=False)
    op.add_column('cmf_unit', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_unit_root_parent_id'), 'cmf_unit', ['root_parent_id'], unique=False)
    op.add_column('cmf_webhook', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_webhook_root_parent_id'), 'cmf_webhook', ['root_parent_id'], unique=False)
    op.add_column('cmf_whatsapp', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_whatsapp_root_parent_id'), 'cmf_whatsapp', ['root_parent_id'], unique=False)
    op.add_column('cmf_wiki', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_wiki_root_parent_id'), 'cmf_wiki', ['root_parent_id'], unique=False)
    op.add_column('cmf_workflow', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_workflow_root_parent_id'), 'cmf_workflow', ['root_parent_id'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_workflow_root_parent_id'), table_name='cmf_workflow')
    op.drop_column('cmf_workflow', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_wiki_root_parent_id'), table_name='cmf_wiki')
    op.drop_column('cmf_wiki', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_whatsapp_root_parent_id'), table_name='cmf_whatsapp')
    op.drop_column('cmf_whatsapp', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_webhook_root_parent_id'), table_name='cmf_webhook')
    op.drop_column('cmf_webhook', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_unit_root_parent_id'), table_name='cmf_unit')
    op.drop_column('cmf_unit', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_ui_form_scheme_rule_root_parent_id'), table_name='cmf_ui_form_scheme_rule')
    op.drop_column('cmf_ui_form_scheme_rule', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_ui_form_scheme_root_parent_id'), table_name='cmf_ui_form_scheme')
    op.drop_column('cmf_ui_form_scheme', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_ui_form_root_parent_id'), table_name='cmf_ui_form')
    op.drop_column('cmf_ui_form', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_u_work_post_root_parent_id'), table_name='cmf_u_work_post')
    op.drop_column('cmf_u_work_post', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_trigger_root_parent_id'), table_name='cmf_trigger')
    op.drop_column('cmf_trigger', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_trans_valid_root_parent_id'), table_name='cmf_trans_valid')
    op.drop_column('cmf_trans_valid', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_trans_filter_root_parent_id'), table_name='cmf_trans_filter')
    op.drop_column('cmf_trans_filter', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_trans_action_root_parent_id'), table_name='cmf_trans_action')
    op.drop_column('cmf_trans_action', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_trans_root_parent_id'), table_name='cmf_trans')
    op.drop_column('cmf_trans', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_time_tracker_history_root_parent_id'), table_name='cmf_time_tracker_history')
    op.drop_column('cmf_time_tracker_history', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_time_tracker_root_parent_id'), table_name='cmf_time_tracker')
    op.drop_column('cmf_time_tracker', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_task_report_root_parent_id'), table_name='cmf_task_report')
    op.drop_column('cmf_task_report', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_task_filter_root_parent_id'), table_name='cmf_task_filter')
    op.drop_column('cmf_task_filter', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_task_root_parent_id'), table_name='cmf_task')
    op.drop_column('cmf_task', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_tag_category_root_parent_id'), table_name='cmf_tag_category')
    op.drop_column('cmf_tag_category', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_tag_root_parent_id'), table_name='cmf_tag')
    op.drop_column('cmf_tag', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_subscription_root_parent_id'), table_name='cmf_subscription')
    op.drop_column('cmf_subscription', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_item_root_parent_id'), table_name='cmf_stock_outcoming_order_item')
    op.drop_column('cmf_stock_outcoming_order_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_outcoming_order_root_parent_id'), table_name='cmf_stock_outcoming_order')
    op.drop_column('cmf_stock_outcoming_order', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_operation_item_root_parent_id'), table_name='cmf_stock_operation_item')
    op.drop_column('cmf_stock_operation_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_operation_root_parent_id'), table_name='cmf_stock_operation')
    op.drop_column('cmf_stock_operation', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_move_item_root_parent_id'), table_name='cmf_stock_move_item')
    op.drop_column('cmf_stock_move_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_move_root_parent_id'), table_name='cmf_stock_move')
    op.drop_column('cmf_stock_move', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_menu_group_root_parent_id'), table_name='cmf_stock_menu_group')
    op.drop_column('cmf_stock_menu_group', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_item_root_parent_id'), table_name='cmf_stock_item')
    op.drop_column('cmf_stock_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_inventory_item_root_parent_id'), table_name='cmf_stock_inventory_item')
    op.drop_column('cmf_stock_inventory_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_inventory_root_parent_id'), table_name='cmf_stock_inventory')
    op.drop_column('cmf_stock_inventory', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_initial_item_root_parent_id'), table_name='cmf_stock_initial_item')
    op.drop_column('cmf_stock_initial_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_initial_root_parent_id'), table_name='cmf_stock_initial')
    op.drop_column('cmf_stock_initial', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_item_root_parent_id'), table_name='cmf_stock_incoming_order_item')
    op.drop_column('cmf_stock_incoming_order_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_incoming_order_root_parent_id'), table_name='cmf_stock_incoming_order')
    op.drop_column('cmf_stock_incoming_order', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_stock_root_parent_id'), table_name='cmf_stock')
    op.drop_column('cmf_stock', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_status_opt_root_parent_id'), table_name='cmf_status_opt')
    op.drop_column('cmf_status_opt', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_status_code_root_parent_id'), table_name='cmf_status_code')
    op.drop_column('cmf_status_code', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_status_root_parent_id'), table_name='cmf_status')
    op.drop_column('cmf_status', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_staff_control_settings_root_parent_id'), table_name='cmf_staff_control_settings')
    op.drop_column('cmf_staff_control_settings', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_scheme_wf_rule_root_parent_id'), table_name='cmf_scheme_wf_rule')
    op.drop_column('cmf_scheme_wf_rule', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_scheme_wf_root_parent_id'), table_name='cmf_scheme_wf')
    op.drop_column('cmf_scheme_wf', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_sale_menu_group_root_parent_id'), table_name='cmf_sale_menu_group')
    op.drop_column('cmf_sale_menu_group', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_role_root_parent_id'), table_name='cmf_role')
    op.drop_column('cmf_role', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_roadmap_root_parent_id'), table_name='cmf_roadmap')
    op.drop_column('cmf_roadmap', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_relation_type_root_parent_id'), table_name='cmf_relation_type')
    op.drop_column('cmf_relation_type', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_relation_option_root_parent_id'), table_name='cmf_relation_option')
    op.drop_column('cmf_relation_option', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_refbook_root_parent_id'), table_name='cmf_refbook')
    op.drop_column('cmf_refbook', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_purchase_order_items_root_parent_id'), table_name='cmf_purchase_order_items')
    op.drop_column('cmf_purchase_order_items', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_purchase_order_root_parent_id'), table_name='cmf_purchase_order')
    op.drop_column('cmf_purchase_order', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_role_assign_root_parent_id'), table_name='cmf_project_role_assign')
    op.drop_column('cmf_project_role_assign', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_role_root_parent_id'), table_name='cmf_project_role')
    op.drop_column('cmf_project_role', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_perm_scheme_rule_root_parent_id'), table_name='cmf_project_perm_scheme_rule')
    op.drop_column('cmf_project_perm_scheme_rule', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_perm_scheme_root_parent_id'), table_name='cmf_project_perm_scheme')
    op.drop_column('cmf_project_perm_scheme', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_perm_permission_root_parent_id'), table_name='cmf_project_perm_permission')
    op.drop_column('cmf_project_perm_permission', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_project_root_parent_id'), table_name='cmf_project')
    op.drop_column('cmf_project', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_product_root_parent_id'), table_name='cmf_product')
    op.drop_column('cmf_product', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_print_tmpl_root_parent_id'), table_name='cmf_print_tmpl')
    op.drop_column('cmf_print_tmpl', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_price_root_parent_id'), table_name='cmf_price')
    op.drop_column('cmf_price', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_zadarma_root_parent_id'), table_name='cmf_plugin_zadarma')
    op.drop_column('cmf_plugin_zadarma', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_trello_root_parent_id'), table_name='cmf_plugin_trello')
    op.drop_column('cmf_plugin_trello', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_telphin_root_parent_id'), table_name='cmf_plugin_telphin')
    op.drop_column('cmf_plugin_telphin', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_s_m_s_gate_root_parent_id'), table_name='cmf_plugin_s_m_s_gate')
    op.drop_column('cmf_plugin_s_m_s_gate', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_mail_box_root_parent_id'), table_name='cmf_plugin_mail_box')
    op.drop_column('cmf_plugin_mail_box', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_jira_root_parent_id'), table_name='cmf_plugin_jira')
    op.drop_column('cmf_plugin_jira', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_git_root_parent_id'), table_name='cmf_plugin_git')
    op.drop_column('cmf_plugin_git', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_csv_root_parent_id'), table_name='cmf_plugin_csv')
    op.drop_column('cmf_plugin_csv', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_confluence_root_parent_id'), table_name='cmf_plugin_confluence')
    op.drop_column('cmf_plugin_confluence', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_asana_root_parent_id'), table_name='cmf_plugin_asana')
    op.drop_column('cmf_plugin_asana', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plugin_root_parent_id'), table_name='cmf_plugin')
    op.drop_column('cmf_plugin', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_plan_root_parent_id'), table_name='cmf_plan')
    op.drop_column('cmf_plan', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_pipeline_root_parent_id'), table_name='cmf_pipeline')
    op.drop_column('cmf_pipeline', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_person_var_root_parent_id'), table_name='cmf_person_var')
    op.drop_column('cmf_person_var', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_person_group_root_parent_id'), table_name='cmf_person_group')
    op.drop_column('cmf_person_group', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_person_root_parent_id'), table_name='cmf_person')
    op.drop_column('cmf_person', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_payment_root_parent_id'), table_name='cmf_payment')
    op.drop_column('cmf_payment', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_org_unit_root_parent_id'), table_name='cmf_org_unit')
    op.drop_column('cmf_org_unit', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_notify_root_parent_id'), table_name='cmf_notify')
    op.drop_column('cmf_notify', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_menu_tree_item_root_parent_id'), table_name='cmf_menu_tree_item')
    op.drop_column('cmf_menu_tree_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_menu_tree_root_parent_id'), table_name='cmf_menu_tree')
    op.drop_column('cmf_menu_tree', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_menu_item_root_parent_id'), table_name='cmf_menu_item')
    op.drop_column('cmf_menu_item', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_mailbox_root_parent_id'), table_name='cmf_mailbox')
    op.drop_column('cmf_mailbox', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_mail_template_root_parent_id'), table_name='cmf_mail_template')
    op.drop_column('cmf_mail_template', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_mail_signature_root_parent_id'), table_name='cmf_mail_signature')
    op.drop_column('cmf_mail_signature', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_mail_root_parent_id'), table_name='cmf_mail')
    op.drop_column('cmf_mail', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_logic_type_root_parent_id'), table_name='cmf_logic_type')
    op.drop_column('cmf_logic_type', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_list_root_parent_id'), table_name='cmf_list')
    op.drop_column('cmf_list', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_link_root_parent_id'), table_name='cmf_link')
    op.drop_column('cmf_link', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_license_root_parent_id'), table_name='cmf_license')
    op.drop_column('cmf_license', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_lead_mailbox_root_parent_id'), table_name='cmf_lead_mailbox')
    op.drop_column('cmf_lead_mailbox', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_lead_root_parent_id'), table_name='cmf_lead')
    op.drop_column('cmf_lead', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_kanban_board_column_root_parent_id'), table_name='cmf_kanban_board_column')
    op.drop_column('cmf_kanban_board_column', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_kanban_board_root_parent_id'), table_name='cmf_kanban_board')
    op.drop_column('cmf_kanban_board', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_job_root_parent_id'), table_name='cmf_job')
    op.drop_column('cmf_job', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_invoice_items_root_parent_id'), table_name='cmf_invoice_items')
    op.drop_column('cmf_invoice_items', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_invoice_root_parent_id'), table_name='cmf_invoice')
    op.drop_column('cmf_invoice', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_integration_root_parent_id'), table_name='cmf_integration')
    op.drop_column('cmf_integration', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_import_root_parent_id'), table_name='cmf_import')
    op.drop_column('cmf_import', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_global_settings_root_parent_id'), table_name='cmf_global_settings')
    op.drop_column('cmf_global_settings', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_git_repo_root_parent_id'), table_name='cmf_git_repo')
    op.drop_column('cmf_git_repo', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_git_merge_request_root_parent_id'), table_name='cmf_git_merge_request')
    op.drop_column('cmf_git_merge_request', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_git_commit_root_parent_id'), table_name='cmf_git_commit')
    op.drop_column('cmf_git_commit', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_git_branch_root_parent_id'), table_name='cmf_git_branch')
    op.drop_column('cmf_git_branch', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_gantt_baseline_root_parent_id'), table_name='cmf_gantt_baseline')
    op.drop_column('cmf_gantt_baseline', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_form_field_root_parent_id'), table_name='cmf_form_field')
    op.drop_column('cmf_form_field', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_form_root_parent_id'), table_name='cmf_form')
    op.drop_column('cmf_form', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_follower_root_parent_id'), table_name='cmf_follower')
    op.drop_column('cmf_follower', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_folder_root_parent_id'), table_name='cmf_folder')
    op.drop_column('cmf_folder', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_filter_root_parent_id'), table_name='cmf_filter')
    op.drop_column('cmf_filter', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_document_history_root_parent_id'), table_name='cmf_document_history')
    op.drop_column('cmf_document_history', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_document_root_parent_id'), table_name='cmf_document')
    op.drop_column('cmf_document', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_deal_items_root_parent_id'), table_name='cmf_deal_items')
    op.drop_column('cmf_deal_items', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_deal_root_parent_id'), table_name='cmf_deal')
    op.drop_column('cmf_deal', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_dashboard_root_parent_id'), table_name='cmf_dashboard')
    op.drop_column('cmf_dashboard', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_currency_root_parent_id'), table_name='cmf_currency')
    op.drop_column('cmf_currency', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_contract_root_parent_id'), table_name='cmf_contract')
    op.drop_column('cmf_contract', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_company_root_parent_id'), table_name='cmf_company')
    op.drop_column('cmf_company', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_comment_root_parent_id'), table_name='cmf_comment')
    op.drop_column('cmf_comment', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_chat_topic_root_parent_id'), table_name='cmf_chat_topic')
    op.drop_column('cmf_chat_topic', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_chat_message_root_parent_id'), table_name='cmf_chat_message')
    op.drop_column('cmf_chat_message', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_chat_group_root_parent_id'), table_name='cmf_chat_group')
    op.drop_column('cmf_chat_group', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_card_root_parent_id'), table_name='cmf_card')
    op.drop_column('cmf_card', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_balance_operation_root_parent_id'), table_name='cmf_balance_operation')
    op.drop_column('cmf_balance_operation', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_balance_root_parent_id'), table_name='cmf_balance')
    op.drop_column('cmf_balance', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_automation_crud_trigger_root_parent_id'), table_name='cmf_automation_crud_trigger')
    op.drop_column('cmf_automation_crud_trigger', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_automation_cron_trigger_root_parent_id'), table_name='cmf_automation_cron_trigger')
    op.drop_column('cmf_automation_cron_trigger', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_auth_plugin_data_root_parent_id'), table_name='cmf_auth_plugin_data')
    op.drop_column('cmf_auth_plugin_data', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_auth_ldap_plugin_root_parent_id'), table_name='cmf_auth_ldap_plugin')
    op.drop_column('cmf_auth_ldap_plugin', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_attachment_root_parent_id'), table_name='cmf_attachment')
    op.drop_column('cmf_attachment', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_activity_root_parent_id'), table_name='cmf_activity')
    op.drop_column('cmf_activity', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_active_entity_filter_root_parent_id'), table_name='cmf_active_entity_filter')
    op.drop_column('cmf_active_entity_filter', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_access_rule_root_parent_id'), table_name='cmf_access_rule')
    op.drop_column('cmf_access_rule', 'root_parent_id')
    op.drop_index(op.f('ix_cmf_access_list_root_parent_id'), table_name='cmf_access_list')
    op.drop_column('cmf_access_list', 'root_parent_id')
    # ### end Alembic commands ###
