"""ext_id

Revision ID: 21b99683a87a
Revises: 6f1b226ec055
Create Date: 2022-09-14 10:28:17.377284

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '21b99683a87a'
down_revision = '6f1b226ec055'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index('ix_cmf_access_list_ext_id', table_name='cmf_access_list')
    op.drop_index('ix_cmf_access_rule_ext_id', table_name='cmf_access_rule')
    op.drop_index('ix_cmf_active_entity_filter_ext_id', table_name='cmf_active_entity_filter')
    op.drop_index('ix_cmf_activity_ext_id', table_name='cmf_activity')
    op.drop_index('ix_cmf_attachment_ext_id', table_name='cmf_attachment')
    op.drop_index('ix_cmf_auth_ldap_plugin_ext_id', table_name='cmf_auth_ldap_plugin')
    op.drop_index('ix_cmf_auth_plugin_data_ext_id', table_name='cmf_auth_plugin_data')
    op.drop_index('ix_cmf_balance_ext_id', table_name='cmf_balance')
    op.drop_index('ix_cmf_balance_operation_ext_id', table_name='cmf_balance_operation')
    op.drop_index('ix_cmf_card_ext_id', table_name='cmf_card')
    op.drop_index('ix_cmf_chat_group_ext_id', table_name='cmf_chat_group')
    op.drop_index('ix_cmf_chat_message_ext_id', table_name='cmf_chat_message')
    op.drop_index('ix_cmf_chat_topic_ext_id', table_name='cmf_chat_topic')
    op.drop_index('ix_cmf_comment_ext_id', table_name='cmf_comment')
    op.drop_index('ix_cmf_company_ext_id', table_name='cmf_company')
    op.drop_index('ix_cmf_contract_ext_id', table_name='cmf_contract')
    op.drop_index('ix_cmf_currency_ext_id', table_name='cmf_currency')
    op.drop_index('ix_cmf_deal_ext_id', table_name='cmf_deal')
    op.drop_index('ix_cmf_deal_items_ext_id', table_name='cmf_deal_items')
    op.drop_index('ix_cmf_document_ext_id', table_name='cmf_document')
    op.drop_index('ix_cmf_document_history_ext_id', table_name='cmf_document_history')
    op.drop_index('ix_cmf_filter_ext_id', table_name='cmf_filter')
    op.drop_index('ix_cmf_folder_ext_id', table_name='cmf_folder')
    op.drop_index('ix_cmf_form_ext_id', table_name='cmf_form')
    op.drop_index('ix_cmf_form_field_ext_id', table_name='cmf_form_field')
    op.drop_index('ix_cmf_global_settings_ext_id', table_name='cmf_global_settings')
    op.drop_index('ix_cmf_import_ext_id', table_name='cmf_import')
    op.drop_index('ix_cmf_integration_ext_id', table_name='cmf_integration')
    op.drop_index('ix_cmf_invoice_ext_id', table_name='cmf_invoice')
    op.drop_index('ix_cmf_invoice_items_ext_id', table_name='cmf_invoice_items')
    op.drop_index('ix_cmf_job_ext_id', table_name='cmf_job')
    op.drop_index('ix_cmf_lead_ext_id', table_name='cmf_lead')
    op.drop_index('ix_cmf_lead_mailbox_ext_id', table_name='cmf_lead_mailbox')
    op.drop_index('ix_cmf_license_ext_id', table_name='cmf_license')
    op.drop_index('ix_cmf_link_ext_id', table_name='cmf_link')
    op.drop_index('ix_cmf_list_ext_id', table_name='cmf_list')
    op.drop_index('ix_cmf_logic_type_ext_id', table_name='cmf_logic_type')
    op.drop_index('ix_cmf_mail_ext_id', table_name='cmf_mail')
    op.drop_index('ix_cmf_mail_signature_ext_id', table_name='cmf_mail_signature')
    op.drop_index('ix_cmf_mail_template_ext_id', table_name='cmf_mail_template')
    op.drop_index('ix_cmf_mailbox_ext_id', table_name='cmf_mailbox')
    op.drop_index('ix_cmf_menu_item_ext_id', table_name='cmf_menu_item')
    op.drop_index('ix_cmf_menu_tree_ext_id', table_name='cmf_menu_tree')
    op.drop_index('ix_cmf_menu_tree_item_ext_id', table_name='cmf_menu_tree_item')
    op.drop_index('ix_cmf_notify_ext_id', table_name='cmf_notify')
    op.drop_index('ix_cmf_org_unit_ext_id', table_name='cmf_org_unit')
    op.drop_index('ix_cmf_payment_ext_id', table_name='cmf_payment')
    op.drop_index('ix_cmf_person_ext_id', table_name='cmf_person')
    op.drop_index('ix_cmf_person_group_ext_id', table_name='cmf_person_group')
    op.drop_index('ix_cmf_person_var_ext_id', table_name='cmf_person_var')
    op.drop_index('ix_cmf_pipeline_ext_id', table_name='cmf_pipeline')
    op.drop_index('ix_cmf_plan_ext_id', table_name='cmf_plan')
    op.drop_index('ix_cmf_plugin_ext_id', table_name='cmf_plugin')
    op.drop_index('ix_cmf_plugin_asana_ext_id', table_name='cmf_plugin_asana')
    op.drop_index('ix_cmf_plugin_confluence_ext_id', table_name='cmf_plugin_confluence')
    op.drop_index('ix_cmf_plugin_jira_ext_id', table_name='cmf_plugin_jira')
    op.drop_index('ix_cmf_plugin_mail_box_ext_id', table_name='cmf_plugin_mail_box')
    op.drop_index('ix_cmf_plugin_s_m_s_gate_ext_id', table_name='cmf_plugin_s_m_s_gate')
    op.drop_index('ix_cmf_plugin_telphin_ext_id', table_name='cmf_plugin_telphin')
    op.drop_index('ix_cmf_plugin_trello_ext_id', table_name='cmf_plugin_trello')
    op.drop_index('ix_cmf_plugin_zadarma_ext_id', table_name='cmf_plugin_zadarma')
    op.drop_index('ix_cmf_price_ext_id', table_name='cmf_price')
    op.drop_index('ix_cmf_print_tmpl_ext_id', table_name='cmf_print_tmpl')
    op.drop_index('ix_cmf_product_ext_id', table_name='cmf_product')
    op.drop_index('ix_cmf_project_ext_id', table_name='cmf_project')
    op.drop_index('ix_cmf_purchase_order_ext_id', table_name='cmf_purchase_order')
    op.drop_index('ix_cmf_purchase_order_items_ext_id', table_name='cmf_purchase_order_items')
    op.drop_index('ix_cmf_refbook_ext_id', table_name='cmf_refbook')
    op.drop_index('ix_cmf_roadmap_ext_id', table_name='cmf_roadmap')
    op.drop_index('ix_cmf_role_ext_id', table_name='cmf_role')
    op.drop_index('ix_cmf_sale_menu_group_ext_id', table_name='cmf_sale_menu_group')
    op.drop_index('ix_cmf_staff_control_settings_ext_id', table_name='cmf_staff_control_settings')
    op.drop_index('ix_cmf_status_ext_id', table_name='cmf_status')
    op.drop_index('ix_cmf_status_opt_ext_id', table_name='cmf_status_opt')
    op.drop_index('ix_cmf_stock_ext_id', table_name='cmf_stock')
    op.drop_index('ix_cmf_stock_incoming_order_ext_id', table_name='cmf_stock_incoming_order')
    op.drop_index('ix_cmf_stock_incoming_order_item_ext_id', table_name='cmf_stock_incoming_order_item')
    op.drop_index('ix_cmf_stock_initial_ext_id', table_name='cmf_stock_initial')
    op.drop_index('ix_cmf_stock_initial_item_ext_id', table_name='cmf_stock_initial_item')
    op.drop_index('ix_cmf_stock_inventory_ext_id', table_name='cmf_stock_inventory')
    op.drop_index('ix_cmf_stock_inventory_item_ext_id', table_name='cmf_stock_inventory_item')
    op.drop_index('ix_cmf_stock_item_ext_id', table_name='cmf_stock_item')
    op.drop_index('ix_cmf_stock_menu_group_ext_id', table_name='cmf_stock_menu_group')
    op.drop_index('ix_cmf_stock_move_ext_id', table_name='cmf_stock_move')
    op.drop_index('ix_cmf_stock_move_item_ext_id', table_name='cmf_stock_move_item')
    op.drop_index('ix_cmf_stock_operation_ext_id', table_name='cmf_stock_operation')
    op.drop_index('ix_cmf_stock_operation_item_ext_id', table_name='cmf_stock_operation_item')
    op.drop_index('ix_cmf_stock_outcoming_order_ext_id', table_name='cmf_stock_outcoming_order')
    op.drop_index('ix_cmf_stock_outcoming_order_item_ext_id', table_name='cmf_stock_outcoming_order_item')
    op.drop_index('ix_cmf_subscription_ext_id', table_name='cmf_subscription')
    op.drop_index('ix_cmf_tag_ext_id', table_name='cmf_tag')
    op.drop_index('ix_cmf_tag_category_ext_id', table_name='cmf_tag_category')
    op.drop_index('ix_cmf_task_ext_id', table_name='cmf_task')
    op.drop_index('ix_cmf_task_time_history_ext_id', table_name='cmf_task_time_history')
    op.drop_index('ix_cmf_trigger_ext_id', table_name='cmf_trigger')
    op.drop_index('ix_cmf_u_work_post_ext_id', table_name='cmf_u_work_post')
    op.drop_index('ix_cmf_unit_ext_id', table_name='cmf_unit')
    op.drop_index('ix_cmf_whatsapp_ext_id', table_name='cmf_whatsapp')
    op.drop_index('ix_cmf_wiki_ext_id', table_name='cmf_wiki')
    op.drop_index('ix_cmf_workflow_ext_id', table_name='cmf_workflow')
    op.drop_index('ix_cmf_workflow_type_ext_id', table_name='cmf_workflow_type')
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_index('ix_cmf_workflow_type_ext_id', 'cmf_workflow_type', ['ext_id'], unique=False)
    op.create_index('ix_cmf_workflow_ext_id', 'cmf_workflow', ['ext_id'], unique=False)
    op.create_index('ix_cmf_wiki_ext_id', 'cmf_wiki', ['ext_id'], unique=False)
    op.create_index('ix_cmf_whatsapp_ext_id', 'cmf_whatsapp', ['ext_id'], unique=False)
    op.create_index('ix_cmf_unit_ext_id', 'cmf_unit', ['ext_id'], unique=False)
    op.create_index('ix_cmf_u_work_post_ext_id', 'cmf_u_work_post', ['ext_id'], unique=False)
    op.create_index('ix_cmf_trigger_ext_id', 'cmf_trigger', ['ext_id'], unique=False)
    op.create_index('ix_cmf_task_time_history_ext_id', 'cmf_task_time_history', ['ext_id'], unique=False)
    op.create_index('ix_cmf_task_ext_id', 'cmf_task', ['ext_id'], unique=False)
    op.create_index('ix_cmf_tag_category_ext_id', 'cmf_tag_category', ['ext_id'], unique=False)
    op.create_index('ix_cmf_tag_ext_id', 'cmf_tag', ['ext_id'], unique=False)
    op.create_index('ix_cmf_subscription_ext_id', 'cmf_subscription', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_outcoming_order_item_ext_id', 'cmf_stock_outcoming_order_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_outcoming_order_ext_id', 'cmf_stock_outcoming_order', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_operation_item_ext_id', 'cmf_stock_operation_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_operation_ext_id', 'cmf_stock_operation', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_move_item_ext_id', 'cmf_stock_move_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_move_ext_id', 'cmf_stock_move', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_menu_group_ext_id', 'cmf_stock_menu_group', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_item_ext_id', 'cmf_stock_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_inventory_item_ext_id', 'cmf_stock_inventory_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_inventory_ext_id', 'cmf_stock_inventory', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_initial_item_ext_id', 'cmf_stock_initial_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_initial_ext_id', 'cmf_stock_initial', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_incoming_order_item_ext_id', 'cmf_stock_incoming_order_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_incoming_order_ext_id', 'cmf_stock_incoming_order', ['ext_id'], unique=False)
    op.create_index('ix_cmf_stock_ext_id', 'cmf_stock', ['ext_id'], unique=False)
    op.create_index('ix_cmf_status_opt_ext_id', 'cmf_status_opt', ['ext_id'], unique=False)
    op.create_index('ix_cmf_status_ext_id', 'cmf_status', ['ext_id'], unique=False)
    op.create_index('ix_cmf_staff_control_settings_ext_id', 'cmf_staff_control_settings', ['ext_id'], unique=False)
    op.create_index('ix_cmf_sale_menu_group_ext_id', 'cmf_sale_menu_group', ['ext_id'], unique=False)
    op.create_index('ix_cmf_role_ext_id', 'cmf_role', ['ext_id'], unique=False)
    op.create_index('ix_cmf_roadmap_ext_id', 'cmf_roadmap', ['ext_id'], unique=False)
    op.create_index('ix_cmf_refbook_ext_id', 'cmf_refbook', ['ext_id'], unique=False)
    op.create_index('ix_cmf_purchase_order_items_ext_id', 'cmf_purchase_order_items', ['ext_id'], unique=False)
    op.create_index('ix_cmf_purchase_order_ext_id', 'cmf_purchase_order', ['ext_id'], unique=False)
    op.create_index('ix_cmf_project_ext_id', 'cmf_project', ['ext_id'], unique=False)
    op.create_index('ix_cmf_product_ext_id', 'cmf_product', ['ext_id'], unique=False)
    op.create_index('ix_cmf_print_tmpl_ext_id', 'cmf_print_tmpl', ['ext_id'], unique=False)
    op.create_index('ix_cmf_price_ext_id', 'cmf_price', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_zadarma_ext_id', 'cmf_plugin_zadarma', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_trello_ext_id', 'cmf_plugin_trello', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_telphin_ext_id', 'cmf_plugin_telphin', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_s_m_s_gate_ext_id', 'cmf_plugin_s_m_s_gate', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_mail_box_ext_id', 'cmf_plugin_mail_box', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_jira_ext_id', 'cmf_plugin_jira', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_confluence_ext_id', 'cmf_plugin_confluence', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_asana_ext_id', 'cmf_plugin_asana', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plugin_ext_id', 'cmf_plugin', ['ext_id'], unique=False)
    op.create_index('ix_cmf_plan_ext_id', 'cmf_plan', ['ext_id'], unique=False)
    op.create_index('ix_cmf_pipeline_ext_id', 'cmf_pipeline', ['ext_id'], unique=False)
    op.create_index('ix_cmf_person_var_ext_id', 'cmf_person_var', ['ext_id'], unique=False)
    op.create_index('ix_cmf_person_group_ext_id', 'cmf_person_group', ['ext_id'], unique=False)
    op.create_index('ix_cmf_person_ext_id', 'cmf_person', ['ext_id'], unique=False)
    op.create_index('ix_cmf_payment_ext_id', 'cmf_payment', ['ext_id'], unique=False)
    op.create_index('ix_cmf_org_unit_ext_id', 'cmf_org_unit', ['ext_id'], unique=False)
    op.create_index('ix_cmf_notify_ext_id', 'cmf_notify', ['ext_id'], unique=False)
    op.create_index('ix_cmf_menu_tree_item_ext_id', 'cmf_menu_tree_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_menu_tree_ext_id', 'cmf_menu_tree', ['ext_id'], unique=False)
    op.create_index('ix_cmf_menu_item_ext_id', 'cmf_menu_item', ['ext_id'], unique=False)
    op.create_index('ix_cmf_mailbox_ext_id', 'cmf_mailbox', ['ext_id'], unique=False)
    op.create_index('ix_cmf_mail_template_ext_id', 'cmf_mail_template', ['ext_id'], unique=False)
    op.create_index('ix_cmf_mail_signature_ext_id', 'cmf_mail_signature', ['ext_id'], unique=False)
    op.create_index('ix_cmf_mail_ext_id', 'cmf_mail', ['ext_id'], unique=False)
    op.create_index('ix_cmf_logic_type_ext_id', 'cmf_logic_type', ['ext_id'], unique=False)
    op.create_index('ix_cmf_list_ext_id', 'cmf_list', ['ext_id'], unique=False)
    op.create_index('ix_cmf_link_ext_id', 'cmf_link', ['ext_id'], unique=False)
    op.create_index('ix_cmf_license_ext_id', 'cmf_license', ['ext_id'], unique=False)
    op.create_index('ix_cmf_lead_mailbox_ext_id', 'cmf_lead_mailbox', ['ext_id'], unique=False)
    op.create_index('ix_cmf_lead_ext_id', 'cmf_lead', ['ext_id'], unique=False)
    op.create_index('ix_cmf_job_ext_id', 'cmf_job', ['ext_id'], unique=False)
    op.create_index('ix_cmf_invoice_items_ext_id', 'cmf_invoice_items', ['ext_id'], unique=False)
    op.create_index('ix_cmf_invoice_ext_id', 'cmf_invoice', ['ext_id'], unique=False)
    op.create_index('ix_cmf_integration_ext_id', 'cmf_integration', ['ext_id'], unique=False)
    op.create_index('ix_cmf_import_ext_id', 'cmf_import', ['ext_id'], unique=False)
    op.create_index('ix_cmf_global_settings_ext_id', 'cmf_global_settings', ['ext_id'], unique=False)
    op.create_index('ix_cmf_form_field_ext_id', 'cmf_form_field', ['ext_id'], unique=False)
    op.create_index('ix_cmf_form_ext_id', 'cmf_form', ['ext_id'], unique=False)
    op.create_index('ix_cmf_folder_ext_id', 'cmf_folder', ['ext_id'], unique=False)
    op.create_index('ix_cmf_filter_ext_id', 'cmf_filter', ['ext_id'], unique=False)
    op.create_index('ix_cmf_document_history_ext_id', 'cmf_document_history', ['ext_id'], unique=False)
    op.create_index('ix_cmf_document_ext_id', 'cmf_document', ['ext_id'], unique=False)
    op.create_index('ix_cmf_deal_items_ext_id', 'cmf_deal_items', ['ext_id'], unique=False)
    op.create_index('ix_cmf_deal_ext_id', 'cmf_deal', ['ext_id'], unique=False)
    op.create_index('ix_cmf_currency_ext_id', 'cmf_currency', ['ext_id'], unique=False)
    op.create_index('ix_cmf_contract_ext_id', 'cmf_contract', ['ext_id'], unique=False)
    op.create_index('ix_cmf_company_ext_id', 'cmf_company', ['ext_id'], unique=False)
    op.create_index('ix_cmf_comment_ext_id', 'cmf_comment', ['ext_id'], unique=False)
    op.create_index('ix_cmf_chat_topic_ext_id', 'cmf_chat_topic', ['ext_id'], unique=False)
    op.create_index('ix_cmf_chat_message_ext_id', 'cmf_chat_message', ['ext_id'], unique=False)
    op.create_index('ix_cmf_chat_group_ext_id', 'cmf_chat_group', ['ext_id'], unique=False)
    op.create_index('ix_cmf_card_ext_id', 'cmf_card', ['ext_id'], unique=False)
    op.create_index('ix_cmf_balance_operation_ext_id', 'cmf_balance_operation', ['ext_id'], unique=False)
    op.create_index('ix_cmf_balance_ext_id', 'cmf_balance', ['ext_id'], unique=False)
    op.create_index('ix_cmf_auth_plugin_data_ext_id', 'cmf_auth_plugin_data', ['ext_id'], unique=False)
    op.create_index('ix_cmf_auth_ldap_plugin_ext_id', 'cmf_auth_ldap_plugin', ['ext_id'], unique=False)
    op.create_index('ix_cmf_attachment_ext_id', 'cmf_attachment', ['ext_id'], unique=False)
    op.create_index('ix_cmf_activity_ext_id', 'cmf_activity', ['ext_id'], unique=False)
    op.create_index('ix_cmf_active_entity_filter_ext_id', 'cmf_active_entity_filter', ['ext_id'], unique=False)
    op.create_index('ix_cmf_access_rule_ext_id', 'cmf_access_rule', ['ext_id'], unique=False)
    op.create_index('ix_cmf_access_list_ext_id', 'cmf_access_list', ['ext_id'], unique=False)
    # ### end Alembic commands ###