# -*- coding: utf-8 -*- ########################################################################### # Copyright (c), The AiiDA team. All rights reserved. # # This file is part of the AiiDA code. # # # # The code is hosted on GitHub at https://github.com/aiidateam/aiida-core # # For further information on the license, see the LICENSE.txt file # # For further information please visit http://www.aiida.net # ########################################################################### # pylint: disable=invalid-name,no-member """Drop the DbCalcState table Revision ID: 162b99bca4a2 Revises: a603da2cc809 Create Date: 2018-11-14 08:37:13.719646 """ from alembic import op from sqlalchemy.dialects import postgresql import sqlalchemy as sa # revision identifiers, used by Alembic. revision = '162b99bca4a2' down_revision = 'a603da2cc809' branch_labels = None depends_on = None [docs]def upgrade(): op.drop_table('db_dbcalcstate') [docs]def downgrade(): op.create_table( 'db_dbcalcstate', sa.Column('id', sa.INTEGER(), nullable=False), sa.Column('dbnode_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('state', sa.VARCHAR(length=255), autoincrement=False, nullable=True), sa.Column('time', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['dbnode_id'], ['db_dbnode.id'], name='db_dbcalcstate_dbnode_id_fkey', ondelete='CASCADE', initially='DEFERRED', deferrable=True), sa.PrimaryKeyConstraint('id', name='db_dbcalcstate_pkey'), sa.UniqueConstraint('dbnode_id', 'state', name='db_dbcalcstate_dbnode_id_state_key') )