--#已更新
ALTER TABLE `newfiber_standard_termite`.`ter_project_info`
ADD COLUMN `production_users` VARCHAR(512) NULL COMMENT '生产人员' AFTER `field_explain`,
ADD COLUMN `install_users` VARCHAR(512) NULL COMMENT '安装人员' AFTER `production_users`,
ADD COLUMN `analysis_users` VARCHAR(512) NULL COMMENT '分析人员' AFTER `install_users`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `category` VARCHAR(32) NULL DEFAULT 'project' COMMENT '分类（生产 production | 项目 project）' AFTER `id`;

ALTER TABLE `newfiber_standard_termite`.`ter_project_info`
ADD COLUMN `center_point` VARCHAR(128) NULL COMMENT '地图中心点' AFTER `analysis_users`;

--#已更新 0527
ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `first_warn_datetime` DATETIME NULL COMMENT '首次报警时间（连续3次手动确认则报警）' AFTER `last_pic_time`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data`
ADD COLUMN `heating` VARCHAR(1) NULL DEFAULT '2' COMMENT '是否加热（1是 | 2否）' AFTER `druing`;
ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data_realtime`
ADD COLUMN `heating` VARCHAR(1) NULL DEFAULT '2' COMMENT '是否加热（1是 | 2否）' AFTER `druing`;
ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data`
ADD COLUMN `druing_datetime` DATETIME NULL COMMENT '投药时间' AFTER `druing`,
ADD COLUMN `heating_datetime` DATETIME NULL COMMENT '加热时间' AFTER `heating`;
ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data_realtime`
ADD COLUMN `druing_datetime` DATETIME NULL COMMENT '投药时间' AFTER `druing`,
ADD COLUMN `heating_datetime` DATETIME NULL COMMENT '加热时间' AFTER `heating`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `remark` VARCHAR(45) NULL AFTER `first_warn_datetime`,
ADD COLUMN `status` VARCHAR(16) NULL AFTER `remark`,
ADD COLUMN `create_by` VARCHAR(64) NULL AFTER `status`,
ADD COLUMN `create_time` DATETIME NULL AFTER `create_by`,
ADD COLUMN `update_by` VARCHAR(64) NULL AFTER `create_time`,
ADD COLUMN `update_time` DATETIME NULL AFTER `update_by`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data`
ADD COLUMN `remark` VARCHAR(45) NULL AFTER `camera`,
ADD COLUMN `status` VARCHAR(16) NULL AFTER `remark`,
ADD COLUMN `create_by` VARCHAR(64) NULL AFTER `status`,
ADD COLUMN `create_time` DATETIME NULL AFTER `create_by`,
ADD COLUMN `update_by` VARCHAR(64) NULL AFTER `create_time`,
ADD COLUMN `update_time` DATETIME NULL AFTER `update_by`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data_realtime`
ADD COLUMN `remark` VARCHAR(45) NULL AFTER `camera`,
ADD COLUMN `status` VARCHAR(16) NULL AFTER `remark`,
ADD COLUMN `create_by` VARCHAR(64) NULL AFTER `status`,
ADD COLUMN `create_time` DATETIME NULL AFTER `create_by`,
ADD COLUMN `update_by` VARCHAR(64) NULL AFTER `create_time`,
ADD COLUMN `update_time` DATETIME NULL AFTER `update_by`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data`
ADD COLUMN `del_flag` CHAR(1) NULL AFTER `update_time`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_monitoring_data_realtime`
ADD COLUMN `del_flag` CHAR(1) NULL AFTER `update_time`;

update ter_device_info set del_flag = 0;
update ter_device_monitoring_data_realtime set del_flag = 0;
update ter_device_monitoring_data set del_flag = 0;

--已更新 0603
ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
 ADD COLUMN  `software` varchar(255) DEFAULT NULL COMMENT '软件版本' AFTER `first_warn_datetime`,
 ADD COLUMN  `hardware` varchar(255) DEFAULT NULL COMMENT '硬件版本' AFTER `software`,
 ADD COLUMN  `voltage` varchar(255) DEFAULT NULL COMMENT '电压' AFTER `hardware`,
 ADD COLUMN  `temperature` varchar(255) DEFAULT NULL COMMENT '温度' AFTER `voltage`,
 ADD COLUMN  `rssi` varchar(100) DEFAULT NULL  COMMENT '信号质量' AFTER `temperature`,
 ADD COLUMN  `ap` varchar(100) DEFAULT NULL COMMENT '中继名称'  AFTER `rssi`,
 ADD COLUMN  `camera` varchar(100) DEFAULT NULL  COMMENT '摄像头' AFTER `ap`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD UNIQUE INDEX `index2` (`sn` ASC);

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `extend_config` VARCHAR(1024) NULL COMMENT '扩展配置（JSON）' AFTER `lonandlat`,
CHANGE COLUMN `del_flag` `del_flag` VARCHAR(1) NULL DEFAULT '0' COMMENT '逻辑删除  0：否 1：是' AFTER `remark`;

ALTER TABLE `newfiber_standard_termite`.`ter_device_info`
ADD COLUMN `sync_state` VARCHAR(32) NULL DEFAULT 'success' COMMENT '同步状态（成功 success | 失败 fail）' AFTER `camera`;

-- 已更新 0613
CREATE TABLE `thi_jingchu_device_config` (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `sn` varchar(100) DEFAULT NULL COMMENT '设备sn',
  `order` varchar(32) DEFAULT NULL COMMENT '白蚁设备安装的点位顺序（自定义6位数）',
  `upload_confirm_flag` char(1) DEFAULT '0' COMMENT '是否上传有白蚁数据（减少误报（0 否 | 1 是））',
  `remark` varchar(45) DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL,
  `create_by` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `del_flag` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `index2` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='三方对接-荆楚平台设备信息';

CREATE TABLE `thi_jingchu_project_config` (
  `id` bigint(20) NOT NULL COMMENT '主键id',
  `project_code` varchar(100) DEFAULT NULL COMMENT '项目编号',
  `mn_no` varchar(64) DEFAULT NULL COMMENT '设备编码',
  `station_id` int(11) DEFAULT NULL COMMENT '中心站地址',
  `station_name` varchar(128) DEFAULT NULL COMMENT '站点名称',
  `device_id` int(11) DEFAULT NULL COMMENT '设备id',
  `device_name` varchar(64) DEFAULT NULL COMMENT '设备名称',
  `remark` varchar(45) DEFAULT NULL,
  `status` varchar(16) DEFAULT NULL,
  `create_by` varchar(64) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(64) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `del_flag` char(1) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `index2` (`project_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='三方对接-荆楚平台项目信息';