"""asset Revision ID: 04e5270f74a3 Revises: 183ded3722ad Create Date: 2024-02-27 21:33:15.364821 """ from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import postgresql # revision identifiers, used by Alembic. revision = '04e5270f74a3' down_revision = '183ded3722ad' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_location', 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=4096), nullable=False), sa.Column('country', sa.String(length=256), nullable=True), sa.Column('country_code', sa.String(length=256), nullable=True), sa.Column('zip_code', sa.String(length=256), nullable=True), sa.Column('area_code', sa.String(length=256), nullable=True), sa.Column('area', sa.String(length=256), nullable=True), sa.Column('city', sa.String(length=256), nullable=True), sa.Column('street', sa.String(length=256), nullable=True), sa.Column('district', sa.String(length=256), nullable=True), sa.Column('mun_district', sa.String(length=256), nullable=True), sa.Column('settlement', sa.String(length=256), nullable=True), sa.Column('city_district', sa.String(length=256), nullable=True), sa.Column('locality', sa.String(length=256), nullable=True), sa.Column('territory', sa.String(length=256), nullable=True), sa.Column('house_number', sa.String(length=256), nullable=True), sa.Column('floor', sa.String(length=256), nullable=True), sa.Column('flat', sa.String(length=256), nullable=True), sa.Column('room', 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.ForeignKeyConstraint(['parent_id'], ['cmf_location.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('cmf_asset_scheme', 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('code_prefix', 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.PrimaryKeyConstraint('id') ) op.create_table('cmf_asset_cat', 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('is_abstract', 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=False), 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('tree_parent_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['parent_id'], ['cmf_asset_scheme.id'], ), sa.ForeignKeyConstraint(['tree_parent_id'], ['cmf_asset_cat.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('cmf_asset', 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('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=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_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('is_public', sa.Boolean(), nullable=True), sa.Column('is_public_editable', sa.Boolean(), nullable=True), sa.Column('is_public_comments', sa.Boolean(), nullable=True), sa.Column('logic_prefix', sa.String(), nullable=True), sa.Column('ui_view_form', sa.String(length=32), nullable=False), sa.Column('parent_logic_prefix', sa.String(), nullable=True), sa.Column('status_modified_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_in_progress_start', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_in_progress_end', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_review_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('status_closed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('no_control', sa.Boolean(), nullable=True), sa.Column('priority', sa.Integer(), nullable=False), sa.Column('mark', sa.String(length=32), nullable=True), sa.Column('alarm_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('deadline', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('plan_start_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('plan_end_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('period_next_date', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('period_interval', sa.String(length=32), nullable=True), sa.Column('is_template', sa.Boolean(), nullable=True), sa.Column('is_penalty', sa.Boolean(), nullable=True), sa.Column('cache_status_type', sa.String(length=32), nullable=True), sa.Column('cache_fields', sa.TEXT(), nullable=True), sa.Column('approved', sa.Boolean(), nullable=False), sa.Column('perm_policy', sa.String(length=32), nullable=False), sa.Column('perm_policy_guest', sa.String(length=32), nullable=False), sa.Column('perm_policy_anonymous', sa.String(length=32), nullable=False), sa.Column('perm_policy_sharelink', sa.String(length=32), nullable=False), sa.Column('sharelink_hash', sa.String(length=32), nullable=True), sa.Column('asset_tag', sa.String(length=256), nullable=True), sa.Column('serial_number', sa.String(length=256), nullable=True), sa.Column('po_number', sa.String(length=256), nullable=True), sa.Column('invoice_number', sa.String(length=256), nullable=True), sa.Column('lease_contract', sa.String(length=256), nullable=True), sa.Column('maintenance_contract', sa.String(length=256), nullable=True), sa.Column('purchase_date', sa.DATE(), nullable=True), sa.Column('refresh_date', sa.DATE(), nullable=True), sa.Column('last_scan_date', sa.DATE(), nullable=True), sa.Column('ownership_type', sa.String(length=32), nullable=True), sa.Column('device_type', sa.String(length=32), nullable=True), sa.Column('os_version', sa.String(length=256), nullable=True), sa.Column('enabled_status', sa.String(length=32), nullable=True), sa.Column('operational_status', sa.String(length=32), nullable=True), sa.Column('imei', sa.String(length=256), nullable=True), sa.Column('phone_number', sa.String(length=256), nullable=True), sa.Column('ip_adress', sa.String(length=32), nullable=True), sa.Column('domain_name', sa.String(length=256), nullable=True), sa.Column('warranty_expiration', sa.DATE(), nullable=True), sa.Column('release_date', sa.DATE(), nullable=True), sa.Column('writeoff_date', sa.DATE(), 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=False), 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('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('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('asset_cat_id', sa.String(length=64), nullable=False), sa.Column('location_id', sa.String(length=64), nullable=True), sa.Column('included_in_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['activity_id'], ['cmf_activity.id'], ), sa.ForeignKeyConstraint(['asset_cat_id'], ['cmf_asset_cat.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(['included_in_id'], ['cmf_asset.id'], ), sa.ForeignKeyConstraint(['location_id'], ['cmf_location.id'], ), sa.ForeignKeyConstraint(['logic_type_id'], ['cmf_logic_type.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_asset_scheme.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['perm_security_level_id'], ['cmf_security_level.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_asset_activity_id'), 'cmf_asset', ['activity_id'], unique=False) op.create_index(op.f('ix_cmf_asset_alarm_date'), 'cmf_asset', ['alarm_date'], unique=False) op.create_index(op.f('ix_cmf_asset_approved'), 'cmf_asset', ['approved'], unique=False) op.create_index(op.f('ix_cmf_asset_asset_cat_id'), 'cmf_asset', ['asset_cat_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cache_status_opt_id'), 'cmf_asset', ['cache_status_opt_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cache_status_type'), 'cmf_asset', ['cache_status_type'], unique=False) op.create_index(op.f('ix_cmf_asset_cloned_from_id'), 'cmf_asset', ['cloned_from_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_author_id'), 'cmf_asset', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_created_at'), 'cmf_asset', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_deleted'), 'cmf_asset', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_import_id'), 'cmf_asset', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_locked_at'), 'cmf_asset', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_locked_by_id'), 'cmf_asset', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_modified_at'), 'cmf_asset', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_modified_by_id'), 'cmf_asset', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_owner_assistant_id'), 'cmf_asset', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_owner_id'), 'cmf_asset', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_version'), 'cmf_asset', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_viewed_at'), 'cmf_asset', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_asset_code'), 'cmf_asset', ['code'], unique=True) op.create_index(op.f('ix_cmf_asset_company_id'), 'cmf_asset', ['company_id'], unique=False) op.create_index(op.f('ix_cmf_asset_default_task_workflow_id'), 'cmf_asset', ['default_task_workflow_id'], unique=False) op.create_index(op.f('ix_cmf_asset_included_in_id'), 'cmf_asset', ['included_in_id'], unique=False) op.create_index(op.f('ix_cmf_asset_is_template'), 'cmf_asset', ['is_template'], unique=False) op.create_index(op.f('ix_cmf_asset_location_id'), 'cmf_asset', ['location_id'], unique=False) op.create_index(op.f('ix_cmf_asset_logic_prefix'), 'cmf_asset', ['logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_asset_logic_type_id'), 'cmf_asset', ['logic_type_id'], unique=False) op.create_index(op.f('ix_cmf_asset_name'), 'cmf_asset', ['name'], unique=False) op.create_index(op.f('ix_cmf_asset_orderno'), 'cmf_asset', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_asset_parent_id'), 'cmf_asset', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_parent_logic_prefix'), 'cmf_asset', ['parent_logic_prefix'], unique=False) op.create_index(op.f('ix_cmf_asset_perm_acl_id'), 'cmf_asset', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_asset_perm_parent_id'), 'cmf_asset', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_perm_security_level_id'), 'cmf_asset', ['perm_security_level_id'], unique=False) op.create_index(op.f('ix_cmf_asset_responsible_id'), 'cmf_asset', ['responsible_id'], unique=False) op.create_index(op.f('ix_cmf_asset_root_parent_id'), 'cmf_asset', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_wf_id'), 'cmf_asset', ['scheme_wf_id'], unique=False) op.create_index(op.f('ix_cmf_asset_status_id'), 'cmf_asset', ['status_id'], unique=False) op.create_index(op.f('ix_cmf_asset_tree_parent_id'), 'cmf_asset', ['tree_parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_waiting_for_id'), 'cmf_asset', ['waiting_for_id'], unique=False) op.create_index(op.f('ix_cmf_asset_workflow_id'), 'cmf_asset', ['workflow_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_author_id'), 'cmf_asset_cat', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_created_at'), 'cmf_asset_cat', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_deleted'), 'cmf_asset_cat', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_locked_at'), 'cmf_asset_cat', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_locked_by_id'), 'cmf_asset_cat', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_modified_at'), 'cmf_asset_cat', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_modified_by_id'), 'cmf_asset_cat', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_owner_id'), 'cmf_asset_cat', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_version'), 'cmf_asset_cat', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_cmf_viewed_at'), 'cmf_asset_cat', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_parent_id'), 'cmf_asset_cat', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_tree_parent_id'), 'cmf_asset_cat', ['tree_parent_id'], unique=False) op.create_table('cmf_asset_cat_role_developer', 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_asset_cat_role_developer_left_id'), 'cmf_asset_cat_role_developer', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_developer_parent_id'), 'cmf_asset_cat_role_developer', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_developer_right_id'), 'cmf_asset_cat_role_developer', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_developer_root_id'), 'cmf_asset_cat_role_developer', ['root_id'], unique=False) op.create_table('cmf_asset_cat_role_manager', 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_asset_cat_role_manager_left_id'), 'cmf_asset_cat_role_manager', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_manager_parent_id'), 'cmf_asset_cat_role_manager', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_manager_right_id'), 'cmf_asset_cat_role_manager', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_manager_root_id'), 'cmf_asset_cat_role_manager', ['root_id'], unique=False) op.create_table('cmf_asset_cat_role_user', 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_table('cmf_asset_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_asset_cmf_owner_assistants_left_id'), 'cmf_asset_cmf_owner_assistants', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_owner_assistants_parent_id'), 'cmf_asset_cmf_owner_assistants', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_owner_assistants_right_id'), 'cmf_asset_cmf_owner_assistants', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_owner_assistants_root_id'), 'cmf_asset_cmf_owner_assistants', ['root_id'], unique=False) op.create_table('cmf_asset_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_asset_executors_left_id'), 'cmf_asset_executors', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_executors_parent_id'), 'cmf_asset_executors', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_executors_right_id'), 'cmf_asset_executors', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_executors_root_id'), 'cmf_asset_executors', ['root_id'], unique=False) op.create_table('cmf_asset_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_asset_local_links_left_id'), 'cmf_asset_local_links', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_local_links_parent_id'), 'cmf_asset_local_links', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_local_links_right_id'), 'cmf_asset_local_links', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_local_links_root_id'), 'cmf_asset_local_links', ['root_id'], unique=False) op.create_table('cmf_asset_owner_group', 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_asset_owner_group_left_id'), 'cmf_asset_owner_group', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_owner_group_parent_id'), 'cmf_asset_owner_group', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_owner_group_right_id'), 'cmf_asset_owner_group', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_owner_group_root_id'), 'cmf_asset_owner_group', ['root_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_author_id'), 'cmf_asset_scheme', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_created_at'), 'cmf_asset_scheme', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_deleted'), 'cmf_asset_scheme', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_locked_at'), 'cmf_asset_scheme', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_locked_by_id'), 'cmf_asset_scheme', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_modified_at'), 'cmf_asset_scheme', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_modified_by_id'), 'cmf_asset_scheme', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_owner_id'), 'cmf_asset_scheme', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_version'), 'cmf_asset_scheme', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_cmf_viewed_at'), 'cmf_asset_scheme', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_code_prefix'), 'cmf_asset_scheme', ['code_prefix'], unique=True) op.create_index(op.f('ix_cmf_asset_scheme_parent_id'), 'cmf_asset_scheme', ['parent_id'], unique=False) op.create_table('cmf_asset_scheme_role_developer', 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_asset_scheme_role_developer_left_id'), 'cmf_asset_scheme_role_developer', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_developer_parent_id'), 'cmf_asset_scheme_role_developer', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_developer_right_id'), 'cmf_asset_scheme_role_developer', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_developer_root_id'), 'cmf_asset_scheme_role_developer', ['root_id'], unique=False) op.create_table('cmf_asset_scheme_role_manager', 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_asset_scheme_role_manager_left_id'), 'cmf_asset_scheme_role_manager', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_manager_parent_id'), 'cmf_asset_scheme_role_manager', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_manager_right_id'), 'cmf_asset_scheme_role_manager', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_manager_root_id'), 'cmf_asset_scheme_role_manager', ['root_id'], unique=False) op.create_table('cmf_asset_scheme_role_user', 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_asset_scheme_role_user_left_id'), 'cmf_asset_scheme_role_user', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_user_parent_id'), 'cmf_asset_scheme_role_user', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_user_right_id'), 'cmf_asset_scheme_role_user', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_scheme_role_user_root_id'), 'cmf_asset_scheme_role_user', ['root_id'], unique=False) op.create_table('cmf_asset_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_asset_spectators_left_id'), 'cmf_asset_spectators', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_spectators_parent_id'), 'cmf_asset_spectators', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_spectators_right_id'), 'cmf_asset_spectators', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_spectators_root_id'), 'cmf_asset_spectators', ['root_id'], unique=False) op.create_table('cmf_asset_support_group', 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_asset_support_group_left_id'), 'cmf_asset_support_group', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_support_group_parent_id'), 'cmf_asset_support_group', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_support_group_right_id'), 'cmf_asset_support_group', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_support_group_root_id'), 'cmf_asset_support_group', ['root_id'], unique=False) op.create_table('cmf_asset_type_cat', 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('is_abstract', 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=False), 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('tree_parent_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['parent_id'], ['cmf_asset_scheme.id'], ), sa.ForeignKeyConstraint(['tree_parent_id'], ['cmf_asset_type_cat.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('cmf_asset_type', 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('model_id', sa.String(length=256), nullable=True), sa.Column('bar_code', sa.String(length=256), nullable=True), sa.Column('product_information', sa.String(length=256), nullable=True), sa.Column('unit_price', sa.Integer(), nullable=True), sa.Column('version', sa.String(length=256), nullable=True), sa.Column('short_name', 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=False), 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('asset_type_cat_id', sa.String(length=64), nullable=False), sa.ForeignKeyConstraint(['asset_type_cat_id'], ['cmf_asset_type_cat.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_asset_scheme.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('cmf_asset_cmf_asset_type', 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_asset.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_asset_type.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_asset_type_asset_type_cat_id'), 'cmf_asset_type', ['asset_type_cat_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_author_id'), 'cmf_asset_type', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_created_at'), 'cmf_asset_type', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_deleted'), 'cmf_asset_type', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_locked_at'), 'cmf_asset_type', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_locked_by_id'), 'cmf_asset_type', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_modified_at'), 'cmf_asset_type', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_modified_by_id'), 'cmf_asset_type', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_owner_id'), 'cmf_asset_type', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_version'), 'cmf_asset_type', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cmf_viewed_at'), 'cmf_asset_type', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_parent_id'), 'cmf_asset_type', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_author_id'), 'cmf_asset_type_cat', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_created_at'), 'cmf_asset_type_cat', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_deleted'), 'cmf_asset_type_cat', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_locked_at'), 'cmf_asset_type_cat', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_locked_by_id'), 'cmf_asset_type_cat', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_modified_at'), 'cmf_asset_type_cat', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_modified_by_id'), 'cmf_asset_type_cat', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_owner_id'), 'cmf_asset_type_cat', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_version'), 'cmf_asset_type_cat', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_cmf_viewed_at'), 'cmf_asset_type_cat', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_parent_id'), 'cmf_asset_type_cat', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_tree_parent_id'), 'cmf_asset_type_cat', ['tree_parent_id'], unique=False) op.create_table('cmf_asset_type_cat_role_developer', 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_asset_type_cat_role_developer_left_id'), 'cmf_asset_type_cat_role_developer', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_developer_parent_id'), 'cmf_asset_type_cat_role_developer', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_developer_right_id'), 'cmf_asset_type_cat_role_developer', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_developer_root_id'), 'cmf_asset_type_cat_role_developer', ['root_id'], unique=False) op.create_table('cmf_asset_type_cat_role_manager', 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_asset_type_cat_role_manager_left_id'), 'cmf_asset_type_cat_role_manager', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_manager_parent_id'), 'cmf_asset_type_cat_role_manager', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_manager_right_id'), 'cmf_asset_type_cat_role_manager', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_manager_root_id'), 'cmf_asset_type_cat_role_manager', ['root_id'], unique=False) op.create_table('cmf_asset_type_cat_role_user', 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_asset_type_cat_role_user_left_id'), 'cmf_asset_type_cat_role_user', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_user_parent_id'), 'cmf_asset_type_cat_role_user', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_user_right_id'), 'cmf_asset_type_cat_role_user', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_type_cat_role_user_root_id'), 'cmf_asset_type_cat_role_user', ['root_id'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_author_id'), 'cmf_location', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_created_at'), 'cmf_location', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_deleted'), 'cmf_location', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_locked_at'), 'cmf_location', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_locked_by_id'), 'cmf_location', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_modified_at'), 'cmf_location', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_modified_by_id'), 'cmf_location', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_owner_id'), 'cmf_location', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_version'), 'cmf_location', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_location_cmf_viewed_at'), 'cmf_location', ['cmf_viewed_at'], unique=False) op.create_index('ix_cmf_location_name_gin_trgm', 'cmf_location', ['name'], unique=False, postgresql_using='gin', postgresql_ops={'name': 'gin_trgm_ops'}) op.create_index(op.f('ix_cmf_location_parent_id'), 'cmf_location', ['parent_id'], unique=False) op.create_table('cmf_task_cmf_asset', 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_task.id'], ), sa.ForeignKeyConstraint(['right_id'], ['cmf_asset.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_task_cmf_asset_left_id'), 'cmf_task_cmf_asset', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_task_cmf_asset_parent_id'), 'cmf_task_cmf_asset', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_task_cmf_asset_right_id'), 'cmf_task_cmf_asset', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_task_cmf_asset_root_id'), 'cmf_task_cmf_asset', ['root_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_user_left_id'), 'cmf_asset_cat_role_user', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_user_parent_id'), 'cmf_asset_cat_role_user', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_user_right_id'), 'cmf_asset_cat_role_user', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cat_role_user_root_id'), 'cmf_asset_cat_role_user', ['root_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_asset_type_left_id'), 'cmf_asset_cmf_asset_type', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_asset_type_parent_id'), 'cmf_asset_cmf_asset_type', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_asset_type_right_id'), 'cmf_asset_cmf_asset_type', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_asset_cmf_asset_type_root_id'), 'cmf_asset_cmf_asset_type', ['root_id'], unique=False) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_index(op.f('ix_cmf_task_cmf_asset_root_id'), table_name='cmf_task_cmf_asset') op.drop_index(op.f('ix_cmf_task_cmf_asset_right_id'), table_name='cmf_task_cmf_asset') op.drop_index(op.f('ix_cmf_task_cmf_asset_parent_id'), table_name='cmf_task_cmf_asset') op.drop_index(op.f('ix_cmf_task_cmf_asset_left_id'), table_name='cmf_task_cmf_asset') op.drop_table('cmf_task_cmf_asset') op.drop_index(op.f('ix_cmf_location_parent_id'), table_name='cmf_location') op.drop_index('ix_cmf_location_name_gin_trgm', table_name='cmf_location', postgresql_using='gin', postgresql_ops={'name': 'gin_trgm_ops'}) op.drop_index(op.f('ix_cmf_location_cmf_viewed_at'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_version'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_owner_id'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_modified_by_id'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_modified_at'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_locked_by_id'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_locked_at'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_deleted'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_created_at'), table_name='cmf_location') op.drop_index(op.f('ix_cmf_location_cmf_author_id'), table_name='cmf_location') op.drop_table('cmf_location') op.drop_index(op.f('ix_cmf_asset_type_cat_role_user_root_id'), table_name='cmf_asset_type_cat_role_user') op.drop_index(op.f('ix_cmf_asset_type_cat_role_user_right_id'), table_name='cmf_asset_type_cat_role_user') op.drop_index(op.f('ix_cmf_asset_type_cat_role_user_parent_id'), table_name='cmf_asset_type_cat_role_user') op.drop_index(op.f('ix_cmf_asset_type_cat_role_user_left_id'), table_name='cmf_asset_type_cat_role_user') op.drop_table('cmf_asset_type_cat_role_user') op.drop_index(op.f('ix_cmf_asset_type_cat_role_manager_root_id'), table_name='cmf_asset_type_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_type_cat_role_manager_right_id'), table_name='cmf_asset_type_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_type_cat_role_manager_parent_id'), table_name='cmf_asset_type_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_type_cat_role_manager_left_id'), table_name='cmf_asset_type_cat_role_manager') op.drop_table('cmf_asset_type_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_type_cat_role_developer_root_id'), table_name='cmf_asset_type_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_type_cat_role_developer_right_id'), table_name='cmf_asset_type_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_type_cat_role_developer_parent_id'), table_name='cmf_asset_type_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_type_cat_role_developer_left_id'), table_name='cmf_asset_type_cat_role_developer') op.drop_table('cmf_asset_type_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_type_cat_tree_parent_id'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_parent_id'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_viewed_at'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_version'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_owner_id'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_modified_by_id'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_modified_at'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_locked_by_id'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_locked_at'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_deleted'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_created_at'), table_name='cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_cat_cmf_author_id'), table_name='cmf_asset_type_cat') op.drop_table('cmf_asset_type_cat') op.drop_index(op.f('ix_cmf_asset_type_parent_id'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_viewed_at'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_version'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_owner_id'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_modified_by_id'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_modified_at'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_locked_by_id'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_locked_at'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_deleted'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_created_at'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_cmf_author_id'), table_name='cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_type_asset_type_cat_id'), table_name='cmf_asset_type') op.drop_table('cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_support_group_root_id'), table_name='cmf_asset_support_group') op.drop_index(op.f('ix_cmf_asset_support_group_right_id'), table_name='cmf_asset_support_group') op.drop_index(op.f('ix_cmf_asset_support_group_parent_id'), table_name='cmf_asset_support_group') op.drop_index(op.f('ix_cmf_asset_support_group_left_id'), table_name='cmf_asset_support_group') op.drop_table('cmf_asset_support_group') op.drop_index(op.f('ix_cmf_asset_spectators_root_id'), table_name='cmf_asset_spectators') op.drop_index(op.f('ix_cmf_asset_spectators_right_id'), table_name='cmf_asset_spectators') op.drop_index(op.f('ix_cmf_asset_spectators_parent_id'), table_name='cmf_asset_spectators') op.drop_index(op.f('ix_cmf_asset_spectators_left_id'), table_name='cmf_asset_spectators') op.drop_table('cmf_asset_spectators') op.drop_index(op.f('ix_cmf_asset_scheme_role_user_root_id'), table_name='cmf_asset_scheme_role_user') op.drop_index(op.f('ix_cmf_asset_scheme_role_user_right_id'), table_name='cmf_asset_scheme_role_user') op.drop_index(op.f('ix_cmf_asset_scheme_role_user_parent_id'), table_name='cmf_asset_scheme_role_user') op.drop_index(op.f('ix_cmf_asset_scheme_role_user_left_id'), table_name='cmf_asset_scheme_role_user') op.drop_table('cmf_asset_scheme_role_user') op.drop_index(op.f('ix_cmf_asset_scheme_role_manager_root_id'), table_name='cmf_asset_scheme_role_manager') op.drop_index(op.f('ix_cmf_asset_scheme_role_manager_right_id'), table_name='cmf_asset_scheme_role_manager') op.drop_index(op.f('ix_cmf_asset_scheme_role_manager_parent_id'), table_name='cmf_asset_scheme_role_manager') op.drop_index(op.f('ix_cmf_asset_scheme_role_manager_left_id'), table_name='cmf_asset_scheme_role_manager') op.drop_table('cmf_asset_scheme_role_manager') op.drop_index(op.f('ix_cmf_asset_scheme_role_developer_root_id'), table_name='cmf_asset_scheme_role_developer') op.drop_index(op.f('ix_cmf_asset_scheme_role_developer_right_id'), table_name='cmf_asset_scheme_role_developer') op.drop_index(op.f('ix_cmf_asset_scheme_role_developer_parent_id'), table_name='cmf_asset_scheme_role_developer') op.drop_index(op.f('ix_cmf_asset_scheme_role_developer_left_id'), table_name='cmf_asset_scheme_role_developer') op.drop_table('cmf_asset_scheme_role_developer') op.drop_index(op.f('ix_cmf_asset_scheme_parent_id'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_code_prefix'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_viewed_at'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_version'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_owner_id'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_modified_by_id'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_modified_at'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_locked_by_id'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_locked_at'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_deleted'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_created_at'), table_name='cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_scheme_cmf_author_id'), table_name='cmf_asset_scheme') op.drop_table('cmf_asset_scheme') op.drop_index(op.f('ix_cmf_asset_owner_group_root_id'), table_name='cmf_asset_owner_group') op.drop_index(op.f('ix_cmf_asset_owner_group_right_id'), table_name='cmf_asset_owner_group') op.drop_index(op.f('ix_cmf_asset_owner_group_parent_id'), table_name='cmf_asset_owner_group') op.drop_index(op.f('ix_cmf_asset_owner_group_left_id'), table_name='cmf_asset_owner_group') op.drop_table('cmf_asset_owner_group') op.drop_index(op.f('ix_cmf_asset_local_links_root_id'), table_name='cmf_asset_local_links') op.drop_index(op.f('ix_cmf_asset_local_links_right_id'), table_name='cmf_asset_local_links') op.drop_index(op.f('ix_cmf_asset_local_links_parent_id'), table_name='cmf_asset_local_links') op.drop_index(op.f('ix_cmf_asset_local_links_left_id'), table_name='cmf_asset_local_links') op.drop_table('cmf_asset_local_links') op.drop_index(op.f('ix_cmf_asset_executors_root_id'), table_name='cmf_asset_executors') op.drop_index(op.f('ix_cmf_asset_executors_right_id'), table_name='cmf_asset_executors') op.drop_index(op.f('ix_cmf_asset_executors_parent_id'), table_name='cmf_asset_executors') op.drop_index(op.f('ix_cmf_asset_executors_left_id'), table_name='cmf_asset_executors') op.drop_table('cmf_asset_executors') op.drop_index(op.f('ix_cmf_asset_cmf_owner_assistants_root_id'), table_name='cmf_asset_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_asset_cmf_owner_assistants_right_id'), table_name='cmf_asset_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_asset_cmf_owner_assistants_parent_id'), table_name='cmf_asset_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_asset_cmf_owner_assistants_left_id'), table_name='cmf_asset_cmf_owner_assistants') op.drop_table('cmf_asset_cmf_owner_assistants') op.drop_index(op.f('ix_cmf_asset_cmf_asset_type_root_id'), table_name='cmf_asset_cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_cmf_asset_type_right_id'), table_name='cmf_asset_cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_cmf_asset_type_parent_id'), table_name='cmf_asset_cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_cmf_asset_type_left_id'), table_name='cmf_asset_cmf_asset_type') op.drop_table('cmf_asset_cmf_asset_type') op.drop_index(op.f('ix_cmf_asset_cat_role_user_root_id'), table_name='cmf_asset_cat_role_user') op.drop_index(op.f('ix_cmf_asset_cat_role_user_right_id'), table_name='cmf_asset_cat_role_user') op.drop_index(op.f('ix_cmf_asset_cat_role_user_parent_id'), table_name='cmf_asset_cat_role_user') op.drop_index(op.f('ix_cmf_asset_cat_role_user_left_id'), table_name='cmf_asset_cat_role_user') op.drop_table('cmf_asset_cat_role_user') op.drop_index(op.f('ix_cmf_asset_cat_role_manager_root_id'), table_name='cmf_asset_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_cat_role_manager_right_id'), table_name='cmf_asset_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_cat_role_manager_parent_id'), table_name='cmf_asset_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_cat_role_manager_left_id'), table_name='cmf_asset_cat_role_manager') op.drop_table('cmf_asset_cat_role_manager') op.drop_index(op.f('ix_cmf_asset_cat_role_developer_root_id'), table_name='cmf_asset_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_cat_role_developer_right_id'), table_name='cmf_asset_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_cat_role_developer_parent_id'), table_name='cmf_asset_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_cat_role_developer_left_id'), table_name='cmf_asset_cat_role_developer') op.drop_table('cmf_asset_cat_role_developer') op.drop_index(op.f('ix_cmf_asset_cat_tree_parent_id'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_parent_id'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_viewed_at'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_version'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_owner_id'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_modified_by_id'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_modified_at'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_locked_by_id'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_locked_at'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_deleted'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_created_at'), table_name='cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_cat_cmf_author_id'), table_name='cmf_asset_cat') op.drop_table('cmf_asset_cat') op.drop_index(op.f('ix_cmf_asset_workflow_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_waiting_for_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_tree_parent_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_status_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_scheme_wf_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_root_parent_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_responsible_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_perm_security_level_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_perm_parent_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_perm_acl_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_parent_logic_prefix'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_parent_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_orderno'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_name'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_logic_type_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_logic_prefix'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_location_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_is_template'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_included_in_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_default_task_workflow_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_company_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_code'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_viewed_at'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_version'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_owner_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_owner_assistant_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_modified_by_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_modified_at'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_locked_by_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_locked_at'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_import_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_deleted'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_created_at'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cmf_author_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cloned_from_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cache_status_type'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_cache_status_opt_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_asset_cat_id'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_approved'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_alarm_date'), table_name='cmf_asset') op.drop_index(op.f('ix_cmf_asset_activity_id'), table_name='cmf_asset') op.drop_table('cmf_asset') # ### end Alembic commands ###