migrations/versions/7def3e843d04_.py

   1 """empty message
   2
   3 Revision ID: 7def3e843d04
   4 Revises: dce69ad1e4eb
   5 Create Date: 2019-01-28 20:27:33.760232
   6
   7 """
   8 from alembic import op
   9 import sqlalchemy as sa
  10 from sqlalchemy.dialects import postgresql
  11
  12 # revision identifiers, used by Alembic.
  13 revision = '7def3e843d04'
  14 down_revision = 'dce69ad1e4eb'
  15 branch_labels = None
  16 depends_on = None
  17
  18
  19 def upgrade():
  20     # ### commands auto generated by Alembic - please adjust! ###
  21     op.create_table('minetest_release',
  22     sa.Column('id', sa.Integer(), nullable=False),
  23     sa.Column('name', sa.String(length=100), nullable=False),
  24     sa.PrimaryKeyConstraint('id'),
  25     sa.UniqueConstraint('name')
  26     )
  27     op.add_column('package_release', sa.Column('max_rel_id', sa.Integer(), nullable=True, server_default=None))
  28     op.add_column('package_release', sa.Column('min_rel_id', sa.Integer(), nullable=True, server_default=None))
  29     op.create_foreign_key(None, 'package_release', 'minetest_release', ['max_rel_id'], ['id'])
  30     op.create_foreign_key(None, 'package_release', 'minetest_release', ['min_rel_id'], ['id'])
  31     # ### end Alembic commands ###
  32
  33
  34 def downgrade():
  35     # ### commands auto generated by Alembic - please adjust! ###
  36     op.drop_constraint(None, 'package_release', type_='foreignkey')
  37     op.drop_constraint(None, 'package_release', type_='foreignkey')
  38     op.drop_column('package_release', 'min_rel_id')
  39     op.drop_column('package_release', 'max_rel_id')
  40     op.drop_table('minetest_release')
  41     # ### end Alembic commands ###