shuqianpinggu/migrations/versions/32ecb1594990_change_some_fi...
WIN-T9V3LPE8NK2\Administrator 4911f3024f 主分支
2025-06-17 17:46:44 +08:00

33 lines
1.0 KiB
Python

"""change some field to Message model
Revision ID: 32ecb1594990
Revises: 3815753f265c
Create Date: 2025-03-24 16:38:51.036123
"""
from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import mysql
# revision identifiers, used by Alembic.
revision = '32ecb1594990'
down_revision = '3815753f265c'
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Messages', sa.Column('content', sa.String(length=500), nullable=True))
op.drop_column('Messages', 'answer')
op.drop_column('Messages', 'question')
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Messages', sa.Column('question', mysql.VARCHAR(collation='utf8mb4_general_ci', length=500), nullable=True))
op.add_column('Messages', sa.Column('answer', mysql.TEXT(collation='utf8mb4_general_ci'), nullable=True))
op.drop_column('Messages', 'content')
# ### end Alembic commands ###