"""Git Integration

Revision ID: a942b63678d4
Revises: 059e4f14a155
Create Date: 2022-11-16 16:32:17.185979

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'a942b63678d4'
down_revision = '059e4f14a155'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('cmf_plugin_git',
    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=True),
    sa.Column('ext_id', sa.String(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('perm_public', sa.Boolean(), nullable=True),
    sa.Column('perm_has_acl', sa.Boolean(), nullable=True),
    sa.Column('perm_inherit', sa.Boolean(), nullable=True),
    sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True),
    sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_encrypt', sa.Boolean(), nullable=True),
    sa.Column('type', sa.String(length=32), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('perm_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_parent_id', sa.String(length=64), nullable=True),
    sa.Column('plugin_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(['plugin_id'], ['cmf_plugin.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_plugin_git_cmf_author_id'), 'cmf_plugin_git', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_created_at'), 'cmf_plugin_git', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_deleted'), 'cmf_plugin_git', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_import_id'), 'cmf_plugin_git', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_locked_at'), 'cmf_plugin_git', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_locked_by_id'), 'cmf_plugin_git', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_modified_at'), 'cmf_plugin_git', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_modified_by_id'), 'cmf_plugin_git', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_owner_assistant_id'), 'cmf_plugin_git', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_owner_id'), 'cmf_plugin_git', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_version'), 'cmf_plugin_git', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_cmf_viewed_at'), 'cmf_plugin_git', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_code'), 'cmf_plugin_git', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_plugin_git_name'), 'cmf_plugin_git', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_orderno'), 'cmf_plugin_git', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_parent_id'), 'cmf_plugin_git', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_perm_acl_id'), 'cmf_plugin_git', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_perm_parent_id'), 'cmf_plugin_git', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_plugin_id'), 'cmf_plugin_git', ['plugin_id'], unique=False)
    op.create_index(op.f('ix_cmf_plugin_git_tree_parent_id'), 'cmf_plugin_git', ['tree_parent_id'], unique=False)
    op.create_table('cmf_git_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(), 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=True),
    sa.Column('ext_id', sa.String(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('perm_public', sa.Boolean(), nullable=True),
    sa.Column('perm_has_acl', sa.Boolean(), nullable=True),
    sa.Column('perm_inherit', sa.Boolean(), nullable=True),
    sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True),
    sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_encrypt', sa.Boolean(), nullable=True),
    sa.Column('etag', sa.String(), nullable=True),
    sa.Column('last_modified', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('url', sa.String(length=4096), nullable=True),
    sa.Column('default_branch', sa.String(), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('perm_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_parent_id', sa.String(length=64), nullable=True),
    sa.Column('git_plugin_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.ForeignKeyConstraint(['git_plugin_id'], ['cmf_plugin_git.id'], ),
    sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_git_repo_cmf_author_id'), 'cmf_git_repo', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_created_at'), 'cmf_git_repo', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_deleted'), 'cmf_git_repo', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_import_id'), 'cmf_git_repo', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_locked_at'), 'cmf_git_repo', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_locked_by_id'), 'cmf_git_repo', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_modified_at'), 'cmf_git_repo', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_modified_by_id'), 'cmf_git_repo', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_owner_assistant_id'), 'cmf_git_repo', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_owner_id'), 'cmf_git_repo', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_version'), 'cmf_git_repo', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_cmf_viewed_at'), 'cmf_git_repo', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_code'), 'cmf_git_repo', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_git_repo_default_branch'), 'cmf_git_repo', ['default_branch'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_ext_id'), 'cmf_git_repo', ['ext_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_git_plugin_id'), 'cmf_git_repo', ['git_plugin_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_name'), 'cmf_git_repo', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_orderno'), 'cmf_git_repo', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_parent_id'), 'cmf_git_repo', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_perm_acl_id'), 'cmf_git_repo', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_perm_parent_id'), 'cmf_git_repo', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_repo_tree_parent_id'), 'cmf_git_repo', ['tree_parent_id'], unique=False)
    op.create_table('cmf_git_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(), 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=True),
    sa.Column('ext_id', sa.String(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('perm_public', sa.Boolean(), nullable=True),
    sa.Column('perm_has_acl', sa.Boolean(), nullable=True),
    sa.Column('perm_inherit', sa.Boolean(), nullable=True),
    sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True),
    sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_encrypt', sa.Boolean(), nullable=True),
    sa.Column('etag', sa.String(), nullable=True),
    sa.Column('last_modified', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('url', sa.String(length=4096), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('perm_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_parent_id', sa.String(length=64), nullable=True),
    sa.Column('git_plugin_id', sa.String(length=64), nullable=True),
    sa.Column('repo_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.ForeignKeyConstraint(['git_plugin_id'], ['cmf_plugin_git.id'], ),
    sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ),
    sa.ForeignKeyConstraint(['repo_id'], ['cmf_git_repo.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_git_branch_cmf_author_id'), 'cmf_git_branch', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_created_at'), 'cmf_git_branch', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_deleted'), 'cmf_git_branch', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_import_id'), 'cmf_git_branch', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_locked_at'), 'cmf_git_branch', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_locked_by_id'), 'cmf_git_branch', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_modified_at'), 'cmf_git_branch', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_modified_by_id'), 'cmf_git_branch', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_owner_assistant_id'), 'cmf_git_branch', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_owner_id'), 'cmf_git_branch', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_version'), 'cmf_git_branch', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_cmf_viewed_at'), 'cmf_git_branch', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_code'), 'cmf_git_branch', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_git_branch_git_plugin_id'), 'cmf_git_branch', ['git_plugin_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_name'), 'cmf_git_branch', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_orderno'), 'cmf_git_branch', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_parent_id'), 'cmf_git_branch', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_perm_acl_id'), 'cmf_git_branch', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_perm_parent_id'), 'cmf_git_branch', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_repo_id'), 'cmf_git_branch', ['repo_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_branch_tree_parent_id'), 'cmf_git_branch', ['tree_parent_id'], unique=False)
    op.create_table('cmf_git_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(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=True),
    sa.Column('ext_id', sa.String(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('perm_public', sa.Boolean(), nullable=True),
    sa.Column('perm_has_acl', sa.Boolean(), nullable=True),
    sa.Column('perm_inherit', sa.Boolean(), nullable=True),
    sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True),
    sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_encrypt', sa.Boolean(), nullable=True),
    sa.Column('etag', sa.String(), nullable=True),
    sa.Column('last_modified', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('sha', sa.String(), nullable=True),
    sa.Column('author_name', sa.String(), nullable=True),
    sa.Column('author_login', sa.String(), nullable=True),
    sa.Column('author_email', sa.String(length=64), nullable=True),
    sa.Column('author_id', sa.String(length=64), nullable=True),
    sa.Column('date', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('url', sa.String(length=4096), nullable=True),
    sa.Column('additions', sa.Integer(), nullable=True),
    sa.Column('deletions', sa.Integer(), nullable=True),
    sa.Column('total', sa.Integer(), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('perm_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_parent_id', sa.String(length=64), nullable=True),
    sa.Column('git_plugin_id', sa.String(length=64), nullable=True),
    sa.Column('repo_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['author_id'], ['cmf_person.id'], ),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.ForeignKeyConstraint(['git_plugin_id'], ['cmf_plugin_git.id'], ),
    sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ),
    sa.ForeignKeyConstraint(['repo_id'], ['cmf_git_repo.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_git_commit_author_email'), 'cmf_git_commit', ['author_email'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_author_id'), 'cmf_git_commit', ['author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_author_login'), 'cmf_git_commit', ['author_login'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_author_name'), 'cmf_git_commit', ['author_name'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_author_id'), 'cmf_git_commit', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_created_at'), 'cmf_git_commit', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_deleted'), 'cmf_git_commit', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_import_id'), 'cmf_git_commit', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_locked_at'), 'cmf_git_commit', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_locked_by_id'), 'cmf_git_commit', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_modified_at'), 'cmf_git_commit', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_modified_by_id'), 'cmf_git_commit', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_owner_assistant_id'), 'cmf_git_commit', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_owner_id'), 'cmf_git_commit', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_version'), 'cmf_git_commit', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_cmf_viewed_at'), 'cmf_git_commit', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_code'), 'cmf_git_commit', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_git_commit_date'), 'cmf_git_commit', ['date'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_git_plugin_id'), 'cmf_git_commit', ['git_plugin_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_name'), 'cmf_git_commit', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_orderno'), 'cmf_git_commit', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_parent_id'), 'cmf_git_commit', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_perm_acl_id'), 'cmf_git_commit', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_perm_parent_id'), 'cmf_git_commit', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_repo_id'), 'cmf_git_commit', ['repo_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_sha'), 'cmf_git_commit', ['sha'], unique=False)
    op.create_index(op.f('ix_cmf_git_commit_tree_parent_id'), 'cmf_git_commit', ['tree_parent_id'], unique=False)
    op.create_table('cmf_git_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(), 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=True),
    sa.Column('ext_id', sa.String(), nullable=True),
    sa.Column('is_favorite', sa.Boolean(), nullable=True),
    sa.Column('has_tree_nodes', sa.Boolean(), nullable=True),
    sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True),
    sa.Column('tree_hidden', sa.Boolean(), nullable=True),
    sa.Column('orderno', sa.Integer(), nullable=True),
    sa.Column('perm_public', sa.Boolean(), nullable=True),
    sa.Column('perm_has_acl', sa.Boolean(), nullable=True),
    sa.Column('perm_inherit', sa.Boolean(), nullable=True),
    sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True),
    sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_encrypt', sa.Boolean(), nullable=True),
    sa.Column('number', sa.Integer(), nullable=True),
    sa.Column('etag', sa.String(), nullable=True),
    sa.Column('last_modified', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('head_branch_name', sa.String(), nullable=True),
    sa.Column('head_repo', sa.String(), nullable=True),
    sa.Column('head_sha', sa.String(), nullable=True),
    sa.Column('base_branch_name', sa.String(), nullable=True),
    sa.Column('base_repo', sa.String(), nullable=True),
    sa.Column('base_sha', sa.String(), nullable=True),
    sa.Column('author_name', sa.String(), nullable=True),
    sa.Column('author_login', sa.String(), nullable=True),
    sa.Column('author_email', sa.String(), nullable=True),
    sa.Column('author_id', sa.String(length=64), nullable=True),
    sa.Column('date', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('status', sa.String(length=32), nullable=True),
    sa.Column('mergeable', sa.Boolean(), nullable=True),
    sa.Column('merged', sa.Boolean(), nullable=True),
    sa.Column('merge_sha', sa.String(), nullable=True),
    sa.Column('merged_at', sa.TIMESTAMP(timezone=True), nullable=True),
    sa.Column('merged_by_name', sa.String(), nullable=True),
    sa.Column('merged_by_login', sa.String(), nullable=True),
    sa.Column('merged_by_email', sa.String(), nullable=True),
    sa.Column('merged_by_id', sa.String(length=64), nullable=True),
    sa.Column('url', sa.String(length=4096), nullable=True),
    sa.Column('additions', sa.Integer(), nullable=True),
    sa.Column('deletions', sa.Integer(), nullable=True),
    sa.Column('commits', sa.Integer(), nullable=True),
    sa.Column('cmf_author_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_owner_assistant_id', sa.String(length=64), nullable=True),
    sa.Column('parent_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True),
    sa.Column('cmf_import_id', sa.String(length=64), nullable=True),
    sa.Column('tree_parent_id', sa.String(length=64), nullable=True),
    sa.Column('perm_acl_id', sa.String(length=64), nullable=True),
    sa.Column('perm_parent_id', sa.String(length=64), nullable=True),
    sa.Column('git_plugin_id', sa.String(length=64), nullable=True),
    sa.Column('repo_id', sa.String(length=64), nullable=True),
    sa.Column('head_branch_id', sa.String(length=64), nullable=True),
    sa.Column('base_branch_id', sa.String(length=64), nullable=True),
    sa.ForeignKeyConstraint(['author_id'], ['cmf_person.id'], ),
    sa.ForeignKeyConstraint(['base_branch_id'], ['cmf_git_branch.id'], ),
    sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ),
    sa.ForeignKeyConstraint(['git_plugin_id'], ['cmf_plugin_git.id'], ),
    sa.ForeignKeyConstraint(['head_branch_id'], ['cmf_git_branch.id'], ),
    sa.ForeignKeyConstraint(['merged_by_id'], ['cmf_person.id'], ),
    sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ),
    sa.ForeignKeyConstraint(['repo_id'], ['cmf_git_repo.id'], ),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cmf_git_merge_request_author_email'), 'cmf_git_merge_request', ['author_email'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_author_id'), 'cmf_git_merge_request', ['author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_author_login'), 'cmf_git_merge_request', ['author_login'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_author_name'), 'cmf_git_merge_request', ['author_name'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_base_branch_id'), 'cmf_git_merge_request', ['base_branch_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_base_branch_name'), 'cmf_git_merge_request', ['base_branch_name'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_base_repo'), 'cmf_git_merge_request', ['base_repo'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_base_sha'), 'cmf_git_merge_request', ['base_sha'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_author_id'), 'cmf_git_merge_request', ['cmf_author_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_created_at'), 'cmf_git_merge_request', ['cmf_created_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_deleted'), 'cmf_git_merge_request', ['cmf_deleted'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_import_id'), 'cmf_git_merge_request', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_locked_at'), 'cmf_git_merge_request', ['cmf_locked_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_locked_by_id'), 'cmf_git_merge_request', ['cmf_locked_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_modified_at'), 'cmf_git_merge_request', ['cmf_modified_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_modified_by_id'), 'cmf_git_merge_request', ['cmf_modified_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_owner_assistant_id'), 'cmf_git_merge_request', ['cmf_owner_assistant_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_owner_id'), 'cmf_git_merge_request', ['cmf_owner_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_version'), 'cmf_git_merge_request', ['cmf_version'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_cmf_viewed_at'), 'cmf_git_merge_request', ['cmf_viewed_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_code'), 'cmf_git_merge_request', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_git_merge_request_date'), 'cmf_git_merge_request', ['date'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_ext_id'), 'cmf_git_merge_request', ['ext_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_git_plugin_id'), 'cmf_git_merge_request', ['git_plugin_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_head_branch_id'), 'cmf_git_merge_request', ['head_branch_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_head_branch_name'), 'cmf_git_merge_request', ['head_branch_name'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_head_repo'), 'cmf_git_merge_request', ['head_repo'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_head_sha'), 'cmf_git_merge_request', ['head_sha'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merge_sha'), 'cmf_git_merge_request', ['merge_sha'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged'), 'cmf_git_merge_request', ['merged'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged_at'), 'cmf_git_merge_request', ['merged_at'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged_by_email'), 'cmf_git_merge_request', ['merged_by_email'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged_by_id'), 'cmf_git_merge_request', ['merged_by_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged_by_login'), 'cmf_git_merge_request', ['merged_by_login'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_merged_by_name'), 'cmf_git_merge_request', ['merged_by_name'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_name'), 'cmf_git_merge_request', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_number'), 'cmf_git_merge_request', ['number'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_orderno'), 'cmf_git_merge_request', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_parent_id'), 'cmf_git_merge_request', ['parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_perm_acl_id'), 'cmf_git_merge_request', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_perm_parent_id'), 'cmf_git_merge_request', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_repo_id'), 'cmf_git_merge_request', ['repo_id'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_status'), 'cmf_git_merge_request', ['status'], unique=False)
    op.create_index(op.f('ix_cmf_git_merge_request_tree_parent_id'), 'cmf_git_merge_request', ['tree_parent_id'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_cmf_git_merge_request_tree_parent_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_status'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_repo_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_perm_parent_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_perm_acl_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_parent_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_orderno'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_number'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_name'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged_by_name'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged_by_login'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged_by_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged_by_email'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged_at'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merged'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_merge_sha'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_head_sha'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_head_repo'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_head_branch_name'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_head_branch_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_git_plugin_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_ext_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_date'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_code'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_viewed_at'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_version'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_owner_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_owner_assistant_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_modified_by_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_modified_at'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_locked_by_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_locked_at'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_import_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_deleted'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_created_at'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_cmf_author_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_base_sha'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_base_repo'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_base_branch_name'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_base_branch_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_author_name'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_author_login'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_author_id'), table_name='cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_merge_request_author_email'), table_name='cmf_git_merge_request')
    op.drop_table('cmf_git_merge_request')
    op.drop_index(op.f('ix_cmf_git_commit_tree_parent_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_sha'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_repo_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_perm_parent_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_perm_acl_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_parent_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_orderno'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_name'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_git_plugin_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_date'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_code'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_viewed_at'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_version'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_owner_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_owner_assistant_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_modified_by_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_modified_at'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_locked_by_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_locked_at'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_import_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_deleted'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_created_at'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_cmf_author_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_author_name'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_author_login'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_author_id'), table_name='cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_commit_author_email'), table_name='cmf_git_commit')
    op.drop_table('cmf_git_commit')
    op.drop_index(op.f('ix_cmf_git_branch_tree_parent_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_repo_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_perm_parent_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_perm_acl_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_parent_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_orderno'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_name'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_git_plugin_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_code'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_viewed_at'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_version'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_owner_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_owner_assistant_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_modified_by_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_modified_at'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_locked_by_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_locked_at'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_import_id'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_deleted'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_created_at'), table_name='cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_branch_cmf_author_id'), table_name='cmf_git_branch')
    op.drop_table('cmf_git_branch')
    op.drop_index(op.f('ix_cmf_git_repo_tree_parent_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_perm_parent_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_perm_acl_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_parent_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_orderno'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_name'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_git_plugin_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_ext_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_default_branch'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_code'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_viewed_at'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_version'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_owner_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_owner_assistant_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_modified_by_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_modified_at'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_locked_by_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_locked_at'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_import_id'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_deleted'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_created_at'), table_name='cmf_git_repo')
    op.drop_index(op.f('ix_cmf_git_repo_cmf_author_id'), table_name='cmf_git_repo')
    op.drop_table('cmf_git_repo')
    op.drop_index(op.f('ix_cmf_plugin_git_tree_parent_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_plugin_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_perm_parent_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_perm_acl_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_parent_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_orderno'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_name'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_code'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_viewed_at'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_version'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_owner_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_owner_assistant_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_modified_by_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_modified_at'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_locked_by_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_locked_at'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_import_id'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_deleted'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_created_at'), table_name='cmf_plugin_git')
    op.drop_index(op.f('ix_cmf_plugin_git_cmf_author_id'), table_name='cmf_plugin_git')
    op.drop_table('cmf_plugin_git')
    # ### end Alembic commands ###
