| 1234567891011121314151617181920212223242526272829303132 |
- """edit_CropCd_input
- Revision ID: 81b859325353
- Revises: a2cfbc6c2673
- Create Date: 2025-07-17 15:02:31.471682
- """
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = '81b859325353'
- down_revision = 'a2cfbc6c2673'
- branch_labels = None
- depends_on = None
- def upgrade():
- """升级数据库到当前版本"""
- # ### commands auto generated by Alembic - please adjust! ###
- op.add_column('CropCd_input_data', sa.Column('AvaP_IDW', sa.Float(), nullable=True, comment='速效钾(mg/kg)（对应Soil_data.AvaK_IDW）'))
- op.drop_column('CropCd_input_data', 'AvaP')
- # ### end Alembic commands ###
- def downgrade():
- """将数据库降级到上一版本"""
- # ### commands auto generated by Alembic - please adjust! ###
- op.add_column('CropCd_input_data', sa.Column('AvaP', sa.DOUBLE_PRECISION(precision=53), autoincrement=False, nullable=True, comment='速效钾(mg/kg)（对应Soil_data.AvaK_IDW）'))
- op.drop_column('CropCd_input_data', 'AvaP_IDW')
- # ### end Alembic commands ###
|
