"""asset v2

Revision ID: 4eeaf4305980
Revises: 04e5270f74a3
Create Date: 2024-02-27 21:58:52.116097

"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision = '4eeaf4305980'
down_revision = '04e5270f74a3'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cmf_asset_cat', sa.Column('name', sa.String(length=256), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('system', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_cat', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('import_original', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('cmf_archived', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_cat', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_cat', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_asset_cat_cmf_import_id'), 'cmf_asset_cat', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_cat_code'), 'cmf_asset_cat', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_asset_cat_name'), 'cmf_asset_cat', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_asset_cat_orderno'), 'cmf_asset_cat', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_asset_cat_perm_acl_id'), 'cmf_asset_cat', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_cat_perm_parent_id'), 'cmf_asset_cat', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_cat_root_parent_id'), 'cmf_asset_cat', ['root_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_asset_cat', 'cmf_access_list', ['perm_acl_id'], ['id'])
    op.create_foreign_key(None, 'cmf_asset_cat', 'cmf_import', ['cmf_import_id'], ['id'])
    op.add_column('cmf_asset_scheme', sa.Column('name', sa.String(length=256), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('system', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_scheme', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('import_original', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('cmf_archived', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_scheme', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_scheme', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_asset_scheme_cmf_import_id'), 'cmf_asset_scheme', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_code'), 'cmf_asset_scheme', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_asset_scheme_name'), 'cmf_asset_scheme', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_orderno'), 'cmf_asset_scheme', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_perm_acl_id'), 'cmf_asset_scheme', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_perm_parent_id'), 'cmf_asset_scheme', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_root_parent_id'), 'cmf_asset_scheme', ['root_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_scheme_tree_parent_id'), 'cmf_asset_scheme', ['tree_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_asset_scheme', 'cmf_import', ['cmf_import_id'], ['id'])
    op.create_foreign_key(None, 'cmf_asset_scheme', 'cmf_access_list', ['perm_acl_id'], ['id'])
    op.add_column('cmf_asset_type', sa.Column('name', sa.String(length=256), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('system', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_type', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('import_original', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('cmf_archived', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_type', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_asset_type_cmf_import_id'), 'cmf_asset_type', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_code'), 'cmf_asset_type', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_asset_type_name'), 'cmf_asset_type', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_orderno'), 'cmf_asset_type', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_perm_acl_id'), 'cmf_asset_type', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_perm_parent_id'), 'cmf_asset_type', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_root_parent_id'), 'cmf_asset_type', ['root_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_tree_parent_id'), 'cmf_asset_type', ['tree_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_asset_type', 'cmf_access_list', ['perm_acl_id'], ['id'])
    op.create_foreign_key(None, 'cmf_asset_type', 'cmf_import', ['cmf_import_id'], ['id'])
    op.add_column('cmf_asset_type_cat', sa.Column('name', sa.String(length=256), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('system', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_type_cat', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('import_original', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('cmf_archived', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_asset_type_cat', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_asset_type_cat', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_asset_type_cat_cmf_import_id'), 'cmf_asset_type_cat', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_cat_code'), 'cmf_asset_type_cat', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_asset_type_cat_name'), 'cmf_asset_type_cat', ['name'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_cat_orderno'), 'cmf_asset_type_cat', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_cat_perm_acl_id'), 'cmf_asset_type_cat', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_cat_perm_parent_id'), 'cmf_asset_type_cat', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_asset_type_cat_root_parent_id'), 'cmf_asset_type_cat', ['root_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_asset_type_cat', 'cmf_access_list', ['perm_acl_id'], ['id'])
    op.create_foreign_key(None, 'cmf_asset_type_cat', 'cmf_import', ['cmf_import_id'], ['id'])
    op.add_column('cmf_location', sa.Column('code', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('system', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_location', sa.Column('text', sa.TEXT(), nullable=True))
    op.add_column('cmf_location', sa.Column('import_original', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('import_raw_json', sa.TEXT(), nullable=True))
    op.add_column('cmf_location', sa.Column('ext_id', sa.String(), nullable=True))
    op.add_column('cmf_location', sa.Column('cmf_archived', sa.Boolean(), nullable=False, server_default="false"))
    op.add_column('cmf_location', sa.Column('is_favorite', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('has_tree_nodes', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('tree_hidden', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('orderno', sa.Integer(), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_public', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_has_acl', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_inherit', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_encrypt', sa.Boolean(), nullable=True))
    op.add_column('cmf_location', sa.Column('cmf_import_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('tree_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('root_parent_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_acl_id', sa.String(length=64), nullable=True))
    op.add_column('cmf_location', sa.Column('perm_parent_id', sa.String(length=64), nullable=True))
    op.create_index(op.f('ix_cmf_location_cmf_import_id'), 'cmf_location', ['cmf_import_id'], unique=False)
    op.create_index(op.f('ix_cmf_location_code'), 'cmf_location', ['code'], unique=True)
    op.create_index(op.f('ix_cmf_location_orderno'), 'cmf_location', ['orderno'], unique=False)
    op.create_index(op.f('ix_cmf_location_perm_acl_id'), 'cmf_location', ['perm_acl_id'], unique=False)
    op.create_index(op.f('ix_cmf_location_perm_parent_id'), 'cmf_location', ['perm_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_location_root_parent_id'), 'cmf_location', ['root_parent_id'], unique=False)
    op.create_index(op.f('ix_cmf_location_tree_parent_id'), 'cmf_location', ['tree_parent_id'], unique=False)
    op.create_foreign_key(None, 'cmf_location', 'cmf_import', ['cmf_import_id'], ['id'])
    op.create_foreign_key(None, 'cmf_location', 'cmf_access_list', ['perm_acl_id'], ['id'])
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint("cmf_location_cmf_import_id_fkey", 'cmf_location', type_='foreignkey')
    op.drop_constraint("cmf_location_perm_acl_id_fkey", 'cmf_location', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_location_tree_parent_id'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_root_parent_id'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_perm_parent_id'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_perm_acl_id'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_orderno'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_code'), table_name='cmf_location')
    op.drop_index(op.f('ix_cmf_location_cmf_import_id'), table_name='cmf_location')
    op.drop_column('cmf_location', 'perm_parent_id')
    op.drop_column('cmf_location', 'perm_acl_id')
    op.drop_column('cmf_location', 'root_parent_id')
    op.drop_column('cmf_location', 'tree_parent_id')
    op.drop_column('cmf_location', 'cmf_import_id')
    op.drop_column('cmf_location', 'perm_encrypt')
    op.drop_column('cmf_location', 'perm_security_level_allowed_ids_cache')
    op.drop_column('cmf_location', 'perm_effective_acl_id')
    op.drop_column('cmf_location', 'perm_inherit_acl_id')
    op.drop_column('cmf_location', 'perm_parent_owner_id')
    op.drop_column('cmf_location', 'perm_inherit')
    op.drop_column('cmf_location', 'perm_has_acl')
    op.drop_column('cmf_location', 'perm_public')
    op.drop_column('cmf_location', 'orderno')
    op.drop_column('cmf_location', 'tree_hidden')
    op.drop_column('cmf_location', 'tree_node_is_branch')
    op.drop_column('cmf_location', 'has_tree_nodes')
    op.drop_column('cmf_location', 'is_favorite')
    op.drop_column('cmf_location', 'cmf_archived')
    op.drop_column('cmf_location', 'ext_id')
    op.drop_column('cmf_location', 'import_raw_json')
    op.drop_column('cmf_location', 'import_original')
    op.drop_column('cmf_location', 'text')
    op.drop_column('cmf_location', 'system')
    op.drop_column('cmf_location', 'code')
    op.drop_constraint("cmf_asset_type_cat_cmf_import_id_fkey", 'cmf_asset_type_cat', type_='foreignkey')
    op.drop_constraint("cmf_asset_type_cat_perm_acl_id_fkey", 'cmf_asset_type_cat', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_asset_type_cat_root_parent_id'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_perm_parent_id'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_perm_acl_id'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_orderno'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_name'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_code'), table_name='cmf_asset_type_cat')
    op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_import_id'), table_name='cmf_asset_type_cat')
    op.drop_column('cmf_asset_type_cat', 'perm_parent_id')
    op.drop_column('cmf_asset_type_cat', 'perm_acl_id')
    op.drop_column('cmf_asset_type_cat', 'root_parent_id')
    op.drop_column('cmf_asset_type_cat', 'cmf_import_id')
    op.drop_column('cmf_asset_type_cat', 'perm_encrypt')
    op.drop_column('cmf_asset_type_cat', 'perm_security_level_allowed_ids_cache')
    op.drop_column('cmf_asset_type_cat', 'perm_effective_acl_id')
    op.drop_column('cmf_asset_type_cat', 'perm_inherit_acl_id')
    op.drop_column('cmf_asset_type_cat', 'perm_parent_owner_id')
    op.drop_column('cmf_asset_type_cat', 'perm_inherit')
    op.drop_column('cmf_asset_type_cat', 'perm_has_acl')
    op.drop_column('cmf_asset_type_cat', 'perm_public')
    op.drop_column('cmf_asset_type_cat', 'orderno')
    op.drop_column('cmf_asset_type_cat', 'tree_hidden')
    op.drop_column('cmf_asset_type_cat', 'tree_node_is_branch')
    op.drop_column('cmf_asset_type_cat', 'has_tree_nodes')
    op.drop_column('cmf_asset_type_cat', 'is_favorite')
    op.drop_column('cmf_asset_type_cat', 'cmf_archived')
    op.drop_column('cmf_asset_type_cat', 'ext_id')
    op.drop_column('cmf_asset_type_cat', 'import_raw_json')
    op.drop_column('cmf_asset_type_cat', 'import_original')
    op.drop_column('cmf_asset_type_cat', 'text')
    op.drop_column('cmf_asset_type_cat', 'system')
    op.drop_column('cmf_asset_type_cat', 'code')
    op.drop_column('cmf_asset_type_cat', 'name')
    op.drop_constraint("cmf_asset_type_cmf_import_id_fkey", 'cmf_asset_type', type_='foreignkey')
    op.drop_constraint("cmf_asset_type_perm_acl_id_fkey", 'cmf_asset_type', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_asset_type_tree_parent_id'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_root_parent_id'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_perm_parent_id'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_perm_acl_id'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_orderno'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_name'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_code'), table_name='cmf_asset_type')
    op.drop_index(op.f('ix_cmf_asset_type_cmf_import_id'), table_name='cmf_asset_type')
    op.drop_column('cmf_asset_type', 'perm_parent_id')
    op.drop_column('cmf_asset_type', 'perm_acl_id')
    op.drop_column('cmf_asset_type', 'root_parent_id')
    op.drop_column('cmf_asset_type', 'tree_parent_id')
    op.drop_column('cmf_asset_type', 'cmf_import_id')
    op.drop_column('cmf_asset_type', 'perm_encrypt')
    op.drop_column('cmf_asset_type', 'perm_security_level_allowed_ids_cache')
    op.drop_column('cmf_asset_type', 'perm_effective_acl_id')
    op.drop_column('cmf_asset_type', 'perm_inherit_acl_id')
    op.drop_column('cmf_asset_type', 'perm_parent_owner_id')
    op.drop_column('cmf_asset_type', 'perm_inherit')
    op.drop_column('cmf_asset_type', 'perm_has_acl')
    op.drop_column('cmf_asset_type', 'perm_public')
    op.drop_column('cmf_asset_type', 'orderno')
    op.drop_column('cmf_asset_type', 'tree_hidden')
    op.drop_column('cmf_asset_type', 'tree_node_is_branch')
    op.drop_column('cmf_asset_type', 'has_tree_nodes')
    op.drop_column('cmf_asset_type', 'is_favorite')
    op.drop_column('cmf_asset_type', 'cmf_archived')
    op.drop_column('cmf_asset_type', 'ext_id')
    op.drop_column('cmf_asset_type', 'import_raw_json')
    op.drop_column('cmf_asset_type', 'import_original')
    op.drop_column('cmf_asset_type', 'text')
    op.drop_column('cmf_asset_type', 'system')
    op.drop_column('cmf_asset_type', 'code')
    op.drop_column('cmf_asset_type', 'name')
    op.drop_constraint("cmf_asset_scheme_cmf_import_id_fkey", 'cmf_asset_scheme', type_='foreignkey')
    op.drop_constraint("cmf_asset_scheme_perm_acl_id_fkey", 'cmf_asset_scheme', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_asset_scheme_tree_parent_id'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_root_parent_id'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_perm_parent_id'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_perm_acl_id'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_orderno'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_name'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_code'), table_name='cmf_asset_scheme')
    op.drop_index(op.f('ix_cmf_asset_scheme_cmf_import_id'), table_name='cmf_asset_scheme')
    op.drop_column('cmf_asset_scheme', 'perm_parent_id')
    op.drop_column('cmf_asset_scheme', 'perm_acl_id')
    op.drop_column('cmf_asset_scheme', 'root_parent_id')
    op.drop_column('cmf_asset_scheme', 'tree_parent_id')
    op.drop_column('cmf_asset_scheme', 'cmf_import_id')
    op.drop_column('cmf_asset_scheme', 'perm_encrypt')
    op.drop_column('cmf_asset_scheme', 'perm_security_level_allowed_ids_cache')
    op.drop_column('cmf_asset_scheme', 'perm_effective_acl_id')
    op.drop_column('cmf_asset_scheme', 'perm_inherit_acl_id')
    op.drop_column('cmf_asset_scheme', 'perm_parent_owner_id')
    op.drop_column('cmf_asset_scheme', 'perm_inherit')
    op.drop_column('cmf_asset_scheme', 'perm_has_acl')
    op.drop_column('cmf_asset_scheme', 'perm_public')
    op.drop_column('cmf_asset_scheme', 'orderno')
    op.drop_column('cmf_asset_scheme', 'tree_hidden')
    op.drop_column('cmf_asset_scheme', 'tree_node_is_branch')
    op.drop_column('cmf_asset_scheme', 'has_tree_nodes')
    op.drop_column('cmf_asset_scheme', 'is_favorite')
    op.drop_column('cmf_asset_scheme', 'cmf_archived')
    op.drop_column('cmf_asset_scheme', 'ext_id')
    op.drop_column('cmf_asset_scheme', 'import_raw_json')
    op.drop_column('cmf_asset_scheme', 'import_original')
    op.drop_column('cmf_asset_scheme', 'text')
    op.drop_column('cmf_asset_scheme', 'system')
    op.drop_column('cmf_asset_scheme', 'code')
    op.drop_column('cmf_asset_scheme', 'name')
    op.drop_constraint("cmf_asset_cat_cmf_import_id_fkey", 'cmf_asset_cat', type_='foreignkey')
    op.drop_constraint("cmf_asset_cat_perm_acl_id_fkey", 'cmf_asset_cat', type_='foreignkey')
    op.drop_index(op.f('ix_cmf_asset_cat_root_parent_id'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_perm_parent_id'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_perm_acl_id'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_orderno'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_name'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_code'), table_name='cmf_asset_cat')
    op.drop_index(op.f('ix_cmf_asset_cat_cmf_import_id'), table_name='cmf_asset_cat')
    op.drop_column('cmf_asset_cat', 'perm_parent_id')
    op.drop_column('cmf_asset_cat', 'perm_acl_id')
    op.drop_column('cmf_asset_cat', 'root_parent_id')
    op.drop_column('cmf_asset_cat', 'cmf_import_id')
    op.drop_column('cmf_asset_cat', 'perm_encrypt')
    op.drop_column('cmf_asset_cat', 'perm_security_level_allowed_ids_cache')
    op.drop_column('cmf_asset_cat', 'perm_effective_acl_id')
    op.drop_column('cmf_asset_cat', 'perm_inherit_acl_id')
    op.drop_column('cmf_asset_cat', 'perm_parent_owner_id')
    op.drop_column('cmf_asset_cat', 'perm_inherit')
    op.drop_column('cmf_asset_cat', 'perm_has_acl')
    op.drop_column('cmf_asset_cat', 'perm_public')
    op.drop_column('cmf_asset_cat', 'orderno')
    op.drop_column('cmf_asset_cat', 'tree_hidden')
    op.drop_column('cmf_asset_cat', 'tree_node_is_branch')
    op.drop_column('cmf_asset_cat', 'has_tree_nodes')
    op.drop_column('cmf_asset_cat', 'is_favorite')
    op.drop_column('cmf_asset_cat', 'cmf_archived')
    op.drop_column('cmf_asset_cat', 'ext_id')
    op.drop_column('cmf_asset_cat', 'import_raw_json')
    op.drop_column('cmf_asset_cat', 'import_original')
    op.drop_column('cmf_asset_cat', 'text')
    op.drop_column('cmf_asset_cat', 'system')
    op.drop_column('cmf_asset_cat', 'code')
    op.drop_column('cmf_asset_cat', 'name')
    # ### end Alembic commands ###