"""docflow_final Revision ID: 219529049a4f Revises: 2b0779e2d7fe Create Date: 2023-07-19 19:24:01.940769 """ from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. revision = '219529049a4f' down_revision = '2b0779e2d7fe' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('cmf_approve_group', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('import_original', sa.Boolean(), nullable=True), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('min_approvers', sa.Integer(), nullable=True), sa.Column('required_signs', 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('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('root_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['parent_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_approve_group_cmf_author_id'), 'cmf_approve_group', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_created_at'), 'cmf_approve_group', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_deleted'), 'cmf_approve_group', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_import_id'), 'cmf_approve_group', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_locked_at'), 'cmf_approve_group', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_locked_by_id'), 'cmf_approve_group', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_modified_at'), 'cmf_approve_group', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_modified_by_id'), 'cmf_approve_group', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_owner_id'), 'cmf_approve_group', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_version'), 'cmf_approve_group', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_approve_group_cmf_viewed_at'), 'cmf_approve_group', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_approve_group_code'), 'cmf_approve_group', ['code'], unique=True) op.create_index(op.f('ix_cmf_approve_group_name'), 'cmf_approve_group', ['name'], unique=False) op.create_index(op.f('ix_cmf_approve_group_orderno'), 'cmf_approve_group', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_approve_group_parent_id'), 'cmf_approve_group', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_perm_acl_id'), 'cmf_approve_group', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_perm_parent_id'), 'cmf_approve_group', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_root_parent_id'), 'cmf_approve_group', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_tree_parent_id'), 'cmf_approve_group', ['tree_parent_id'], unique=False) op.create_table('cmf_approve', sa.Column('id', sa.String(length=64), nullable=False), sa.Column('cmf_locked_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_created_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_modified_at', sa.TIMESTAMP(timezone=True), nullable=False), sa.Column('cmf_viewed_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('cmf_deleted', sa.Boolean(), nullable=False), sa.Column('cmf_version', sa.BIGINT(), nullable=True), sa.Column('name', sa.String(length=256), nullable=True), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('system', sa.Boolean(), nullable=False), sa.Column('text', sa.TEXT(), nullable=True), sa.Column('import_original', sa.Boolean(), nullable=True), sa.Column('import_raw_json', sa.TEXT(), nullable=True), sa.Column('ext_id', sa.String(), nullable=True), sa.Column('is_favorite', sa.Boolean(), nullable=True), sa.Column('has_tree_nodes', sa.Boolean(), nullable=True), sa.Column('tree_node_is_branch', sa.Boolean(), nullable=True), sa.Column('tree_hidden', sa.Boolean(), nullable=True), sa.Column('orderno', sa.Integer(), nullable=True), sa.Column('perm_public', sa.Boolean(), nullable=True), sa.Column('perm_has_acl', sa.Boolean(), nullable=True), sa.Column('perm_inherit', sa.Boolean(), nullable=True), sa.Column('perm_parent_owner_id', sa.String(length=64), nullable=True), sa.Column('perm_inherit_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_effective_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_security_level_allowed_ids_cache', sa.TEXT(), nullable=True), sa.Column('perm_encrypt', sa.Boolean(), nullable=True), sa.Column('approve_type', sa.String(length=32), nullable=True), sa.Column('status', sa.String(length=32), nullable=True), sa.Column('obj_version', sa.BIGINT(), nullable=True), sa.Column('sign', sa.String(), nullable=True), sa.Column('approved_at', sa.TIMESTAMP(timezone=True), nullable=True), sa.Column('resolution', sa.String(length=32), nullable=True), sa.Column('approver_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('parent_id', sa.String(length=64), nullable=True), sa.Column('cmf_modified_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_locked_by_id', sa.String(length=64), nullable=True), sa.Column('cmf_import_id', sa.String(length=64), nullable=True), sa.Column('tree_parent_id', sa.String(length=64), nullable=True), sa.Column('root_parent_id', sa.String(length=64), nullable=True), sa.Column('perm_acl_id', sa.String(length=64), nullable=True), sa.Column('perm_parent_id', sa.String(length=64), nullable=True), sa.Column('approver_id', sa.String(length=64), nullable=True), sa.Column('obj_id', sa.String(length=64), nullable=False), sa.Column('obj_status_id', sa.String(length=64), nullable=True), sa.Column('approve_group_id', sa.String(length=64), nullable=True), sa.ForeignKeyConstraint(['approve_group_id'], ['cmf_approve_group.id'], ), sa.ForeignKeyConstraint(['approver_id'], ['cmf_person.id'], ), sa.ForeignKeyConstraint(['cmf_import_id'], ['cmf_import.id'], ), sa.ForeignKeyConstraint(['obj_status_id'], ['cmf_status.id'], ), sa.ForeignKeyConstraint(['perm_acl_id'], ['cmf_access_list.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_approve_approve_group_id'), 'cmf_approve', ['approve_group_id'], unique=False) op.create_index(op.f('ix_cmf_approve_approver_id'), 'cmf_approve', ['approver_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_author_id'), 'cmf_approve', ['cmf_author_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_created_at'), 'cmf_approve', ['cmf_created_at'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_deleted'), 'cmf_approve', ['cmf_deleted'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_import_id'), 'cmf_approve', ['cmf_import_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_locked_at'), 'cmf_approve', ['cmf_locked_at'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_locked_by_id'), 'cmf_approve', ['cmf_locked_by_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_modified_at'), 'cmf_approve', ['cmf_modified_at'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_modified_by_id'), 'cmf_approve', ['cmf_modified_by_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_owner_id'), 'cmf_approve', ['cmf_owner_id'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_version'), 'cmf_approve', ['cmf_version'], unique=False) op.create_index(op.f('ix_cmf_approve_cmf_viewed_at'), 'cmf_approve', ['cmf_viewed_at'], unique=False) op.create_index(op.f('ix_cmf_approve_code'), 'cmf_approve', ['code'], unique=True) op.create_index(op.f('ix_cmf_approve_name'), 'cmf_approve', ['name'], unique=False) op.create_index(op.f('ix_cmf_approve_obj_id'), 'cmf_approve', ['obj_id'], unique=False) op.create_index(op.f('ix_cmf_approve_obj_status_id'), 'cmf_approve', ['obj_status_id'], unique=False) op.create_index(op.f('ix_cmf_approve_obj_version'), 'cmf_approve', ['obj_version'], unique=False) op.create_index(op.f('ix_cmf_approve_orderno'), 'cmf_approve', ['orderno'], unique=False) op.create_index(op.f('ix_cmf_approve_parent_id'), 'cmf_approve', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_perm_acl_id'), 'cmf_approve', ['perm_acl_id'], unique=False) op.create_index(op.f('ix_cmf_approve_perm_parent_id'), 'cmf_approve', ['perm_parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_root_parent_id'), 'cmf_approve', ['root_parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_tree_parent_id'), 'cmf_approve', ['tree_parent_id'], unique=False) op.create_table('cmf_approve_group_approvers', sa.Column('id', sa.String(length=128), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_approve_group_approvers_left_id'), 'cmf_approve_group_approvers', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_approvers_parent_id'), 'cmf_approve_group_approvers', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_approvers_right_id'), 'cmf_approve_group_approvers', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_approvers_root_id'), 'cmf_approve_group_approvers', ['root_id'], unique=False) op.create_table('cmf_approve_group_master_approvers', sa.Column('id', sa.String(length=128), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_approve_group_master_approvers_left_id'), 'cmf_approve_group_master_approvers', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_master_approvers_parent_id'), 'cmf_approve_group_master_approvers', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_master_approvers_right_id'), 'cmf_approve_group_master_approvers', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_approve_group_master_approvers_root_id'), 'cmf_approve_group_master_approvers', ['root_id'], unique=False) op.create_table('cmf_status_master_approvers', sa.Column('id', sa.String(length=128), nullable=False), sa.Column('parent_id', sa.String(length=64), nullable=True), sa.Column('root_id', sa.String(length=64), nullable=True), sa.Column('description', sa.String(length=4096), nullable=True), sa.Column('left_id', sa.String(length=64), nullable=True), sa.Column('right_id', sa.String(length=64), nullable=True), sa.Column('left_name_cache', sa.String(length=256), nullable=True), sa.Column('right_name_cache', sa.String(length=256), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_cmf_status_master_approvers_left_id'), 'cmf_status_master_approvers', ['left_id'], unique=False) op.create_index(op.f('ix_cmf_status_master_approvers_parent_id'), 'cmf_status_master_approvers', ['parent_id'], unique=False) op.create_index(op.f('ix_cmf_status_master_approvers_right_id'), 'cmf_status_master_approvers', ['right_id'], unique=False) op.create_index(op.f('ix_cmf_status_master_approvers_root_id'), 'cmf_status_master_approvers', ['root_id'], unique=False) op.drop_index('ix_cmf_document_history_cmf_sign_left_id', table_name='cmf_document_history_cmf_sign') op.drop_index('ix_cmf_document_history_cmf_sign_parent_id', table_name='cmf_document_history_cmf_sign') op.drop_index('ix_cmf_document_history_cmf_sign_right_id', table_name='cmf_document_history_cmf_sign') op.drop_index('ix_cmf_document_history_cmf_sign_root_id', table_name='cmf_document_history_cmf_sign') op.drop_table('cmf_document_history_cmf_sign') op.add_column('cmf_document', sa.Column('publish_approved_only', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_document', sa.Column('publish_by_owner_only', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_document', sa.Column('doc_version', sa.BIGINT(), nullable=True)) op.add_column('cmf_document', sa.Column('cur_published_version_id', sa.String(length=64), nullable=True)) op.add_column('cmf_document', sa.Column('cur_workflow_version_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_document_cur_published_version_id'), 'cmf_document', ['cur_published_version_id'], unique=False) op.create_index(op.f('ix_cmf_document_cur_workflow_version_id'), 'cmf_document', ['cur_workflow_version_id'], unique=False) op.create_index(op.f('ix_cmf_document_doc_version'), 'cmf_document', ['doc_version'], unique=False) op.create_foreign_key(None, 'cmf_document', 'cmf_document_history', ['cur_published_version_id'], ['id']) op.create_foreign_key(None, 'cmf_document', 'cmf_document_history', ['cur_workflow_version_id'], ['id']) op.add_column('cmf_document_history', sa.Column('official_number', sa.String(), nullable=True)) op.add_column('cmf_document_history', sa.Column('official_date', sa.TIMESTAMP(timezone=True), nullable=True)) op.add_column('cmf_document_history', sa.Column('cur_workflow', sa.Boolean(), nullable=True)) op.add_column('cmf_document_history', sa.Column('has_published', sa.Boolean(), nullable=True)) op.add_column('cmf_document_history', sa.Column('doc_version', sa.BIGINT(), nullable=True)) op.add_column('cmf_document_history', sa.Column('status_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_document_history_doc_version'), 'cmf_document_history', ['doc_version'], unique=False) op.create_index(op.f('ix_cmf_document_history_status_id'), 'cmf_document_history', ['status_id'], unique=False) op.create_foreign_key(None, 'cmf_document_history', 'cmf_status', ['status_id'], ['id']) op.add_column('cmf_project', sa.Column('publish_approved_only', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_project', sa.Column('publish_by_owner_only', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_scheme_wf', sa.Column('default_document_approve_wf_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_scheme_wf_default_document_approve_wf_id'), 'cmf_scheme_wf', ['default_document_approve_wf_id'], unique=False) op.create_foreign_key(None, 'cmf_scheme_wf', 'cmf_workflow', ['default_document_approve_wf_id'], ['id']) op.add_column('cmf_status', sa.Column('need_approve', sa.Boolean(), nullable=True)) op.add_column('cmf_status', sa.Column('trans_approved_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('trans_rejected_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('trans_updated_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('trans_expired_id', sa.String(length=64), nullable=True)) op.add_column('cmf_status', sa.Column('trans_assigned_id', sa.String(length=64), nullable=True)) op.create_index(op.f('ix_cmf_status_trans_approved_id'), 'cmf_status', ['trans_approved_id'], unique=False) op.create_index(op.f('ix_cmf_status_trans_assigned_id'), 'cmf_status', ['trans_assigned_id'], unique=False) op.create_index(op.f('ix_cmf_status_trans_expired_id'), 'cmf_status', ['trans_expired_id'], unique=False) op.create_index(op.f('ix_cmf_status_trans_rejected_id'), 'cmf_status', ['trans_rejected_id'], unique=False) op.create_index(op.f('ix_cmf_status_trans_updated_id'), 'cmf_status', ['trans_updated_id'], unique=False) op.create_foreign_key(None, 'cmf_status', 'cmf_trans', ['trans_expired_id'], ['id']) op.create_foreign_key(None, 'cmf_status', 'cmf_trans', ['trans_approved_id'], ['id']) op.create_foreign_key(None, 'cmf_status', 'cmf_trans', ['trans_assigned_id'], ['id']) op.create_foreign_key(None, 'cmf_status', 'cmf_trans', ['trans_updated_id'], ['id']) op.create_foreign_key(None, 'cmf_status', 'cmf_trans', ['trans_rejected_id'], ['id']) op.add_column('cmf_workflow', sa.Column('publish_approved_only', sa.Boolean(), nullable=False, server_default='false')) op.add_column('cmf_workflow', sa.Column('publish_by_owner_only', sa.Boolean(), nullable=False, server_default='false')) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_column('cmf_workflow', 'publish_by_owner_only') op.drop_column('cmf_workflow', 'publish_approved_only') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_constraint(None, 'cmf_status', type_='foreignkey') op.drop_index(op.f('ix_cmf_status_trans_updated_id'), table_name='cmf_status') op.drop_index(op.f('ix_cmf_status_trans_rejected_id'), table_name='cmf_status') op.drop_index(op.f('ix_cmf_status_trans_expired_id'), table_name='cmf_status') op.drop_index(op.f('ix_cmf_status_trans_assigned_id'), table_name='cmf_status') op.drop_index(op.f('ix_cmf_status_trans_approved_id'), table_name='cmf_status') op.drop_column('cmf_status', 'trans_assigned_id') op.drop_column('cmf_status', 'trans_expired_id') op.drop_column('cmf_status', 'trans_updated_id') op.drop_column('cmf_status', 'trans_rejected_id') op.drop_column('cmf_status', 'trans_approved_id') op.drop_column('cmf_status', 'need_approve') op.drop_constraint(None, 'cmf_scheme_wf', type_='foreignkey') op.drop_index(op.f('ix_cmf_scheme_wf_default_document_approve_wf_id'), table_name='cmf_scheme_wf') op.drop_column('cmf_scheme_wf', 'default_document_approve_wf_id') op.drop_column('cmf_project', 'publish_by_owner_only') op.drop_column('cmf_project', 'publish_approved_only') op.drop_constraint(None, 'cmf_document_history', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_history_status_id'), table_name='cmf_document_history') op.drop_index(op.f('ix_cmf_document_history_doc_version'), table_name='cmf_document_history') op.drop_column('cmf_document_history', 'status_id') op.drop_column('cmf_document_history', 'doc_version') op.drop_column('cmf_document_history', 'has_published') op.drop_column('cmf_document_history', 'cur_workflow') op.drop_column('cmf_document_history', 'official_date') op.drop_column('cmf_document_history', 'official_number') op.drop_constraint(None, 'cmf_document', type_='foreignkey') op.drop_constraint(None, 'cmf_document', type_='foreignkey') op.drop_index(op.f('ix_cmf_document_doc_version'), table_name='cmf_document') op.drop_index(op.f('ix_cmf_document_cur_workflow_version_id'), table_name='cmf_document') op.drop_index(op.f('ix_cmf_document_cur_published_version_id'), table_name='cmf_document') op.drop_column('cmf_document', 'cur_workflow_version_id') op.drop_column('cmf_document', 'cur_published_version_id') op.drop_column('cmf_document', 'doc_version') op.drop_column('cmf_document', 'publish_by_owner_only') op.drop_column('cmf_document', 'publish_approved_only') op.create_table('cmf_document_history_cmf_sign', sa.Column('id', sa.VARCHAR(length=128), autoincrement=False, nullable=False), sa.Column('parent_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('root_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('description', sa.VARCHAR(length=4096), autoincrement=False, nullable=True), sa.Column('left_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('right_id', sa.VARCHAR(length=64), autoincrement=False, nullable=True), sa.Column('left_name_cache', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.Column('right_name_cache', sa.VARCHAR(length=256), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['left_id'], ['cmf_document_history.id'], name='cmf_document_history_cmf_sign_left_id_fkey'), sa.ForeignKeyConstraint(['right_id'], ['cmf_sign.id'], name='cmf_document_history_cmf_sign_right_id_fkey'), sa.PrimaryKeyConstraint('id', name='cmf_document_history_cmf_sign_pkey') ) op.create_index('ix_cmf_document_history_cmf_sign_root_id', 'cmf_document_history_cmf_sign', ['root_id'], unique=False) op.create_index('ix_cmf_document_history_cmf_sign_right_id', 'cmf_document_history_cmf_sign', ['right_id'], unique=False) op.create_index('ix_cmf_document_history_cmf_sign_parent_id', 'cmf_document_history_cmf_sign', ['parent_id'], unique=False) op.create_index('ix_cmf_document_history_cmf_sign_left_id', 'cmf_document_history_cmf_sign', ['left_id'], unique=False) op.drop_index(op.f('ix_cmf_status_master_approvers_root_id'), table_name='cmf_status_master_approvers') op.drop_index(op.f('ix_cmf_status_master_approvers_right_id'), table_name='cmf_status_master_approvers') op.drop_index(op.f('ix_cmf_status_master_approvers_parent_id'), table_name='cmf_status_master_approvers') op.drop_index(op.f('ix_cmf_status_master_approvers_left_id'), table_name='cmf_status_master_approvers') op.drop_table('cmf_status_master_approvers') op.drop_index(op.f('ix_cmf_approve_group_master_approvers_root_id'), table_name='cmf_approve_group_master_approvers') op.drop_index(op.f('ix_cmf_approve_group_master_approvers_right_id'), table_name='cmf_approve_group_master_approvers') op.drop_index(op.f('ix_cmf_approve_group_master_approvers_parent_id'), table_name='cmf_approve_group_master_approvers') op.drop_index(op.f('ix_cmf_approve_group_master_approvers_left_id'), table_name='cmf_approve_group_master_approvers') op.drop_table('cmf_approve_group_master_approvers') op.drop_index(op.f('ix_cmf_approve_group_approvers_root_id'), table_name='cmf_approve_group_approvers') op.drop_index(op.f('ix_cmf_approve_group_approvers_right_id'), table_name='cmf_approve_group_approvers') op.drop_index(op.f('ix_cmf_approve_group_approvers_parent_id'), table_name='cmf_approve_group_approvers') op.drop_index(op.f('ix_cmf_approve_group_approvers_left_id'), table_name='cmf_approve_group_approvers') op.drop_table('cmf_approve_group_approvers') op.drop_index(op.f('ix_cmf_approve_group_tree_parent_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_root_parent_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_perm_parent_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_perm_acl_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_parent_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_orderno'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_name'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_code'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_viewed_at'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_version'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_owner_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_modified_by_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_modified_at'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_locked_by_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_locked_at'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_import_id'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_deleted'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_created_at'), table_name='cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_group_cmf_author_id'), table_name='cmf_approve_group') op.drop_table('cmf_approve_group') op.drop_index(op.f('ix_cmf_approve_tree_parent_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_root_parent_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_perm_parent_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_perm_acl_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_parent_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_orderno'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_obj_version'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_obj_status_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_obj_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_name'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_code'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_viewed_at'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_version'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_owner_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_modified_by_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_modified_at'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_locked_by_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_locked_at'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_import_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_deleted'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_created_at'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_cmf_author_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_approver_id'), table_name='cmf_approve') op.drop_index(op.f('ix_cmf_approve_approve_group_id'), table_name='cmf_approve') op.drop_table('cmf_approve') # ### end Alembic commands ###