"""empty message Revision ID: 026e6bde589e Revises: 6d8a938930ff Create Date: 2020-04-27 12:28:08.979541 """ from alembic import op import sqlalchemy as sa from sqlalchemy.dialects import postgresql # revision identifiers, used by Alembic. revision = '026e6bde589e' down_revision = '6d8a938930ff' branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_table('blockchain_transaction') # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('blockchain_transaction', sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False), sa.Column('created', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('submitted_date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('added_date', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('hash', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('credit_transfer_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('authorising_user_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('updated', postgresql.TIMESTAMP(), autoincrement=False, nullable=True), sa.Column('block', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('status', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('transaction_type', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('message', sa.VARCHAR(), autoincrement=False, nullable=True), sa.Column('signing_blockchain_address_id', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('nonce', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('has_output_txn', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.Column('is_bitcoin', sa.BOOLEAN(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['credit_transfer_id'], ['credit_transfer.id'], name='blockchain_transaction_credit_transfer_id_fkey'), sa.ForeignKeyConstraint(['signing_blockchain_address_id'], ['blockchain_address.id'], name='blockchain_transaction_signing_blockchain_address_id_fkey'), sa.PrimaryKeyConstraint('id', name='blockchain_transaction_pkey') ) # ### end Alembic commands ###