2023081625_increase_slot_datamodel_5fcd397aae72.py 1.0 KB

123456789101112131415161718192021222324252627282930313233343536
  1. """increase_slot_datamodel
  2. Revision ID: 5fcd397aae72
  3. Revises: 4f1ef609b19a
  4. Create Date: 2023-08-16 22:25:30.650590
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = "5fcd397aae72"
  10. down_revision = "4f1ef609b19a"
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. # ### commands auto generated by Alembic - please adjust! ###
  15. op.add_column("slots", sa.Column("place", sa.String(), nullable=False, server_default=""))
  16. op.add_column(
  17. "slots",
  18. sa.Column("responsibleContact", sa.String(), nullable=False, server_default=""),
  19. )
  20. op.alter_column("volunteers", "surname", existing_type=sa.VARCHAR(length=128), nullable=False)
  21. # ### end Alembic commands ###
  22. def downgrade():
  23. # ### commands auto generated by Alembic - please adjust! ###
  24. op.alter_column("volunteers", "surname", existing_type=sa.VARCHAR(length=128), nullable=True)
  25. op.drop_column("slots", "responsibleContact")
  26. op.drop_column("slots", "place")
  27. # ### end Alembic commands ###