9fafbd60eca1_add_message_file_belongs_to.py 830 B

1234567891011121314151617181920212223242526272829303132
  1. """add message file belongs to
  2. Revision ID: 9fafbd60eca1
  3. Revises: 4823da1d26cf
  4. Create Date: 2024-01-15 13:07:20.340896
  5. """
  6. import sqlalchemy as sa
  7. from alembic import op
  8. # revision identifiers, used by Alembic.
  9. revision = '9fafbd60eca1'
  10. down_revision = '4823da1d26cf'
  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('message_files', schema=None) as batch_op:
  16. batch_op.add_column(sa.Column('belongs_to', sa.String(length=255), nullable=True))
  17. # ### end Alembic commands ###
  18. def downgrade():
  19. # ### commands auto generated by Alembic - please adjust! ###
  20. with op.batch_alter_table('message_files', schema=None) as batch_op:
  21. batch_op.drop_column('belongs_to')
  22. # ### end Alembic commands ###