ALTER TABLE irrigation_monitoring.t_site_manage CHANGE monitor_indicator_id site_type varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '站点类型';
ALTER TABLE irrigation_monitoring.t_site_manage MODIFY COLUMN unit_id bigint NOT NULL COMMENT '管理单位id';
ALTER TABLE irrigation_monitoring.t_site_manage MODIFY COLUMN monitor_type varchar(20) NOT NULL COMMENT '监测方式';

ALTER TABLE irrigation_monitoring.t_monitor_point ADD COLUMN `bind_template_id` BIGINT(20) NULL COMMENT '模板id' AFTER `device_id`;

--  2024-11-11
ALTER TABLE `t_monitor_point`
    CHANGE COLUMN `monitor_type` `monitor_type` TINYINT(1) NULL DEFAULT NULL COMMENT '监测方式 人工  1   遥测  2' COLLATE 'utf8_general_ci' AFTER `formula_param_value`,
    CHANGE COLUMN `flow_type` `flow_type` TINYINT(1) NULL DEFAULT NULL COMMENT '量水方式   标准化断面  1   水位流量关系  2   设备直报  3' COLLATE 'utf8_general_ci' AFTER `monitor_type`;