"""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 ###