cd0e9c173a7f_initial_migration.py 1017 B

123456789101112131415161718192021222324252627282930313233343536
  1. """initial migration
  2. Revision ID: cd0e9c173a7f
  3. Revises:
  4. Create Date: 2023-07-18 15:53:06.213349
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = 'cd0e9c173a7f'
  10. down_revision = None
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. # ### commands auto generated by Alembic - please adjust! ###
  15. with op.batch_alter_table('link', schema=None) as batch_op:
  16. batch_op.add_column(sa.Column('hit_count', sa.Integer(), nullable=True))
  17. batch_op.add_column(sa.Column('owner_name', sa.String(length=255), nullable=True))
  18. batch_op.create_unique_constraint(None, ['name'])
  19. # ### end Alembic commands ###
  20. def downgrade():
  21. # ### commands auto generated by Alembic - please adjust! ###
  22. with op.batch_alter_table('link', schema=None) as batch_op:
  23. batch_op.drop_constraint(None, type_='unique')
  24. batch_op.drop_column('owner_name')
  25. batch_op.drop_column('hit_count')
  26. # ### end Alembic commands ###