"""megafix_workflow_integra Revision ID: 74c753e3288b Revises: 27bf9961e080 Create Date: 2022-10-07 15:47:50.294578 """ from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import postgresql # revision identifiers, used by Alembic. revision = '74c753e3288b' down_revision = '27bf9961e080' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_audit', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('parent_name', sa.String(), nullable=True), sa.Column('audit_data', sa.TEXT(), nullable=False), sa.Column('operate', sa.String(length=32), nullable=False), sa.Column('cmf_model_name', sa.String(), nullable=False), sa.Column('html_diff_data', sa.TEXT(), nullable=False), sa.Column('cmf_author_id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=False), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_audit_cmf_author_id'), 'cmf_audit', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_audit_cmf_created_at'), 'cmf_audit', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_audit_cmf_modified_at'), 'cmf_audit', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_audit_parent_id'), 'cmf_audit', ['parent_id'], unique=False) op.create_table('cmf_scheme_wf', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('is_public', sa.Boolean(), nullable=True), sa.Column('is_public_editable', sa.Boolean(), nullable=True), sa.Column('is_public_comments', sa.Boolean(), nullable=True), sa.Column('logic_prefix', sa.String(), nullable=True), sa.Column('parent_logic_prefix', sa.String(), nullable=True), sa.Column('status_modified_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_in_progress_start', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_in_progress_end', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_review_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_closed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('no_control', sa.Boolean(), nullable=True), sa.Column('priority_old', sa.String(length=32), nullable=False), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('mark', sa.String(length=32), nullable=True), sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('deadline', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('time_estimate', sa.Integer(), nullable=True), sa.Column('plan_start_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('plan_end_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('period_next_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('period_interval', sa.String(length=32), nullable=True), sa.Column('is_template', sa.Boolean(), nullable=True), sa.Column('is_penalty', sa.Boolean(), nullable=True), sa.Column('cache_status_type', sa.String(length=32), nullable=True), sa.Column('cache_fields', sa.TEXT(), nullable=True), sa.Column('approved', sa.Boolean(), nullable=False), sa.Column('perm_policy', sa.String(length=32), nullable=False), sa.Column('perm_policy_guest', sa.String(length=32), nullable=False), sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False), sa.Column('perm_policy_sharelink', sa.String(length=32), nullable=False), sa.Column('sharelink_hash', sa.String(length=32), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('workflow_id', sa.String(length=64), nullable=True), sa.Column('default_task_workflow_id', sa.String(length=64), nullable=True), sa.Column('logic_type_id', sa.String(length=64), nullable=True), sa.Column('scheme_wf_id', sa.String(length=64), nullable=True), sa.Column('status_id', sa.String(length=64), nullable=True), sa.Column('company_id', sa.String(length=64), nullable=True), sa.Column('responsible_id', sa.String(length=64), nullable=True), sa.Column('waiting_for_id', sa.String(length=64), nullable=True), sa.Column('cloned_from_id', sa.String(length=64), nullable=True), sa.Column('activity_id', sa.String(length=64), nullable=True), sa.Column('cache_status_opt_id', sa.String(length=64), nullable=True), sa.Column('template_id', sa.String(length=64), nullable=True), sa.Column('default_list_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_epic_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_release_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_version_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_sprint_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_document_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_subtask_workflow_id', sa.String(length=64), nullable=True), sa.Column('default_task_logic_type_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['activity_id'], ['cmf_activity.id'], ), sa.ForeignKeyConstraint(['cache_status_opt_id'], ['cmf_status_opt.id'], ), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['company_id'], ['cmf_company.id'], ), sa.ForeignKeyConstraint(['default_document_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_epic_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_list_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_release_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_sprint_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_subtask_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_task_logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['default_task_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['default_version_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['status_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['template_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_scheme_wf_activity_id'), 'cmf_scheme_wf', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_alarm_date'), 'cmf_scheme_wf', ['alarm_date'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_approved'), 'cmf_scheme_wf', ['approved'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cache_status_opt_id'), 'cmf_scheme_wf', ['cache_status_opt_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cache_status_type'), 'cmf_scheme_wf', ['cache_status_type'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cloned_from_id'), 'cmf_scheme_wf', ['cloned_from_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_author_id'), 'cmf_scheme_wf', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_created_at'), 'cmf_scheme_wf', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_deleted'), 'cmf_scheme_wf', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_import_id'), 'cmf_scheme_wf', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_locked_at'), 'cmf_scheme_wf', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_locked_by_id'), 'cmf_scheme_wf', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_modified_at'), 'cmf_scheme_wf', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_modified_by_id'), 'cmf_scheme_wf', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_owner_assistant_id'), 'cmf_scheme_wf', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_owner_id'), 'cmf_scheme_wf', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_version'), 'cmf_scheme_wf', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_viewed_at'), 'cmf_scheme_wf', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_code'), 'cmf_scheme_wf', ['code'], unique=True) op.create_index(op.f('ix_cmf_scheme_wf_company_id'), 'cmf_scheme_wf', ['company_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_document_workflow_id'), 'cmf_scheme_wf', ['default_document_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_epic_workflow_id'), 'cmf_scheme_wf', ['default_epic_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_list_workflow_id'), 'cmf_scheme_wf', ['default_list_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_release_workflow_id'), 'cmf_scheme_wf', ['default_release_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_sprint_workflow_id'), 'cmf_scheme_wf', ['default_sprint_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_subtask_workflow_id'), 'cmf_scheme_wf', ['default_subtask_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_task_logic_type_id'), 'cmf_scheme_wf', ['default_task_logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_task_workflow_id'), 'cmf_scheme_wf', ['default_task_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_default_version_workflow_id'), 'cmf_scheme_wf', ['default_version_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_is_template'), 'cmf_scheme_wf', ['is_template'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_logic_prefix'), 'cmf_scheme_wf', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_logic_type_id'), 'cmf_scheme_wf', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_name'), 'cmf_scheme_wf', ['name'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_orderno'), 'cmf_scheme_wf', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_parent_id'), 'cmf_scheme_wf', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_parent_logic_prefix'), 'cmf_scheme_wf', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_perm_acl_id'), 'cmf_scheme_wf', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_perm_parent_id'), 'cmf_scheme_wf', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_responsible_id'), 'cmf_scheme_wf', ['responsible_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_scheme_wf_id'), 'cmf_scheme_wf', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_status_id'), 'cmf_scheme_wf', ['status_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_template_id'), 'cmf_scheme_wf', ['template_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_tree_parent_id'), 'cmf_scheme_wf', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_waiting_for_id'), 'cmf_scheme_wf', ['waiting_for_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_workflow_id'), 'cmf_scheme_wf', ['workflow_id'], unique=False) op.create_table('cmf_scheme_wf_cmf_logic_type', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint(['left_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_logic_type.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_left_id'), 'cmf_scheme_wf_cmf_logic_type', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_parent_id'), 'cmf_scheme_wf_cmf_logic_type', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_right_id'), 'cmf_scheme_wf_cmf_logic_type', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_root_id'), 'cmf_scheme_wf_cmf_logic_type', ['root_id'], unique=False) op.create_table('cmf_scheme_wf_executors', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_scheme_wf_executors_left_id'), 'cmf_scheme_wf_executors', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_executors_parent_id'), 'cmf_scheme_wf_executors', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_executors_right_id'), 'cmf_scheme_wf_executors', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_executors_root_id'), 'cmf_scheme_wf_executors', ['root_id'], unique=False) op.create_table('cmf_scheme_wf_rule', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('cmf_model_name', sa.String(length=32), nullable=True), sa.Column('target_view', sa.String(length=32), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('scheme_wf_id', sa.String(length=64), nullable=False), sa.Column('logic_type_id', sa.String(length=64), nullable=True), sa.Column('activity_id', sa.String(length=64), nullable=True), sa.Column('target_workflow_id', sa.String(length=64), nullable=True), sa.Column('target_scheme_wf_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['activity_id'], ['cmf_activity.id'], ), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['target_scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['target_workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_scheme_wf_rule_activity_id'), 'cmf_scheme_wf_rule', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_author_id'), 'cmf_scheme_wf_rule', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_created_at'), 'cmf_scheme_wf_rule', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_deleted'), 'cmf_scheme_wf_rule', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_import_id'), 'cmf_scheme_wf_rule', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_locked_at'), 'cmf_scheme_wf_rule', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_locked_by_id'), 'cmf_scheme_wf_rule', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_modified_at'), 'cmf_scheme_wf_rule', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_modified_by_id'), 'cmf_scheme_wf_rule', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_owner_assistant_id'), 'cmf_scheme_wf_rule', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_owner_id'), 'cmf_scheme_wf_rule', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_version'), 'cmf_scheme_wf_rule', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_cmf_viewed_at'), 'cmf_scheme_wf_rule', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_code'), 'cmf_scheme_wf_rule', ['code'], unique=True) op.create_index(op.f('ix_cmf_scheme_wf_rule_logic_type_id'), 'cmf_scheme_wf_rule', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_name'), 'cmf_scheme_wf_rule', ['name'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_orderno'), 'cmf_scheme_wf_rule', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_parent_id'), 'cmf_scheme_wf_rule', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_perm_acl_id'), 'cmf_scheme_wf_rule', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_perm_parent_id'), 'cmf_scheme_wf_rule', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_scheme_wf_id'), 'cmf_scheme_wf_rule', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_target_scheme_wf_id'), 'cmf_scheme_wf_rule', ['target_scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_target_workflow_id'), 'cmf_scheme_wf_rule', ['target_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_rule_tree_parent_id'), 'cmf_scheme_wf_rule', ['tree_parent_id'], unique=False) op.create_table('cmf_scheme_wf_spectators', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_scheme_wf_spectators_left_id'), 'cmf_scheme_wf_spectators', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_spectators_parent_id'), 'cmf_scheme_wf_spectators', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_spectators_right_id'), 'cmf_scheme_wf_spectators', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_scheme_wf_spectators_root_id'), 'cmf_scheme_wf_spectators', ['root_id'], unique=False) op.create_table('cmf_tag_cmf_scheme_wf', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint(['left_id'], ['cmf_tag.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_scheme_wf.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_tag_cmf_scheme_wf_left_id'), 'cmf_tag_cmf_scheme_wf', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_tag_cmf_scheme_wf_parent_id'), 'cmf_tag_cmf_scheme_wf', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_tag_cmf_scheme_wf_right_id'), 'cmf_tag_cmf_scheme_wf', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_tag_cmf_scheme_wf_root_id'), 'cmf_tag_cmf_scheme_wf', ['root_id'], unique=False) op.create_table('cmf_trans', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('trans_display_form', sa.String(length=32), nullable=True), sa.Column('trans_form_fields', sa.TEXT(), nullable=True), sa.Column('trans_form_descr', sa.TEXT(), nullable=True), sa.Column('trans_form_show', sa.Boolean(), nullable=True), sa.Column('trans_form_comment_require', sa.Boolean(), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('workflow_id', sa.String(length=64), nullable=False), sa.Column('status_to_id', sa.String(length=64), nullable=True), sa.Column('do_filter_by_id', sa.String(length=64), nullable=True), sa.Column('do_validation_by_id', sa.String(length=64), nullable=True), sa.Column('do_action_by_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['do_action_by_id'], ['cmf_trans.id'], ), sa.ForeignKeyConstraint(['do_filter_by_id'], ['cmf_trans.id'], ), sa.ForeignKeyConstraint(['do_validation_by_id'], ['cmf_trans.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['status_to_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_cmf_author_id'), 'cmf_trans', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_created_at'), 'cmf_trans', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_deleted'), 'cmf_trans', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_import_id'), 'cmf_trans', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_locked_at'), 'cmf_trans', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_locked_by_id'), 'cmf_trans', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_modified_at'), 'cmf_trans', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_modified_by_id'), 'cmf_trans', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_owner_assistant_id'), 'cmf_trans', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_owner_id'), 'cmf_trans', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_version'), 'cmf_trans', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_viewed_at'), 'cmf_trans', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_trans_code'), 'cmf_trans', ['code'], unique=True) op.create_index(op.f('ix_cmf_trans_do_action_by_id'), 'cmf_trans', ['do_action_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_do_filter_by_id'), 'cmf_trans', ['do_filter_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_do_validation_by_id'), 'cmf_trans', ['do_validation_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_name'), 'cmf_trans', ['name'], unique=False) op.create_index(op.f('ix_cmf_trans_orderno'), 'cmf_trans', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_trans_parent_id'), 'cmf_trans', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_perm_acl_id'), 'cmf_trans', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_trans_perm_parent_id'), 'cmf_trans', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_status_to_id'), 'cmf_trans', ['status_to_id'], unique=False) op.create_index(op.f('ix_cmf_trans_tree_parent_id'), 'cmf_trans', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_workflow_id'), 'cmf_trans', ['workflow_id'], unique=False) op.create_table('cmf_trans_action', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('cmf_model_name', sa.String(length=32), nullable=True), sa.Column('logic_type', sa.String(length=32), nullable=True), sa.Column('wz_field_name', sa.String(length=64), nullable=True), sa.Column('wz_value_text', sa.String(length=64), nullable=True), sa.Column('wz_clear', sa.Boolean(), nullable=True), sa.Column('bql', sa.TEXT(), nullable=True), sa.Column('eval_code', sa.TEXT(), nullable=True), sa.Column('wz_operate', sa.String(length=32), nullable=True), sa.Column('auto_text', sa.TEXT(), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('transition_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['transition_id'], ['cmf_trans.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_action_cmf_author_id'), 'cmf_trans_action', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_created_at'), 'cmf_trans_action', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_deleted'), 'cmf_trans_action', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_import_id'), 'cmf_trans_action', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_locked_at'), 'cmf_trans_action', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_locked_by_id'), 'cmf_trans_action', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_modified_at'), 'cmf_trans_action', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_modified_by_id'), 'cmf_trans_action', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_owner_assistant_id'), 'cmf_trans_action', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_owner_id'), 'cmf_trans_action', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_version'), 'cmf_trans_action', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_trans_action_cmf_viewed_at'), 'cmf_trans_action', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_trans_action_code'), 'cmf_trans_action', ['code'], unique=True) op.create_index(op.f('ix_cmf_trans_action_name'), 'cmf_trans_action', ['name'], unique=False) op.create_index(op.f('ix_cmf_trans_action_orderno'), 'cmf_trans_action', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_trans_action_parent_id'), 'cmf_trans_action', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_perm_acl_id'), 'cmf_trans_action', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_perm_parent_id'), 'cmf_trans_action', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_transition_id'), 'cmf_trans_action', ['transition_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_tree_parent_id'), 'cmf_trans_action', ['tree_parent_id'], unique=False) op.create_table('cmf_trans_action_wz_value_obj', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_action_wz_value_obj_left_id'), 'cmf_trans_action_wz_value_obj', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_wz_value_obj_parent_id'), 'cmf_trans_action_wz_value_obj', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_wz_value_obj_right_id'), 'cmf_trans_action_wz_value_obj', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_trans_action_wz_value_obj_root_id'), 'cmf_trans_action_wz_value_obj', ['root_id'], unique=False) op.create_table('cmf_trans_cmf_status', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint(['left_id'], ['cmf_trans.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_status.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_cmf_status_left_id'), 'cmf_trans_cmf_status', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_status_parent_id'), 'cmf_trans_cmf_status', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_status_right_id'), 'cmf_trans_cmf_status', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_trans_cmf_status_root_id'), 'cmf_trans_cmf_status', ['root_id'], unique=False) op.create_table('cmf_trans_filter', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('cmf_model_name', sa.String(length=32), nullable=True), sa.Column('logic_type', sa.String(length=32), nullable=True), sa.Column('wz_field_name', sa.String(length=64), nullable=True), sa.Column('wz_condition', sa.String(length=32), nullable=True), sa.Column('wz_value_text', sa.String(length=64), nullable=True), sa.Column('wz_start_value', sa.String(length=64), nullable=True), sa.Column('wz_end_value', sa.String(length=64), nullable=True), sa.Column('wz_bql_cache', sa.TEXT(), nullable=True), sa.Column('bql', sa.TEXT(), nullable=True), sa.Column('eval_code', sa.TEXT(), nullable=True), sa.Column('wz_prev_status_options', sa.TEXT(), nullable=True), sa.Column('auto_text', sa.TEXT(), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('transition_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['transition_id'], ['cmf_trans.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_filter_cmf_author_id'), 'cmf_trans_filter', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_created_at'), 'cmf_trans_filter', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_deleted'), 'cmf_trans_filter', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_import_id'), 'cmf_trans_filter', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_locked_at'), 'cmf_trans_filter', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_locked_by_id'), 'cmf_trans_filter', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_modified_at'), 'cmf_trans_filter', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_modified_by_id'), 'cmf_trans_filter', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_owner_assistant_id'), 'cmf_trans_filter', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_owner_id'), 'cmf_trans_filter', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_version'), 'cmf_trans_filter', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_cmf_viewed_at'), 'cmf_trans_filter', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_code'), 'cmf_trans_filter', ['code'], unique=True) op.create_index(op.f('ix_cmf_trans_filter_name'), 'cmf_trans_filter', ['name'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_orderno'), 'cmf_trans_filter', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_parent_id'), 'cmf_trans_filter', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_perm_acl_id'), 'cmf_trans_filter', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_perm_parent_id'), 'cmf_trans_filter', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_transition_id'), 'cmf_trans_filter', ['transition_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_tree_parent_id'), 'cmf_trans_filter', ['tree_parent_id'], unique=False) op.create_table('cmf_trans_filter_wz_value_obj', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_filter_wz_value_obj_left_id'), 'cmf_trans_filter_wz_value_obj', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_wz_value_obj_parent_id'), 'cmf_trans_filter_wz_value_obj', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_wz_value_obj_right_id'), 'cmf_trans_filter_wz_value_obj', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_trans_filter_wz_value_obj_root_id'), 'cmf_trans_filter_wz_value_obj', ['root_id'], unique=False) op.create_table('cmf_trans_valid', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('logic_type', sa.String(length=32), nullable=True), sa.Column('error_message', sa.String(length=64), nullable=True), sa.Column('wz_field_name', sa.String(length=64), nullable=True), sa.Column('wz_condition', sa.String(length=32), nullable=True), sa.Column('wz_value_text', sa.String(length=64), nullable=True), sa.Column('wz_start_value', sa.String(length=64), nullable=True), sa.Column('wz_end_value', sa.String(length=64), nullable=True), sa.Column('wz_bql_cache', sa.TEXT(), nullable=True), sa.Column('bql', sa.TEXT(), nullable=True), sa.Column('cmf_model_name', sa.String(length=32), nullable=True), sa.Column('eval_code', sa.TEXT(), nullable=True), sa.Column('wz_prev_status_options', sa.TEXT(), nullable=True), sa.Column('auto_text', sa.TEXT(), nullable=True), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('transition_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['transition_id'], ['cmf_trans.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_valid_cmf_author_id'), 'cmf_trans_valid', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_created_at'), 'cmf_trans_valid', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_deleted'), 'cmf_trans_valid', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_import_id'), 'cmf_trans_valid', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_locked_at'), 'cmf_trans_valid', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_locked_by_id'), 'cmf_trans_valid', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_modified_at'), 'cmf_trans_valid', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_modified_by_id'), 'cmf_trans_valid', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_owner_assistant_id'), 'cmf_trans_valid', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_owner_id'), 'cmf_trans_valid', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_version'), 'cmf_trans_valid', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_cmf_viewed_at'), 'cmf_trans_valid', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_code'), 'cmf_trans_valid', ['code'], unique=True) op.create_index(op.f('ix_cmf_trans_valid_name'), 'cmf_trans_valid', ['name'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_orderno'), 'cmf_trans_valid', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_parent_id'), 'cmf_trans_valid', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_perm_acl_id'), 'cmf_trans_valid', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_perm_parent_id'), 'cmf_trans_valid', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_transition_id'), 'cmf_trans_valid', ['transition_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_tree_parent_id'), 'cmf_trans_valid', ['tree_parent_id'], unique=False) op.create_table('cmf_trans_valid_wz_value_obj', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_trans_valid_wz_value_obj_left_id'), 'cmf_trans_valid_wz_value_obj', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_wz_value_obj_parent_id'), 'cmf_trans_valid_wz_value_obj', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_wz_value_obj_right_id'), 'cmf_trans_valid_wz_value_obj', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_trans_valid_wz_value_obj_root_id'), 'cmf_trans_valid_wz_value_obj', ['root_id'], unique=False) op.drop_index('ix_cmf_workflow_type_cmf_author_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_created_at', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_deleted', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_import_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_locked_at', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_locked_by_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_modified_at', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_modified_by_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_owner_assistant_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_owner_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_version', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_cmf_viewed_at', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_code', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_name', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_orderno', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_parent_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_perm_acl_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_perm_parent_id', table_name='cmf_workflow_type') op.drop_index('ix_cmf_workflow_type_tree_parent_id', table_name='cmf_workflow_type') op.add_column('cmf_active_entity_filter', sa.Column('filter_logic_prefix', sa.String(length=32), nullable=True)) op.drop_column('cmf_active_entity_filter', 'filter_workflow_type') op.drop_column('cmf_activity', 'default_deadline_shift') op.drop_column('cmf_activity', 'prefix') op.add_column('cmf_chat_group', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_chat_group', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_chat_group', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_chat_group_workflow_type', table_name='cmf_chat_group') op.create_index(op.f('ix_cmf_chat_group_logic_prefix'), 'cmf_chat_group', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_chat_group_parent_logic_prefix'), 'cmf_chat_group', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_chat_group_scheme_wf_id'), 'cmf_chat_group', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_group', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_chat_group', 'workflow_type') op.add_column('cmf_chat_topic', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_chat_topic_workflow_type', table_name='cmf_chat_topic') op.create_index(op.f('ix_cmf_chat_topic_logic_prefix'), 'cmf_chat_topic', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_chat_topic_parent_logic_prefix'), 'cmf_chat_topic', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_chat_topic_scheme_wf_id'), 'cmf_chat_topic', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_topic', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_chat_topic', 'workflow_type') op.add_column('cmf_company', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_company', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_company', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_company_workflow_type', table_name='cmf_company') op.create_index(op.f('ix_cmf_company_logic_prefix'), 'cmf_company', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_company_parent_logic_prefix'), 'cmf_company', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_company_scheme_wf_id'), 'cmf_company', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_company', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_company', 'workflow_type') op.add_column('cmf_deal', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_deal', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_deal', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_deal_workflow_type', table_name='cmf_deal') op.create_index(op.f('ix_cmf_deal_logic_prefix'), 'cmf_deal', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_deal_parent_logic_prefix'), 'cmf_deal', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_deal_scheme_wf_id'), 'cmf_deal', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_deal', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_deal', 'workflow_type') op.add_column('cmf_document', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_document', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_document', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_document_workflow_type', table_name='cmf_document') op.create_index(op.f('ix_cmf_document_logic_prefix'), 'cmf_document', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_document_parent_logic_prefix'), 'cmf_document', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_document_scheme_wf_id'), 'cmf_document', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_document', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_document', 'workflow_type') op.add_column('cmf_folder', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_folder', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_folder', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_folder_workflow_type', table_name='cmf_folder') op.create_index(op.f('ix_cmf_folder_logic_prefix'), 'cmf_folder', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_folder_parent_logic_prefix'), 'cmf_folder', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_folder_scheme_wf_id'), 'cmf_folder', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_folder', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_folder', 'workflow_type') op.add_column('cmf_import', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_import', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_import', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_import_workflow_type', table_name='cmf_import') op.create_index(op.f('ix_cmf_import_logic_prefix'), 'cmf_import', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_import_parent_logic_prefix'), 'cmf_import', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_import_scheme_wf_id'), 'cmf_import', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_import', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_import', 'workflow_type') op.add_column('cmf_invoice', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_invoice', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_invoice', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_invoice_workflow_type', table_name='cmf_invoice') op.create_index(op.f('ix_cmf_invoice_logic_prefix'), 'cmf_invoice', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_invoice_parent_logic_prefix'), 'cmf_invoice', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_invoice_scheme_wf_id'), 'cmf_invoice', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_invoice', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_invoice', 'workflow_type') op.add_column('cmf_lead', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_lead', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_lead', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_lead_workflow_type', table_name='cmf_lead') op.create_index(op.f('ix_cmf_lead_logic_prefix'), 'cmf_lead', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_lead_parent_logic_prefix'), 'cmf_lead', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_lead_scheme_wf_id'), 'cmf_lead', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_lead', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_lead', 'workflow_type') op.add_column('cmf_list', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_list', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_list', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.add_column('cmf_list', sa.Column('default_task_logic_type_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_list_workflow_type', table_name='cmf_list') op.create_index(op.f('ix_cmf_list_default_task_logic_type_id'), 'cmf_list', ['default_task_logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_list_logic_prefix'), 'cmf_list', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_list_parent_logic_prefix'), 'cmf_list', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_list_scheme_wf_id'), 'cmf_list', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_list', 'cmf_logic_type', ['default_task_logic_type_id'], ['id']) op.create_foreign_key(None, 'cmf_list', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_list', 'workflow_type') op.add_column('cmf_logic_type', sa.Column('filter_parent_logic_prefix', sa.String(length=32), nullable=True)) op.add_column('cmf_logic_type', sa.Column('cmf_model_name', sa.String(), nullable=True)) op.add_column('cmf_logic_type', sa.Column('obj_code_prefix', sa.String(length=32), nullable=True)) op.add_column('cmf_logic_type', sa.Column('template_id', sa.String(length=64), nullable=True)) op.add_column('cmf_logic_type', sa.Column('filter_activity_id', sa.String(length=64), nullable=True)) op.add_column('cmf_logic_type', sa.Column('default_workflow_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_logic_type_activity_id', table_name='cmf_logic_type') op.drop_index('ix_cmf_logic_type_parent_workflow_type', table_name='cmf_logic_type') op.drop_index('ix_cmf_logic_type_workflow_id', table_name='cmf_logic_type') op.drop_index('ix_cmf_logic_type_workflow_subtask_id', table_name='cmf_logic_type') op.drop_index('ix_cmf_logic_type_name', table_name='cmf_logic_type') op.create_index(op.f('ix_cmf_logic_type_name'), 'cmf_logic_type', ['name'], unique=True) op.create_index(op.f('ix_cmf_logic_type_default_workflow_id'), 'cmf_logic_type', ['default_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_logic_type_filter_activity_id'), 'cmf_logic_type', ['filter_activity_id'], unique=False) op.create_index(op.f('ix_cmf_logic_type_template_id'), 'cmf_logic_type', ['template_id'], unique=False) op.drop_constraint('cmf_logic_type_activity_id_fkey', 'cmf_logic_type', type_='foreignkey') op.drop_constraint('cmf_logic_type_workflow_id_fkey', 'cmf_logic_type', type_='foreignkey') op.drop_constraint('cmf_logic_type_workflow_subtask_id_fkey', 'cmf_logic_type', type_='foreignkey') op.create_foreign_key(None, 'cmf_logic_type', 'cmf_logic_type', ['template_id'], ['id']) op.create_foreign_key(None, 'cmf_logic_type', 'cmf_workflow', ['default_workflow_id'], ['id']) op.create_foreign_key(None, 'cmf_logic_type', 'cmf_activity', ['filter_activity_id'], ['id']) op.drop_column('cmf_logic_type', 'has_workflow') op.drop_column('cmf_logic_type', 'parent_workflow_type') op.drop_column('cmf_logic_type', 'activity_id') op.drop_column('cmf_logic_type', 'workflow_id') op.drop_column('cmf_logic_type', 'cmf_model') op.drop_column('cmf_logic_type', 'workflow_subtask_id') op.add_column('cmf_mail', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_mail', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_mail', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_mail_workflow_type', table_name='cmf_mail') op.create_index(op.f('ix_cmf_mail_logic_prefix'), 'cmf_mail', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_mail_parent_logic_prefix'), 'cmf_mail', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_mail_scheme_wf_id'), 'cmf_mail', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_mail', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_mail', 'workflow_type') op.add_column('cmf_payment', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_payment', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_payment', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_payment_workflow_type', table_name='cmf_payment') op.create_index(op.f('ix_cmf_payment_logic_prefix'), 'cmf_payment', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_payment_parent_logic_prefix'), 'cmf_payment', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_payment_scheme_wf_id'), 'cmf_payment', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_payment', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_payment', 'workflow_type') op.add_column('cmf_pipeline', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_pipeline', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_pipeline', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_pipeline_workflow_type', table_name='cmf_pipeline') op.create_index(op.f('ix_cmf_pipeline_logic_prefix'), 'cmf_pipeline', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_pipeline_parent_logic_prefix'), 'cmf_pipeline', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_pipeline_scheme_wf_id'), 'cmf_pipeline', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_pipeline', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_pipeline', 'workflow_type') op.add_column('cmf_project', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_project', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_project', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_project_default_document_workflow_id', table_name='cmf_project') op.drop_index('ix_cmf_project_default_epic_workflow_id', table_name='cmf_project') op.drop_index('ix_cmf_project_default_list_workflow_id', table_name='cmf_project') op.drop_index('ix_cmf_project_default_release_workflow_id', table_name='cmf_project') op.drop_index('ix_cmf_project_default_sprint_workflow_id', table_name='cmf_project') op.create_index(op.f('ix_cmf_project_logic_prefix'), 'cmf_project', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_project_parent_logic_prefix'), 'cmf_project', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_project_scheme_wf_id'), 'cmf_project', ['scheme_wf_id'], unique=False) op.drop_constraint('cmf_project_default_epic_workflow_id_fkey', 'cmf_project', type_='foreignkey') op.drop_constraint('cmf_project_default_release_workflow_id_fkey', 'cmf_project', type_='foreignkey') op.drop_constraint('cmf_project_default_sprint_workflow_id_fkey', 'cmf_project', type_='foreignkey') op.drop_constraint('cmf_project_default_list_workflow_id_fkey', 'cmf_project', type_='foreignkey') op.drop_constraint('cmf_project_default_document_workflow_id_fkey', 'cmf_project', type_='foreignkey') op.create_foreign_key(None, 'cmf_project', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_project', 'default_list_workflow_id') op.drop_column('cmf_project', 'default_epic_workflow_id') op.drop_column('cmf_project', 'default_sprint_workflow_id') op.drop_column('cmf_project', 'default_document_workflow_id') op.drop_column('cmf_project', 'default_release_workflow_id') op.add_column('cmf_purchase_order', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_purchase_order_workflow_type', table_name='cmf_purchase_order') op.create_index(op.f('ix_cmf_purchase_order_logic_prefix'), 'cmf_purchase_order', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_parent_logic_prefix'), 'cmf_purchase_order', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_scheme_wf_id'), 'cmf_purchase_order', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_purchase_order', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_purchase_order', 'workflow_type') op.add_column('cmf_purchase_order_items', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_purchase_order_items_workflow_type', table_name='cmf_purchase_order_items') op.create_index(op.f('ix_cmf_purchase_order_items_logic_prefix'), 'cmf_purchase_order_items', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_items_parent_logic_prefix'), 'cmf_purchase_order_items', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_items_scheme_wf_id'), 'cmf_purchase_order_items', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_purchase_order_items', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_purchase_order_items', 'workflow_type') op.add_column('cmf_roadmap', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_roadmap', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_roadmap', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_roadmap_workflow_type', table_name='cmf_roadmap') op.create_index(op.f('ix_cmf_roadmap_logic_prefix'), 'cmf_roadmap', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_roadmap_parent_logic_prefix'), 'cmf_roadmap', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_roadmap_scheme_wf_id'), 'cmf_roadmap', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_roadmap', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_roadmap', 'workflow_type') op.drop_index('ix_cmf_status_cmf_model_activity_id', table_name='cmf_status') op.drop_constraint('cmf_status_cmf_model_activity_id_fkey', 'cmf_status', type_='foreignkey') op.drop_column('cmf_status', 'options') op.drop_column('cmf_status', 'cmf_model') op.drop_column('cmf_status', 'cmf_model_activity_id') op.add_column('cmf_stock_incoming_order', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_stock_incoming_order_workflow_type', table_name='cmf_stock_incoming_order') op.create_index(op.f('ix_cmf_stock_incoming_order_logic_prefix'), 'cmf_stock_incoming_order', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_incoming_order_parent_logic_prefix'), 'cmf_stock_incoming_order', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_incoming_order_scheme_wf_id'), 'cmf_stock_incoming_order', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_incoming_order', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_stock_incoming_order', 'workflow_type') op.add_column('cmf_stock_initial', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_stock_initial_workflow_type', table_name='cmf_stock_initial') op.create_index(op.f('ix_cmf_stock_initial_logic_prefix'), 'cmf_stock_initial', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_initial_parent_logic_prefix'), 'cmf_stock_initial', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_initial_scheme_wf_id'), 'cmf_stock_initial', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_initial', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_stock_initial', 'workflow_type') op.add_column('cmf_stock_inventory', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_stock_inventory_workflow_type', table_name='cmf_stock_inventory') op.create_index(op.f('ix_cmf_stock_inventory_logic_prefix'), 'cmf_stock_inventory', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_inventory_parent_logic_prefix'), 'cmf_stock_inventory', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_inventory_scheme_wf_id'), 'cmf_stock_inventory', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_inventory', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_stock_inventory', 'workflow_type') op.add_column('cmf_stock_move', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_move', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_move', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_stock_move_workflow_type', table_name='cmf_stock_move') op.create_index(op.f('ix_cmf_stock_move_logic_prefix'), 'cmf_stock_move', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_move_parent_logic_prefix'), 'cmf_stock_move', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_move_scheme_wf_id'), 'cmf_stock_move', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_move', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_stock_move', 'workflow_type') op.add_column('cmf_stock_outcoming_order', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_stock_outcoming_order_workflow_type', table_name='cmf_stock_outcoming_order') op.create_index(op.f('ix_cmf_stock_outcoming_order_logic_prefix'), 'cmf_stock_outcoming_order', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_outcoming_order_parent_logic_prefix'), 'cmf_stock_outcoming_order', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_stock_outcoming_order_scheme_wf_id'), 'cmf_stock_outcoming_order', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_outcoming_order', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_stock_outcoming_order', 'workflow_type') op.add_column('cmf_tag', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_tag', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.drop_index('ix_cmf_tag_parent_logic_type_id', table_name='cmf_tag') op.drop_index('ix_cmf_tag_parent_workflow_type', table_name='cmf_tag') op.drop_constraint('cmf_tag_parent_logic_type_id_fkey', 'cmf_tag', type_='foreignkey') op.drop_column('cmf_tag', 'has_workflow') op.drop_column('cmf_tag', 'parent_logic_type_id') op.drop_column('cmf_tag', 'parent_workflow_type') op.add_column('cmf_task', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_task', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_task', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_task_workflow_type', table_name='cmf_task') op.create_index(op.f('ix_cmf_task_logic_prefix'), 'cmf_task', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_task_parent_logic_prefix'), 'cmf_task', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_task_scheme_wf_id'), 'cmf_task', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_task', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_task', 'workflow_type') op.add_column('cmf_u_work_post', sa.Column('logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('parent_logic_prefix', sa.String(), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('scheme_wf_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_u_work_post_workflow_type', table_name='cmf_u_work_post') op.create_index(op.f('ix_cmf_u_work_post_logic_prefix'), 'cmf_u_work_post', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_u_work_post_parent_logic_prefix'), 'cmf_u_work_post', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_u_work_post_scheme_wf_id'), 'cmf_u_work_post', ['scheme_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_u_work_post', 'cmf_scheme_wf', ['scheme_wf_id'], ['id']) op.drop_column('cmf_u_work_post', 'workflow_type') op.add_column('cmf_workflow', sa.Column('default_deadline_shift', sa.Integer(), nullable=True)) op.add_column('cmf_workflow', sa.Column('default_task_need_approve', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_workflow', sa.Column('default_task_only_owner_close', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_workflow', sa.Column('save_eval_code', sa.TEXT(), nullable=True)) op.add_column('cmf_workflow', sa.Column('scheme_draw_config', sa.TEXT(), nullable=True)) op.add_column('cmf_workflow', sa.Column('template_id', sa.String(length=64), nullable=True)) op.drop_index('ix_cmf_workflow_activity_id', table_name='cmf_workflow') op.drop_index('ix_cmf_workflow_logic_type_id', table_name='cmf_workflow') op.drop_index('ix_cmf_workflow_tag_id', table_name='cmf_workflow') op.drop_index('ix_cmf_workflow_workflow_type_id', table_name='cmf_workflow') op.create_index(op.f('ix_cmf_workflow_template_id'), 'cmf_workflow', ['template_id'], unique=False) op.drop_constraint('cmf_workflow_workflow_type_id_fkey', 'cmf_workflow', type_='foreignkey') op.drop_constraint('cmf_workflow_activity_id_fkey', 'cmf_workflow', type_='foreignkey') op.drop_constraint('cmf_workflow_logic_type_id_fkey', 'cmf_workflow', type_='foreignkey') op.drop_constraint('cmf_workflow_tag_id_fkey', 'cmf_workflow', type_='foreignkey') op.create_foreign_key(None, 'cmf_workflow', 'cmf_workflow', ['template_id'], ['id']) op.drop_column('cmf_workflow', 'activity_id') op.drop_column('cmf_workflow', 'logic_type_id') op.drop_column('cmf_workflow', 'workflow_type_id') op.drop_column('cmf_workflow', 'tag_id') op.drop_column('cmf_workflow', 'cmf_model') op.drop_column('cmf_workflow', 'short_name') op.drop_table('cmf_workflow_type') # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('cmf_workflow', sa.Column('short_name', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('cmf_model', sa.VARCHAR(length=32), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('tag_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('workflow_type_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('logic_type_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('activity_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_workflow', type_='foreignkey') op.create_foreign_key('cmf_workflow_tag_id_fkey', 'cmf_workflow', 'cmf_tag', ['tag_id'], ['id']) op.create_foreign_key('cmf_workflow_logic_type_id_fkey', 'cmf_workflow', 'cmf_logic_type', ['logic_type_id'], ['id']) op.create_foreign_key('cmf_workflow_activity_id_fkey', 'cmf_workflow', 'cmf_activity', ['activity_id'], ['id']) op.create_foreign_key('cmf_workflow_workflow_type_id_fkey', 'cmf_workflow', 'cmf_workflow_type', ['workflow_type_id'], ['id']) op.drop_index(op.f('ix_cmf_workflow_template_id'), table_name='cmf_workflow') op.create_index('ix_cmf_workflow_workflow_type_id', 'cmf_workflow', ['workflow_type_id'], unique=False) op.create_index('ix_cmf_workflow_tag_id', 'cmf_workflow', ['tag_id'], unique=False) op.create_index('ix_cmf_workflow_logic_type_id', 'cmf_workflow', ['logic_type_id'], unique=False) op.create_index('ix_cmf_workflow_activity_id', 'cmf_workflow', ['activity_id'], unique=False) op.drop_column('cmf_workflow', 'template_id') op.drop_column('cmf_workflow', 'scheme_draw_config') op.drop_column('cmf_workflow', 'save_eval_code') op.drop_column('cmf_workflow', 'default_task_only_owner_close') op.drop_column('cmf_workflow', 'default_task_need_approve') op.drop_column('cmf_workflow', 'default_deadline_shift') op.add_column('cmf_u_work_post', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_u_work_post', type_='foreignkey') op.drop_index(op.f('ix_cmf_u_work_post_scheme_wf_id'), table_name='cmf_u_work_post') op.drop_index(op.f('ix_cmf_u_work_post_parent_logic_prefix'), table_name='cmf_u_work_post') op.drop_index(op.f('ix_cmf_u_work_post_logic_prefix'), table_name='cmf_u_work_post') op.create_index('ix_cmf_u_work_post_workflow_type', 'cmf_u_work_post', ['workflow_type'], unique=False) op.drop_column('cmf_u_work_post', 'scheme_wf_id') op.drop_column('cmf_u_work_post', 'parent_logic_prefix') op.drop_column('cmf_u_work_post', 'logic_prefix') op.add_column('cmf_task', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_task', type_='foreignkey') op.drop_index(op.f('ix_cmf_task_scheme_wf_id'), table_name='cmf_task') op.drop_index(op.f('ix_cmf_task_parent_logic_prefix'), table_name='cmf_task') op.drop_index(op.f('ix_cmf_task_logic_prefix'), table_name='cmf_task') op.create_index('ix_cmf_task_workflow_type', 'cmf_task', ['workflow_type'], unique=False) op.drop_column('cmf_task', 'scheme_wf_id') op.drop_column('cmf_task', 'parent_logic_prefix') op.drop_column('cmf_task', 'logic_prefix') op.add_column('cmf_tag', sa.Column('parent_workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_tag', sa.Column('parent_logic_type_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_tag', sa.Column('has_workflow', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False)) op.create_foreign_key('cmf_tag_parent_logic_type_id_fkey', 'cmf_tag', 'cmf_logic_type', ['parent_logic_type_id'], ['id']) op.create_index('ix_cmf_tag_parent_workflow_type', 'cmf_tag', ['parent_workflow_type'], unique=False) op.create_index('ix_cmf_tag_parent_logic_type_id', 'cmf_tag', ['parent_logic_type_id'], unique=False) op.drop_column('cmf_tag', 'parent_logic_prefix') op.drop_column('cmf_tag', 'logic_prefix') op.add_column('cmf_stock_outcoming_order', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_outcoming_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_outcoming_order_scheme_wf_id'), table_name='cmf_stock_outcoming_order') op.drop_index(op.f('ix_cmf_stock_outcoming_order_parent_logic_prefix'), table_name='cmf_stock_outcoming_order') op.drop_index(op.f('ix_cmf_stock_outcoming_order_logic_prefix'), table_name='cmf_stock_outcoming_order') op.create_index('ix_cmf_stock_outcoming_order_workflow_type', 'cmf_stock_outcoming_order', ['workflow_type'], unique=False) op.drop_column('cmf_stock_outcoming_order', 'scheme_wf_id') op.drop_column('cmf_stock_outcoming_order', 'parent_logic_prefix') op.drop_column('cmf_stock_outcoming_order', 'logic_prefix') op.add_column('cmf_stock_move', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_move', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_move_scheme_wf_id'), table_name='cmf_stock_move') op.drop_index(op.f('ix_cmf_stock_move_parent_logic_prefix'), table_name='cmf_stock_move') op.drop_index(op.f('ix_cmf_stock_move_logic_prefix'), table_name='cmf_stock_move') op.create_index('ix_cmf_stock_move_workflow_type', 'cmf_stock_move', ['workflow_type'], unique=False) op.drop_column('cmf_stock_move', 'scheme_wf_id') op.drop_column('cmf_stock_move', 'parent_logic_prefix') op.drop_column('cmf_stock_move', 'logic_prefix') op.add_column('cmf_stock_inventory', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_inventory', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_inventory_scheme_wf_id'), table_name='cmf_stock_inventory') op.drop_index(op.f('ix_cmf_stock_inventory_parent_logic_prefix'), table_name='cmf_stock_inventory') op.drop_index(op.f('ix_cmf_stock_inventory_logic_prefix'), table_name='cmf_stock_inventory') op.create_index('ix_cmf_stock_inventory_workflow_type', 'cmf_stock_inventory', ['workflow_type'], unique=False) op.drop_column('cmf_stock_inventory', 'scheme_wf_id') op.drop_column('cmf_stock_inventory', 'parent_logic_prefix') op.drop_column('cmf_stock_inventory', 'logic_prefix') op.add_column('cmf_stock_initial', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_initial', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_initial_scheme_wf_id'), table_name='cmf_stock_initial') op.drop_index(op.f('ix_cmf_stock_initial_parent_logic_prefix'), table_name='cmf_stock_initial') op.drop_index(op.f('ix_cmf_stock_initial_logic_prefix'), table_name='cmf_stock_initial') op.create_index('ix_cmf_stock_initial_workflow_type', 'cmf_stock_initial', ['workflow_type'], unique=False) op.drop_column('cmf_stock_initial', 'scheme_wf_id') op.drop_column('cmf_stock_initial', 'parent_logic_prefix') op.drop_column('cmf_stock_initial', 'logic_prefix') op.add_column('cmf_stock_incoming_order', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_incoming_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_incoming_order_scheme_wf_id'), table_name='cmf_stock_incoming_order') op.drop_index(op.f('ix_cmf_stock_incoming_order_parent_logic_prefix'), table_name='cmf_stock_incoming_order') op.drop_index(op.f('ix_cmf_stock_incoming_order_logic_prefix'), table_name='cmf_stock_incoming_order') op.create_index('ix_cmf_stock_incoming_order_workflow_type', 'cmf_stock_incoming_order', ['workflow_type'], unique=False) op.drop_column('cmf_stock_incoming_order', 'scheme_wf_id') op.drop_column('cmf_stock_incoming_order', 'parent_logic_prefix') op.drop_column('cmf_stock_incoming_order', 'logic_prefix') op.add_column('cmf_status', sa.Column('cmf_model_activity_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_status', sa.Column('cmf_model', sa.VARCHAR(length=32), autoincrement=False, nullable=True)) op.add_column('cmf_status', sa.Column('options', sa.TEXT(), autoincrement=False, nullable=True)) op.create_foreign_key('cmf_status_cmf_model_activity_id_fkey', 'cmf_status', 'cmf_activity', ['cmf_model_activity_id'], ['id']) op.create_index('ix_cmf_status_cmf_model_activity_id', 'cmf_status', ['cmf_model_activity_id'], unique=False) op.add_column('cmf_roadmap', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_roadmap', type_='foreignkey') op.drop_index(op.f('ix_cmf_roadmap_scheme_wf_id'), table_name='cmf_roadmap') op.drop_index(op.f('ix_cmf_roadmap_parent_logic_prefix'), table_name='cmf_roadmap') op.drop_index(op.f('ix_cmf_roadmap_logic_prefix'), table_name='cmf_roadmap') op.create_index('ix_cmf_roadmap_workflow_type', 'cmf_roadmap', ['workflow_type'], unique=False) op.drop_column('cmf_roadmap', 'scheme_wf_id') op.drop_column('cmf_roadmap', 'parent_logic_prefix') op.drop_column('cmf_roadmap', 'logic_prefix') op.add_column('cmf_purchase_order_items', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_purchase_order_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_purchase_order_items_scheme_wf_id'), table_name='cmf_purchase_order_items') op.drop_index(op.f('ix_cmf_purchase_order_items_parent_logic_prefix'), table_name='cmf_purchase_order_items') op.drop_index(op.f('ix_cmf_purchase_order_items_logic_prefix'), table_name='cmf_purchase_order_items') op.create_index('ix_cmf_purchase_order_items_workflow_type', 'cmf_purchase_order_items', ['workflow_type'], unique=False) op.drop_column('cmf_purchase_order_items', 'scheme_wf_id') op.drop_column('cmf_purchase_order_items', 'parent_logic_prefix') op.drop_column('cmf_purchase_order_items', 'logic_prefix') op.add_column('cmf_purchase_order', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_purchase_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_purchase_order_scheme_wf_id'), table_name='cmf_purchase_order') op.drop_index(op.f('ix_cmf_purchase_order_parent_logic_prefix'), table_name='cmf_purchase_order') op.drop_index(op.f('ix_cmf_purchase_order_logic_prefix'), table_name='cmf_purchase_order') op.create_index('ix_cmf_purchase_order_workflow_type', 'cmf_purchase_order', ['workflow_type'], unique=False) op.drop_column('cmf_purchase_order', 'scheme_wf_id') op.drop_column('cmf_purchase_order', 'parent_logic_prefix') op.drop_column('cmf_purchase_order', 'logic_prefix') op.add_column('cmf_project', sa.Column('default_release_workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_project', sa.Column('default_document_workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_project', sa.Column('default_sprint_workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_project', sa.Column('default_epic_workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_project', sa.Column('default_list_workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_project', type_='foreignkey') op.create_foreign_key('cmf_project_default_document_workflow_id_fkey', 'cmf_project', 'cmf_workflow', ['default_document_workflow_id'], ['id']) op.create_foreign_key('cmf_project_default_list_workflow_id_fkey', 'cmf_project', 'cmf_workflow', ['default_list_workflow_id'], ['id']) op.create_foreign_key('cmf_project_default_sprint_workflow_id_fkey', 'cmf_project', 'cmf_workflow', ['default_sprint_workflow_id'], ['id']) op.create_foreign_key('cmf_project_default_release_workflow_id_fkey', 'cmf_project', 'cmf_workflow', ['default_release_workflow_id'], ['id']) op.create_foreign_key('cmf_project_default_epic_workflow_id_fkey', 'cmf_project', 'cmf_workflow', ['default_epic_workflow_id'], ['id']) op.drop_index(op.f('ix_cmf_project_scheme_wf_id'), table_name='cmf_project') op.drop_index(op.f('ix_cmf_project_parent_logic_prefix'), table_name='cmf_project') op.drop_index(op.f('ix_cmf_project_logic_prefix'), table_name='cmf_project') op.create_index('ix_cmf_project_default_sprint_workflow_id', 'cmf_project', ['default_sprint_workflow_id'], unique=False) op.create_index('ix_cmf_project_default_release_workflow_id', 'cmf_project', ['default_release_workflow_id'], unique=False) op.create_index('ix_cmf_project_default_list_workflow_id', 'cmf_project', ['default_list_workflow_id'], unique=False) op.create_index('ix_cmf_project_default_epic_workflow_id', 'cmf_project', ['default_epic_workflow_id'], unique=False) op.create_index('ix_cmf_project_default_document_workflow_id', 'cmf_project', ['default_document_workflow_id'], unique=False) op.drop_column('cmf_project', 'scheme_wf_id') op.drop_column('cmf_project', 'parent_logic_prefix') op.drop_column('cmf_project', 'logic_prefix') op.add_column('cmf_pipeline', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_pipeline', type_='foreignkey') op.drop_index(op.f('ix_cmf_pipeline_scheme_wf_id'), table_name='cmf_pipeline') op.drop_index(op.f('ix_cmf_pipeline_parent_logic_prefix'), table_name='cmf_pipeline') op.drop_index(op.f('ix_cmf_pipeline_logic_prefix'), table_name='cmf_pipeline') op.create_index('ix_cmf_pipeline_workflow_type', 'cmf_pipeline', ['workflow_type'], unique=False) op.drop_column('cmf_pipeline', 'scheme_wf_id') op.drop_column('cmf_pipeline', 'parent_logic_prefix') op.drop_column('cmf_pipeline', 'logic_prefix') op.add_column('cmf_payment', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_payment', type_='foreignkey') op.drop_index(op.f('ix_cmf_payment_scheme_wf_id'), table_name='cmf_payment') op.drop_index(op.f('ix_cmf_payment_parent_logic_prefix'), table_name='cmf_payment') op.drop_index(op.f('ix_cmf_payment_logic_prefix'), table_name='cmf_payment') op.create_index('ix_cmf_payment_workflow_type', 'cmf_payment', ['workflow_type'], unique=False) op.drop_column('cmf_payment', 'scheme_wf_id') op.drop_column('cmf_payment', 'parent_logic_prefix') op.drop_column('cmf_payment', 'logic_prefix') op.add_column('cmf_mail', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_mail', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_scheme_wf_id'), table_name='cmf_mail') op.drop_index(op.f('ix_cmf_mail_parent_logic_prefix'), table_name='cmf_mail') op.drop_index(op.f('ix_cmf_mail_logic_prefix'), table_name='cmf_mail') op.create_index('ix_cmf_mail_workflow_type', 'cmf_mail', ['workflow_type'], unique=False) op.drop_column('cmf_mail', 'scheme_wf_id') op.drop_column('cmf_mail', 'parent_logic_prefix') op.drop_column('cmf_mail', 'logic_prefix') op.add_column('cmf_logic_type', sa.Column('workflow_subtask_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_logic_type', sa.Column('cmf_model', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_logic_type', sa.Column('workflow_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_logic_type', sa.Column('activity_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_logic_type', sa.Column('parent_workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_logic_type', sa.Column('has_workflow', sa.BOOLEAN(), server_default=sa.text('false'), autoincrement=False, nullable=False)) op.drop_constraint(None, 'cmf_logic_type', type_='foreignkey') op.drop_constraint(None, 'cmf_logic_type', type_='foreignkey') op.drop_constraint(None, 'cmf_logic_type', type_='foreignkey') op.create_foreign_key('cmf_logic_type_workflow_subtask_id_fkey', 'cmf_logic_type', 'cmf_workflow', ['workflow_subtask_id'], ['id']) op.create_foreign_key('cmf_logic_type_workflow_id_fkey', 'cmf_logic_type', 'cmf_workflow', ['workflow_id'], ['id']) op.create_foreign_key('cmf_logic_type_activity_id_fkey', 'cmf_logic_type', 'cmf_activity', ['activity_id'], ['id']) op.drop_index(op.f('ix_cmf_logic_type_template_id'), table_name='cmf_logic_type') op.drop_index(op.f('ix_cmf_logic_type_filter_activity_id'), table_name='cmf_logic_type') op.drop_index(op.f('ix_cmf_logic_type_default_workflow_id'), table_name='cmf_logic_type') op.drop_index(op.f('ix_cmf_logic_type_name'), table_name='cmf_logic_type') op.create_index('ix_cmf_logic_type_name', 'cmf_logic_type', ['name'], unique=False) op.create_index('ix_cmf_logic_type_workflow_subtask_id', 'cmf_logic_type', ['workflow_subtask_id'], unique=False) op.create_index('ix_cmf_logic_type_workflow_id', 'cmf_logic_type', ['workflow_id'], unique=False) op.create_index('ix_cmf_logic_type_parent_workflow_type', 'cmf_logic_type', ['parent_workflow_type'], unique=False) op.create_index('ix_cmf_logic_type_activity_id', 'cmf_logic_type', ['activity_id'], unique=False) op.drop_column('cmf_logic_type', 'default_workflow_id') op.drop_column('cmf_logic_type', 'filter_activity_id') op.drop_column('cmf_logic_type', 'template_id') op.drop_column('cmf_logic_type', 'obj_code_prefix') op.drop_column('cmf_logic_type', 'cmf_model_name') op.drop_column('cmf_logic_type', 'filter_parent_logic_prefix') op.add_column('cmf_list', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_list', type_='foreignkey') op.drop_constraint(None, 'cmf_list', type_='foreignkey') op.drop_index(op.f('ix_cmf_list_scheme_wf_id'), table_name='cmf_list') op.drop_index(op.f('ix_cmf_list_parent_logic_prefix'), table_name='cmf_list') op.drop_index(op.f('ix_cmf_list_logic_prefix'), table_name='cmf_list') op.drop_index(op.f('ix_cmf_list_default_task_logic_type_id'), table_name='cmf_list') op.create_index('ix_cmf_list_workflow_type', 'cmf_list', ['workflow_type'], unique=False) op.drop_column('cmf_list', 'default_task_logic_type_id') op.drop_column('cmf_list', 'scheme_wf_id') op.drop_column('cmf_list', 'parent_logic_prefix') op.drop_column('cmf_list', 'logic_prefix') op.add_column('cmf_lead', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_lead', type_='foreignkey') op.drop_index(op.f('ix_cmf_lead_scheme_wf_id'), table_name='cmf_lead') op.drop_index(op.f('ix_cmf_lead_parent_logic_prefix'), table_name='cmf_lead') op.drop_index(op.f('ix_cmf_lead_logic_prefix'), table_name='cmf_lead') op.create_index('ix_cmf_lead_workflow_type', 'cmf_lead', ['workflow_type'], unique=False) op.drop_column('cmf_lead', 'scheme_wf_id') op.drop_column('cmf_lead', 'parent_logic_prefix') op.drop_column('cmf_lead', 'logic_prefix') op.add_column('cmf_invoice', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_invoice', type_='foreignkey') op.drop_index(op.f('ix_cmf_invoice_scheme_wf_id'), table_name='cmf_invoice') op.drop_index(op.f('ix_cmf_invoice_parent_logic_prefix'), table_name='cmf_invoice') op.drop_index(op.f('ix_cmf_invoice_logic_prefix'), table_name='cmf_invoice') op.create_index('ix_cmf_invoice_workflow_type', 'cmf_invoice', ['workflow_type'], unique=False) op.drop_column('cmf_invoice', 'scheme_wf_id') op.drop_column('cmf_invoice', 'parent_logic_prefix') op.drop_column('cmf_invoice', 'logic_prefix') op.add_column('cmf_import', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_import', type_='foreignkey') op.drop_index(op.f('ix_cmf_import_scheme_wf_id'), table_name='cmf_import') op.drop_index(op.f('ix_cmf_import_parent_logic_prefix'), table_name='cmf_import') op.drop_index(op.f('ix_cmf_import_logic_prefix'), table_name='cmf_import') op.create_index('ix_cmf_import_workflow_type', 'cmf_import', ['workflow_type'], unique=False) op.drop_column('cmf_import', 'scheme_wf_id') op.drop_column('cmf_import', 'parent_logic_prefix') op.drop_column('cmf_import', 'logic_prefix') op.add_column('cmf_folder', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_folder', type_='foreignkey') op.drop_index(op.f('ix_cmf_folder_scheme_wf_id'), table_name='cmf_folder') op.drop_index(op.f('ix_cmf_folder_parent_logic_prefix'), table_name='cmf_folder') op.drop_index(op.f('ix_cmf_folder_logic_prefix'), table_name='cmf_folder') op.create_index('ix_cmf_folder_workflow_type', 'cmf_folder', ['workflow_type'], unique=False) op.drop_column('cmf_folder', 'scheme_wf_id') op.drop_column('cmf_folder', 'parent_logic_prefix') op.drop_column('cmf_folder', 'logic_prefix') op.add_column('cmf_document', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_document', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_scheme_wf_id'), table_name='cmf_document') op.drop_index(op.f('ix_cmf_document_parent_logic_prefix'), table_name='cmf_document') op.drop_index(op.f('ix_cmf_document_logic_prefix'), table_name='cmf_document') op.create_index('ix_cmf_document_workflow_type', 'cmf_document', ['workflow_type'], unique=False) op.drop_column('cmf_document', 'scheme_wf_id') op.drop_column('cmf_document', 'parent_logic_prefix') op.drop_column('cmf_document', 'logic_prefix') op.add_column('cmf_deal', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_deal', type_='foreignkey') op.drop_index(op.f('ix_cmf_deal_scheme_wf_id'), table_name='cmf_deal') op.drop_index(op.f('ix_cmf_deal_parent_logic_prefix'), table_name='cmf_deal') op.drop_index(op.f('ix_cmf_deal_logic_prefix'), table_name='cmf_deal') op.create_index('ix_cmf_deal_workflow_type', 'cmf_deal', ['workflow_type'], unique=False) op.drop_column('cmf_deal', 'scheme_wf_id') op.drop_column('cmf_deal', 'parent_logic_prefix') op.drop_column('cmf_deal', 'logic_prefix') op.add_column('cmf_company', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_company', type_='foreignkey') op.drop_index(op.f('ix_cmf_company_scheme_wf_id'), table_name='cmf_company') op.drop_index(op.f('ix_cmf_company_parent_logic_prefix'), table_name='cmf_company') op.drop_index(op.f('ix_cmf_company_logic_prefix'), table_name='cmf_company') op.create_index('ix_cmf_company_workflow_type', 'cmf_company', ['workflow_type'], unique=False) op.drop_column('cmf_company', 'scheme_wf_id') op.drop_column('cmf_company', 'parent_logic_prefix') op.drop_column('cmf_company', 'logic_prefix') op.add_column('cmf_chat_topic', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_chat_topic', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_topic_scheme_wf_id'), table_name='cmf_chat_topic') op.drop_index(op.f('ix_cmf_chat_topic_parent_logic_prefix'), table_name='cmf_chat_topic') op.drop_index(op.f('ix_cmf_chat_topic_logic_prefix'), table_name='cmf_chat_topic') op.create_index('ix_cmf_chat_topic_workflow_type', 'cmf_chat_topic', ['workflow_type'], unique=False) op.drop_column('cmf_chat_topic', 'scheme_wf_id') op.drop_column('cmf_chat_topic', 'parent_logic_prefix') op.drop_column('cmf_chat_topic', 'logic_prefix') op.add_column('cmf_chat_group', sa.Column('workflow_type', sa.VARCHAR(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_chat_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_group_scheme_wf_id'), table_name='cmf_chat_group') op.drop_index(op.f('ix_cmf_chat_group_parent_logic_prefix'), table_name='cmf_chat_group') op.drop_index(op.f('ix_cmf_chat_group_logic_prefix'), table_name='cmf_chat_group') op.create_index('ix_cmf_chat_group_workflow_type', 'cmf_chat_group', ['workflow_type'], unique=False) op.drop_column('cmf_chat_group', 'scheme_wf_id') op.drop_column('cmf_chat_group', 'parent_logic_prefix') op.drop_column('cmf_chat_group', 'logic_prefix') op.add_column('cmf_activity', sa.Column('prefix', sa.VARCHAR(length=32), autoincrement=False, nullable=True)) op.add_column('cmf_activity', sa.Column('default_deadline_shift', sa.INTEGER(), autoincrement=False, nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('filter_workflow_type', sa.VARCHAR(length=32), autoincrement=False, nullable=True)) op.drop_column('cmf_active_entity_filter', 'filter_logic_prefix') op.create_table('cmf_workflow_type', sa.Column('id', sa.VARCHAR(length=64), autoincrement=False, nullable=False), sa.Column('cmf_locked_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('cmf_created_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=False), sa.Column('cmf_modified_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=False), sa.Column('cmf_viewed_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.Column('cmf_deleted', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('cmf_version', sa.BIGINT(), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.Column('code', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('system', sa.BOOLEAN(), autoincrement=False, nullable=False), sa.Column('text', sa.TEXT(), autoincrement=False, nullable=True), sa.Column('is_favorite', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('has_tree_nodes', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('tree_node_is_branch', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('tree_hidden', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('orderno', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('cmf_model', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('cmf_author_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('cmf_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('cmf_owner_assistant_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('cmf_modified_by_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('cmf_locked_by_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('cmf_import_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('tree_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('short_name', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('perm_encrypt', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('perm_inherit', sa.BOOLEAN(), server_default=sa.text('true'), autoincrement=False, nullable=True), sa.Column('perm_acl_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('perm_has_acl', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('perm_inherit_acl_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('perm_effective_acl_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('perm_parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('perm_parent_owner_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('perm_public', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('ext_id', sa.VARCHAR(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], name='cmf_workflow_type_cmf_import_id_fkey'), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], name='cmf_workflow_type_perm_acl_id_fkey'), sa.PrimaryKeyConstraint('id', name='cmf_workflow_type_pkey') ) op.create_index('ix_cmf_workflow_type_tree_parent_id', 'cmf_workflow_type', ['tree_parent_id'], unique=False) op.create_index('ix_cmf_workflow_type_perm_parent_id', 'cmf_workflow_type', ['perm_parent_id'], unique=False) op.create_index('ix_cmf_workflow_type_perm_acl_id', 'cmf_workflow_type', ['perm_acl_id'], unique=False) op.create_index('ix_cmf_workflow_type_parent_id', 'cmf_workflow_type', ['parent_id'], unique=False) op.create_index('ix_cmf_workflow_type_orderno', 'cmf_workflow_type', ['orderno'], unique=False) op.create_index('ix_cmf_workflow_type_name', 'cmf_workflow_type', ['name'], unique=False) op.create_index('ix_cmf_workflow_type_code', 'cmf_workflow_type', ['code'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_viewed_at', 'cmf_workflow_type', ['cmf_viewed_at'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_version', 'cmf_workflow_type', ['cmf_version'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_owner_id', 'cmf_workflow_type', ['cmf_owner_id'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_owner_assistant_id', 'cmf_workflow_type', ['cmf_owner_assistant_id'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_modified_by_id', 'cmf_workflow_type', ['cmf_modified_by_id'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_modified_at', 'cmf_workflow_type', ['cmf_modified_at'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_locked_by_id', 'cmf_workflow_type', ['cmf_locked_by_id'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_locked_at', 'cmf_workflow_type', ['cmf_locked_at'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_import_id', 'cmf_workflow_type', ['cmf_import_id'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_deleted', 'cmf_workflow_type', ['cmf_deleted'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_created_at', 'cmf_workflow_type', ['cmf_created_at'], unique=False) op.create_index('ix_cmf_workflow_type_cmf_author_id', 'cmf_workflow_type', ['cmf_author_id'], unique=False) op.drop_index(op.f('ix_cmf_trans_valid_wz_value_obj_root_id'), table_name='cmf_trans_valid_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_valid_wz_value_obj_right_id'), table_name='cmf_trans_valid_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_valid_wz_value_obj_parent_id'), table_name='cmf_trans_valid_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_valid_wz_value_obj_left_id'), table_name='cmf_trans_valid_wz_value_obj') op.drop_table('cmf_trans_valid_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_valid_tree_parent_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_transition_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_perm_parent_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_perm_acl_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_parent_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_orderno'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_name'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_code'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_viewed_at'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_version'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_owner_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_owner_assistant_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_modified_by_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_modified_at'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_locked_by_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_locked_at'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_import_id'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_deleted'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_created_at'), table_name='cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_valid_cmf_author_id'), table_name='cmf_trans_valid') op.drop_table('cmf_trans_valid') op.drop_index(op.f('ix_cmf_trans_filter_wz_value_obj_root_id'), table_name='cmf_trans_filter_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_filter_wz_value_obj_right_id'), table_name='cmf_trans_filter_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_filter_wz_value_obj_parent_id'), table_name='cmf_trans_filter_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_filter_wz_value_obj_left_id'), table_name='cmf_trans_filter_wz_value_obj') op.drop_table('cmf_trans_filter_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_filter_tree_parent_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_transition_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_perm_parent_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_perm_acl_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_parent_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_orderno'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_name'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_code'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_viewed_at'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_version'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_owner_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_owner_assistant_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_modified_by_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_modified_at'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_locked_by_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_locked_at'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_import_id'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_deleted'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_created_at'), table_name='cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_filter_cmf_author_id'), table_name='cmf_trans_filter') op.drop_table('cmf_trans_filter') op.drop_index(op.f('ix_cmf_trans_cmf_status_root_id'), table_name='cmf_trans_cmf_status') op.drop_index(op.f('ix_cmf_trans_cmf_status_right_id'), table_name='cmf_trans_cmf_status') op.drop_index(op.f('ix_cmf_trans_cmf_status_parent_id'), table_name='cmf_trans_cmf_status') op.drop_index(op.f('ix_cmf_trans_cmf_status_left_id'), table_name='cmf_trans_cmf_status') op.drop_table('cmf_trans_cmf_status') op.drop_index(op.f('ix_cmf_trans_action_wz_value_obj_root_id'), table_name='cmf_trans_action_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_action_wz_value_obj_right_id'), table_name='cmf_trans_action_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_action_wz_value_obj_parent_id'), table_name='cmf_trans_action_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_action_wz_value_obj_left_id'), table_name='cmf_trans_action_wz_value_obj') op.drop_table('cmf_trans_action_wz_value_obj') op.drop_index(op.f('ix_cmf_trans_action_tree_parent_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_transition_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_perm_parent_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_perm_acl_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_parent_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_orderno'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_name'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_code'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_viewed_at'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_version'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_owner_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_owner_assistant_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_modified_by_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_modified_at'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_locked_by_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_locked_at'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_import_id'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_deleted'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_created_at'), table_name='cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_action_cmf_author_id'), table_name='cmf_trans_action') op.drop_table('cmf_trans_action') op.drop_index(op.f('ix_cmf_trans_workflow_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_tree_parent_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_status_to_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_perm_parent_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_perm_acl_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_parent_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_orderno'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_name'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_do_validation_by_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_do_filter_by_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_do_action_by_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_code'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_viewed_at'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_version'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_owner_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_owner_assistant_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_modified_by_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_modified_at'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_locked_by_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_locked_at'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_import_id'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_deleted'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_created_at'), table_name='cmf_trans') op.drop_index(op.f('ix_cmf_trans_cmf_author_id'), table_name='cmf_trans') op.drop_table('cmf_trans') op.drop_index(op.f('ix_cmf_tag_cmf_scheme_wf_root_id'), table_name='cmf_tag_cmf_scheme_wf') op.drop_index(op.f('ix_cmf_tag_cmf_scheme_wf_right_id'), table_name='cmf_tag_cmf_scheme_wf') op.drop_index(op.f('ix_cmf_tag_cmf_scheme_wf_parent_id'), table_name='cmf_tag_cmf_scheme_wf') op.drop_index(op.f('ix_cmf_tag_cmf_scheme_wf_left_id'), table_name='cmf_tag_cmf_scheme_wf') op.drop_table('cmf_tag_cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_spectators_root_id'), table_name='cmf_scheme_wf_spectators') op.drop_index(op.f('ix_cmf_scheme_wf_spectators_right_id'), table_name='cmf_scheme_wf_spectators') op.drop_index(op.f('ix_cmf_scheme_wf_spectators_parent_id'), table_name='cmf_scheme_wf_spectators') op.drop_index(op.f('ix_cmf_scheme_wf_spectators_left_id'), table_name='cmf_scheme_wf_spectators') op.drop_table('cmf_scheme_wf_spectators') op.drop_index(op.f('ix_cmf_scheme_wf_rule_tree_parent_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_target_workflow_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_target_scheme_wf_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_scheme_wf_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_perm_parent_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_perm_acl_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_parent_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_orderno'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_name'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_logic_type_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_code'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_viewed_at'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_version'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_owner_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_owner_assistant_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_modified_by_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_modified_at'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_locked_by_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_locked_at'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_import_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_deleted'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_created_at'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_cmf_author_id'), table_name='cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_rule_activity_id'), table_name='cmf_scheme_wf_rule') op.drop_table('cmf_scheme_wf_rule') op.drop_index(op.f('ix_cmf_scheme_wf_executors_root_id'), table_name='cmf_scheme_wf_executors') op.drop_index(op.f('ix_cmf_scheme_wf_executors_right_id'), table_name='cmf_scheme_wf_executors') op.drop_index(op.f('ix_cmf_scheme_wf_executors_parent_id'), table_name='cmf_scheme_wf_executors') op.drop_index(op.f('ix_cmf_scheme_wf_executors_left_id'), table_name='cmf_scheme_wf_executors') op.drop_table('cmf_scheme_wf_executors') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_root_id'), table_name='cmf_scheme_wf_cmf_logic_type') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_right_id'), table_name='cmf_scheme_wf_cmf_logic_type') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_parent_id'), table_name='cmf_scheme_wf_cmf_logic_type') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_logic_type_left_id'), table_name='cmf_scheme_wf_cmf_logic_type') op.drop_table('cmf_scheme_wf_cmf_logic_type') op.drop_index(op.f('ix_cmf_scheme_wf_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_waiting_for_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_tree_parent_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_template_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_status_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_scheme_wf_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_responsible_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_perm_parent_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_perm_acl_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_parent_logic_prefix'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_parent_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_orderno'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_name'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_logic_type_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_logic_prefix'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_is_template'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_version_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_task_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_task_logic_type_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_subtask_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_sprint_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_release_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_list_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_epic_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_default_document_workflow_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_company_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_code'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_viewed_at'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_version'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_owner_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_owner_assistant_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_modified_by_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_modified_at'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_locked_by_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_locked_at'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_import_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_deleted'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_created_at'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cmf_author_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cloned_from_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cache_status_type'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_cache_status_opt_id'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_approved'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_alarm_date'), table_name='cmf_scheme_wf') op.drop_index(op.f('ix_cmf_scheme_wf_activity_id'), table_name='cmf_scheme_wf') op.drop_table('cmf_scheme_wf') op.drop_index(op.f('ix_cmf_audit_parent_id'), table_name='cmf_audit') op.drop_index(op.f('ix_cmf_audit_cmf_modified_at'), table_name='cmf_audit') op.drop_index(op.f('ix_cmf_audit_cmf_created_at'), table_name='cmf_audit') op.drop_index(op.f('ix_cmf_audit_cmf_author_id'), table_name='cmf_audit') op.drop_table('cmf_audit') # ### end Alembic commands ###