"""FiftyThousandSurvey_comment

Revision ID: 43e67e4ab3f6
Revises: 781090b305e2
Create Date: 2025-07-19 16:55:37.108093

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '43e67e4ab3f6'
down_revision = '781090b305e2'
branch_labels = None
depends_on = None


def upgrade():
    """升级数据库到当前版本"""
    # ### commands auto generated by Alembic - please adjust! ###
    
    # 为五万亩调查数据表添加comment
    op.execute("COMMENT ON TABLE fifty_thousand_survey_data IS '五万亩调查数据表'")
    
    # 为五万亩调查数据表的列添加comment
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.gid IS '主键ID'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.id IS '编号'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dwmc IS '点位原始编码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.r_dwmc IS '点位重编码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lat IS '位置信息-纬度'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lon IS '位置信息-经度'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.xmc IS '位置信息-县名称'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zmc IS '位置信息-镇名称'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cmc IS '位置信息-村名称'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cd IS '土壤单全量-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_as IS '土壤单全量-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_pb IS '土壤单全量-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph IS 'pH值'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_cd IS '早稻米-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_as IS '早稻米-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_pb IS '早稻米-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_cd IS '晚稻米-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_as IS '晚稻米-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_pb IS '晚稻米-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_cd IS '土壤参比值-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_as IS '土壤参比值-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_pb IS '土壤参比值-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_cd IS '稻米参比值-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_as IS '稻米参比值-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_pb IS '稻米参比值-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd IS '土壤指数-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as IS '土壤指数-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb IS '土壤指数-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_cd IS '早造米指数-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_as IS '早造米指数-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_pb IS '早造米指数-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_cd IS '晚造米指数-镉(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_as IS '晚造米指数-砷(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_pb IS '晚造米指数-铅(mg/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_max IS '土壤综合指数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_max IS '稻米综合指数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_tfj_max IS '综合指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_mfj_max IS '综合指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_tfj_max IS '环保97号文土壤指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_mfj_max IS '环保98号文稻米指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pdtj IS '综合风险等级代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_pdtj IS '土壤环境质量类别代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_xtfx IS '综合风险等级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_xtfx IS '土壤环境质量类别'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_max IS '单金属最大米指数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_max IS '单金属最大米指数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pd_max IS '单金属最大米指数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd_fj IS '按土壤指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as_fj IS '按土壤指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb_fj IS '按土壤指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_fj IS '按稻米指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_fj IS '按稻米指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pb_fj IS '按稻米指数分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj IS '单金属风险代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj1 IS '单金属风险代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_pdtj IS '单金属风险代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_xtfx IS '单金属协同风险等级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_xtfx IS '单金属协同风险等级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_xtfx IS '单金属协同风险等级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_fz IS '镉分风险分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_fz IS '砷分风险分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_pdtj IS '镉-砷复合污染分级代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_fhwr IS '镉-砷复合污染分级代码'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx IS '镉-砷复合污染分级'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx_pb IS '铅是否有风险'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cec__cmol_ IS '阳离子交换容量(cmol/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tom_g_kg_ IS '土壤有机质(g/kg)'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_cd IS '单金属稻米最大值'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_as IS '单金属稻米最大值'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_pb IS '单金属稻米最大值'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_cd IS '稻米富集系数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_as IS '稻米富集系数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_pb IS '稻米富集系数'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_g_kg_ IS '粘粒'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_g_kg_ IS '粘粒'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_g_kg_ IS '粘粒'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_zb IS '黏粒占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_zb IS '粉粒占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_zb IS '砂粒占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.trlx IS '土壤质地'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_cd IS '土壤单金属提取态'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lin_suan_er_qing_an IS '土壤单金属提取态'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_pb IS '土壤单金属提取态'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_cd IS '土壤单金v属提取态占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_as IS '土壤单金属提取态占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_pb IS '土壤单金属提取态占比'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cr IS '土壤单金属全量'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_hg IS '土壤单金属全量'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_2_00mm IS '土壤机械组成数据>2.00mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"2_1mm\" IS '土壤机械组成数据2-1mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"1_0_5mm\" IS '土壤机械组成数据1-0.5mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_5_0_25mm\" IS '土壤机械组成数据0.5-0.25mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_25_0_05m\" IS '土壤机械组成数据0.25-0.05mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_05_0_02m\" IS '土壤机械组成数据0.05-0.02mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_02_0_002\" IS '土壤机械组成数据0.02-0.002mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_0_002mm IS '土壤机械组成数据<0.002mm粒径分布'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj IS 'pH值分级1'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj_2 IS 'pH值分级2'")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.geom IS '几何位置信息'")
    
    # ### end Alembic commands ###


def downgrade():
    """将数据库降级到上一版本"""
    # ### commands auto generated by Alembic - please adjust! ###
    
    # 移除五万亩调查数据表的comment
    op.execute("COMMENT ON TABLE fifty_thousand_survey_data IS NULL")
    
    # 移除五万亩调查数据表的列comment
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.gid IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.id IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dwmc IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.r_dwmc IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lat IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lon IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.xmc IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zmc IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cmc IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_tfj_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_mfj_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_tfj_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_mfj_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pdtj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_pdtj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_xtfx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_xtfx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pd_max IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pb_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj1 IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_pdtj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_xtfx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_xtfx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_xtfx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_fz IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_fz IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_pdtj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_fhwr IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cec__cmol_ IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tom_g_kg_ IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_g_kg_ IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_g_kg_ IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_g_kg_ IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_zb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_zb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_zb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.trlx IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lin_suan_er_qing_an IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_cd IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_as IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_pb IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cr IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_hg IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_2_00mm IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"2_1mm\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"1_0_5mm\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_5_0_25mm\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_25_0_05m\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_05_0_02m\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_02_0_002\" IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_0_002mm IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj_2 IS NULL")
    op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.geom IS NULL")
    
    # ### end Alembic commands ###