"""new permisions iter 3 Revision ID: ff93e481ed54 Revises: 70fd05adf739 Create Date: 2022-07-05 00:04:15.420878 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = 'ff93e481ed54' down_revision = '70fd05adf739' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_access_list', 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('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_policy', sa.String(length=32), server_default='default', nullable=True), sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True), sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True), sa.Column('perm_effective_acl_scope', sa.String(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('disabled', sa.Boolean(), nullable=True), sa.Column('scope', sa.String(length=64), nullable=False), sa.Column('next_acl_scope', sa.String(length=64), nullable=True), sa.Column('policy', sa.String(length=64), 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('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_inherit_obj_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('object_owner_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.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_access_list_cmf_author_id'), 'cmf_access_list', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_created_at'), 'cmf_access_list', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_deleted'), 'cmf_access_list', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_import_id'), 'cmf_access_list', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_locked_at'), 'cmf_access_list', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_locked_by_id'), 'cmf_access_list', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_modified_at'), 'cmf_access_list', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_modified_by_id'), 'cmf_access_list', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_owner_assistant_id'), 'cmf_access_list', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_owner_id'), 'cmf_access_list', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_version'), 'cmf_access_list', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_access_list_cmf_viewed_at'), 'cmf_access_list', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_access_list_code'), 'cmf_access_list', ['code'], unique=True) op.create_index(op.f('ix_cmf_access_list_name'), 'cmf_access_list', ['name'], unique=False) op.create_index(op.f('ix_cmf_access_list_object_owner_id'), 'cmf_access_list', ['object_owner_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_orderno'), 'cmf_access_list', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_access_list_parent_id'), 'cmf_access_list', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_perm_acl_id'), 'cmf_access_list', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_perm_inherit_obj_id'), 'cmf_access_list', ['perm_inherit_obj_id'], unique=False) op.create_index(op.f('ix_cmf_access_list_tree_parent_id'), 'cmf_access_list', ['tree_parent_id'], unique=False) op.create_table('cmf_access_rule', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('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_policy', sa.String(length=32), server_default='default', nullable=True), sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True), sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True), sa.Column('perm_effective_acl_scope', sa.String(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('disabled', sa.Boolean(), nullable=True), sa.Column('sys_type', sa.String(), nullable=True), sa.Column('object_models', sa.TEXT(), nullable=True), sa.Column('object_fields', sa.TEXT(), nullable=True), sa.Column('access_level', 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_inherit_obj_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_access_list.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_access_rule_cmf_author_id'), 'cmf_access_rule', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_created_at'), 'cmf_access_rule', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_deleted'), 'cmf_access_rule', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_import_id'), 'cmf_access_rule', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_locked_at'), 'cmf_access_rule', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_locked_by_id'), 'cmf_access_rule', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_modified_at'), 'cmf_access_rule', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_modified_by_id'), 'cmf_access_rule', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_owner_assistant_id'), 'cmf_access_rule', ['cmf_owner_assistant_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_owner_id'), 'cmf_access_rule', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_version'), 'cmf_access_rule', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_access_rule_cmf_viewed_at'), 'cmf_access_rule', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_access_rule_code'), 'cmf_access_rule', ['code'], unique=True) op.create_index(op.f('ix_cmf_access_rule_name'), 'cmf_access_rule', ['name'], unique=False) op.create_index(op.f('ix_cmf_access_rule_orderno'), 'cmf_access_rule', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_access_rule_parent_id'), 'cmf_access_rule', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_perm_acl_id'), 'cmf_access_rule', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_perm_inherit_obj_id'), 'cmf_access_rule', ['perm_inherit_obj_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_tree_parent_id'), 'cmf_access_rule', ['tree_parent_id'], unique=False) op.create_table('cmf_access_rule_subjects', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_access_rule_subjects_left_id'), 'cmf_access_rule_subjects', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_subjects_parent_id'), 'cmf_access_rule_subjects', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_subjects_right_id'), 'cmf_access_rule_subjects', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_access_rule_subjects_root_id'), 'cmf_access_rule_subjects', ['root_id'], unique=False) op.add_column('cmf_active_entity_filter', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_active_entity_filter_perm_acl_id'), 'cmf_active_entity_filter', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_active_entity_filter_perm_inherit_obj_id'), 'cmf_active_entity_filter', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_active_entity_filter', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_active_entity_filter', 'perm_private') op.drop_column('cmf_active_entity_filter', 'perm_id') op.drop_column('cmf_active_entity_filter', 'perm_readonly') op.drop_column('cmf_active_entity_filter', 'perm_field') op.add_column('cmf_activity', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_activity', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_activity', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_activity_perm_acl_id'), 'cmf_activity', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_activity_perm_inherit_obj_id'), 'cmf_activity', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_activity', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_activity', 'perm_private') op.drop_column('cmf_activity', 'perm_id') op.drop_column('cmf_activity', 'perm_readonly') op.drop_column('cmf_activity', 'perm_field') op.add_column('cmf_attachment', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_attachment_perm_acl_id'), 'cmf_attachment', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_attachment_perm_inherit_obj_id'), 'cmf_attachment', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_attachment', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_attachment', 'perm_private') op.drop_column('cmf_attachment', 'perm_id') op.drop_column('cmf_attachment', 'perm_readonly') op.drop_column('cmf_attachment', 'perm_field') op.add_column('cmf_balance', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_balance', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_balance', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_balance_perm_acl_id'), 'cmf_balance', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_balance_perm_inherit_obj_id'), 'cmf_balance', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_balance', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_balance', 'perm_private') op.drop_column('cmf_balance', 'perm_id') op.drop_column('cmf_balance', 'perm_readonly') op.drop_column('cmf_balance', 'perm_field') op.add_column('cmf_balance_operation', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_balance_operation_perm_acl_id'), 'cmf_balance_operation', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_balance_operation_perm_inherit_obj_id'), 'cmf_balance_operation', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_balance_operation', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_balance_operation', 'perm_private') op.drop_column('cmf_balance_operation', 'perm_id') op.drop_column('cmf_balance_operation', 'perm_readonly') op.drop_column('cmf_balance_operation', 'perm_field') op.add_column('cmf_card', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_card', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_card', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_card', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_card', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_card_perm_acl_id'), 'cmf_card', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_card_perm_inherit_obj_id'), 'cmf_card', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_card', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_card', 'perm_private') op.drop_column('cmf_card', 'perm_id') op.drop_column('cmf_card', 'perm_readonly') op.drop_column('cmf_card', 'perm_field') op.add_column('cmf_chat_group', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_chat_group_perm_acl_id'), 'cmf_chat_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_chat_group_perm_inherit_obj_id'), 'cmf_chat_group', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_group', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_chat_group', 'perm_id') op.drop_column('cmf_chat_group', 'perm_field') op.add_column('cmf_chat_message', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_chat_message_perm_acl_id'), 'cmf_chat_message', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_chat_message_perm_inherit_obj_id'), 'cmf_chat_message', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_message', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_chat_message', 'perm_private') op.drop_column('cmf_chat_message', 'perm_id') op.drop_column('cmf_chat_message', 'perm_readonly') op.drop_column('cmf_chat_message', 'perm_field') op.add_column('cmf_chat_topic', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_chat_topic_perm_acl_id'), 'cmf_chat_topic', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_chat_topic_perm_inherit_obj_id'), 'cmf_chat_topic', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_chat_topic', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_chat_topic', 'perm_id') op.drop_column('cmf_chat_topic', 'perm_field') op.add_column('cmf_comment', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_comment', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_comment', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_comment_perm_acl_id'), 'cmf_comment', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_comment_perm_inherit_obj_id'), 'cmf_comment', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_comment', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_comment', 'perm_private') op.drop_column('cmf_comment', 'perm_id') op.drop_column('cmf_comment', 'perm_readonly') op.drop_column('cmf_comment', 'perm_field') op.add_column('cmf_company', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_company', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_company', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_company', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_company', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_company', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_company_perm_acl_id'), 'cmf_company', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_company_perm_inherit_obj_id'), 'cmf_company', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_company', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_company', 'perm_id') op.drop_column('cmf_company', 'perm_field') op.add_column('cmf_contract', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_contract', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_contract', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_contract_perm_acl_id'), 'cmf_contract', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_contract_perm_inherit_obj_id'), 'cmf_contract', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_contract', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_contract', 'perm_private') op.drop_column('cmf_contract', 'perm_id') op.drop_column('cmf_contract', 'perm_readonly') op.drop_column('cmf_contract', 'perm_field') op.add_column('cmf_currency', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_currency', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_currency', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_currency_perm_acl_id'), 'cmf_currency', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_currency_perm_inherit_obj_id'), 'cmf_currency', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_currency', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_currency', 'perm_private') op.drop_column('cmf_currency', 'perm_id') op.drop_column('cmf_currency', 'perm_readonly') op.drop_column('cmf_currency', 'perm_field') op.add_column('cmf_deal', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_deal', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_deal', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_deal_perm_acl_id'), 'cmf_deal', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_deal_perm_inherit_obj_id'), 'cmf_deal', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_deal', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_deal', 'perm_id') op.drop_column('cmf_deal', 'perm_field') op.add_column('cmf_deal_items', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_deal_items_perm_acl_id'), 'cmf_deal_items', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_deal_items_perm_inherit_obj_id'), 'cmf_deal_items', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_deal_items', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_deal_items', 'perm_private') op.drop_column('cmf_deal_items', 'perm_id') op.drop_column('cmf_deal_items', 'perm_readonly') op.drop_column('cmf_deal_items', 'perm_field') op.add_column('cmf_document', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_document', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_document', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_document', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_document', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_document', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_document_perm_acl_id'), 'cmf_document', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_document_perm_inherit_obj_id'), 'cmf_document', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_document', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_document', 'perm_id') op.drop_column('cmf_document', 'perm_field') op.add_column('cmf_document_history', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_document_history_perm_acl_id'), 'cmf_document_history', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_document_history_perm_inherit_obj_id'), 'cmf_document_history', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_document_history', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_document_history', 'perm_private') op.drop_column('cmf_document_history', 'perm_id') op.drop_column('cmf_document_history', 'perm_readonly') op.drop_column('cmf_document_history', 'perm_field') op.add_column('cmf_filter', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_filter', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_filter', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_filter_perm_acl_id'), 'cmf_filter', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_filter_perm_inherit_obj_id'), 'cmf_filter', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_filter', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_filter', 'perm_private') op.drop_column('cmf_filter', 'perm_id') op.drop_column('cmf_filter', 'perm_readonly') op.drop_column('cmf_filter', 'perm_field') op.add_column('cmf_folder', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_folder', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_folder', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_folder_perm_acl_id'), 'cmf_folder', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_folder_perm_inherit_obj_id'), 'cmf_folder', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_folder', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_folder', 'perm_private') op.drop_column('cmf_folder', 'perm_id') op.drop_column('cmf_folder', 'perm_readonly') op.drop_column('cmf_folder', 'perm_field') op.add_column('cmf_form', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_form', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_form', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_form', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_form', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_form_perm_acl_id'), 'cmf_form', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_form_perm_inherit_obj_id'), 'cmf_form', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_form', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_form', 'perm_private') op.drop_column('cmf_form', 'perm_id') op.drop_column('cmf_form', 'perm_readonly') op.drop_column('cmf_form', 'perm_field') op.add_column('cmf_form_field', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_form_field_perm_acl_id'), 'cmf_form_field', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_form_field_perm_inherit_obj_id'), 'cmf_form_field', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_form_field', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_form_field', 'perm_private') op.drop_column('cmf_form_field', 'perm_id') op.drop_column('cmf_form_field', 'perm_readonly') op.drop_column('cmf_form_field', 'perm_field') op.add_column('cmf_import', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_import', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_import', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_import', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_import', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_import', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_import_perm_acl_id'), 'cmf_import', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_import_perm_inherit_obj_id'), 'cmf_import', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_import', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_import', 'perm_id') op.drop_column('cmf_import', 'perm_field') op.add_column('cmf_integration', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_integration', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_integration', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_integration_perm_acl_id'), 'cmf_integration', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_integration_perm_inherit_obj_id'), 'cmf_integration', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_integration', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_integration', 'perm_private') op.drop_column('cmf_integration', 'perm_id') op.drop_column('cmf_integration', 'perm_readonly') op.drop_column('cmf_integration', 'perm_field') op.add_column('cmf_invoice', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_invoice_perm_acl_id'), 'cmf_invoice', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_invoice_perm_inherit_obj_id'), 'cmf_invoice', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_invoice', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_invoice', 'perm_id') op.drop_column('cmf_invoice', 'perm_field') op.add_column('cmf_invoice_items', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_invoice_items_perm_acl_id'), 'cmf_invoice_items', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_invoice_items_perm_inherit_obj_id'), 'cmf_invoice_items', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_invoice_items', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_invoice_items', 'perm_private') op.drop_column('cmf_invoice_items', 'perm_id') op.drop_column('cmf_invoice_items', 'perm_readonly') op.drop_column('cmf_invoice_items', 'perm_field') op.add_column('cmf_job', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_job', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_job', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_job', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_job', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_job_perm_acl_id'), 'cmf_job', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_job_perm_inherit_obj_id'), 'cmf_job', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_job', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_job', 'perm_private') op.drop_column('cmf_job', 'perm_id') op.drop_column('cmf_job', 'perm_readonly') op.drop_column('cmf_job', 'perm_field') op.add_column('cmf_lead', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_lead', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_lead', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_lead_perm_acl_id'), 'cmf_lead', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_lead_perm_inherit_obj_id'), 'cmf_lead', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_lead', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_lead', 'perm_id') op.drop_column('cmf_lead', 'perm_field') op.add_column('cmf_lead_mailbox', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_lead_mailbox_perm_acl_id'), 'cmf_lead_mailbox', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_lead_mailbox_perm_inherit_obj_id'), 'cmf_lead_mailbox', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_lead_mailbox', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_lead_mailbox', 'perm_private') op.drop_column('cmf_lead_mailbox', 'perm_id') op.drop_column('cmf_lead_mailbox', 'perm_readonly') op.drop_column('cmf_lead_mailbox', 'perm_field') op.add_column('cmf_link', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_link', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_link', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_link', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_link', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_link_perm_acl_id'), 'cmf_link', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_link_perm_inherit_obj_id'), 'cmf_link', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_link', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_link', 'perm_private') op.drop_column('cmf_link', 'perm_id') op.drop_column('cmf_link', 'perm_readonly') op.drop_column('cmf_link', 'perm_field') op.add_column('cmf_list', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_list', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_list', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_list', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_list', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_list', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_list_perm_acl_id'), 'cmf_list', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_list_perm_inherit_obj_id'), 'cmf_list', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_list', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_list', 'perm_id') op.drop_column('cmf_list', 'perm_field') op.add_column('cmf_mail', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_mail', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_perm_acl_id'), 'cmf_mail', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_mail_perm_inherit_obj_id'), 'cmf_mail', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_mail', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_mail', 'perm_id') op.drop_column('cmf_mail', 'perm_field') op.add_column('cmf_mail_signature', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_signature_perm_acl_id'), 'cmf_mail_signature', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_mail_signature_perm_inherit_obj_id'), 'cmf_mail_signature', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_mail_signature', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_mail_signature', 'perm_private') op.drop_column('cmf_mail_signature', 'perm_id') op.drop_column('cmf_mail_signature', 'perm_readonly') op.drop_column('cmf_mail_signature', 'perm_field') op.add_column('cmf_mail_template', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mail_template_perm_acl_id'), 'cmf_mail_template', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_mail_template_perm_inherit_obj_id'), 'cmf_mail_template', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_mail_template', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_mail_template', 'perm_private') op.drop_column('cmf_mail_template', 'perm_id') op.drop_column('cmf_mail_template', 'perm_readonly') op.drop_column('cmf_mail_template', 'perm_field') op.add_column('cmf_mailbox', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_mailbox_perm_acl_id'), 'cmf_mailbox', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_mailbox_perm_inherit_obj_id'), 'cmf_mailbox', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_mailbox', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_mailbox', 'perm_private') op.drop_column('cmf_mailbox', 'perm_id') op.drop_column('cmf_mailbox', 'perm_readonly') op.drop_column('cmf_mailbox', 'perm_field') op.add_column('cmf_menu_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_item_perm_acl_id'), 'cmf_menu_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_menu_item_perm_inherit_obj_id'), 'cmf_menu_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_menu_item', 'perm_private') op.drop_column('cmf_menu_item', 'perm_id') op.drop_column('cmf_menu_item', 'perm_readonly') op.drop_column('cmf_menu_item', 'perm_field') op.add_column('cmf_menu_tree', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_tree_perm_acl_id'), 'cmf_menu_tree', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_menu_tree_perm_inherit_obj_id'), 'cmf_menu_tree', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_tree', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_menu_tree', 'perm_private') op.drop_column('cmf_menu_tree', 'perm_id') op.drop_column('cmf_menu_tree', 'perm_readonly') op.drop_column('cmf_menu_tree', 'perm_field') op.add_column('cmf_menu_tree_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_menu_tree_item_perm_acl_id'), 'cmf_menu_tree_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_menu_tree_item_perm_inherit_obj_id'), 'cmf_menu_tree_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_menu_tree_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_menu_tree_item', 'perm_private') op.drop_column('cmf_menu_tree_item', 'perm_id') op.drop_column('cmf_menu_tree_item', 'perm_readonly') op.drop_column('cmf_menu_tree_item', 'perm_field') op.add_column('cmf_notify', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_notify', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_notify', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_notify_perm_acl_id'), 'cmf_notify', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_notify_perm_inherit_obj_id'), 'cmf_notify', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_notify', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_notify', 'perm_private') op.drop_column('cmf_notify', 'perm_id') op.drop_column('cmf_notify', 'perm_readonly') op.drop_column('cmf_notify', 'perm_field') op.add_column('cmf_org_unit', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_org_unit_perm_acl_id'), 'cmf_org_unit', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_org_unit_perm_inherit_obj_id'), 'cmf_org_unit', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_org_unit', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_org_unit', 'perm_private') op.drop_column('cmf_org_unit', 'perm_id') op.drop_column('cmf_org_unit', 'perm_readonly') op.drop_column('cmf_org_unit', 'perm_field') op.add_column('cmf_payment', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_payment', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_payment', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_payment_perm_acl_id'), 'cmf_payment', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_payment_perm_inherit_obj_id'), 'cmf_payment', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_payment', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_payment', 'perm_id') op.drop_column('cmf_payment', 'perm_field') op.add_column('cmf_person', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_person', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_person', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_perm_acl_id'), 'cmf_person', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_person_perm_inherit_obj_id'), 'cmf_person', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_person', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_person', 'perm_private') op.drop_column('cmf_person', 'perm_id') op.drop_column('cmf_person', 'perm_readonly') op.drop_column('cmf_person', 'perm_field') op.add_column('cmf_person_group', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_group_perm_acl_id'), 'cmf_person_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_person_group_perm_inherit_obj_id'), 'cmf_person_group', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_person_group', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_person_group', 'perm_private') op.drop_column('cmf_person_group', 'perm_id') op.drop_column('cmf_person_group', 'perm_readonly') op.drop_column('cmf_person_group', 'perm_field') op.add_column('cmf_person_var', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_person_var_perm_acl_id'), 'cmf_person_var', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_person_var_perm_inherit_obj_id'), 'cmf_person_var', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_person_var', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_person_var', 'perm_private') op.drop_column('cmf_person_var', 'perm_id') op.drop_column('cmf_person_var', 'perm_readonly') op.drop_column('cmf_person_var', 'perm_field') op.add_column('cmf_pipeline', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_pipeline_perm_acl_id'), 'cmf_pipeline', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_pipeline_perm_inherit_obj_id'), 'cmf_pipeline', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_pipeline', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_pipeline', 'perm_id') op.drop_column('cmf_pipeline', 'perm_field') op.add_column('cmf_plan', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plan', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plan', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plan_perm_acl_id'), 'cmf_plan', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plan_perm_inherit_obj_id'), 'cmf_plan', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plan', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plan', 'perm_private') op.drop_column('cmf_plan', 'perm_id') op.drop_column('cmf_plan', 'perm_readonly') op.drop_column('cmf_plan', 'perm_field') op.add_column('cmf_plugin', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_perm_acl_id'), 'cmf_plugin', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_perm_inherit_obj_id'), 'cmf_plugin', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin', 'perm_private') op.drop_column('cmf_plugin', 'perm_id') op.drop_column('cmf_plugin', 'perm_readonly') op.drop_column('cmf_plugin', 'perm_field') op.add_column('cmf_plugin_asana', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_asana_perm_acl_id'), 'cmf_plugin_asana', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_asana_perm_inherit_obj_id'), 'cmf_plugin_asana', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_asana', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_asana', 'perm_private') op.drop_column('cmf_plugin_asana', 'perm_id') op.drop_column('cmf_plugin_asana', 'perm_readonly') op.drop_column('cmf_plugin_asana', 'perm_field') op.add_column('cmf_plugin_confluence', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_confluence_perm_acl_id'), 'cmf_plugin_confluence', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_confluence_perm_inherit_obj_id'), 'cmf_plugin_confluence', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_confluence', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_confluence', 'perm_private') op.drop_column('cmf_plugin_confluence', 'perm_id') op.drop_column('cmf_plugin_confluence', 'perm_readonly') op.drop_column('cmf_plugin_confluence', 'perm_field') op.add_column('cmf_plugin_jira', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_jira_perm_acl_id'), 'cmf_plugin_jira', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_jira_perm_inherit_obj_id'), 'cmf_plugin_jira', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_jira', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_jira', 'perm_private') op.drop_column('cmf_plugin_jira', 'perm_id') op.drop_column('cmf_plugin_jira', 'perm_readonly') op.drop_column('cmf_plugin_jira', 'perm_field') op.add_column('cmf_plugin_mail_box', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_mail_box_perm_acl_id'), 'cmf_plugin_mail_box', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_mail_box_perm_inherit_obj_id'), 'cmf_plugin_mail_box', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_mail_box', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_mail_box', 'perm_private') op.drop_column('cmf_plugin_mail_box', 'perm_id') op.drop_column('cmf_plugin_mail_box', 'perm_readonly') op.drop_column('cmf_plugin_mail_box', 'perm_field') op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_s_m_s_gate_perm_acl_id'), 'cmf_plugin_s_m_s_gate', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_s_m_s_gate_perm_inherit_obj_id'), 'cmf_plugin_s_m_s_gate', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_s_m_s_gate', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_s_m_s_gate', 'perm_private') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_id') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_readonly') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_field') op.add_column('cmf_plugin_telphin', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_telphin_perm_acl_id'), 'cmf_plugin_telphin', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_telphin_perm_inherit_obj_id'), 'cmf_plugin_telphin', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_telphin', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_telphin', 'perm_private') op.drop_column('cmf_plugin_telphin', 'perm_id') op.drop_column('cmf_plugin_telphin', 'perm_readonly') op.drop_column('cmf_plugin_telphin', 'perm_field') op.add_column('cmf_plugin_trello', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_trello_perm_acl_id'), 'cmf_plugin_trello', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_trello_perm_inherit_obj_id'), 'cmf_plugin_trello', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_trello', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_trello', 'perm_private') op.drop_column('cmf_plugin_trello', 'perm_id') op.drop_column('cmf_plugin_trello', 'perm_readonly') op.drop_column('cmf_plugin_trello', 'perm_field') op.add_column('cmf_plugin_zadarma', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_plugin_zadarma_perm_acl_id'), 'cmf_plugin_zadarma', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_plugin_zadarma_perm_inherit_obj_id'), 'cmf_plugin_zadarma', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_plugin_zadarma', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_plugin_zadarma', 'perm_private') op.drop_column('cmf_plugin_zadarma', 'perm_id') op.drop_column('cmf_plugin_zadarma', 'perm_readonly') op.drop_column('cmf_plugin_zadarma', 'perm_field') op.add_column('cmf_price', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_price', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_price', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_price', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_price', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_price_perm_acl_id'), 'cmf_price', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_price_perm_inherit_obj_id'), 'cmf_price', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_price', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_price', 'perm_private') op.drop_column('cmf_price', 'perm_id') op.drop_column('cmf_price', 'perm_readonly') op.drop_column('cmf_price', 'perm_field') op.add_column('cmf_print_tmpl', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_print_tmpl_perm_acl_id'), 'cmf_print_tmpl', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_print_tmpl_perm_inherit_obj_id'), 'cmf_print_tmpl', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_print_tmpl', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_print_tmpl', 'perm_private') op.drop_column('cmf_print_tmpl', 'perm_id') op.drop_column('cmf_print_tmpl', 'perm_readonly') op.drop_column('cmf_print_tmpl', 'perm_field') op.add_column('cmf_product', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_product', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_product', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_product', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_product', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_product_perm_acl_id'), 'cmf_product', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_product_perm_inherit_obj_id'), 'cmf_product', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_product', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_product', 'perm_private') op.drop_column('cmf_product', 'perm_id') op.drop_column('cmf_product', 'perm_readonly') op.drop_column('cmf_product', 'perm_field') op.add_column('cmf_project', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_project', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_project', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_project', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_project', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_project', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_project_perm_acl_id'), 'cmf_project', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_project_perm_inherit_obj_id'), 'cmf_project', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_project', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_project', 'perm_id') op.drop_column('cmf_project', 'perm_field') op.add_column('cmf_purchase_order', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_purchase_order_perm_acl_id'), 'cmf_purchase_order', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_perm_inherit_obj_id'), 'cmf_purchase_order', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_purchase_order', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_purchase_order', 'perm_id') op.drop_column('cmf_purchase_order', 'perm_field') op.add_column('cmf_purchase_order_items', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_purchase_order_items_perm_acl_id'), 'cmf_purchase_order_items', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_purchase_order_items_perm_inherit_obj_id'), 'cmf_purchase_order_items', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_purchase_order_items', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_purchase_order_items', 'perm_id') op.drop_column('cmf_purchase_order_items', 'perm_field') op.add_column('cmf_refbook', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_refbook_perm_acl_id'), 'cmf_refbook', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_refbook_perm_inherit_obj_id'), 'cmf_refbook', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_refbook', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_refbook', 'perm_private') op.drop_column('cmf_refbook', 'perm_id') op.drop_column('cmf_refbook', 'perm_readonly') op.drop_column('cmf_refbook', 'perm_field') op.add_column('cmf_roadmap', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_roadmap_perm_acl_id'), 'cmf_roadmap', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_roadmap_perm_inherit_obj_id'), 'cmf_roadmap', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_roadmap', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_roadmap', 'perm_id') op.drop_column('cmf_roadmap', 'perm_field') op.add_column('cmf_role', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_role', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_role', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_role', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_role', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_role_perm_acl_id'), 'cmf_role', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_role_perm_inherit_obj_id'), 'cmf_role', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_role', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_role', 'perm_private') op.drop_column('cmf_role', 'perm_id') op.drop_column('cmf_role', 'perm_readonly') op.drop_column('cmf_role', 'perm_field') op.add_column('cmf_sale_menu_group', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_sale_menu_group_perm_acl_id'), 'cmf_sale_menu_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_sale_menu_group_perm_inherit_obj_id'), 'cmf_sale_menu_group', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_sale_menu_group', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_sale_menu_group', 'perm_private') op.drop_column('cmf_sale_menu_group', 'perm_id') op.drop_column('cmf_sale_menu_group', 'perm_readonly') op.drop_column('cmf_sale_menu_group', 'perm_field') op.add_column('cmf_staff_control_settings', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_staff_control_settings_perm_acl_id'), 'cmf_staff_control_settings', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_staff_control_settings_perm_inherit_obj_id'), 'cmf_staff_control_settings', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_staff_control_settings', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_staff_control_settings', 'perm_private') op.drop_column('cmf_staff_control_settings', 'perm_id') op.drop_column('cmf_staff_control_settings', 'perm_readonly') op.drop_column('cmf_staff_control_settings', 'perm_field') op.add_column('cmf_status', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_status', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_status', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_status', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_perm_acl_id'), 'cmf_status', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_status_perm_inherit_obj_id'), 'cmf_status', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_status', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_status', 'perm_private') op.drop_column('cmf_status', 'perm_id') op.drop_column('cmf_status', 'perm_readonly') op.drop_column('cmf_status', 'perm_field') op.add_column('cmf_status_opt', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_opt_perm_acl_id'), 'cmf_status_opt', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_status_opt_perm_inherit_obj_id'), 'cmf_status_opt', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_status_opt', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_status_opt', 'perm_private') op.drop_column('cmf_status_opt', 'perm_id') op.drop_column('cmf_status_opt', 'perm_readonly') op.drop_column('cmf_status_opt', 'perm_field') op.add_column('cmf_stock', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_perm_acl_id'), 'cmf_stock', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_perm_inherit_obj_id'), 'cmf_stock', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock', 'perm_private') op.drop_column('cmf_stock', 'perm_id') op.drop_column('cmf_stock', 'perm_readonly') op.drop_column('cmf_stock', 'perm_field') op.add_column('cmf_stock_incoming_order', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_incoming_order_perm_acl_id'), 'cmf_stock_incoming_order', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_incoming_order_perm_inherit_obj_id'), 'cmf_stock_incoming_order', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_incoming_order', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_incoming_order', 'perm_id') op.drop_column('cmf_stock_incoming_order', 'perm_field') op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_incoming_order_item_perm_acl_id'), 'cmf_stock_incoming_order_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_incoming_order_item_perm_inherit_obj_id'), 'cmf_stock_incoming_order_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_incoming_order_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_incoming_order_item', 'perm_private') op.drop_column('cmf_stock_incoming_order_item', 'perm_id') op.drop_column('cmf_stock_incoming_order_item', 'perm_readonly') op.drop_column('cmf_stock_incoming_order_item', 'perm_field') op.add_column('cmf_stock_initial', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_initial_perm_acl_id'), 'cmf_stock_initial', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_initial_perm_inherit_obj_id'), 'cmf_stock_initial', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_initial', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_initial', 'perm_id') op.drop_column('cmf_stock_initial', 'perm_field') op.add_column('cmf_stock_initial_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_initial_item_perm_acl_id'), 'cmf_stock_initial_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_initial_item_perm_inherit_obj_id'), 'cmf_stock_initial_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_initial_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_initial_item', 'perm_private') op.drop_column('cmf_stock_initial_item', 'perm_id') op.drop_column('cmf_stock_initial_item', 'perm_readonly') op.drop_column('cmf_stock_initial_item', 'perm_field') op.add_column('cmf_stock_inventory', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_inventory_perm_acl_id'), 'cmf_stock_inventory', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_inventory_perm_inherit_obj_id'), 'cmf_stock_inventory', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_inventory', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_inventory', 'perm_id') op.drop_column('cmf_stock_inventory', 'perm_field') op.add_column('cmf_stock_inventory_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_inventory_item_perm_acl_id'), 'cmf_stock_inventory_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_inventory_item_perm_inherit_obj_id'), 'cmf_stock_inventory_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_inventory_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_inventory_item', 'perm_private') op.drop_column('cmf_stock_inventory_item', 'perm_id') op.drop_column('cmf_stock_inventory_item', 'perm_readonly') op.drop_column('cmf_stock_inventory_item', 'perm_field') op.add_column('cmf_stock_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_item_perm_acl_id'), 'cmf_stock_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_item_perm_inherit_obj_id'), 'cmf_stock_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_item', 'perm_private') op.drop_column('cmf_stock_item', 'perm_id') op.drop_column('cmf_stock_item', 'perm_readonly') op.drop_column('cmf_stock_item', 'perm_field') op.add_column('cmf_stock_menu_group', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_menu_group_perm_acl_id'), 'cmf_stock_menu_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_menu_group_perm_inherit_obj_id'), 'cmf_stock_menu_group', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_menu_group', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_menu_group', 'perm_private') op.drop_column('cmf_stock_menu_group', 'perm_id') op.drop_column('cmf_stock_menu_group', 'perm_readonly') op.drop_column('cmf_stock_menu_group', 'perm_field') op.add_column('cmf_stock_move', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_move_perm_acl_id'), 'cmf_stock_move', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_move_perm_inherit_obj_id'), 'cmf_stock_move', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_move', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_move', 'perm_id') op.drop_column('cmf_stock_move', 'perm_field') op.add_column('cmf_stock_move_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_move_item_perm_acl_id'), 'cmf_stock_move_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_move_item_perm_inherit_obj_id'), 'cmf_stock_move_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_move_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_move_item', 'perm_private') op.drop_column('cmf_stock_move_item', 'perm_id') op.drop_column('cmf_stock_move_item', 'perm_readonly') op.drop_column('cmf_stock_move_item', 'perm_field') op.add_column('cmf_stock_operation', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_operation_perm_acl_id'), 'cmf_stock_operation', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_operation_perm_inherit_obj_id'), 'cmf_stock_operation', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_operation', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_operation', 'perm_private') op.drop_column('cmf_stock_operation', 'perm_id') op.drop_column('cmf_stock_operation', 'perm_readonly') op.drop_column('cmf_stock_operation', 'perm_field') op.add_column('cmf_stock_operation_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_operation_item_perm_acl_id'), 'cmf_stock_operation_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_operation_item_perm_inherit_obj_id'), 'cmf_stock_operation_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_operation_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_operation_item', 'perm_private') op.drop_column('cmf_stock_operation_item', 'perm_id') op.drop_column('cmf_stock_operation_item', 'perm_readonly') op.drop_column('cmf_stock_operation_item', 'perm_field') op.add_column('cmf_stock_outcoming_order', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_outcoming_order_perm_acl_id'), 'cmf_stock_outcoming_order', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_outcoming_order_perm_inherit_obj_id'), 'cmf_stock_outcoming_order', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_outcoming_order', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_outcoming_order', 'perm_id') op.drop_column('cmf_stock_outcoming_order', 'perm_field') op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_stock_outcoming_order_item_perm_acl_id'), 'cmf_stock_outcoming_order_item', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_stock_outcoming_order_item_perm_inherit_obj_id'), 'cmf_stock_outcoming_order_item', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_stock_outcoming_order_item', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_stock_outcoming_order_item', 'perm_private') op.drop_column('cmf_stock_outcoming_order_item', 'perm_id') op.drop_column('cmf_stock_outcoming_order_item', 'perm_readonly') op.drop_column('cmf_stock_outcoming_order_item', 'perm_field') op.add_column('cmf_subscription', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_subscription_perm_acl_id'), 'cmf_subscription', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_subscription_perm_inherit_obj_id'), 'cmf_subscription', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_subscription', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_subscription', 'perm_private') op.drop_column('cmf_subscription', 'perm_id') op.drop_column('cmf_subscription', 'perm_readonly') op.drop_column('cmf_subscription', 'perm_field') op.add_column('cmf_tag', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_tag', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_tag', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_tag_perm_acl_id'), 'cmf_tag', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_tag_perm_inherit_obj_id'), 'cmf_tag', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_tag', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_tag', 'perm_private') op.drop_column('cmf_tag', 'perm_id') op.drop_column('cmf_tag', 'perm_readonly') op.drop_column('cmf_tag', 'perm_field') op.add_column('cmf_tag_category', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_tag_category_perm_acl_id'), 'cmf_tag_category', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_tag_category_perm_inherit_obj_id'), 'cmf_tag_category', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_tag_category', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_tag_category', 'perm_private') op.drop_column('cmf_tag_category', 'perm_id') op.drop_column('cmf_tag_category', 'perm_readonly') op.drop_column('cmf_tag_category', 'perm_field') op.add_column('cmf_task', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_task', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_task', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_task', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_task', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_task', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_task_perm_acl_id'), 'cmf_task', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_task_perm_inherit_obj_id'), 'cmf_task', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_task', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_task', 'perm_id') op.drop_column('cmf_task', 'perm_field') op.add_column('cmf_trigger', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_trigger_perm_acl_id'), 'cmf_trigger', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_trigger_perm_inherit_obj_id'), 'cmf_trigger', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_trigger', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_trigger', 'perm_private') op.drop_column('cmf_trigger', 'perm_id') op.drop_column('cmf_trigger', 'perm_readonly') op.drop_column('cmf_trigger', 'perm_field') op.add_column('cmf_u_work_post', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_u_work_post_perm_acl_id'), 'cmf_u_work_post', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_u_work_post_perm_inherit_obj_id'), 'cmf_u_work_post', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_u_work_post', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_u_work_post', 'perm_id') op.drop_column('cmf_u_work_post', 'perm_field') op.add_column('cmf_unit', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_unit', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_unit', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_unit_perm_acl_id'), 'cmf_unit', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_unit_perm_inherit_obj_id'), 'cmf_unit', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_unit', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_unit', 'perm_private') op.drop_column('cmf_unit', 'perm_id') op.drop_column('cmf_unit', 'perm_readonly') op.drop_column('cmf_unit', 'perm_field') op.add_column('cmf_whatsapp', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_whatsapp_perm_acl_id'), 'cmf_whatsapp', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_whatsapp_perm_inherit_obj_id'), 'cmf_whatsapp', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_whatsapp', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_whatsapp', 'perm_private') op.drop_column('cmf_whatsapp', 'perm_id') op.drop_column('cmf_whatsapp', 'perm_readonly') op.drop_column('cmf_whatsapp', 'perm_field') op.add_column('cmf_wiki', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_wiki_perm_acl_id'), 'cmf_wiki', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_wiki_perm_inherit_obj_id'), 'cmf_wiki', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_wiki', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_wiki', 'perm_private') op.drop_column('cmf_wiki', 'perm_id') op.drop_column('cmf_wiki', 'perm_readonly') op.drop_column('cmf_wiki', 'perm_field') op.add_column('cmf_workflow', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_workflow_perm_acl_id'), 'cmf_workflow', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_workflow_perm_inherit_obj_id'), 'cmf_workflow', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_workflow', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_workflow', 'perm_private') op.drop_column('cmf_workflow', 'perm_id') op.drop_column('cmf_workflow', 'perm_readonly') op.drop_column('cmf_workflow', 'perm_field') op.add_column('cmf_workflow_type', sa.Column('perm_policy', sa.String(length=32), server_default='default', nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_inherit', sa.Boolean(), server_default=sa.text('true'), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_inherit_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_effective_acl_scope', sa.String(), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_inherit_obj_id', sa.String(length=64), nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_acl_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_workflow_type_perm_acl_id'), 'cmf_workflow_type', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_workflow_type_perm_inherit_obj_id'), 'cmf_workflow_type', ['perm_inherit_obj_id'], unique=False) op.create_foreign_key(None, 'cmf_workflow_type', 'cmf_access_list', ['perm_acl_id'], ['id']) op.drop_column('cmf_workflow_type', 'perm_private') op.drop_column('cmf_workflow_type', 'perm_id') op.drop_column('cmf_workflow_type', 'perm_readonly') op.drop_column('cmf_workflow_type', 'perm_field') # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('cmf_workflow_type', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_workflow_type', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_workflow_type', type_='foreignkey') op.drop_index(op.f('ix_cmf_workflow_type_perm_inherit_obj_id'), table_name='cmf_workflow_type') op.drop_index(op.f('ix_cmf_workflow_type_perm_acl_id'), table_name='cmf_workflow_type') op.drop_column('cmf_workflow_type', 'perm_acl_id') op.drop_column('cmf_workflow_type', 'perm_inherit_obj_id') op.drop_column('cmf_workflow_type', 'perm_effective_acl_scope') op.drop_column('cmf_workflow_type', 'perm_inherit_acl_scope') op.drop_column('cmf_workflow_type', 'perm_inherit') op.drop_column('cmf_workflow_type', 'perm_policy') op.add_column('cmf_workflow', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_workflow', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_workflow', type_='foreignkey') op.drop_index(op.f('ix_cmf_workflow_perm_inherit_obj_id'), table_name='cmf_workflow') op.drop_index(op.f('ix_cmf_workflow_perm_acl_id'), table_name='cmf_workflow') op.drop_column('cmf_workflow', 'perm_acl_id') op.drop_column('cmf_workflow', 'perm_inherit_obj_id') op.drop_column('cmf_workflow', 'perm_effective_acl_scope') op.drop_column('cmf_workflow', 'perm_inherit_acl_scope') op.drop_column('cmf_workflow', 'perm_inherit') op.drop_column('cmf_workflow', 'perm_policy') op.add_column('cmf_wiki', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_wiki', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_wiki', type_='foreignkey') op.drop_index(op.f('ix_cmf_wiki_perm_inherit_obj_id'), table_name='cmf_wiki') op.drop_index(op.f('ix_cmf_wiki_perm_acl_id'), table_name='cmf_wiki') op.drop_column('cmf_wiki', 'perm_acl_id') op.drop_column('cmf_wiki', 'perm_inherit_obj_id') op.drop_column('cmf_wiki', 'perm_effective_acl_scope') op.drop_column('cmf_wiki', 'perm_inherit_acl_scope') op.drop_column('cmf_wiki', 'perm_inherit') op.drop_column('cmf_wiki', 'perm_policy') op.add_column('cmf_whatsapp', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_whatsapp', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_whatsapp', type_='foreignkey') op.drop_index(op.f('ix_cmf_whatsapp_perm_inherit_obj_id'), table_name='cmf_whatsapp') op.drop_index(op.f('ix_cmf_whatsapp_perm_acl_id'), table_name='cmf_whatsapp') op.drop_column('cmf_whatsapp', 'perm_acl_id') op.drop_column('cmf_whatsapp', 'perm_inherit_obj_id') op.drop_column('cmf_whatsapp', 'perm_effective_acl_scope') op.drop_column('cmf_whatsapp', 'perm_inherit_acl_scope') op.drop_column('cmf_whatsapp', 'perm_inherit') op.drop_column('cmf_whatsapp', 'perm_policy') op.add_column('cmf_unit', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_unit', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_unit', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_unit', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_unit', type_='foreignkey') op.drop_index(op.f('ix_cmf_unit_perm_inherit_obj_id'), table_name='cmf_unit') op.drop_index(op.f('ix_cmf_unit_perm_acl_id'), table_name='cmf_unit') op.drop_column('cmf_unit', 'perm_acl_id') op.drop_column('cmf_unit', 'perm_inherit_obj_id') op.drop_column('cmf_unit', 'perm_effective_acl_scope') op.drop_column('cmf_unit', 'perm_inherit_acl_scope') op.drop_column('cmf_unit', 'perm_inherit') op.drop_column('cmf_unit', 'perm_policy') op.add_column('cmf_u_work_post', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_u_work_post', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_u_work_post', type_='foreignkey') op.drop_index(op.f('ix_cmf_u_work_post_perm_inherit_obj_id'), table_name='cmf_u_work_post') op.drop_index(op.f('ix_cmf_u_work_post_perm_acl_id'), table_name='cmf_u_work_post') op.drop_column('cmf_u_work_post', 'perm_acl_id') op.drop_column('cmf_u_work_post', 'perm_inherit_obj_id') op.drop_column('cmf_u_work_post', 'perm_effective_acl_scope') op.drop_column('cmf_u_work_post', 'perm_inherit_acl_scope') op.drop_column('cmf_u_work_post', 'perm_inherit') op.drop_column('cmf_u_work_post', 'perm_policy') op.add_column('cmf_trigger', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_trigger', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_trigger', type_='foreignkey') op.drop_index(op.f('ix_cmf_trigger_perm_inherit_obj_id'), table_name='cmf_trigger') op.drop_index(op.f('ix_cmf_trigger_perm_acl_id'), table_name='cmf_trigger') op.drop_column('cmf_trigger', 'perm_acl_id') op.drop_column('cmf_trigger', 'perm_inherit_obj_id') op.drop_column('cmf_trigger', 'perm_effective_acl_scope') op.drop_column('cmf_trigger', 'perm_inherit_acl_scope') op.drop_column('cmf_trigger', 'perm_inherit') op.drop_column('cmf_trigger', 'perm_policy') op.add_column('cmf_task', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_task', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_task', type_='foreignkey') op.drop_index(op.f('ix_cmf_task_perm_inherit_obj_id'), table_name='cmf_task') op.drop_index(op.f('ix_cmf_task_perm_acl_id'), table_name='cmf_task') op.drop_column('cmf_task', 'perm_acl_id') op.drop_column('cmf_task', 'perm_inherit_obj_id') op.drop_column('cmf_task', 'perm_effective_acl_scope') op.drop_column('cmf_task', 'perm_inherit_acl_scope') op.drop_column('cmf_task', 'perm_inherit') op.drop_column('cmf_task', 'perm_policy') op.add_column('cmf_tag_category', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_tag_category', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_tag_category', type_='foreignkey') op.drop_index(op.f('ix_cmf_tag_category_perm_inherit_obj_id'), table_name='cmf_tag_category') op.drop_index(op.f('ix_cmf_tag_category_perm_acl_id'), table_name='cmf_tag_category') op.drop_column('cmf_tag_category', 'perm_acl_id') op.drop_column('cmf_tag_category', 'perm_inherit_obj_id') op.drop_column('cmf_tag_category', 'perm_effective_acl_scope') op.drop_column('cmf_tag_category', 'perm_inherit_acl_scope') op.drop_column('cmf_tag_category', 'perm_inherit') op.drop_column('cmf_tag_category', 'perm_policy') op.add_column('cmf_tag', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_tag', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_tag', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_tag', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_tag', type_='foreignkey') op.drop_index(op.f('ix_cmf_tag_perm_inherit_obj_id'), table_name='cmf_tag') op.drop_index(op.f('ix_cmf_tag_perm_acl_id'), table_name='cmf_tag') op.drop_column('cmf_tag', 'perm_acl_id') op.drop_column('cmf_tag', 'perm_inherit_obj_id') op.drop_column('cmf_tag', 'perm_effective_acl_scope') op.drop_column('cmf_tag', 'perm_inherit_acl_scope') op.drop_column('cmf_tag', 'perm_inherit') op.drop_column('cmf_tag', 'perm_policy') op.add_column('cmf_subscription', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_subscription', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_subscription', type_='foreignkey') op.drop_index(op.f('ix_cmf_subscription_perm_inherit_obj_id'), table_name='cmf_subscription') op.drop_index(op.f('ix_cmf_subscription_perm_acl_id'), table_name='cmf_subscription') op.drop_column('cmf_subscription', 'perm_acl_id') op.drop_column('cmf_subscription', 'perm_inherit_obj_id') op.drop_column('cmf_subscription', 'perm_effective_acl_scope') op.drop_column('cmf_subscription', 'perm_inherit_acl_scope') op.drop_column('cmf_subscription', 'perm_inherit') op.drop_column('cmf_subscription', 'perm_policy') op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_outcoming_order_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_outcoming_order_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_outcoming_order_item_perm_inherit_obj_id'), table_name='cmf_stock_outcoming_order_item') op.drop_index(op.f('ix_cmf_stock_outcoming_order_item_perm_acl_id'), table_name='cmf_stock_outcoming_order_item') op.drop_column('cmf_stock_outcoming_order_item', 'perm_acl_id') op.drop_column('cmf_stock_outcoming_order_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_outcoming_order_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_outcoming_order_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_outcoming_order_item', 'perm_inherit') op.drop_column('cmf_stock_outcoming_order_item', 'perm_policy') op.add_column('cmf_stock_outcoming_order', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_outcoming_order', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_outcoming_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_outcoming_order_perm_inherit_obj_id'), table_name='cmf_stock_outcoming_order') op.drop_index(op.f('ix_cmf_stock_outcoming_order_perm_acl_id'), table_name='cmf_stock_outcoming_order') op.drop_column('cmf_stock_outcoming_order', 'perm_acl_id') op.drop_column('cmf_stock_outcoming_order', 'perm_inherit_obj_id') op.drop_column('cmf_stock_outcoming_order', 'perm_effective_acl_scope') op.drop_column('cmf_stock_outcoming_order', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_outcoming_order', 'perm_inherit') op.drop_column('cmf_stock_outcoming_order', 'perm_policy') op.add_column('cmf_stock_operation_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_operation_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_operation_item_perm_inherit_obj_id'), table_name='cmf_stock_operation_item') op.drop_index(op.f('ix_cmf_stock_operation_item_perm_acl_id'), table_name='cmf_stock_operation_item') op.drop_column('cmf_stock_operation_item', 'perm_acl_id') op.drop_column('cmf_stock_operation_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_operation_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_operation_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_operation_item', 'perm_inherit') op.drop_column('cmf_stock_operation_item', 'perm_policy') op.add_column('cmf_stock_operation', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_operation', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_operation', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_operation_perm_inherit_obj_id'), table_name='cmf_stock_operation') op.drop_index(op.f('ix_cmf_stock_operation_perm_acl_id'), table_name='cmf_stock_operation') op.drop_column('cmf_stock_operation', 'perm_acl_id') op.drop_column('cmf_stock_operation', 'perm_inherit_obj_id') op.drop_column('cmf_stock_operation', 'perm_effective_acl_scope') op.drop_column('cmf_stock_operation', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_operation', 'perm_inherit') op.drop_column('cmf_stock_operation', 'perm_policy') op.add_column('cmf_stock_move_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_move_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_move_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_move_item_perm_inherit_obj_id'), table_name='cmf_stock_move_item') op.drop_index(op.f('ix_cmf_stock_move_item_perm_acl_id'), table_name='cmf_stock_move_item') op.drop_column('cmf_stock_move_item', 'perm_acl_id') op.drop_column('cmf_stock_move_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_move_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_move_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_move_item', 'perm_inherit') op.drop_column('cmf_stock_move_item', 'perm_policy') op.add_column('cmf_stock_move', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_move', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_move', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_move_perm_inherit_obj_id'), table_name='cmf_stock_move') op.drop_index(op.f('ix_cmf_stock_move_perm_acl_id'), table_name='cmf_stock_move') op.drop_column('cmf_stock_move', 'perm_acl_id') op.drop_column('cmf_stock_move', 'perm_inherit_obj_id') op.drop_column('cmf_stock_move', 'perm_effective_acl_scope') op.drop_column('cmf_stock_move', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_move', 'perm_inherit') op.drop_column('cmf_stock_move', 'perm_policy') op.add_column('cmf_stock_menu_group', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_menu_group', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_menu_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_menu_group_perm_inherit_obj_id'), table_name='cmf_stock_menu_group') op.drop_index(op.f('ix_cmf_stock_menu_group_perm_acl_id'), table_name='cmf_stock_menu_group') op.drop_column('cmf_stock_menu_group', 'perm_acl_id') op.drop_column('cmf_stock_menu_group', 'perm_inherit_obj_id') op.drop_column('cmf_stock_menu_group', 'perm_effective_acl_scope') op.drop_column('cmf_stock_menu_group', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_menu_group', 'perm_inherit') op.drop_column('cmf_stock_menu_group', 'perm_policy') op.add_column('cmf_stock_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_item_perm_inherit_obj_id'), table_name='cmf_stock_item') op.drop_index(op.f('ix_cmf_stock_item_perm_acl_id'), table_name='cmf_stock_item') op.drop_column('cmf_stock_item', 'perm_acl_id') op.drop_column('cmf_stock_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_item', 'perm_inherit') op.drop_column('cmf_stock_item', 'perm_policy') op.add_column('cmf_stock_inventory_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_inventory_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_inventory_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_inventory_item_perm_inherit_obj_id'), table_name='cmf_stock_inventory_item') op.drop_index(op.f('ix_cmf_stock_inventory_item_perm_acl_id'), table_name='cmf_stock_inventory_item') op.drop_column('cmf_stock_inventory_item', 'perm_acl_id') op.drop_column('cmf_stock_inventory_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_inventory_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_inventory_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_inventory_item', 'perm_inherit') op.drop_column('cmf_stock_inventory_item', 'perm_policy') op.add_column('cmf_stock_inventory', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_inventory', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_inventory', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_inventory_perm_inherit_obj_id'), table_name='cmf_stock_inventory') op.drop_index(op.f('ix_cmf_stock_inventory_perm_acl_id'), table_name='cmf_stock_inventory') op.drop_column('cmf_stock_inventory', 'perm_acl_id') op.drop_column('cmf_stock_inventory', 'perm_inherit_obj_id') op.drop_column('cmf_stock_inventory', 'perm_effective_acl_scope') op.drop_column('cmf_stock_inventory', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_inventory', 'perm_inherit') op.drop_column('cmf_stock_inventory', 'perm_policy') op.add_column('cmf_stock_initial_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_initial_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_initial_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_initial_item_perm_inherit_obj_id'), table_name='cmf_stock_initial_item') op.drop_index(op.f('ix_cmf_stock_initial_item_perm_acl_id'), table_name='cmf_stock_initial_item') op.drop_column('cmf_stock_initial_item', 'perm_acl_id') op.drop_column('cmf_stock_initial_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_initial_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_initial_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_initial_item', 'perm_inherit') op.drop_column('cmf_stock_initial_item', 'perm_policy') op.add_column('cmf_stock_initial', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_initial', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_initial', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_initial_perm_inherit_obj_id'), table_name='cmf_stock_initial') op.drop_index(op.f('ix_cmf_stock_initial_perm_acl_id'), table_name='cmf_stock_initial') op.drop_column('cmf_stock_initial', 'perm_acl_id') op.drop_column('cmf_stock_initial', 'perm_inherit_obj_id') op.drop_column('cmf_stock_initial', 'perm_effective_acl_scope') op.drop_column('cmf_stock_initial', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_initial', 'perm_inherit') op.drop_column('cmf_stock_initial', 'perm_policy') op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock_incoming_order_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_incoming_order_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_incoming_order_item_perm_inherit_obj_id'), table_name='cmf_stock_incoming_order_item') op.drop_index(op.f('ix_cmf_stock_incoming_order_item_perm_acl_id'), table_name='cmf_stock_incoming_order_item') op.drop_column('cmf_stock_incoming_order_item', 'perm_acl_id') op.drop_column('cmf_stock_incoming_order_item', 'perm_inherit_obj_id') op.drop_column('cmf_stock_incoming_order_item', 'perm_effective_acl_scope') op.drop_column('cmf_stock_incoming_order_item', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_incoming_order_item', 'perm_inherit') op.drop_column('cmf_stock_incoming_order_item', 'perm_policy') op.add_column('cmf_stock_incoming_order', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock_incoming_order', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock_incoming_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_incoming_order_perm_inherit_obj_id'), table_name='cmf_stock_incoming_order') op.drop_index(op.f('ix_cmf_stock_incoming_order_perm_acl_id'), table_name='cmf_stock_incoming_order') op.drop_column('cmf_stock_incoming_order', 'perm_acl_id') op.drop_column('cmf_stock_incoming_order', 'perm_inherit_obj_id') op.drop_column('cmf_stock_incoming_order', 'perm_effective_acl_scope') op.drop_column('cmf_stock_incoming_order', 'perm_inherit_acl_scope') op.drop_column('cmf_stock_incoming_order', 'perm_inherit') op.drop_column('cmf_stock_incoming_order', 'perm_policy') op.add_column('cmf_stock', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_stock', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_stock', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_stock', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_stock', type_='foreignkey') op.drop_index(op.f('ix_cmf_stock_perm_inherit_obj_id'), table_name='cmf_stock') op.drop_index(op.f('ix_cmf_stock_perm_acl_id'), table_name='cmf_stock') op.drop_column('cmf_stock', 'perm_acl_id') op.drop_column('cmf_stock', 'perm_inherit_obj_id') op.drop_column('cmf_stock', 'perm_effective_acl_scope') op.drop_column('cmf_stock', 'perm_inherit_acl_scope') op.drop_column('cmf_stock', 'perm_inherit') op.drop_column('cmf_stock', 'perm_policy') op.add_column('cmf_status_opt', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_status_opt', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_status_opt', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_opt_perm_inherit_obj_id'), table_name='cmf_status_opt') op.drop_index(op.f('ix_cmf_status_opt_perm_acl_id'), table_name='cmf_status_opt') op.drop_column('cmf_status_opt', 'perm_acl_id') op.drop_column('cmf_status_opt', 'perm_inherit_obj_id') op.drop_column('cmf_status_opt', 'perm_effective_acl_scope') op.drop_column('cmf_status_opt', 'perm_inherit_acl_scope') op.drop_column('cmf_status_opt', 'perm_inherit') op.drop_column('cmf_status_opt', 'perm_policy') op.add_column('cmf_status', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_status', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_status', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_status', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_perm_inherit_obj_id'), table_name='cmf_status') op.drop_index(op.f('ix_cmf_status_perm_acl_id'), table_name='cmf_status') op.drop_column('cmf_status', 'perm_acl_id') op.drop_column('cmf_status', 'perm_inherit_obj_id') op.drop_column('cmf_status', 'perm_effective_acl_scope') op.drop_column('cmf_status', 'perm_inherit_acl_scope') op.drop_column('cmf_status', 'perm_inherit') op.drop_column('cmf_status', 'perm_policy') op.add_column('cmf_staff_control_settings', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_staff_control_settings', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_staff_control_settings', type_='foreignkey') op.drop_index(op.f('ix_cmf_staff_control_settings_perm_inherit_obj_id'), table_name='cmf_staff_control_settings') op.drop_index(op.f('ix_cmf_staff_control_settings_perm_acl_id'), table_name='cmf_staff_control_settings') op.drop_column('cmf_staff_control_settings', 'perm_acl_id') op.drop_column('cmf_staff_control_settings', 'perm_inherit_obj_id') op.drop_column('cmf_staff_control_settings', 'perm_effective_acl_scope') op.drop_column('cmf_staff_control_settings', 'perm_inherit_acl_scope') op.drop_column('cmf_staff_control_settings', 'perm_inherit') op.drop_column('cmf_staff_control_settings', 'perm_policy') op.add_column('cmf_sale_menu_group', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_sale_menu_group', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_sale_menu_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_sale_menu_group_perm_inherit_obj_id'), table_name='cmf_sale_menu_group') op.drop_index(op.f('ix_cmf_sale_menu_group_perm_acl_id'), table_name='cmf_sale_menu_group') op.drop_column('cmf_sale_menu_group', 'perm_acl_id') op.drop_column('cmf_sale_menu_group', 'perm_inherit_obj_id') op.drop_column('cmf_sale_menu_group', 'perm_effective_acl_scope') op.drop_column('cmf_sale_menu_group', 'perm_inherit_acl_scope') op.drop_column('cmf_sale_menu_group', 'perm_inherit') op.drop_column('cmf_sale_menu_group', 'perm_policy') op.add_column('cmf_role', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_role', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_role', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_role', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_role', type_='foreignkey') op.drop_index(op.f('ix_cmf_role_perm_inherit_obj_id'), table_name='cmf_role') op.drop_index(op.f('ix_cmf_role_perm_acl_id'), table_name='cmf_role') op.drop_column('cmf_role', 'perm_acl_id') op.drop_column('cmf_role', 'perm_inherit_obj_id') op.drop_column('cmf_role', 'perm_effective_acl_scope') op.drop_column('cmf_role', 'perm_inherit_acl_scope') op.drop_column('cmf_role', 'perm_inherit') op.drop_column('cmf_role', 'perm_policy') op.add_column('cmf_roadmap', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_roadmap', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_roadmap', type_='foreignkey') op.drop_index(op.f('ix_cmf_roadmap_perm_inherit_obj_id'), table_name='cmf_roadmap') op.drop_index(op.f('ix_cmf_roadmap_perm_acl_id'), table_name='cmf_roadmap') op.drop_column('cmf_roadmap', 'perm_acl_id') op.drop_column('cmf_roadmap', 'perm_inherit_obj_id') op.drop_column('cmf_roadmap', 'perm_effective_acl_scope') op.drop_column('cmf_roadmap', 'perm_inherit_acl_scope') op.drop_column('cmf_roadmap', 'perm_inherit') op.drop_column('cmf_roadmap', 'perm_policy') op.add_column('cmf_refbook', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_refbook', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_refbook', type_='foreignkey') op.drop_index(op.f('ix_cmf_refbook_perm_inherit_obj_id'), table_name='cmf_refbook') op.drop_index(op.f('ix_cmf_refbook_perm_acl_id'), table_name='cmf_refbook') op.drop_column('cmf_refbook', 'perm_acl_id') op.drop_column('cmf_refbook', 'perm_inherit_obj_id') op.drop_column('cmf_refbook', 'perm_effective_acl_scope') op.drop_column('cmf_refbook', 'perm_inherit_acl_scope') op.drop_column('cmf_refbook', 'perm_inherit') op.drop_column('cmf_refbook', 'perm_policy') op.add_column('cmf_purchase_order_items', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_purchase_order_items', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_purchase_order_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_purchase_order_items_perm_inherit_obj_id'), table_name='cmf_purchase_order_items') op.drop_index(op.f('ix_cmf_purchase_order_items_perm_acl_id'), table_name='cmf_purchase_order_items') op.drop_column('cmf_purchase_order_items', 'perm_acl_id') op.drop_column('cmf_purchase_order_items', 'perm_inherit_obj_id') op.drop_column('cmf_purchase_order_items', 'perm_effective_acl_scope') op.drop_column('cmf_purchase_order_items', 'perm_inherit_acl_scope') op.drop_column('cmf_purchase_order_items', 'perm_inherit') op.drop_column('cmf_purchase_order_items', 'perm_policy') op.add_column('cmf_purchase_order', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_purchase_order', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_purchase_order', type_='foreignkey') op.drop_index(op.f('ix_cmf_purchase_order_perm_inherit_obj_id'), table_name='cmf_purchase_order') op.drop_index(op.f('ix_cmf_purchase_order_perm_acl_id'), table_name='cmf_purchase_order') op.drop_column('cmf_purchase_order', 'perm_acl_id') op.drop_column('cmf_purchase_order', 'perm_inherit_obj_id') op.drop_column('cmf_purchase_order', 'perm_effective_acl_scope') op.drop_column('cmf_purchase_order', 'perm_inherit_acl_scope') op.drop_column('cmf_purchase_order', 'perm_inherit') op.drop_column('cmf_purchase_order', 'perm_policy') op.add_column('cmf_project', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_project', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_project', type_='foreignkey') op.drop_index(op.f('ix_cmf_project_perm_inherit_obj_id'), table_name='cmf_project') op.drop_index(op.f('ix_cmf_project_perm_acl_id'), table_name='cmf_project') op.drop_column('cmf_project', 'perm_acl_id') op.drop_column('cmf_project', 'perm_inherit_obj_id') op.drop_column('cmf_project', 'perm_effective_acl_scope') op.drop_column('cmf_project', 'perm_inherit_acl_scope') op.drop_column('cmf_project', 'perm_inherit') op.drop_column('cmf_project', 'perm_policy') op.add_column('cmf_product', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_product', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_product', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_product', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_product', type_='foreignkey') op.drop_index(op.f('ix_cmf_product_perm_inherit_obj_id'), table_name='cmf_product') op.drop_index(op.f('ix_cmf_product_perm_acl_id'), table_name='cmf_product') op.drop_column('cmf_product', 'perm_acl_id') op.drop_column('cmf_product', 'perm_inherit_obj_id') op.drop_column('cmf_product', 'perm_effective_acl_scope') op.drop_column('cmf_product', 'perm_inherit_acl_scope') op.drop_column('cmf_product', 'perm_inherit') op.drop_column('cmf_product', 'perm_policy') op.add_column('cmf_print_tmpl', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_print_tmpl', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_print_tmpl', type_='foreignkey') op.drop_index(op.f('ix_cmf_print_tmpl_perm_inherit_obj_id'), table_name='cmf_print_tmpl') op.drop_index(op.f('ix_cmf_print_tmpl_perm_acl_id'), table_name='cmf_print_tmpl') op.drop_column('cmf_print_tmpl', 'perm_acl_id') op.drop_column('cmf_print_tmpl', 'perm_inherit_obj_id') op.drop_column('cmf_print_tmpl', 'perm_effective_acl_scope') op.drop_column('cmf_print_tmpl', 'perm_inherit_acl_scope') op.drop_column('cmf_print_tmpl', 'perm_inherit') op.drop_column('cmf_print_tmpl', 'perm_policy') op.add_column('cmf_price', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_price', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_price', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_price', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_price', type_='foreignkey') op.drop_index(op.f('ix_cmf_price_perm_inherit_obj_id'), table_name='cmf_price') op.drop_index(op.f('ix_cmf_price_perm_acl_id'), table_name='cmf_price') op.drop_column('cmf_price', 'perm_acl_id') op.drop_column('cmf_price', 'perm_inherit_obj_id') op.drop_column('cmf_price', 'perm_effective_acl_scope') op.drop_column('cmf_price', 'perm_inherit_acl_scope') op.drop_column('cmf_price', 'perm_inherit') op.drop_column('cmf_price', 'perm_policy') op.add_column('cmf_plugin_zadarma', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_zadarma', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_zadarma', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_zadarma_perm_inherit_obj_id'), table_name='cmf_plugin_zadarma') op.drop_index(op.f('ix_cmf_plugin_zadarma_perm_acl_id'), table_name='cmf_plugin_zadarma') op.drop_column('cmf_plugin_zadarma', 'perm_acl_id') op.drop_column('cmf_plugin_zadarma', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_zadarma', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_zadarma', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_zadarma', 'perm_inherit') op.drop_column('cmf_plugin_zadarma', 'perm_policy') op.add_column('cmf_plugin_trello', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_trello', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_trello', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_trello_perm_inherit_obj_id'), table_name='cmf_plugin_trello') op.drop_index(op.f('ix_cmf_plugin_trello_perm_acl_id'), table_name='cmf_plugin_trello') op.drop_column('cmf_plugin_trello', 'perm_acl_id') op.drop_column('cmf_plugin_trello', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_trello', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_trello', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_trello', 'perm_inherit') op.drop_column('cmf_plugin_trello', 'perm_policy') op.add_column('cmf_plugin_telphin', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_telphin', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_telphin', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_telphin_perm_inherit_obj_id'), table_name='cmf_plugin_telphin') op.drop_index(op.f('ix_cmf_plugin_telphin_perm_acl_id'), table_name='cmf_plugin_telphin') op.drop_column('cmf_plugin_telphin', 'perm_acl_id') op.drop_column('cmf_plugin_telphin', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_telphin', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_telphin', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_telphin', 'perm_inherit') op.drop_column('cmf_plugin_telphin', 'perm_policy') op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_s_m_s_gate', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_s_m_s_gate', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_s_m_s_gate_perm_inherit_obj_id'), table_name='cmf_plugin_s_m_s_gate') op.drop_index(op.f('ix_cmf_plugin_s_m_s_gate_perm_acl_id'), table_name='cmf_plugin_s_m_s_gate') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_acl_id') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_inherit') op.drop_column('cmf_plugin_s_m_s_gate', 'perm_policy') op.add_column('cmf_plugin_mail_box', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_mail_box', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_mail_box', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_mail_box_perm_inherit_obj_id'), table_name='cmf_plugin_mail_box') op.drop_index(op.f('ix_cmf_plugin_mail_box_perm_acl_id'), table_name='cmf_plugin_mail_box') op.drop_column('cmf_plugin_mail_box', 'perm_acl_id') op.drop_column('cmf_plugin_mail_box', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_mail_box', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_mail_box', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_mail_box', 'perm_inherit') op.drop_column('cmf_plugin_mail_box', 'perm_policy') op.add_column('cmf_plugin_jira', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_jira', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_jira', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_jira_perm_inherit_obj_id'), table_name='cmf_plugin_jira') op.drop_index(op.f('ix_cmf_plugin_jira_perm_acl_id'), table_name='cmf_plugin_jira') op.drop_column('cmf_plugin_jira', 'perm_acl_id') op.drop_column('cmf_plugin_jira', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_jira', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_jira', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_jira', 'perm_inherit') op.drop_column('cmf_plugin_jira', 'perm_policy') op.add_column('cmf_plugin_confluence', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_confluence', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_confluence', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_confluence_perm_inherit_obj_id'), table_name='cmf_plugin_confluence') op.drop_index(op.f('ix_cmf_plugin_confluence_perm_acl_id'), table_name='cmf_plugin_confluence') op.drop_column('cmf_plugin_confluence', 'perm_acl_id') op.drop_column('cmf_plugin_confluence', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_confluence', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_confluence', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_confluence', 'perm_inherit') op.drop_column('cmf_plugin_confluence', 'perm_policy') op.add_column('cmf_plugin_asana', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin_asana', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin_asana', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_asana_perm_inherit_obj_id'), table_name='cmf_plugin_asana') op.drop_index(op.f('ix_cmf_plugin_asana_perm_acl_id'), table_name='cmf_plugin_asana') op.drop_column('cmf_plugin_asana', 'perm_acl_id') op.drop_column('cmf_plugin_asana', 'perm_inherit_obj_id') op.drop_column('cmf_plugin_asana', 'perm_effective_acl_scope') op.drop_column('cmf_plugin_asana', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin_asana', 'perm_inherit') op.drop_column('cmf_plugin_asana', 'perm_policy') op.add_column('cmf_plugin', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plugin', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plugin', type_='foreignkey') op.drop_index(op.f('ix_cmf_plugin_perm_inherit_obj_id'), table_name='cmf_plugin') op.drop_index(op.f('ix_cmf_plugin_perm_acl_id'), table_name='cmf_plugin') op.drop_column('cmf_plugin', 'perm_acl_id') op.drop_column('cmf_plugin', 'perm_inherit_obj_id') op.drop_column('cmf_plugin', 'perm_effective_acl_scope') op.drop_column('cmf_plugin', 'perm_inherit_acl_scope') op.drop_column('cmf_plugin', 'perm_inherit') op.drop_column('cmf_plugin', 'perm_policy') op.add_column('cmf_plan', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_plan', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_plan', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_plan', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_plan', type_='foreignkey') op.drop_index(op.f('ix_cmf_plan_perm_inherit_obj_id'), table_name='cmf_plan') op.drop_index(op.f('ix_cmf_plan_perm_acl_id'), table_name='cmf_plan') op.drop_column('cmf_plan', 'perm_acl_id') op.drop_column('cmf_plan', 'perm_inherit_obj_id') op.drop_column('cmf_plan', 'perm_effective_acl_scope') op.drop_column('cmf_plan', 'perm_inherit_acl_scope') op.drop_column('cmf_plan', 'perm_inherit') op.drop_column('cmf_plan', 'perm_policy') op.add_column('cmf_pipeline', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_pipeline', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_pipeline', type_='foreignkey') op.drop_index(op.f('ix_cmf_pipeline_perm_inherit_obj_id'), table_name='cmf_pipeline') op.drop_index(op.f('ix_cmf_pipeline_perm_acl_id'), table_name='cmf_pipeline') op.drop_column('cmf_pipeline', 'perm_acl_id') op.drop_column('cmf_pipeline', 'perm_inherit_obj_id') op.drop_column('cmf_pipeline', 'perm_effective_acl_scope') op.drop_column('cmf_pipeline', 'perm_inherit_acl_scope') op.drop_column('cmf_pipeline', 'perm_inherit') op.drop_column('cmf_pipeline', 'perm_policy') op.add_column('cmf_person_var', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_person_var', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_person_var', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_var_perm_inherit_obj_id'), table_name='cmf_person_var') op.drop_index(op.f('ix_cmf_person_var_perm_acl_id'), table_name='cmf_person_var') op.drop_column('cmf_person_var', 'perm_acl_id') op.drop_column('cmf_person_var', 'perm_inherit_obj_id') op.drop_column('cmf_person_var', 'perm_effective_acl_scope') op.drop_column('cmf_person_var', 'perm_inherit_acl_scope') op.drop_column('cmf_person_var', 'perm_inherit') op.drop_column('cmf_person_var', 'perm_policy') op.add_column('cmf_person_group', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_person_group', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_person_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_group_perm_inherit_obj_id'), table_name='cmf_person_group') op.drop_index(op.f('ix_cmf_person_group_perm_acl_id'), table_name='cmf_person_group') op.drop_column('cmf_person_group', 'perm_acl_id') op.drop_column('cmf_person_group', 'perm_inherit_obj_id') op.drop_column('cmf_person_group', 'perm_effective_acl_scope') op.drop_column('cmf_person_group', 'perm_inherit_acl_scope') op.drop_column('cmf_person_group', 'perm_inherit') op.drop_column('cmf_person_group', 'perm_policy') op.add_column('cmf_person', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_person', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_person', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_person', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_person', type_='foreignkey') op.drop_index(op.f('ix_cmf_person_perm_inherit_obj_id'), table_name='cmf_person') op.drop_index(op.f('ix_cmf_person_perm_acl_id'), table_name='cmf_person') op.drop_column('cmf_person', 'perm_acl_id') op.drop_column('cmf_person', 'perm_inherit_obj_id') op.drop_column('cmf_person', 'perm_effective_acl_scope') op.drop_column('cmf_person', 'perm_inherit_acl_scope') op.drop_column('cmf_person', 'perm_inherit') op.drop_column('cmf_person', 'perm_policy') op.add_column('cmf_payment', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_payment', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_payment', type_='foreignkey') op.drop_index(op.f('ix_cmf_payment_perm_inherit_obj_id'), table_name='cmf_payment') op.drop_index(op.f('ix_cmf_payment_perm_acl_id'), table_name='cmf_payment') op.drop_column('cmf_payment', 'perm_acl_id') op.drop_column('cmf_payment', 'perm_inherit_obj_id') op.drop_column('cmf_payment', 'perm_effective_acl_scope') op.drop_column('cmf_payment', 'perm_inherit_acl_scope') op.drop_column('cmf_payment', 'perm_inherit') op.drop_column('cmf_payment', 'perm_policy') op.add_column('cmf_org_unit', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_org_unit', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_org_unit', type_='foreignkey') op.drop_index(op.f('ix_cmf_org_unit_perm_inherit_obj_id'), table_name='cmf_org_unit') op.drop_index(op.f('ix_cmf_org_unit_perm_acl_id'), table_name='cmf_org_unit') op.drop_column('cmf_org_unit', 'perm_acl_id') op.drop_column('cmf_org_unit', 'perm_inherit_obj_id') op.drop_column('cmf_org_unit', 'perm_effective_acl_scope') op.drop_column('cmf_org_unit', 'perm_inherit_acl_scope') op.drop_column('cmf_org_unit', 'perm_inherit') op.drop_column('cmf_org_unit', 'perm_policy') op.add_column('cmf_notify', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_notify', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_notify', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_notify', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_notify', type_='foreignkey') op.drop_index(op.f('ix_cmf_notify_perm_inherit_obj_id'), table_name='cmf_notify') op.drop_index(op.f('ix_cmf_notify_perm_acl_id'), table_name='cmf_notify') op.drop_column('cmf_notify', 'perm_acl_id') op.drop_column('cmf_notify', 'perm_inherit_obj_id') op.drop_column('cmf_notify', 'perm_effective_acl_scope') op.drop_column('cmf_notify', 'perm_inherit_acl_scope') op.drop_column('cmf_notify', 'perm_inherit') op.drop_column('cmf_notify', 'perm_policy') op.add_column('cmf_menu_tree_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_menu_tree_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_tree_item_perm_inherit_obj_id'), table_name='cmf_menu_tree_item') op.drop_index(op.f('ix_cmf_menu_tree_item_perm_acl_id'), table_name='cmf_menu_tree_item') op.drop_column('cmf_menu_tree_item', 'perm_acl_id') op.drop_column('cmf_menu_tree_item', 'perm_inherit_obj_id') op.drop_column('cmf_menu_tree_item', 'perm_effective_acl_scope') op.drop_column('cmf_menu_tree_item', 'perm_inherit_acl_scope') op.drop_column('cmf_menu_tree_item', 'perm_inherit') op.drop_column('cmf_menu_tree_item', 'perm_policy') op.add_column('cmf_menu_tree', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_menu_tree', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_menu_tree', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_tree_perm_inherit_obj_id'), table_name='cmf_menu_tree') op.drop_index(op.f('ix_cmf_menu_tree_perm_acl_id'), table_name='cmf_menu_tree') op.drop_column('cmf_menu_tree', 'perm_acl_id') op.drop_column('cmf_menu_tree', 'perm_inherit_obj_id') op.drop_column('cmf_menu_tree', 'perm_effective_acl_scope') op.drop_column('cmf_menu_tree', 'perm_inherit_acl_scope') op.drop_column('cmf_menu_tree', 'perm_inherit') op.drop_column('cmf_menu_tree', 'perm_policy') op.add_column('cmf_menu_item', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_menu_item', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_menu_item', type_='foreignkey') op.drop_index(op.f('ix_cmf_menu_item_perm_inherit_obj_id'), table_name='cmf_menu_item') op.drop_index(op.f('ix_cmf_menu_item_perm_acl_id'), table_name='cmf_menu_item') op.drop_column('cmf_menu_item', 'perm_acl_id') op.drop_column('cmf_menu_item', 'perm_inherit_obj_id') op.drop_column('cmf_menu_item', 'perm_effective_acl_scope') op.drop_column('cmf_menu_item', 'perm_inherit_acl_scope') op.drop_column('cmf_menu_item', 'perm_inherit') op.drop_column('cmf_menu_item', 'perm_policy') op.add_column('cmf_mailbox', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_mailbox', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_mailbox', type_='foreignkey') op.drop_index(op.f('ix_cmf_mailbox_perm_inherit_obj_id'), table_name='cmf_mailbox') op.drop_index(op.f('ix_cmf_mailbox_perm_acl_id'), table_name='cmf_mailbox') op.drop_column('cmf_mailbox', 'perm_acl_id') op.drop_column('cmf_mailbox', 'perm_inherit_obj_id') op.drop_column('cmf_mailbox', 'perm_effective_acl_scope') op.drop_column('cmf_mailbox', 'perm_inherit_acl_scope') op.drop_column('cmf_mailbox', 'perm_inherit') op.drop_column('cmf_mailbox', 'perm_policy') op.add_column('cmf_mail_template', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_mail_template', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_mail_template', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_template_perm_inherit_obj_id'), table_name='cmf_mail_template') op.drop_index(op.f('ix_cmf_mail_template_perm_acl_id'), table_name='cmf_mail_template') op.drop_column('cmf_mail_template', 'perm_acl_id') op.drop_column('cmf_mail_template', 'perm_inherit_obj_id') op.drop_column('cmf_mail_template', 'perm_effective_acl_scope') op.drop_column('cmf_mail_template', 'perm_inherit_acl_scope') op.drop_column('cmf_mail_template', 'perm_inherit') op.drop_column('cmf_mail_template', 'perm_policy') op.add_column('cmf_mail_signature', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_mail_signature', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_mail_signature', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_signature_perm_inherit_obj_id'), table_name='cmf_mail_signature') op.drop_index(op.f('ix_cmf_mail_signature_perm_acl_id'), table_name='cmf_mail_signature') op.drop_column('cmf_mail_signature', 'perm_acl_id') op.drop_column('cmf_mail_signature', 'perm_inherit_obj_id') op.drop_column('cmf_mail_signature', 'perm_effective_acl_scope') op.drop_column('cmf_mail_signature', 'perm_inherit_acl_scope') op.drop_column('cmf_mail_signature', 'perm_inherit') op.drop_column('cmf_mail_signature', 'perm_policy') op.add_column('cmf_mail', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_mail', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_mail', type_='foreignkey') op.drop_index(op.f('ix_cmf_mail_perm_inherit_obj_id'), table_name='cmf_mail') op.drop_index(op.f('ix_cmf_mail_perm_acl_id'), table_name='cmf_mail') op.drop_column('cmf_mail', 'perm_acl_id') op.drop_column('cmf_mail', 'perm_inherit_obj_id') op.drop_column('cmf_mail', 'perm_effective_acl_scope') op.drop_column('cmf_mail', 'perm_inherit_acl_scope') op.drop_column('cmf_mail', 'perm_inherit') op.drop_column('cmf_mail', 'perm_policy') op.add_column('cmf_list', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_list', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_list', type_='foreignkey') op.drop_index(op.f('ix_cmf_list_perm_inherit_obj_id'), table_name='cmf_list') op.drop_index(op.f('ix_cmf_list_perm_acl_id'), table_name='cmf_list') op.drop_column('cmf_list', 'perm_acl_id') op.drop_column('cmf_list', 'perm_inherit_obj_id') op.drop_column('cmf_list', 'perm_effective_acl_scope') op.drop_column('cmf_list', 'perm_inherit_acl_scope') op.drop_column('cmf_list', 'perm_inherit') op.drop_column('cmf_list', 'perm_policy') op.add_column('cmf_link', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_link', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_link', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_link', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_link', type_='foreignkey') op.drop_index(op.f('ix_cmf_link_perm_inherit_obj_id'), table_name='cmf_link') op.drop_index(op.f('ix_cmf_link_perm_acl_id'), table_name='cmf_link') op.drop_column('cmf_link', 'perm_acl_id') op.drop_column('cmf_link', 'perm_inherit_obj_id') op.drop_column('cmf_link', 'perm_effective_acl_scope') op.drop_column('cmf_link', 'perm_inherit_acl_scope') op.drop_column('cmf_link', 'perm_inherit') op.drop_column('cmf_link', 'perm_policy') op.add_column('cmf_lead_mailbox', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_lead_mailbox', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_lead_mailbox', type_='foreignkey') op.drop_index(op.f('ix_cmf_lead_mailbox_perm_inherit_obj_id'), table_name='cmf_lead_mailbox') op.drop_index(op.f('ix_cmf_lead_mailbox_perm_acl_id'), table_name='cmf_lead_mailbox') op.drop_column('cmf_lead_mailbox', 'perm_acl_id') op.drop_column('cmf_lead_mailbox', 'perm_inherit_obj_id') op.drop_column('cmf_lead_mailbox', 'perm_effective_acl_scope') op.drop_column('cmf_lead_mailbox', 'perm_inherit_acl_scope') op.drop_column('cmf_lead_mailbox', 'perm_inherit') op.drop_column('cmf_lead_mailbox', 'perm_policy') op.add_column('cmf_lead', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_lead', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_lead', type_='foreignkey') op.drop_index(op.f('ix_cmf_lead_perm_inherit_obj_id'), table_name='cmf_lead') op.drop_index(op.f('ix_cmf_lead_perm_acl_id'), table_name='cmf_lead') op.drop_column('cmf_lead', 'perm_acl_id') op.drop_column('cmf_lead', 'perm_inherit_obj_id') op.drop_column('cmf_lead', 'perm_effective_acl_scope') op.drop_column('cmf_lead', 'perm_inherit_acl_scope') op.drop_column('cmf_lead', 'perm_inherit') op.drop_column('cmf_lead', 'perm_policy') op.add_column('cmf_job', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_job', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_job', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_job', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_job', type_='foreignkey') op.drop_index(op.f('ix_cmf_job_perm_inherit_obj_id'), table_name='cmf_job') op.drop_index(op.f('ix_cmf_job_perm_acl_id'), table_name='cmf_job') op.drop_column('cmf_job', 'perm_acl_id') op.drop_column('cmf_job', 'perm_inherit_obj_id') op.drop_column('cmf_job', 'perm_effective_acl_scope') op.drop_column('cmf_job', 'perm_inherit_acl_scope') op.drop_column('cmf_job', 'perm_inherit') op.drop_column('cmf_job', 'perm_policy') op.add_column('cmf_invoice_items', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_invoice_items', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_invoice_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_invoice_items_perm_inherit_obj_id'), table_name='cmf_invoice_items') op.drop_index(op.f('ix_cmf_invoice_items_perm_acl_id'), table_name='cmf_invoice_items') op.drop_column('cmf_invoice_items', 'perm_acl_id') op.drop_column('cmf_invoice_items', 'perm_inherit_obj_id') op.drop_column('cmf_invoice_items', 'perm_effective_acl_scope') op.drop_column('cmf_invoice_items', 'perm_inherit_acl_scope') op.drop_column('cmf_invoice_items', 'perm_inherit') op.drop_column('cmf_invoice_items', 'perm_policy') op.add_column('cmf_invoice', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_invoice', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_invoice', type_='foreignkey') op.drop_index(op.f('ix_cmf_invoice_perm_inherit_obj_id'), table_name='cmf_invoice') op.drop_index(op.f('ix_cmf_invoice_perm_acl_id'), table_name='cmf_invoice') op.drop_column('cmf_invoice', 'perm_acl_id') op.drop_column('cmf_invoice', 'perm_inherit_obj_id') op.drop_column('cmf_invoice', 'perm_effective_acl_scope') op.drop_column('cmf_invoice', 'perm_inherit_acl_scope') op.drop_column('cmf_invoice', 'perm_inherit') op.drop_column('cmf_invoice', 'perm_policy') op.add_column('cmf_integration', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_integration', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_integration', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_integration', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_integration', type_='foreignkey') op.drop_index(op.f('ix_cmf_integration_perm_inherit_obj_id'), table_name='cmf_integration') op.drop_index(op.f('ix_cmf_integration_perm_acl_id'), table_name='cmf_integration') op.drop_column('cmf_integration', 'perm_acl_id') op.drop_column('cmf_integration', 'perm_inherit_obj_id') op.drop_column('cmf_integration', 'perm_effective_acl_scope') op.drop_column('cmf_integration', 'perm_inherit_acl_scope') op.drop_column('cmf_integration', 'perm_inherit') op.drop_column('cmf_integration', 'perm_policy') op.add_column('cmf_import', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_import', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_import', type_='foreignkey') op.drop_index(op.f('ix_cmf_import_perm_inherit_obj_id'), table_name='cmf_import') op.drop_index(op.f('ix_cmf_import_perm_acl_id'), table_name='cmf_import') op.drop_column('cmf_import', 'perm_acl_id') op.drop_column('cmf_import', 'perm_inherit_obj_id') op.drop_column('cmf_import', 'perm_effective_acl_scope') op.drop_column('cmf_import', 'perm_inherit_acl_scope') op.drop_column('cmf_import', 'perm_inherit') op.drop_column('cmf_import', 'perm_policy') op.add_column('cmf_form_field', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_form_field', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_form_field', type_='foreignkey') op.drop_index(op.f('ix_cmf_form_field_perm_inherit_obj_id'), table_name='cmf_form_field') op.drop_index(op.f('ix_cmf_form_field_perm_acl_id'), table_name='cmf_form_field') op.drop_column('cmf_form_field', 'perm_acl_id') op.drop_column('cmf_form_field', 'perm_inherit_obj_id') op.drop_column('cmf_form_field', 'perm_effective_acl_scope') op.drop_column('cmf_form_field', 'perm_inherit_acl_scope') op.drop_column('cmf_form_field', 'perm_inherit') op.drop_column('cmf_form_field', 'perm_policy') op.add_column('cmf_form', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_form', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_form', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_form', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_form', type_='foreignkey') op.drop_index(op.f('ix_cmf_form_perm_inherit_obj_id'), table_name='cmf_form') op.drop_index(op.f('ix_cmf_form_perm_acl_id'), table_name='cmf_form') op.drop_column('cmf_form', 'perm_acl_id') op.drop_column('cmf_form', 'perm_inherit_obj_id') op.drop_column('cmf_form', 'perm_effective_acl_scope') op.drop_column('cmf_form', 'perm_inherit_acl_scope') op.drop_column('cmf_form', 'perm_inherit') op.drop_column('cmf_form', 'perm_policy') op.add_column('cmf_folder', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_folder', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_folder', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_folder', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_folder', type_='foreignkey') op.drop_index(op.f('ix_cmf_folder_perm_inherit_obj_id'), table_name='cmf_folder') op.drop_index(op.f('ix_cmf_folder_perm_acl_id'), table_name='cmf_folder') op.drop_column('cmf_folder', 'perm_acl_id') op.drop_column('cmf_folder', 'perm_inherit_obj_id') op.drop_column('cmf_folder', 'perm_effective_acl_scope') op.drop_column('cmf_folder', 'perm_inherit_acl_scope') op.drop_column('cmf_folder', 'perm_inherit') op.drop_column('cmf_folder', 'perm_policy') op.add_column('cmf_filter', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_filter', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_filter', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_filter', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_filter', type_='foreignkey') op.drop_index(op.f('ix_cmf_filter_perm_inherit_obj_id'), table_name='cmf_filter') op.drop_index(op.f('ix_cmf_filter_perm_acl_id'), table_name='cmf_filter') op.drop_column('cmf_filter', 'perm_acl_id') op.drop_column('cmf_filter', 'perm_inherit_obj_id') op.drop_column('cmf_filter', 'perm_effective_acl_scope') op.drop_column('cmf_filter', 'perm_inherit_acl_scope') op.drop_column('cmf_filter', 'perm_inherit') op.drop_column('cmf_filter', 'perm_policy') op.add_column('cmf_document_history', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_document_history', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_document_history', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_history_perm_inherit_obj_id'), table_name='cmf_document_history') op.drop_index(op.f('ix_cmf_document_history_perm_acl_id'), table_name='cmf_document_history') op.drop_column('cmf_document_history', 'perm_acl_id') op.drop_column('cmf_document_history', 'perm_inherit_obj_id') op.drop_column('cmf_document_history', 'perm_effective_acl_scope') op.drop_column('cmf_document_history', 'perm_inherit_acl_scope') op.drop_column('cmf_document_history', 'perm_inherit') op.drop_column('cmf_document_history', 'perm_policy') op.add_column('cmf_document', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_document', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_document', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_perm_inherit_obj_id'), table_name='cmf_document') op.drop_index(op.f('ix_cmf_document_perm_acl_id'), table_name='cmf_document') op.drop_column('cmf_document', 'perm_acl_id') op.drop_column('cmf_document', 'perm_inherit_obj_id') op.drop_column('cmf_document', 'perm_effective_acl_scope') op.drop_column('cmf_document', 'perm_inherit_acl_scope') op.drop_column('cmf_document', 'perm_inherit') op.drop_column('cmf_document', 'perm_policy') op.add_column('cmf_deal_items', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_deal_items', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_deal_items', type_='foreignkey') op.drop_index(op.f('ix_cmf_deal_items_perm_inherit_obj_id'), table_name='cmf_deal_items') op.drop_index(op.f('ix_cmf_deal_items_perm_acl_id'), table_name='cmf_deal_items') op.drop_column('cmf_deal_items', 'perm_acl_id') op.drop_column('cmf_deal_items', 'perm_inherit_obj_id') op.drop_column('cmf_deal_items', 'perm_effective_acl_scope') op.drop_column('cmf_deal_items', 'perm_inherit_acl_scope') op.drop_column('cmf_deal_items', 'perm_inherit') op.drop_column('cmf_deal_items', 'perm_policy') op.add_column('cmf_deal', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_deal', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_deal', type_='foreignkey') op.drop_index(op.f('ix_cmf_deal_perm_inherit_obj_id'), table_name='cmf_deal') op.drop_index(op.f('ix_cmf_deal_perm_acl_id'), table_name='cmf_deal') op.drop_column('cmf_deal', 'perm_acl_id') op.drop_column('cmf_deal', 'perm_inherit_obj_id') op.drop_column('cmf_deal', 'perm_effective_acl_scope') op.drop_column('cmf_deal', 'perm_inherit_acl_scope') op.drop_column('cmf_deal', 'perm_inherit') op.drop_column('cmf_deal', 'perm_policy') op.add_column('cmf_currency', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_currency', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_currency', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_currency', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_currency', type_='foreignkey') op.drop_index(op.f('ix_cmf_currency_perm_inherit_obj_id'), table_name='cmf_currency') op.drop_index(op.f('ix_cmf_currency_perm_acl_id'), table_name='cmf_currency') op.drop_column('cmf_currency', 'perm_acl_id') op.drop_column('cmf_currency', 'perm_inherit_obj_id') op.drop_column('cmf_currency', 'perm_effective_acl_scope') op.drop_column('cmf_currency', 'perm_inherit_acl_scope') op.drop_column('cmf_currency', 'perm_inherit') op.drop_column('cmf_currency', 'perm_policy') op.add_column('cmf_contract', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_contract', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_contract', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_contract', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_contract', type_='foreignkey') op.drop_index(op.f('ix_cmf_contract_perm_inherit_obj_id'), table_name='cmf_contract') op.drop_index(op.f('ix_cmf_contract_perm_acl_id'), table_name='cmf_contract') op.drop_column('cmf_contract', 'perm_acl_id') op.drop_column('cmf_contract', 'perm_inherit_obj_id') op.drop_column('cmf_contract', 'perm_effective_acl_scope') op.drop_column('cmf_contract', 'perm_inherit_acl_scope') op.drop_column('cmf_contract', 'perm_inherit') op.drop_column('cmf_contract', 'perm_policy') op.add_column('cmf_company', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_company', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_company', type_='foreignkey') op.drop_index(op.f('ix_cmf_company_perm_inherit_obj_id'), table_name='cmf_company') op.drop_index(op.f('ix_cmf_company_perm_acl_id'), table_name='cmf_company') op.drop_column('cmf_company', 'perm_acl_id') op.drop_column('cmf_company', 'perm_inherit_obj_id') op.drop_column('cmf_company', 'perm_effective_acl_scope') op.drop_column('cmf_company', 'perm_inherit_acl_scope') op.drop_column('cmf_company', 'perm_inherit') op.drop_column('cmf_company', 'perm_policy') op.add_column('cmf_comment', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_comment', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_comment', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_comment', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_comment', type_='foreignkey') op.drop_index(op.f('ix_cmf_comment_perm_inherit_obj_id'), table_name='cmf_comment') op.drop_index(op.f('ix_cmf_comment_perm_acl_id'), table_name='cmf_comment') op.drop_column('cmf_comment', 'perm_acl_id') op.drop_column('cmf_comment', 'perm_inherit_obj_id') op.drop_column('cmf_comment', 'perm_effective_acl_scope') op.drop_column('cmf_comment', 'perm_inherit_acl_scope') op.drop_column('cmf_comment', 'perm_inherit') op.drop_column('cmf_comment', 'perm_policy') op.add_column('cmf_chat_topic', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_chat_topic', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_chat_topic', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_topic_perm_inherit_obj_id'), table_name='cmf_chat_topic') op.drop_index(op.f('ix_cmf_chat_topic_perm_acl_id'), table_name='cmf_chat_topic') op.drop_column('cmf_chat_topic', 'perm_acl_id') op.drop_column('cmf_chat_topic', 'perm_inherit_obj_id') op.drop_column('cmf_chat_topic', 'perm_effective_acl_scope') op.drop_column('cmf_chat_topic', 'perm_inherit_acl_scope') op.drop_column('cmf_chat_topic', 'perm_inherit') op.drop_column('cmf_chat_topic', 'perm_policy') op.add_column('cmf_chat_message', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_chat_message', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_chat_message', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_message_perm_inherit_obj_id'), table_name='cmf_chat_message') op.drop_index(op.f('ix_cmf_chat_message_perm_acl_id'), table_name='cmf_chat_message') op.drop_column('cmf_chat_message', 'perm_acl_id') op.drop_column('cmf_chat_message', 'perm_inherit_obj_id') op.drop_column('cmf_chat_message', 'perm_effective_acl_scope') op.drop_column('cmf_chat_message', 'perm_inherit_acl_scope') op.drop_column('cmf_chat_message', 'perm_inherit') op.drop_column('cmf_chat_message', 'perm_policy') op.add_column('cmf_chat_group', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_chat_group', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_chat_group', type_='foreignkey') op.drop_index(op.f('ix_cmf_chat_group_perm_inherit_obj_id'), table_name='cmf_chat_group') op.drop_index(op.f('ix_cmf_chat_group_perm_acl_id'), table_name='cmf_chat_group') op.drop_column('cmf_chat_group', 'perm_acl_id') op.drop_column('cmf_chat_group', 'perm_inherit_obj_id') op.drop_column('cmf_chat_group', 'perm_effective_acl_scope') op.drop_column('cmf_chat_group', 'perm_inherit_acl_scope') op.drop_column('cmf_chat_group', 'perm_inherit') op.drop_column('cmf_chat_group', 'perm_policy') op.add_column('cmf_card', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_card', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_card', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_card', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_card', type_='foreignkey') op.drop_index(op.f('ix_cmf_card_perm_inherit_obj_id'), table_name='cmf_card') op.drop_index(op.f('ix_cmf_card_perm_acl_id'), table_name='cmf_card') op.drop_column('cmf_card', 'perm_acl_id') op.drop_column('cmf_card', 'perm_inherit_obj_id') op.drop_column('cmf_card', 'perm_effective_acl_scope') op.drop_column('cmf_card', 'perm_inherit_acl_scope') op.drop_column('cmf_card', 'perm_inherit') op.drop_column('cmf_card', 'perm_policy') op.add_column('cmf_balance_operation', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_balance_operation', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_balance_operation', type_='foreignkey') op.drop_index(op.f('ix_cmf_balance_operation_perm_inherit_obj_id'), table_name='cmf_balance_operation') op.drop_index(op.f('ix_cmf_balance_operation_perm_acl_id'), table_name='cmf_balance_operation') op.drop_column('cmf_balance_operation', 'perm_acl_id') op.drop_column('cmf_balance_operation', 'perm_inherit_obj_id') op.drop_column('cmf_balance_operation', 'perm_effective_acl_scope') op.drop_column('cmf_balance_operation', 'perm_inherit_acl_scope') op.drop_column('cmf_balance_operation', 'perm_inherit') op.drop_column('cmf_balance_operation', 'perm_policy') op.add_column('cmf_balance', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_balance', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_balance', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_balance', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_balance', type_='foreignkey') op.drop_index(op.f('ix_cmf_balance_perm_inherit_obj_id'), table_name='cmf_balance') op.drop_index(op.f('ix_cmf_balance_perm_acl_id'), table_name='cmf_balance') op.drop_column('cmf_balance', 'perm_acl_id') op.drop_column('cmf_balance', 'perm_inherit_obj_id') op.drop_column('cmf_balance', 'perm_effective_acl_scope') op.drop_column('cmf_balance', 'perm_inherit_acl_scope') op.drop_column('cmf_balance', 'perm_inherit') op.drop_column('cmf_balance', 'perm_policy') op.add_column('cmf_attachment', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_attachment', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_attachment', type_='foreignkey') op.drop_index(op.f('ix_cmf_attachment_perm_inherit_obj_id'), table_name='cmf_attachment') op.drop_index(op.f('ix_cmf_attachment_perm_acl_id'), table_name='cmf_attachment') op.drop_column('cmf_attachment', 'perm_acl_id') op.drop_column('cmf_attachment', 'perm_inherit_obj_id') op.drop_column('cmf_attachment', 'perm_effective_acl_scope') op.drop_column('cmf_attachment', 'perm_inherit_acl_scope') op.drop_column('cmf_attachment', 'perm_inherit') op.drop_column('cmf_attachment', 'perm_policy') op.add_column('cmf_activity', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_activity', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_activity', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_activity', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_activity', type_='foreignkey') op.drop_index(op.f('ix_cmf_activity_perm_inherit_obj_id'), table_name='cmf_activity') op.drop_index(op.f('ix_cmf_activity_perm_acl_id'), table_name='cmf_activity') op.drop_column('cmf_activity', 'perm_acl_id') op.drop_column('cmf_activity', 'perm_inherit_obj_id') op.drop_column('cmf_activity', 'perm_effective_acl_scope') op.drop_column('cmf_activity', 'perm_inherit_acl_scope') op.drop_column('cmf_activity', 'perm_inherit') op.drop_column('cmf_activity', 'perm_policy') op.add_column('cmf_active_entity_filter', sa.Column('perm_field', sa.VARCHAR(), autoincrement=False, nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_readonly', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True)) op.add_column('cmf_active_entity_filter', sa.Column('perm_private', sa.BOOLEAN(), autoincrement=False, nullable=True)) op.drop_constraint(None, 'cmf_active_entity_filter', type_='foreignkey') op.drop_index(op.f('ix_cmf_active_entity_filter_perm_inherit_obj_id'), table_name='cmf_active_entity_filter') op.drop_index(op.f('ix_cmf_active_entity_filter_perm_acl_id'), table_name='cmf_active_entity_filter') op.drop_column('cmf_active_entity_filter', 'perm_acl_id') op.drop_column('cmf_active_entity_filter', 'perm_inherit_obj_id') op.drop_column('cmf_active_entity_filter', 'perm_effective_acl_scope') op.drop_column('cmf_active_entity_filter', 'perm_inherit_acl_scope') op.drop_column('cmf_active_entity_filter', 'perm_inherit') op.drop_column('cmf_active_entity_filter', 'perm_policy') op.drop_index(op.f('ix_cmf_access_rule_subjects_root_id'), table_name='cmf_access_rule_subjects') op.drop_index(op.f('ix_cmf_access_rule_subjects_right_id'), table_name='cmf_access_rule_subjects') op.drop_index(op.f('ix_cmf_access_rule_subjects_parent_id'), table_name='cmf_access_rule_subjects') op.drop_index(op.f('ix_cmf_access_rule_subjects_left_id'), table_name='cmf_access_rule_subjects') op.drop_table('cmf_access_rule_subjects') op.drop_index(op.f('ix_cmf_access_rule_tree_parent_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_perm_inherit_obj_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_perm_acl_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_parent_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_orderno'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_name'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_code'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_viewed_at'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_version'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_owner_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_owner_assistant_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_modified_by_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_modified_at'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_locked_by_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_locked_at'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_import_id'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_deleted'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_created_at'), table_name='cmf_access_rule') op.drop_index(op.f('ix_cmf_access_rule_cmf_author_id'), table_name='cmf_access_rule') op.drop_table('cmf_access_rule') op.drop_index(op.f('ix_cmf_access_list_tree_parent_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_perm_inherit_obj_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_perm_acl_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_parent_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_orderno'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_object_owner_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_name'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_code'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_viewed_at'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_version'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_owner_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_owner_assistant_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_modified_by_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_modified_at'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_locked_by_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_locked_at'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_import_id'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_deleted'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_created_at'), table_name='cmf_access_list') op.drop_index(op.f('ix_cmf_access_list_cmf_author_id'), table_name='cmf_access_list') op.drop_table('cmf_access_list') # ### end Alembic commands ###