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