"""active_entity.workflow

Revision ID: 0617d0af5c50
Revises: 099814b5aa85
Create Date: 2022-05-26 22:16:45.992907

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '0617d0af5c50'
down_revision = '099814b5aa85'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_chat_group', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_chat_group_workflow_id'), 'cmf_chat_group', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_chat_group', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_chat_topic', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_chat_topic_workflow_id'), 'cmf_chat_topic', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_chat_topic', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_company', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_company_workflow_id'), 'cmf_company', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_company', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_deal', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_deal_workflow_id'), 'cmf_deal', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_deal', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_document', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_document_workflow_id'), 'cmf_document', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_document', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_invoice', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_invoice_workflow_id'), 'cmf_invoice', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_invoice', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_lead', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_lead_workflow_id'), 'cmf_lead', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_lead', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_list', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_list_workflow_id'), 'cmf_list', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_list', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_mail', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_mail_workflow_id'), 'cmf_mail', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_mail', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_payment', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_payment_workflow_id'), 'cmf_payment', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_payment', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_pipeline', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_pipeline_workflow_id'), 'cmf_pipeline', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_pipeline', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_project', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_project_workflow_id'), 'cmf_project', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_project', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_purchase_order', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_purchase_order_workflow_id'), 'cmf_purchase_order', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_purchase_order', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_purchase_order_items', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_purchase_order_items_workflow_id'), 'cmf_purchase_order_items', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_purchase_order_items', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_roadmap', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_roadmap_workflow_id'), 'cmf_roadmap', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_roadmap', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_stock_move', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_stock_move_workflow_id'), 'cmf_stock_move', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_stock_move', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_stock_move_items', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_stock_move_items_workflow_id'), 'cmf_stock_move_items', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_stock_move_items', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_task', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_task_workflow_id'), 'cmf_task', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_task', 'cmf_workflow', ['workflow_id'], ['id'])
    op.add_column('cmf_u_work_post', sa.Column('workflow_id', sa.String(length=64), nullable=(True,)))
    op.create_index(op.f('ix_cmf_u_work_post_workflow_id'), 'cmf_u_work_post', ['workflow_id'], unique=False)
    op.create_foreign_key(None, 'cmf_u_work_post', 'cmf_workflow', ['workflow_id'], ['id'])
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint(None, 'cmf_u_work_post', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_u_work_post_workflow_id'), table_name='cmf_u_work_post')
    op.drop_column('cmf_u_work_post', 'workflow_id')
    op.drop_constraint(None, 'cmf_task', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_task_workflow_id'), table_name='cmf_task')
    op.drop_column('cmf_task', 'workflow_id')
    op.drop_constraint(None, 'cmf_stock_move_items', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_stock_move_items_workflow_id'), table_name='cmf_stock_move_items')
    op.drop_column('cmf_stock_move_items', 'workflow_id')
    op.drop_constraint(None, 'cmf_stock_move', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_stock_move_workflow_id'), table_name='cmf_stock_move')
    op.drop_column('cmf_stock_move', 'workflow_id')
    op.drop_constraint(None, 'cmf_roadmap', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_roadmap_workflow_id'), table_name='cmf_roadmap')
    op.drop_column('cmf_roadmap', 'workflow_id')
    op.drop_constraint(None, 'cmf_purchase_order_items', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_purchase_order_items_workflow_id'), table_name='cmf_purchase_order_items')
    op.drop_column('cmf_purchase_order_items', 'workflow_id')
    op.drop_constraint(None, 'cmf_purchase_order', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_purchase_order_workflow_id'), table_name='cmf_purchase_order')
    op.drop_column('cmf_purchase_order', 'workflow_id')
    op.drop_constraint(None, 'cmf_project', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_project_workflow_id'), table_name='cmf_project')
    op.drop_column('cmf_project', 'workflow_id')
    op.drop_constraint(None, 'cmf_pipeline', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_pipeline_workflow_id'), table_name='cmf_pipeline')
    op.drop_column('cmf_pipeline', 'workflow_id')
    op.drop_constraint(None, 'cmf_payment', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_payment_workflow_id'), table_name='cmf_payment')
    op.drop_column('cmf_payment', 'workflow_id')
    op.drop_constraint(None, 'cmf_mail', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_mail_workflow_id'), table_name='cmf_mail')
    op.drop_column('cmf_mail', 'workflow_id')
    op.drop_constraint(None, 'cmf_list', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_list_workflow_id'), table_name='cmf_list')
    op.drop_column('cmf_list', 'workflow_id')
    op.drop_constraint(None, 'cmf_lead', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_lead_workflow_id'), table_name='cmf_lead')
    op.drop_column('cmf_lead', 'workflow_id')
    op.drop_constraint(None, 'cmf_invoice', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_invoice_workflow_id'), table_name='cmf_invoice')
    op.drop_column('cmf_invoice', 'workflow_id')
    op.drop_constraint(None, 'cmf_document', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_document_workflow_id'), table_name='cmf_document')
    op.drop_column('cmf_document', 'workflow_id')
    op.drop_constraint(None, 'cmf_deal', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_deal_workflow_id'), table_name='cmf_deal')
    op.drop_column('cmf_deal', 'workflow_id')
    op.drop_constraint(None, 'cmf_company', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_company_workflow_id'), table_name='cmf_company')
    op.drop_column('cmf_company', 'workflow_id')
    op.drop_constraint(None, 'cmf_chat_topic', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_chat_topic_workflow_id'), table_name='cmf_chat_topic')
    op.drop_column('cmf_chat_topic', 'workflow_id')
    op.drop_constraint(None, 'cmf_chat_group', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_chat_group_workflow_id'), table_name='cmf_chat_group')
    op.drop_column('cmf_chat_group', 'workflow_id')
    # ### end Alembic commands ###