"""add_evagit_models Revision ID: e14cc4d2dca2 Revises: 5b6a31da96c9 Create Date: 2025-04-09 07:50:08.321688 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = 'e14cc4d2dca2' down_revision = '5b6a31da96c9' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_evagit_group', 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=64), 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('is_public', sa.Boolean(), nullable=False), sa.Column('is_public_editable', sa.Boolean(), nullable=False), sa.Column('is_public_comments', sa.Boolean(), nullable=False), sa.Column('has_children_archived', sa.Boolean(), nullable=False), sa.Column('logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form', sa.String(length=32), nullable=False), sa.Column('parent_logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form_options', sa.TEXT(), nullable=False), 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=False), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('mark', sa.String(length=32), nullable=True), sa.Column('user_rating', sa.Numeric(precision=14, scale=2), nullable=True), sa.Column('user_rating_count', sa.Integer(), nullable=False), sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('deadline', sa.TIMESTAMP(timezone=True), 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=False), sa.Column('is_penalty', sa.Boolean(), nullable=False), 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('url_prefix', sa.String(length=256), nullable=True), sa.Column('view_scope', sa.String(length=32), nullable=False), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('perm_security_level_id', sa.String(length=64), nullable=True), sa.Column('resolution_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.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_task_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_folder.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['perm_security_level_id'], ['cmf_security_level.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.ForeignKeyConstraint(['resolution_id'], ['cmf_resolution.id'], ), sa.ForeignKeyConstraint(['scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['status_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_group_activity_id'), 'cmf_evagit_group', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_alarm_date'), 'cmf_evagit_group', ['alarm_date'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_approved'), 'cmf_evagit_group', ['approved'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cache_status_opt_id'), 'cmf_evagit_group', ['cache_status_opt_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cache_status_type'), 'cmf_evagit_group', ['cache_status_type'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cloned_from_id'), 'cmf_evagit_group', ['cloned_from_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_author_id'), 'cmf_evagit_group', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_created_at'), 'cmf_evagit_group', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_deleted'), 'cmf_evagit_group', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_import_id'), 'cmf_evagit_group', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_locked_at'), 'cmf_evagit_group', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_locked_by_id'), 'cmf_evagit_group', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_modified_at'), 'cmf_evagit_group', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_modified_by_id'), 'cmf_evagit_group', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_owner_assistant_id'), 'cmf_evagit_group', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_owner_id'), 'cmf_evagit_group', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_version'), 'cmf_evagit_group', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_viewed_at'), 'cmf_evagit_group', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_code'), 'cmf_evagit_group', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_group_company_id'), 'cmf_evagit_group', ['company_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_deadline'), 'cmf_evagit_group', ['deadline'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_default_task_workflow_id'), 'cmf_evagit_group', ['default_task_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_is_template'), 'cmf_evagit_group', ['is_template'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_logic_prefix'), 'cmf_evagit_group', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_logic_type_id'), 'cmf_evagit_group', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_name'), 'cmf_evagit_group', ['name'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_orderno'), 'cmf_evagit_group', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_parent_id'), 'cmf_evagit_group', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_parent_logic_prefix'), 'cmf_evagit_group', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_perm_acl_id'), 'cmf_evagit_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_perm_parent_id'), 'cmf_evagit_group', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_perm_security_level_id'), 'cmf_evagit_group', ['perm_security_level_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_project_id'), 'cmf_evagit_group', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_resolution_id'), 'cmf_evagit_group', ['resolution_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_responsible_id'), 'cmf_evagit_group', ['responsible_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_root_parent_id'), 'cmf_evagit_group', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_scheme_wf_id'), 'cmf_evagit_group', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_status_id'), 'cmf_evagit_group', ['status_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_tree_parent_id'), 'cmf_evagit_group', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_waiting_for_id'), 'cmf_evagit_group', ['waiting_for_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_workflow_id'), 'cmf_evagit_group', ['workflow_id'], unique=False) op.create_table('cmf_evagit_group_cmf_owner_assistants', sa.Column('id', sa.String(length=128), 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_evagit_group_cmf_owner_assistants_left_id'), 'cmf_evagit_group_cmf_owner_assistants', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_parent_id'), 'cmf_evagit_group_cmf_owner_assistants', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_right_id'), 'cmf_evagit_group_cmf_owner_assistants', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_root_id'), 'cmf_evagit_group_cmf_owner_assistants', ['root_id'], unique=False) op.create_table('cmf_evagit_group_executors', sa.Column('id', sa.String(length=128), 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_evagit_group_executors_left_id'), 'cmf_evagit_group_executors', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_executors_parent_id'), 'cmf_evagit_group_executors', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_executors_right_id'), 'cmf_evagit_group_executors', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_executors_root_id'), 'cmf_evagit_group_executors', ['root_id'], unique=False) op.create_table('cmf_evagit_group_local_links', sa.Column('id', sa.String(length=128), 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_evagit_group_local_links_left_id'), 'cmf_evagit_group_local_links', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_local_links_parent_id'), 'cmf_evagit_group_local_links', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_local_links_right_id'), 'cmf_evagit_group_local_links', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_local_links_root_id'), 'cmf_evagit_group_local_links', ['root_id'], unique=False) op.create_table('cmf_evagit_group_spectators', sa.Column('id', sa.String(length=128), 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_evagit_group_spectators_left_id'), 'cmf_evagit_group_spectators', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_spectators_parent_id'), 'cmf_evagit_group_spectators', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_spectators_right_id'), 'cmf_evagit_group_spectators', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_group_spectators_root_id'), 'cmf_evagit_group_spectators', ['root_id'], unique=False) op.create_table('cmf_evagit_repo', 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=64), 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('is_public', sa.Boolean(), nullable=False), sa.Column('is_public_editable', sa.Boolean(), nullable=False), sa.Column('is_public_comments', sa.Boolean(), nullable=False), sa.Column('has_children_archived', sa.Boolean(), nullable=False), sa.Column('logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form', sa.String(length=32), nullable=False), sa.Column('parent_logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form_options', sa.TEXT(), nullable=False), 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=False), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('mark', sa.String(length=32), nullable=True), sa.Column('user_rating', sa.Numeric(precision=14, scale=2), nullable=True), sa.Column('user_rating_count', sa.Integer(), nullable=False), sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('deadline', sa.TIMESTAMP(timezone=True), 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=False), sa.Column('is_penalty', sa.Boolean(), nullable=False), 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('url', sa.String(length=64), nullable=True), sa.Column('view_scope', sa.String(length=32), nullable=False), sa.Column('is_readme_created', sa.Boolean(), nullable=False), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('perm_security_level_id', sa.String(length=64), nullable=True), sa.Column('resolution_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.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_task_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(['perm_security_level_id'], ['cmf_security_level.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.ForeignKeyConstraint(['resolution_id'], ['cmf_resolution.id'], ), sa.ForeignKeyConstraint(['scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['status_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_repo_activity_id'), 'cmf_evagit_repo', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_alarm_date'), 'cmf_evagit_repo', ['alarm_date'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_approved'), 'cmf_evagit_repo', ['approved'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cache_status_opt_id'), 'cmf_evagit_repo', ['cache_status_opt_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cache_status_type'), 'cmf_evagit_repo', ['cache_status_type'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cloned_from_id'), 'cmf_evagit_repo', ['cloned_from_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_author_id'), 'cmf_evagit_repo', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_created_at'), 'cmf_evagit_repo', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_deleted'), 'cmf_evagit_repo', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_import_id'), 'cmf_evagit_repo', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_locked_at'), 'cmf_evagit_repo', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_locked_by_id'), 'cmf_evagit_repo', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_modified_at'), 'cmf_evagit_repo', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_modified_by_id'), 'cmf_evagit_repo', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistant_id'), 'cmf_evagit_repo', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_owner_id'), 'cmf_evagit_repo', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_version'), 'cmf_evagit_repo', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_viewed_at'), 'cmf_evagit_repo', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_code'), 'cmf_evagit_repo', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_repo_company_id'), 'cmf_evagit_repo', ['company_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_deadline'), 'cmf_evagit_repo', ['deadline'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_default_task_workflow_id'), 'cmf_evagit_repo', ['default_task_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_is_template'), 'cmf_evagit_repo', ['is_template'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_logic_prefix'), 'cmf_evagit_repo', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_logic_type_id'), 'cmf_evagit_repo', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_orderno'), 'cmf_evagit_repo', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_parent_id'), 'cmf_evagit_repo', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_parent_logic_prefix'), 'cmf_evagit_repo', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_perm_acl_id'), 'cmf_evagit_repo', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_perm_parent_id'), 'cmf_evagit_repo', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_perm_security_level_id'), 'cmf_evagit_repo', ['perm_security_level_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_project_id'), 'cmf_evagit_repo', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_resolution_id'), 'cmf_evagit_repo', ['resolution_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_responsible_id'), 'cmf_evagit_repo', ['responsible_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_root_parent_id'), 'cmf_evagit_repo', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_scheme_wf_id'), 'cmf_evagit_repo', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_status_id'), 'cmf_evagit_repo', ['status_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_tree_parent_id'), 'cmf_evagit_repo', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_waiting_for_id'), 'cmf_evagit_repo', ['waiting_for_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_workflow_id'), 'cmf_evagit_repo', ['workflow_id'], unique=False) op.create_table('cmf_evagit_repo_cmf_owner_assistants', sa.Column('id', sa.String(length=128), 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_evagit_repo_cmf_owner_assistants_left_id'), 'cmf_evagit_repo_cmf_owner_assistants', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_parent_id'), 'cmf_evagit_repo_cmf_owner_assistants', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_right_id'), 'cmf_evagit_repo_cmf_owner_assistants', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_root_id'), 'cmf_evagit_repo_cmf_owner_assistants', ['root_id'], unique=False) op.create_table('cmf_evagit_repo_cmf_project', sa.Column('id', sa.String(length=128), 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_evagit_repo.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_repo_cmf_project_left_id'), 'cmf_evagit_repo_cmf_project', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_project_parent_id'), 'cmf_evagit_repo_cmf_project', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_project_right_id'), 'cmf_evagit_repo_cmf_project', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_cmf_project_root_id'), 'cmf_evagit_repo_cmf_project', ['root_id'], unique=False) op.create_table('cmf_evagit_repo_executors', sa.Column('id', sa.String(length=128), 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_evagit_repo_executors_left_id'), 'cmf_evagit_repo_executors', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_executors_parent_id'), 'cmf_evagit_repo_executors', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_executors_right_id'), 'cmf_evagit_repo_executors', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_executors_root_id'), 'cmf_evagit_repo_executors', ['root_id'], unique=False) op.create_table('cmf_evagit_repo_local_links', sa.Column('id', sa.String(length=128), 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_evagit_repo_local_links_left_id'), 'cmf_evagit_repo_local_links', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_local_links_parent_id'), 'cmf_evagit_repo_local_links', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_local_links_right_id'), 'cmf_evagit_repo_local_links', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_local_links_root_id'), 'cmf_evagit_repo_local_links', ['root_id'], unique=False) op.create_table('cmf_evagit_repo_spectators', sa.Column('id', sa.String(length=128), 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_evagit_repo_spectators_left_id'), 'cmf_evagit_repo_spectators', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_spectators_parent_id'), 'cmf_evagit_repo_spectators', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_spectators_right_id'), 'cmf_evagit_repo_spectators', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_repo_spectators_root_id'), 'cmf_evagit_repo_spectators', ['root_id'], unique=False) op.create_table('cmf_evagit_commit', 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(), 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('commit_author', sa.String(), nullable=True), sa.Column('sha', sa.String(), nullable=True), sa.Column('commited_date', sa.TIMESTAMP(timezone=True), 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('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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_evagit_repo.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_commit_cmf_author_id'), 'cmf_evagit_commit', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_created_at'), 'cmf_evagit_commit', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_deleted'), 'cmf_evagit_commit', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_import_id'), 'cmf_evagit_commit', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_locked_at'), 'cmf_evagit_commit', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_locked_by_id'), 'cmf_evagit_commit', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_modified_at'), 'cmf_evagit_commit', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_modified_by_id'), 'cmf_evagit_commit', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_owner_id'), 'cmf_evagit_commit', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_version'), 'cmf_evagit_commit', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_cmf_viewed_at'), 'cmf_evagit_commit', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_code'), 'cmf_evagit_commit', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_commit_orderno'), 'cmf_evagit_commit', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_parent_id'), 'cmf_evagit_commit', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_perm_acl_id'), 'cmf_evagit_commit', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_perm_parent_id'), 'cmf_evagit_commit', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_project_id'), 'cmf_evagit_commit', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_root_parent_id'), 'cmf_evagit_commit', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_commit_tree_parent_id'), 'cmf_evagit_commit', ['tree_parent_id'], unique=False) op.create_table('cmf_evagit_branch', 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=64), nullable=False), 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), 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('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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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('commit_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['commit_id'], ['cmf_evagit_commit.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_evagit_repo.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_branch_cmf_author_id'), 'cmf_evagit_branch', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_created_at'), 'cmf_evagit_branch', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_deleted'), 'cmf_evagit_branch', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_import_id'), 'cmf_evagit_branch', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_locked_at'), 'cmf_evagit_branch', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_locked_by_id'), 'cmf_evagit_branch', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_modified_at'), 'cmf_evagit_branch', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_modified_by_id'), 'cmf_evagit_branch', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_owner_id'), 'cmf_evagit_branch', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_version'), 'cmf_evagit_branch', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_cmf_viewed_at'), 'cmf_evagit_branch', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_code'), 'cmf_evagit_branch', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_branch_commit_id'), 'cmf_evagit_branch', ['commit_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_orderno'), 'cmf_evagit_branch', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_parent_id'), 'cmf_evagit_branch', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_perm_acl_id'), 'cmf_evagit_branch', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_perm_parent_id'), 'cmf_evagit_branch', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_project_id'), 'cmf_evagit_branch', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_root_parent_id'), 'cmf_evagit_branch', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_branch_tree_parent_id'), 'cmf_evagit_branch', ['tree_parent_id'], unique=False) op.create_table('cmf_evagit_merge_request', 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=64), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.String(length=256), nullable=True), sa.Column('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('is_public', sa.Boolean(), nullable=False), sa.Column('is_public_editable', sa.Boolean(), nullable=False), sa.Column('is_public_comments', sa.Boolean(), nullable=False), sa.Column('has_children_archived', sa.Boolean(), nullable=False), sa.Column('logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form', sa.String(length=32), nullable=False), sa.Column('parent_logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form_options', sa.TEXT(), nullable=False), 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=False), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('mark', sa.String(length=32), nullable=True), sa.Column('user_rating', sa.Numeric(precision=14, scale=2), nullable=True), sa.Column('user_rating_count', sa.Integer(), nullable=False), sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('deadline', sa.TIMESTAMP(timezone=True), 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=False), sa.Column('is_penalty', sa.Boolean(), nullable=False), 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('delete_source_branch', sa.Boolean(), nullable=False), sa.Column('merged_at', sa.TIMESTAMP(timezone=True), 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('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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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('cmf_owner_assistant_id', sa.String(length=64), nullable=True), sa.Column('perm_security_level_id', sa.String(length=64), nullable=True), sa.Column('resolution_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('branch_from_id', sa.String(length=64), nullable=True), sa.Column('branch_to_id', sa.String(length=64), nullable=True), sa.Column('merged_by_id', sa.String(length=64), nullable=True), sa.Column('closed_by_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['activity_id'], ['cmf_activity.id'], ), sa.ForeignKeyConstraint(['branch_from_id'], ['cmf_evagit_branch.id'], ), sa.ForeignKeyConstraint(['branch_to_id'], ['cmf_evagit_branch.id'], ), sa.ForeignKeyConstraint(['cache_status_opt_id'], ['cmf_status_opt.id'], ), sa.ForeignKeyConstraint(['closed_by_id'], ['cmf_person.id'], ), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['company_id'], ['cmf_company.id'], ), sa.ForeignKeyConstraint(['default_task_workflow_id'], ['cmf_workflow.id'], ), sa.ForeignKeyConstraint(['logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['merged_by_id'], ['cmf_person.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_folder.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['perm_security_level_id'], ['cmf_security_level.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.ForeignKeyConstraint(['resolution_id'], ['cmf_resolution.id'], ), sa.ForeignKeyConstraint(['scheme_wf_id'], ['cmf_scheme_wf.id'], ), sa.ForeignKeyConstraint(['status_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['workflow_id'], ['cmf_workflow.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_merge_request_activity_id'), 'cmf_evagit_merge_request', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_alarm_date'), 'cmf_evagit_merge_request', ['alarm_date'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_approved'), 'cmf_evagit_merge_request', ['approved'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_branch_from_id'), 'cmf_evagit_merge_request', ['branch_from_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_branch_to_id'), 'cmf_evagit_merge_request', ['branch_to_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cache_status_opt_id'), 'cmf_evagit_merge_request', ['cache_status_opt_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cache_status_type'), 'cmf_evagit_merge_request', ['cache_status_type'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cloned_from_id'), 'cmf_evagit_merge_request', ['cloned_from_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_closed_by_id'), 'cmf_evagit_merge_request', ['closed_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_author_id'), 'cmf_evagit_merge_request', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_created_at'), 'cmf_evagit_merge_request', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_deleted'), 'cmf_evagit_merge_request', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_import_id'), 'cmf_evagit_merge_request', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_locked_at'), 'cmf_evagit_merge_request', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_locked_by_id'), 'cmf_evagit_merge_request', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_modified_at'), 'cmf_evagit_merge_request', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_modified_by_id'), 'cmf_evagit_merge_request', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistant_id'), 'cmf_evagit_merge_request', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_id'), 'cmf_evagit_merge_request', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_version'), 'cmf_evagit_merge_request', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_viewed_at'), 'cmf_evagit_merge_request', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_code'), 'cmf_evagit_merge_request', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_merge_request_company_id'), 'cmf_evagit_merge_request', ['company_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_deadline'), 'cmf_evagit_merge_request', ['deadline'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_default_task_workflow_id'), 'cmf_evagit_merge_request', ['default_task_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_is_template'), 'cmf_evagit_merge_request', ['is_template'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_logic_prefix'), 'cmf_evagit_merge_request', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_logic_type_id'), 'cmf_evagit_merge_request', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_merged_at'), 'cmf_evagit_merge_request', ['merged_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_merged_by_id'), 'cmf_evagit_merge_request', ['merged_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_name'), 'cmf_evagit_merge_request', ['name'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_orderno'), 'cmf_evagit_merge_request', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_parent_id'), 'cmf_evagit_merge_request', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_parent_logic_prefix'), 'cmf_evagit_merge_request', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_perm_acl_id'), 'cmf_evagit_merge_request', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_perm_parent_id'), 'cmf_evagit_merge_request', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_perm_security_level_id'), 'cmf_evagit_merge_request', ['perm_security_level_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_project_id'), 'cmf_evagit_merge_request', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_resolution_id'), 'cmf_evagit_merge_request', ['resolution_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_responsible_id'), 'cmf_evagit_merge_request', ['responsible_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_root_parent_id'), 'cmf_evagit_merge_request', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_scheme_wf_id'), 'cmf_evagit_merge_request', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_status_id'), 'cmf_evagit_merge_request', ['status_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_text'), 'cmf_evagit_merge_request', ['text'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_tree_parent_id'), 'cmf_evagit_merge_request', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_waiting_for_id'), 'cmf_evagit_merge_request', ['waiting_for_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_workflow_id'), 'cmf_evagit_merge_request', ['workflow_id'], unique=False) op.create_table('cmf_evagit_merge_request_cmf_evagit_commit', sa.Column('id', sa.String(length=128), 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_evagit_merge_request.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_evagit_commit.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_left_id'), 'cmf_evagit_merge_request_cmf_evagit_commit', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_parent_id'), 'cmf_evagit_merge_request_cmf_evagit_commit', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_right_id'), 'cmf_evagit_merge_request_cmf_evagit_commit', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_root_id'), 'cmf_evagit_merge_request_cmf_evagit_commit', ['root_id'], unique=False) op.create_table('cmf_evagit_merge_request_cmf_owner_assistants', sa.Column('id', sa.String(length=128), 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_evagit_merge_request_cmf_owner_assistants_left_id'), 'cmf_evagit_merge_request_cmf_owner_assistants', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_parent_id'), 'cmf_evagit_merge_request_cmf_owner_assistants', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_right_id'), 'cmf_evagit_merge_request_cmf_owner_assistants', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_root_id'), 'cmf_evagit_merge_request_cmf_owner_assistants', ['root_id'], unique=False) op.create_table('cmf_evagit_merge_request_executors', sa.Column('id', sa.String(length=128), 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_evagit_merge_request_executors_left_id'), 'cmf_evagit_merge_request_executors', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_executors_parent_id'), 'cmf_evagit_merge_request_executors', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_executors_right_id'), 'cmf_evagit_merge_request_executors', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_executors_root_id'), 'cmf_evagit_merge_request_executors', ['root_id'], unique=False) op.create_table('cmf_evagit_merge_request_local_links', sa.Column('id', sa.String(length=128), 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_evagit_merge_request_local_links_left_id'), 'cmf_evagit_merge_request_local_links', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_local_links_parent_id'), 'cmf_evagit_merge_request_local_links', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_local_links_right_id'), 'cmf_evagit_merge_request_local_links', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_local_links_root_id'), 'cmf_evagit_merge_request_local_links', ['root_id'], unique=False) op.create_table('cmf_evagit_merge_request_spectators', sa.Column('id', sa.String(length=128), 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_evagit_merge_request_spectators_left_id'), 'cmf_evagit_merge_request_spectators', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_spectators_parent_id'), 'cmf_evagit_merge_request_spectators', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_spectators_right_id'), 'cmf_evagit_merge_request_spectators', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_merge_request_spectators_root_id'), 'cmf_evagit_merge_request_spectators', ['root_id'], unique=False) op.create_table('cmf_evagit_role', 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('perm_create_repo', sa.Boolean(), nullable=False), sa.Column('perm_delete_repo', sa.Boolean(), nullable=False), sa.Column('perm_edit_repo', sa.Boolean(), nullable=False), sa.Column('perm_setup_repo_access', sa.Boolean(), nullable=False), sa.Column('perm_create_group', sa.Boolean(), nullable=False), sa.Column('perm_delete_group', sa.Boolean(), nullable=False), sa.Column('perm_setup_group_access', sa.Boolean(), nullable=False), sa.Column('perm_comment_on_commit', sa.Boolean(), nullable=False), sa.Column('perm_create_branch', sa.Boolean(), nullable=False), sa.Column('perm_delete_branch', sa.Boolean(), nullable=False), sa.Column('perm_push', sa.Boolean(), nullable=False), sa.Column('perm_comment_on_merge_request', sa.Boolean(), nullable=False), sa.Column('perm_create_merge_request', sa.Boolean(), nullable=False), sa.Column('perm_edit_merge_request', sa.Boolean(), nullable=False), sa.Column('perm_close_merge_request', sa.Boolean(), nullable=False), sa.Column('perm_merge_merge_request', sa.Boolean(), nullable=False), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_role_cmf_author_id'), 'cmf_evagit_role', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_created_at'), 'cmf_evagit_role', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_deleted'), 'cmf_evagit_role', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_import_id'), 'cmf_evagit_role', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_locked_at'), 'cmf_evagit_role', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_locked_by_id'), 'cmf_evagit_role', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_modified_at'), 'cmf_evagit_role', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_modified_by_id'), 'cmf_evagit_role', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_owner_id'), 'cmf_evagit_role', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_version'), 'cmf_evagit_role', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_cmf_viewed_at'), 'cmf_evagit_role', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_code'), 'cmf_evagit_role', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_role_name'), 'cmf_evagit_role', ['name'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_parent_id'), 'cmf_evagit_role', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_perm_acl_id'), 'cmf_evagit_role', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_perm_parent_id'), 'cmf_evagit_role', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_project_id'), 'cmf_evagit_role', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_root_parent_id'), 'cmf_evagit_role', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_tree_parent_id'), 'cmf_evagit_role', ['tree_parent_id'], unique=False) op.create_table('cmf_evagit_role_assign', 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('expiration_date', sa.TIMESTAMP(timezone=True), 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('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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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('git_role_id', sa.String(length=64), nullable=False), sa.Column('member_id', sa.String(length=64), nullable=False), sa.Column('namespace_id', sa.String(length=64), nullable=False), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['git_role_id'], ['cmf_evagit_role.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_author_id'), 'cmf_evagit_role_assign', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_created_at'), 'cmf_evagit_role_assign', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_deleted'), 'cmf_evagit_role_assign', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_import_id'), 'cmf_evagit_role_assign', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_locked_at'), 'cmf_evagit_role_assign', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_locked_by_id'), 'cmf_evagit_role_assign', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_modified_at'), 'cmf_evagit_role_assign', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_modified_by_id'), 'cmf_evagit_role_assign', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_owner_id'), 'cmf_evagit_role_assign', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_version'), 'cmf_evagit_role_assign', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_cmf_viewed_at'), 'cmf_evagit_role_assign', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_code'), 'cmf_evagit_role_assign', ['code'], unique=True) op.create_index(op.f('ix_cmf_evagit_role_assign_git_role_id'), 'cmf_evagit_role_assign', ['git_role_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_member_id'), 'cmf_evagit_role_assign', ['member_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_name'), 'cmf_evagit_role_assign', ['name'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_namespace_id'), 'cmf_evagit_role_assign', ['namespace_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_orderno'), 'cmf_evagit_role_assign', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_parent_id'), 'cmf_evagit_role_assign', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_perm_acl_id'), 'cmf_evagit_role_assign', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_perm_parent_id'), 'cmf_evagit_role_assign', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_project_id'), 'cmf_evagit_role_assign', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_root_parent_id'), 'cmf_evagit_role_assign', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_evagit_role_assign_tree_parent_id'), 'cmf_evagit_role_assign', ['tree_parent_id'], unique=False) op.create_table('cmf_ssh_key', 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('import_original', sa.Boolean(), nullable=False), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('cmf_archived', sa.Boolean(), nullable=False), sa.Column('is_favorite', sa.Boolean(), nullable=False), sa.Column('has_tree_nodes', sa.Boolean(), nullable=False), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=False), sa.Column('tree_hidden', sa.Boolean(), nullable=False), sa.Column('sl_owner_lock', sa.Boolean(), nullable=False), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=False), sa.Column('perm_has_acl', sa.Boolean(), nullable=False), sa.Column('perm_inherit', sa.Boolean(), nullable=False), 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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=False), sa.Column('perm_encrypt_help', sa.String(length=256), nullable=True), sa.Column('key', sa.String(length=256), nullable=False), sa.Column('fingerprint', sa.String(length=256), nullable=True), sa.Column('fingerprint_sha256', sa.String(length=256), nullable=True), sa.Column('last_used_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('expiration_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('is_revoked', sa.Boolean(), nullable=False), sa.Column('is_allowed_to_write', sa.Boolean(), nullable=False), sa.Column('cmf_author_id', sa.String(length=64), nullable=True), sa.Column('cmf_owner_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('root_parent_id', sa.String(length=64), nullable=True), sa.Column('project_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.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['project_id'], ['cmf_project.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_ssh_key_cmf_author_id'), 'cmf_ssh_key', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_created_at'), 'cmf_ssh_key', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_deleted'), 'cmf_ssh_key', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_import_id'), 'cmf_ssh_key', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_locked_at'), 'cmf_ssh_key', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_locked_by_id'), 'cmf_ssh_key', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_modified_at'), 'cmf_ssh_key', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_modified_by_id'), 'cmf_ssh_key', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_owner_id'), 'cmf_ssh_key', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_version'), 'cmf_ssh_key', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_cmf_viewed_at'), 'cmf_ssh_key', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_code'), 'cmf_ssh_key', ['code'], unique=True) op.create_index(op.f('ix_cmf_ssh_key_name'), 'cmf_ssh_key', ['name'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_orderno'), 'cmf_ssh_key', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_parent_id'), 'cmf_ssh_key', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_perm_acl_id'), 'cmf_ssh_key', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_perm_parent_id'), 'cmf_ssh_key', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_project_id'), 'cmf_ssh_key', ['project_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_root_parent_id'), 'cmf_ssh_key', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_ssh_key_tree_parent_id'), 'cmf_ssh_key', ['tree_parent_id'], unique=False) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_index(op.f('ix_cmf_ssh_key_tree_parent_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_root_parent_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_project_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_perm_parent_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_perm_acl_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_parent_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_orderno'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_name'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_code'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_viewed_at'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_version'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_owner_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_modified_by_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_modified_at'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_locked_by_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_locked_at'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_import_id'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_deleted'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_created_at'), table_name='cmf_ssh_key') op.drop_index(op.f('ix_cmf_ssh_key_cmf_author_id'), table_name='cmf_ssh_key') op.drop_table('cmf_ssh_key') op.drop_index(op.f('ix_cmf_evagit_role_assign_tree_parent_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_root_parent_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_project_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_perm_parent_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_perm_acl_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_parent_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_orderno'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_namespace_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_name'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_member_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_git_role_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_code'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_viewed_at'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_version'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_owner_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_modified_by_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_modified_at'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_locked_by_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_locked_at'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_import_id'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_deleted'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_created_at'), table_name='cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_assign_cmf_author_id'), table_name='cmf_evagit_role_assign') op.drop_table('cmf_evagit_role_assign') op.drop_index(op.f('ix_cmf_evagit_role_tree_parent_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_root_parent_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_project_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_perm_parent_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_perm_acl_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_parent_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_name'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_code'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_viewed_at'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_version'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_owner_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_modified_by_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_modified_at'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_locked_by_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_locked_at'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_import_id'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_deleted'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_created_at'), table_name='cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_role_cmf_author_id'), table_name='cmf_evagit_role') op.drop_table('cmf_evagit_role') op.drop_index(op.f('ix_cmf_evagit_repo_spectators_root_id'), table_name='cmf_evagit_repo_spectators') op.drop_index(op.f('ix_cmf_evagit_repo_spectators_right_id'), table_name='cmf_evagit_repo_spectators') op.drop_index(op.f('ix_cmf_evagit_repo_spectators_parent_id'), table_name='cmf_evagit_repo_spectators') op.drop_index(op.f('ix_cmf_evagit_repo_spectators_left_id'), table_name='cmf_evagit_repo_spectators') op.drop_table('cmf_evagit_repo_spectators') op.drop_index(op.f('ix_cmf_evagit_repo_local_links_root_id'), table_name='cmf_evagit_repo_local_links') op.drop_index(op.f('ix_cmf_evagit_repo_local_links_right_id'), table_name='cmf_evagit_repo_local_links') op.drop_index(op.f('ix_cmf_evagit_repo_local_links_parent_id'), table_name='cmf_evagit_repo_local_links') op.drop_index(op.f('ix_cmf_evagit_repo_local_links_left_id'), table_name='cmf_evagit_repo_local_links') op.drop_table('cmf_evagit_repo_local_links') op.drop_index(op.f('ix_cmf_evagit_repo_executors_root_id'), table_name='cmf_evagit_repo_executors') op.drop_index(op.f('ix_cmf_evagit_repo_executors_right_id'), table_name='cmf_evagit_repo_executors') op.drop_index(op.f('ix_cmf_evagit_repo_executors_parent_id'), table_name='cmf_evagit_repo_executors') op.drop_index(op.f('ix_cmf_evagit_repo_executors_left_id'), table_name='cmf_evagit_repo_executors') op.drop_table('cmf_evagit_repo_executors') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_project_root_id'), table_name='cmf_evagit_repo_cmf_project') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_project_right_id'), table_name='cmf_evagit_repo_cmf_project') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_project_parent_id'), table_name='cmf_evagit_repo_cmf_project') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_project_left_id'), table_name='cmf_evagit_repo_cmf_project') op.drop_table('cmf_evagit_repo_cmf_project') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_root_id'), table_name='cmf_evagit_repo_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_right_id'), table_name='cmf_evagit_repo_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_parent_id'), table_name='cmf_evagit_repo_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistants_left_id'), table_name='cmf_evagit_repo_cmf_owner_assistants') op.drop_table('cmf_evagit_repo_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_repo_workflow_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_waiting_for_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_tree_parent_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_status_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_scheme_wf_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_root_parent_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_responsible_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_resolution_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_project_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_perm_security_level_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_perm_parent_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_perm_acl_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_parent_logic_prefix'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_parent_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_orderno'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_logic_type_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_logic_prefix'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_is_template'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_default_task_workflow_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_deadline'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_company_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_code'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_viewed_at'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_version'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_owner_assistant_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_modified_by_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_modified_at'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_locked_by_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_locked_at'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_import_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_deleted'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_created_at'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cmf_author_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cloned_from_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cache_status_type'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_cache_status_opt_id'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_approved'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_alarm_date'), table_name='cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_repo_activity_id'), table_name='cmf_evagit_repo') op.drop_table('cmf_evagit_repo') op.drop_index(op.f('ix_cmf_evagit_merge_request_spectators_root_id'), table_name='cmf_evagit_merge_request_spectators') op.drop_index(op.f('ix_cmf_evagit_merge_request_spectators_right_id'), table_name='cmf_evagit_merge_request_spectators') op.drop_index(op.f('ix_cmf_evagit_merge_request_spectators_parent_id'), table_name='cmf_evagit_merge_request_spectators') op.drop_index(op.f('ix_cmf_evagit_merge_request_spectators_left_id'), table_name='cmf_evagit_merge_request_spectators') op.drop_table('cmf_evagit_merge_request_spectators') op.drop_index(op.f('ix_cmf_evagit_merge_request_local_links_root_id'), table_name='cmf_evagit_merge_request_local_links') op.drop_index(op.f('ix_cmf_evagit_merge_request_local_links_right_id'), table_name='cmf_evagit_merge_request_local_links') op.drop_index(op.f('ix_cmf_evagit_merge_request_local_links_parent_id'), table_name='cmf_evagit_merge_request_local_links') op.drop_index(op.f('ix_cmf_evagit_merge_request_local_links_left_id'), table_name='cmf_evagit_merge_request_local_links') op.drop_table('cmf_evagit_merge_request_local_links') op.drop_index(op.f('ix_cmf_evagit_merge_request_executors_root_id'), table_name='cmf_evagit_merge_request_executors') op.drop_index(op.f('ix_cmf_evagit_merge_request_executors_right_id'), table_name='cmf_evagit_merge_request_executors') op.drop_index(op.f('ix_cmf_evagit_merge_request_executors_parent_id'), table_name='cmf_evagit_merge_request_executors') op.drop_index(op.f('ix_cmf_evagit_merge_request_executors_left_id'), table_name='cmf_evagit_merge_request_executors') op.drop_table('cmf_evagit_merge_request_executors') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_root_id'), table_name='cmf_evagit_merge_request_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_right_id'), table_name='cmf_evagit_merge_request_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_parent_id'), table_name='cmf_evagit_merge_request_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistants_left_id'), table_name='cmf_evagit_merge_request_cmf_owner_assistants') op.drop_table('cmf_evagit_merge_request_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_root_id'), table_name='cmf_evagit_merge_request_cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_right_id'), table_name='cmf_evagit_merge_request_cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_parent_id'), table_name='cmf_evagit_merge_request_cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_evagit_commit_left_id'), table_name='cmf_evagit_merge_request_cmf_evagit_commit') op.drop_table('cmf_evagit_merge_request_cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_merge_request_workflow_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_waiting_for_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_tree_parent_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_text'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_status_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_scheme_wf_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_root_parent_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_responsible_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_resolution_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_project_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_perm_security_level_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_perm_parent_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_perm_acl_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_parent_logic_prefix'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_parent_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_orderno'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_name'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_merged_by_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_merged_at'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_logic_type_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_logic_prefix'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_is_template'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_default_task_workflow_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_deadline'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_company_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_code'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_viewed_at'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_version'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_owner_assistant_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_modified_by_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_modified_at'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_locked_by_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_locked_at'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_import_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_deleted'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_created_at'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cmf_author_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_closed_by_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cloned_from_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cache_status_type'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_cache_status_opt_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_branch_to_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_branch_from_id'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_approved'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_alarm_date'), table_name='cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_merge_request_activity_id'), table_name='cmf_evagit_merge_request') op.drop_table('cmf_evagit_merge_request') op.drop_index(op.f('ix_cmf_evagit_group_spectators_root_id'), table_name='cmf_evagit_group_spectators') op.drop_index(op.f('ix_cmf_evagit_group_spectators_right_id'), table_name='cmf_evagit_group_spectators') op.drop_index(op.f('ix_cmf_evagit_group_spectators_parent_id'), table_name='cmf_evagit_group_spectators') op.drop_index(op.f('ix_cmf_evagit_group_spectators_left_id'), table_name='cmf_evagit_group_spectators') op.drop_table('cmf_evagit_group_spectators') op.drop_index(op.f('ix_cmf_evagit_group_local_links_root_id'), table_name='cmf_evagit_group_local_links') op.drop_index(op.f('ix_cmf_evagit_group_local_links_right_id'), table_name='cmf_evagit_group_local_links') op.drop_index(op.f('ix_cmf_evagit_group_local_links_parent_id'), table_name='cmf_evagit_group_local_links') op.drop_index(op.f('ix_cmf_evagit_group_local_links_left_id'), table_name='cmf_evagit_group_local_links') op.drop_table('cmf_evagit_group_local_links') op.drop_index(op.f('ix_cmf_evagit_group_executors_root_id'), table_name='cmf_evagit_group_executors') op.drop_index(op.f('ix_cmf_evagit_group_executors_right_id'), table_name='cmf_evagit_group_executors') op.drop_index(op.f('ix_cmf_evagit_group_executors_parent_id'), table_name='cmf_evagit_group_executors') op.drop_index(op.f('ix_cmf_evagit_group_executors_left_id'), table_name='cmf_evagit_group_executors') op.drop_table('cmf_evagit_group_executors') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_root_id'), table_name='cmf_evagit_group_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_right_id'), table_name='cmf_evagit_group_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_parent_id'), table_name='cmf_evagit_group_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_assistants_left_id'), table_name='cmf_evagit_group_cmf_owner_assistants') op.drop_table('cmf_evagit_group_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_evagit_group_workflow_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_waiting_for_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_tree_parent_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_status_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_scheme_wf_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_root_parent_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_responsible_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_resolution_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_project_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_perm_security_level_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_perm_parent_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_perm_acl_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_parent_logic_prefix'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_parent_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_orderno'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_name'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_logic_type_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_logic_prefix'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_is_template'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_default_task_workflow_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_deadline'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_company_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_code'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_viewed_at'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_version'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_owner_assistant_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_modified_by_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_modified_at'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_locked_by_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_locked_at'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_import_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_deleted'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_created_at'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cmf_author_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cloned_from_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cache_status_type'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_cache_status_opt_id'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_approved'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_alarm_date'), table_name='cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_group_activity_id'), table_name='cmf_evagit_group') op.drop_table('cmf_evagit_group') op.drop_index(op.f('ix_cmf_evagit_commit_tree_parent_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_root_parent_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_project_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_perm_parent_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_perm_acl_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_parent_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_orderno'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_code'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_viewed_at'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_version'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_owner_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_modified_by_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_modified_at'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_locked_by_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_locked_at'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_import_id'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_deleted'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_created_at'), table_name='cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_commit_cmf_author_id'), table_name='cmf_evagit_commit') op.drop_table('cmf_evagit_commit') op.drop_index(op.f('ix_cmf_evagit_branch_tree_parent_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_root_parent_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_project_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_perm_parent_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_perm_acl_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_parent_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_orderno'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_commit_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_code'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_viewed_at'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_version'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_owner_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_modified_by_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_modified_at'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_locked_by_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_locked_at'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_import_id'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_deleted'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_created_at'), table_name='cmf_evagit_branch') op.drop_index(op.f('ix_cmf_evagit_branch_cmf_author_id'), table_name='cmf_evagit_branch') op.drop_table('cmf_evagit_branch') # ### end Alembic commands ###