43e67e4ab3f6_fiftythousandsurvey_comment.py 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238
  1. """FiftyThousandSurvey_comment
  2. Revision ID: 43e67e4ab3f6
  3. Revises: 781090b305e2
  4. Create Date: 2025-07-19 16:55:37.108093
  5. """
  6. from alembic import op
  7. import sqlalchemy as sa
  8. # revision identifiers, used by Alembic.
  9. revision = '43e67e4ab3f6'
  10. down_revision = '781090b305e2'
  11. branch_labels = None
  12. depends_on = None
  13. def upgrade():
  14. """升级数据库到当前版本"""
  15. # ### commands auto generated by Alembic - please adjust! ###
  16. # 为五万亩调查数据表添加comment
  17. op.execute("COMMENT ON TABLE fifty_thousand_survey_data IS '五万亩调查数据表'")
  18. # 为五万亩调查数据表的列添加comment
  19. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.gid IS '主键ID'")
  20. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.id IS '编号'")
  21. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dwmc IS '点位原始编码'")
  22. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.r_dwmc IS '点位重编码'")
  23. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lat IS '位置信息-纬度'")
  24. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lon IS '位置信息-经度'")
  25. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.xmc IS '位置信息-县名称'")
  26. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zmc IS '位置信息-镇名称'")
  27. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cmc IS '位置信息-村名称'")
  28. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cd IS '土壤单全量-镉(mg/kg)'")
  29. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_as IS '土壤单全量-砷(mg/kg)'")
  30. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_pb IS '土壤单全量-铅(mg/kg)'")
  31. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph IS 'pH值'")
  32. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_cd IS '早稻米-镉(mg/kg)'")
  33. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_as IS '早稻米-砷(mg/kg)'")
  34. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_pb IS '早稻米-铅(mg/kg)'")
  35. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_cd IS '晚稻米-镉(mg/kg)'")
  36. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_as IS '晚稻米-砷(mg/kg)'")
  37. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_pb IS '晚稻米-铅(mg/kg)'")
  38. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_cd IS '土壤参比值-镉(mg/kg)'")
  39. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_as IS '土壤参比值-砷(mg/kg)'")
  40. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_pb IS '土壤参比值-铅(mg/kg)'")
  41. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_cd IS '稻米参比值-镉(mg/kg)'")
  42. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_as IS '稻米参比值-砷(mg/kg)'")
  43. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_pb IS '稻米参比值-铅(mg/kg)'")
  44. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd IS '土壤指数-镉(mg/kg)'")
  45. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as IS '土壤指数-砷(mg/kg)'")
  46. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb IS '土壤指数-铅(mg/kg)'")
  47. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_cd IS '早造米指数-镉(mg/kg)'")
  48. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_as IS '早造米指数-砷(mg/kg)'")
  49. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_pb IS '早造米指数-铅(mg/kg)'")
  50. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_cd IS '晚造米指数-镉(mg/kg)'")
  51. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_as IS '晚造米指数-砷(mg/kg)'")
  52. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_pb IS '晚造米指数-铅(mg/kg)'")
  53. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_max IS '土壤综合指数'")
  54. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_max IS '稻米综合指数'")
  55. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_tfj_max IS '综合指数分级'")
  56. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_mfj_max IS '综合指数分级'")
  57. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_tfj_max IS '环保97号文土壤指数分级'")
  58. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_mfj_max IS '环保98号文稻米指数分级'")
  59. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pdtj IS '综合风险等级代码'")
  60. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_pdtj IS '土壤环境质量类别代码'")
  61. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_xtfx IS '综合风险等级'")
  62. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_xtfx IS '土壤环境质量类别'")
  63. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_max IS '单金属最大米指数'")
  64. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_max IS '单金属最大米指数'")
  65. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pd_max IS '单金属最大米指数'")
  66. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd_fj IS '按土壤指数分级'")
  67. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as_fj IS '按土壤指数分级'")
  68. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb_fj IS '按土壤指数分级'")
  69. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_fj IS '按稻米指数分级'")
  70. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_fj IS '按稻米指数分级'")
  71. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pb_fj IS '按稻米指数分级'")
  72. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj IS '单金属风险代码'")
  73. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj1 IS '单金属风险代码'")
  74. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_pdtj IS '单金属风险代码'")
  75. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_xtfx IS '单金属协同风险等级'")
  76. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_xtfx IS '单金属协同风险等级'")
  77. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_xtfx IS '单金属协同风险等级'")
  78. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_fz IS '镉分风险分级'")
  79. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_fz IS '砷分风险分级'")
  80. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_pdtj IS '镉-砷复合污染分级代码'")
  81. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_fhwr IS '镉-砷复合污染分级代码'")
  82. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx IS '镉-砷复合污染分级'")
  83. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx_pb IS '铅是否有风险'")
  84. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cec__cmol_ IS '阳离子交换容量(cmol/kg)'")
  85. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tom_g_kg_ IS '土壤有机质(g/kg)'")
  86. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_cd IS '单金属稻米最大值'")
  87. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_as IS '单金属稻米最大值'")
  88. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_pb IS '单金属稻米最大值'")
  89. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_cd IS '稻米富集系数'")
  90. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_as IS '稻米富集系数'")
  91. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_pb IS '稻米富集系数'")
  92. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_g_kg_ IS '粘粒'")
  93. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_g_kg_ IS '粘粒'")
  94. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_g_kg_ IS '粘粒'")
  95. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_zb IS '黏粒占比'")
  96. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_zb IS '粉粒占比'")
  97. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_zb IS '砂粒占比'")
  98. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.trlx IS '土壤质地'")
  99. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_cd IS '土壤单金属提取态'")
  100. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lin_suan_er_qing_an IS '土壤单金属提取态'")
  101. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_pb IS '土壤单金属提取态'")
  102. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_cd IS '土壤单金v属提取态占比'")
  103. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_as IS '土壤单金属提取态占比'")
  104. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_pb IS '土壤单金属提取态占比'")
  105. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cr IS '土壤单金属全量'")
  106. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_hg IS '土壤单金属全量'")
  107. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_2_00mm IS '土壤机械组成数据>2.00mm粒径分布'")
  108. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"2_1mm\" IS '土壤机械组成数据2-1mm粒径分布'")
  109. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"1_0_5mm\" IS '土壤机械组成数据1-0.5mm粒径分布'")
  110. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_5_0_25mm\" IS '土壤机械组成数据0.5-0.25mm粒径分布'")
  111. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_25_0_05m\" IS '土壤机械组成数据0.25-0.05mm粒径分布'")
  112. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_05_0_02m\" IS '土壤机械组成数据0.05-0.02mm粒径分布'")
  113. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_02_0_002\" IS '土壤机械组成数据0.02-0.002mm粒径分布'")
  114. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_0_002mm IS '土壤机械组成数据<0.002mm粒径分布'")
  115. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj IS 'pH值分级1'")
  116. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj_2 IS 'pH值分级2'")
  117. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.geom IS '几何位置信息'")
  118. # ### end Alembic commands ###
  119. def downgrade():
  120. """将数据库降级到上一版本"""
  121. # ### commands auto generated by Alembic - please adjust! ###
  122. # 移除五万亩调查数据表的comment
  123. op.execute("COMMENT ON TABLE fifty_thousand_survey_data IS NULL")
  124. # 移除五万亩调查数据表的列comment
  125. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.gid IS NULL")
  126. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.id IS NULL")
  127. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dwmc IS NULL")
  128. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.r_dwmc IS NULL")
  129. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lat IS NULL")
  130. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lon IS NULL")
  131. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.xmc IS NULL")
  132. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zmc IS NULL")
  133. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cmc IS NULL")
  134. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cd IS NULL")
  135. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_as IS NULL")
  136. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_pb IS NULL")
  137. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph IS NULL")
  138. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_cd IS NULL")
  139. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_as IS NULL")
  140. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zzm_pb IS NULL")
  141. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_cd IS NULL")
  142. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_as IS NULL")
  143. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wzm_pb IS NULL")
  144. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_cd IS NULL")
  145. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_as IS NULL")
  146. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tcb_pb IS NULL")
  147. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_cd IS NULL")
  148. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_as IS NULL")
  149. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mcb_pb IS NULL")
  150. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd IS NULL")
  151. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as IS NULL")
  152. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb IS NULL")
  153. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_cd IS NULL")
  154. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_as IS NULL")
  155. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.z_mzs_pb IS NULL")
  156. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_cd IS NULL")
  157. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_as IS NULL")
  158. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.w_mzs_pb IS NULL")
  159. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_max IS NULL")
  160. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_max IS NULL")
  161. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_tfj_max IS NULL")
  162. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_mfj_max IS NULL")
  163. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_tfj_max IS NULL")
  164. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_mfj_max IS NULL")
  165. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pdtj IS NULL")
  166. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_pdtj IS NULL")
  167. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_xtfx IS NULL")
  168. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.h_xtfx IS NULL")
  169. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_max IS NULL")
  170. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_max IS NULL")
  171. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pd_max IS NULL")
  172. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_cd_fj IS NULL")
  173. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_as_fj IS NULL")
  174. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tzs_pb_fj IS NULL")
  175. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_cd_fj IS NULL")
  176. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_as_fj IS NULL")
  177. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mzs_pb_fj IS NULL")
  178. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj IS NULL")
  179. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_pdtj1 IS NULL")
  180. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_pdtj IS NULL")
  181. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_xtfx IS NULL")
  182. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_xtfx IS NULL")
  183. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_pb_xtfx IS NULL")
  184. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_cd_fz IS NULL")
  185. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.s_as_fz IS NULL")
  186. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_pdtj IS NULL")
  187. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cd_as_fhwr IS NULL")
  188. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx IS NULL")
  189. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.wrlx_pb IS NULL")
  190. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.cec__cmol_ IS NULL")
  191. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tom_g_kg_ IS NULL")
  192. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_cd IS NULL")
  193. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_as IS NULL")
  194. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.mmax_pb IS NULL")
  195. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_cd IS NULL")
  196. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_as IS NULL")
  197. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.bcf_pb IS NULL")
  198. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_g_kg_ IS NULL")
  199. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_g_kg_ IS NULL")
  200. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_g_kg_ IS NULL")
  201. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.nl_zb IS NULL")
  202. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.fl_zb IS NULL")
  203. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.sl_zb IS NULL")
  204. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.trlx IS NULL")
  205. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_cd IS NULL")
  206. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.lin_suan_er_qing_an IS NULL")
  207. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.dtpa_pb IS NULL")
  208. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_cd IS NULL")
  209. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_as IS NULL")
  210. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.zb_pb IS NULL")
  211. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_cr IS NULL")
  212. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.tql_hg IS NULL")
  213. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_2_00mm IS NULL")
  214. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"2_1mm\" IS NULL")
  215. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"1_0_5mm\" IS NULL")
  216. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_5_0_25mm\" IS NULL")
  217. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_25_0_05m\" IS NULL")
  218. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_05_0_02m\" IS NULL")
  219. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.\"0_02_0_002\" IS NULL")
  220. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.f_0_002mm IS NULL")
  221. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj IS NULL")
  222. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.ph_fj_2 IS NULL")
  223. op.execute("COMMENT ON COLUMN fifty_thousand_survey_data.geom IS NULL")
  224. # ### end Alembic commands ###