Digitale bierlijst

a09086bfe84c_create_persons_table.py 506B

1234567891011121314151617181920212223242526272829
  1. """Create persons table
  2. Revision ID: a09086bfe84c
  3. Revises:
  4. Create Date: 2018-08-19 21:03:55.857085
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = 'a09086bfe84c'
  10. down_revision = None
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. op.create_table(
  15. 'people',
  16. sa.Column('person_id', sa.Integer, primary_key=True),
  17. sa.Column('name', sa.String, nullable=False)
  18. )
  19. def downgrade():
  20. op.drop_table('people')