"""empty message Revision ID: 0dc4fb24c4b6 Revises: 6027b3a5875e Create Date: 2022-05-23 04:31:09.310607 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = '0dc4fb24c4b6' down_revision = '6027b3a5875e' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('cmf_active_entity_filter', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_activity', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_activity_orderno'), 'cmf_activity', ['orderno'], unique=False) op.add_column('cmf_attachment', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_attachment_orderno'), 'cmf_attachment', ['orderno'], unique=False) op.add_column('cmf_balance', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_balance_orderno'), 'cmf_balance', ['orderno'], unique=False) op.add_column('cmf_balance_operation', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_balance_operation_orderno'), 'cmf_balance_operation', ['orderno'], unique=False) op.add_column('cmf_card', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_card_orderno'), 'cmf_card', ['orderno'], unique=False) op.alter_column('cmf_chat_group', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_chat_message', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_chat_message_orderno'), 'cmf_chat_message', ['orderno'], unique=False) op.alter_column('cmf_chat_topic', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_comment', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_comment_orderno'), 'cmf_comment', ['orderno'], unique=False) op.alter_column('cmf_company', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_contract', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_contract_orderno'), 'cmf_contract', ['orderno'], unique=False) op.add_column('cmf_currency', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_currency_orderno'), 'cmf_currency', ['orderno'], unique=False) op.alter_column('cmf_deal', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_deal_items', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_deal_items_orderno'), 'cmf_deal_items', ['orderno'], unique=False) op.alter_column('cmf_document', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_document_history', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_document_history_orderno'), 'cmf_document_history', ['orderno'], unique=False) op.alter_column('cmf_filter', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_form', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_form_orderno'), 'cmf_form', ['orderno'], unique=False) op.alter_column('cmf_form_field', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_import', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_import_orderno'), 'cmf_import', ['orderno'], unique=False) op.add_column('cmf_integration', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_integration_orderno'), 'cmf_integration', ['orderno'], unique=False) op.alter_column('cmf_invoice', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_invoice_items', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_invoice_items_orderno'), 'cmf_invoice_items', ['orderno'], unique=False) op.add_column('cmf_job', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_job_orderno'), 'cmf_job', ['orderno'], unique=False) op.alter_column('cmf_lead', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_lead_mailbox', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_lead_mailbox_orderno'), 'cmf_lead_mailbox', ['orderno'], unique=False) op.add_column('cmf_link', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_link_orderno'), 'cmf_link', ['orderno'], unique=False) op.alter_column('cmf_list', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_mail', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_mail_signature', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_mail_signature_orderno'), 'cmf_mail_signature', ['orderno'], unique=False) op.add_column('cmf_mail_template', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_mail_template_orderno'), 'cmf_mail_template', ['orderno'], unique=False) op.add_column('cmf_mailbox', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_mailbox_orderno'), 'cmf_mailbox', ['orderno'], unique=False) op.alter_column('cmf_menu_item', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_menu_tree', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_menu_tree_orderno'), 'cmf_menu_tree', ['orderno'], unique=False) op.add_column('cmf_notify', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_notify_orderno'), 'cmf_notify', ['orderno'], unique=False) op.add_column('cmf_org_unit', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_org_unit_orderno'), 'cmf_org_unit', ['orderno'], unique=False) op.alter_column('cmf_payment', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_person', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_person_orderno'), 'cmf_person', ['orderno'], unique=False) op.add_column('cmf_person_group', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_person_group_orderno'), 'cmf_person_group', ['orderno'], unique=False) op.add_column('cmf_person_var', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_person_var_orderno'), 'cmf_person_var', ['orderno'], unique=False) op.alter_column('cmf_pipeline', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_plan', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plan_orderno'), 'cmf_plan', ['orderno'], unique=False) op.add_column('cmf_plugin', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_orderno'), 'cmf_plugin', ['orderno'], unique=False) op.add_column('cmf_plugin_asana', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_asana_orderno'), 'cmf_plugin_asana', ['orderno'], unique=False) op.add_column('cmf_plugin_confluence', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_confluence_orderno'), 'cmf_plugin_confluence', ['orderno'], unique=False) op.add_column('cmf_plugin_jira', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_jira_orderno'), 'cmf_plugin_jira', ['orderno'], unique=False) op.add_column('cmf_plugin_mail_box', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_mail_box_orderno'), 'cmf_plugin_mail_box', ['orderno'], unique=False) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_s_m_s_gate_orderno'), 'cmf_plugin_s_m_s_gate', ['orderno'], unique=False) op.add_column('cmf_plugin_telphin', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_telphin_orderno'), 'cmf_plugin_telphin', ['orderno'], unique=False) op.add_column('cmf_plugin_trello', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_trello_orderno'), 'cmf_plugin_trello', ['orderno'], unique=False) op.add_column('cmf_plugin_zadarma', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_plugin_zadarma_orderno'), 'cmf_plugin_zadarma', ['orderno'], unique=False) op.add_column('cmf_price', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_price_orderno'), 'cmf_price', ['orderno'], unique=False) op.add_column('cmf_print_tmpl', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_print_tmpl_orderno'), 'cmf_print_tmpl', ['orderno'], unique=False) op.add_column('cmf_product', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_product_orderno'), 'cmf_product', ['orderno'], unique=False) op.alter_column('cmf_project', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_purchase_order', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_purchase_order_items', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_roadmap', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_role', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_role_orderno'), 'cmf_role', ['orderno'], unique=False) op.add_column('cmf_staff_control_settings', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_staff_control_settings_orderno'), 'cmf_staff_control_settings', ['orderno'], unique=False) op.alter_column('cmf_status', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_status_opt', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_stock', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_stock_orderno'), 'cmf_stock', ['orderno'], unique=False) op.add_column('cmf_stock_items', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_stock_items_orderno'), 'cmf_stock_items', ['orderno'], unique=False) op.alter_column('cmf_stock_move', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_stock_move_items', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_stock_operations', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_stock_operations_orderno'), 'cmf_stock_operations', ['orderno'], unique=False) op.add_column('cmf_subscription', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_subscription_orderno'), 'cmf_subscription', ['orderno'], unique=False) op.add_column('cmf_tag', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_tag_orderno'), 'cmf_tag', ['orderno'], unique=False) op.add_column('cmf_tag_category', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_tag_category_orderno'), 'cmf_tag_category', ['orderno'], unique=False) op.alter_column('cmf_task', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_trigger', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.alter_column('cmf_u_work_post', 'orderno', existing_type=sa.INTEGER(), nullable=True) op.add_column('cmf_unit', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_unit_orderno'), 'cmf_unit', ['orderno'], unique=False) op.add_column('cmf_whatsapp', sa.Column('orderno', sa.Integer(), nullable=True)) op.create_index(op.f('ix_cmf_whatsapp_orderno'), 'cmf_whatsapp', ['orderno'], unique=False) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_index(op.f('ix_cmf_whatsapp_orderno'), table_name='cmf_whatsapp') op.drop_column('cmf_whatsapp', 'orderno') op.drop_index(op.f('ix_cmf_unit_orderno'), table_name='cmf_unit') op.drop_column('cmf_unit', 'orderno') op.alter_column('cmf_u_work_post', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_trigger', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_task', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_tag_category_orderno'), table_name='cmf_tag_category') op.drop_column('cmf_tag_category', 'orderno') op.drop_index(op.f('ix_cmf_tag_orderno'), table_name='cmf_tag') op.drop_column('cmf_tag', 'orderno') op.drop_index(op.f('ix_cmf_subscription_orderno'), table_name='cmf_subscription') op.drop_column('cmf_subscription', 'orderno') op.drop_index(op.f('ix_cmf_stock_operations_orderno'), table_name='cmf_stock_operations') op.drop_column('cmf_stock_operations', 'orderno') op.alter_column('cmf_stock_move_items', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_stock_move', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_stock_items_orderno'), table_name='cmf_stock_items') op.drop_column('cmf_stock_items', 'orderno') op.drop_index(op.f('ix_cmf_stock_orderno'), table_name='cmf_stock') op.drop_column('cmf_stock', 'orderno') op.alter_column('cmf_status_opt', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_status', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_staff_control_settings_orderno'), table_name='cmf_staff_control_settings') op.drop_column('cmf_staff_control_settings', 'orderno') op.drop_index(op.f('ix_cmf_role_orderno'), table_name='cmf_role') op.drop_column('cmf_role', 'orderno') op.alter_column('cmf_roadmap', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_purchase_order_items', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_purchase_order', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_project', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_product_orderno'), table_name='cmf_product') op.drop_column('cmf_product', 'orderno') op.drop_index(op.f('ix_cmf_print_tmpl_orderno'), table_name='cmf_print_tmpl') op.drop_column('cmf_print_tmpl', 'orderno') op.drop_index(op.f('ix_cmf_price_orderno'), table_name='cmf_price') op.drop_column('cmf_price', 'orderno') op.drop_index(op.f('ix_cmf_plugin_zadarma_orderno'), table_name='cmf_plugin_zadarma') op.drop_column('cmf_plugin_zadarma', 'orderno') op.drop_index(op.f('ix_cmf_plugin_trello_orderno'), table_name='cmf_plugin_trello') op.drop_column('cmf_plugin_trello', 'orderno') op.drop_index(op.f('ix_cmf_plugin_telphin_orderno'), table_name='cmf_plugin_telphin') op.drop_column('cmf_plugin_telphin', 'orderno') op.drop_index(op.f('ix_cmf_plugin_s_m_s_gate_orderno'), table_name='cmf_plugin_s_m_s_gate') op.drop_column('cmf_plugin_s_m_s_gate', 'orderno') op.drop_index(op.f('ix_cmf_plugin_mail_box_orderno'), table_name='cmf_plugin_mail_box') op.drop_column('cmf_plugin_mail_box', 'orderno') op.drop_index(op.f('ix_cmf_plugin_jira_orderno'), table_name='cmf_plugin_jira') op.drop_column('cmf_plugin_jira', 'orderno') op.drop_index(op.f('ix_cmf_plugin_confluence_orderno'), table_name='cmf_plugin_confluence') op.drop_column('cmf_plugin_confluence', 'orderno') op.drop_index(op.f('ix_cmf_plugin_asana_orderno'), table_name='cmf_plugin_asana') op.drop_column('cmf_plugin_asana', 'orderno') op.drop_index(op.f('ix_cmf_plugin_orderno'), table_name='cmf_plugin') op.drop_column('cmf_plugin', 'orderno') op.drop_index(op.f('ix_cmf_plan_orderno'), table_name='cmf_plan') op.drop_column('cmf_plan', 'orderno') op.alter_column('cmf_pipeline', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_person_var_orderno'), table_name='cmf_person_var') op.drop_column('cmf_person_var', 'orderno') op.drop_index(op.f('ix_cmf_person_group_orderno'), table_name='cmf_person_group') op.drop_column('cmf_person_group', 'orderno') op.drop_index(op.f('ix_cmf_person_orderno'), table_name='cmf_person') op.drop_column('cmf_person', 'orderno') op.alter_column('cmf_payment', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_org_unit_orderno'), table_name='cmf_org_unit') op.drop_column('cmf_org_unit', 'orderno') op.drop_index(op.f('ix_cmf_notify_orderno'), table_name='cmf_notify') op.drop_column('cmf_notify', 'orderno') op.drop_index(op.f('ix_cmf_menu_tree_orderno'), table_name='cmf_menu_tree') op.drop_column('cmf_menu_tree', 'orderno') op.alter_column('cmf_menu_item', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_mailbox_orderno'), table_name='cmf_mailbox') op.drop_column('cmf_mailbox', 'orderno') op.drop_index(op.f('ix_cmf_mail_template_orderno'), table_name='cmf_mail_template') op.drop_column('cmf_mail_template', 'orderno') op.drop_index(op.f('ix_cmf_mail_signature_orderno'), table_name='cmf_mail_signature') op.drop_column('cmf_mail_signature', 'orderno') op.alter_column('cmf_mail', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.alter_column('cmf_list', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_link_orderno'), table_name='cmf_link') op.drop_column('cmf_link', 'orderno') op.drop_index(op.f('ix_cmf_lead_mailbox_orderno'), table_name='cmf_lead_mailbox') op.drop_column('cmf_lead_mailbox', 'orderno') op.alter_column('cmf_lead', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_job_orderno'), table_name='cmf_job') op.drop_column('cmf_job', 'orderno') op.drop_index(op.f('ix_cmf_invoice_items_orderno'), table_name='cmf_invoice_items') op.drop_column('cmf_invoice_items', 'orderno') op.alter_column('cmf_invoice', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_integration_orderno'), table_name='cmf_integration') op.drop_column('cmf_integration', 'orderno') op.drop_index(op.f('ix_cmf_import_orderno'), table_name='cmf_import') op.drop_column('cmf_import', 'orderno') op.alter_column('cmf_form_field', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_form_orderno'), table_name='cmf_form') op.drop_column('cmf_form', 'orderno') op.alter_column('cmf_filter', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_document_history_orderno'), table_name='cmf_document_history') op.drop_column('cmf_document_history', 'orderno') op.alter_column('cmf_document', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_deal_items_orderno'), table_name='cmf_deal_items') op.drop_column('cmf_deal_items', 'orderno') op.alter_column('cmf_deal', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_currency_orderno'), table_name='cmf_currency') op.drop_column('cmf_currency', 'orderno') op.drop_index(op.f('ix_cmf_contract_orderno'), table_name='cmf_contract') op.drop_column('cmf_contract', 'orderno') op.alter_column('cmf_company', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_comment_orderno'), table_name='cmf_comment') op.drop_column('cmf_comment', 'orderno') op.alter_column('cmf_chat_topic', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_chat_message_orderno'), table_name='cmf_chat_message') op.drop_column('cmf_chat_message', 'orderno') op.alter_column('cmf_chat_group', 'orderno', existing_type=sa.INTEGER(), nullable=False) op.drop_index(op.f('ix_cmf_card_orderno'), table_name='cmf_card') op.drop_column('cmf_card', 'orderno') op.drop_index(op.f('ix_cmf_balance_operation_orderno'), table_name='cmf_balance_operation') op.drop_column('cmf_balance_operation', 'orderno') op.drop_index(op.f('ix_cmf_balance_orderno'), table_name='cmf_balance') op.drop_column('cmf_balance', 'orderno') op.drop_index(op.f('ix_cmf_attachment_orderno'), table_name='cmf_attachment') op.drop_column('cmf_attachment', 'orderno') op.drop_index(op.f('ix_cmf_activity_orderno'), table_name='cmf_activity') op.drop_column('cmf_activity', 'orderno') op.alter_column('cmf_active_entity_filter', 'orderno', existing_type=sa.INTEGER(), nullable=False) # ### end Alembic commands ###