SHJX_GM/SHJXCamera/hypermanganate_database.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80028
Source Host           : localhost:3306
Source Database       : hypermanganate_database

Target Server Type    : MYSQL
Target Server Version : 80028
File Encoding         : 65001

Date: 2023-09-07 09:52:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for batch
-- ----------------------------
DROP TABLE IF EXISTS `batch`;
CREATE TABLE `batch` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `Createtime` datetime DEFAULT NULL,
  `currentvalue` int NOT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of batch
-- ----------------------------
INSERT INTO `batch` VALUES ('19', '2023-08-28 09:45:43', '4');

-- ----------------------------
-- Table structure for camera2_value
-- ----------------------------
DROP TABLE IF EXISTS `camera2_value`;
CREATE TABLE `camera2_value` (
  `SerialKey` int NOT NULL,
  `Brightness` smallint NOT NULL DEFAULT '100' COMMENT '亮度: 0-255',
  `Contrast` smallint NOT NULL DEFAULT '50' COMMENT '对比度0-255',
  `Hue` smallint NOT NULL DEFAULT '20' COMMENT '色调0-0',
  `Saturation` smallint NOT NULL DEFAULT '20' COMMENT '饱和度0-255',
  `Sharpness` smallint NOT NULL DEFAULT '20' COMMENT '锐度0-255',
  `WhiteBalance` smallint NOT NULL DEFAULT '20' COMMENT '白平衡0-10000',
  `Gain` smallint NOT NULL DEFAULT '20' COMMENT '增益0-255',
  PRIMARY KEY (`SerialKey`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of camera2_value
-- ----------------------------
INSERT INTO `camera2_value` VALUES ('0', '76', '255', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for camera_value
-- ----------------------------
DROP TABLE IF EXISTS `camera_value`;
CREATE TABLE `camera_value` (
  `SerialKey` int NOT NULL,
  `Brightness` smallint NOT NULL DEFAULT '100' COMMENT '亮度: 0-255',
  `Contrast` smallint NOT NULL DEFAULT '50' COMMENT '对比度0-255',
  `Hue` smallint NOT NULL DEFAULT '50' COMMENT '色调0-0',
  `Saturation` smallint NOT NULL DEFAULT '50' COMMENT '饱和度0-255',
  `Sharpness` smallint NOT NULL DEFAULT '50' COMMENT '锐度0-255',
  `WhiteBalance` smallint NOT NULL DEFAULT '0' COMMENT '白平衡0-10000',
  `Gain` smallint NOT NULL DEFAULT '50' COMMENT '增益0-255',
  PRIMARY KEY (`SerialKey`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of camera_value
-- ----------------------------
INSERT INTO `camera_value` VALUES ('0', '157', '255', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for dissolve_date
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_date`;
CREATE TABLE `dissolve_date` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `PositionName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地址名称',
  `SampleSource` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样品地址名称',
  `LastTryTime` datetime DEFAULT NULL COMMENT '最后尝试时间',
  `Start` int DEFAULT NULL COMMENT '执行',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dissolve_date
-- ----------------------------
INSERT INTO `dissolve_date` VALUES ('1', 'R1', '', '2023-08-28 15:06:02', '0');
INSERT INTO `dissolve_date` VALUES ('2', 'R2', '', '2023-08-28 14:59:37', '0');
INSERT INTO `dissolve_date` VALUES ('3', 'R3', '', '2023-08-28 15:01:49', '0');
INSERT INTO `dissolve_date` VALUES ('4', 'R4', '', '2023-05-20 10:14:59', '0');
INSERT INTO `dissolve_date` VALUES ('5', 'R5', '', '2023-05-20 10:18:39', '0');
INSERT INTO `dissolve_date` VALUES ('6', 'R6', '', '2023-04-03 15:16:30', '0');
INSERT INTO `dissolve_date` VALUES ('7', 'R7', '', '2023-04-03 15:21:31', '0');
INSERT INTO `dissolve_date` VALUES ('8', 'R8', '', '2023-04-03 15:25:41', '0');
INSERT INTO `dissolve_date` VALUES ('9', 'R9', '', '2023-04-03 15:30:14', '0');
INSERT INTO `dissolve_date` VALUES ('10', 'R10', '', '2023-03-10 17:21:07', '0');
INSERT INTO `dissolve_date` VALUES ('11', 'R11', '', '2023-03-02 09:56:59', '0');
INSERT INTO `dissolve_date` VALUES ('12', 'R12', '', '2023-03-02 09:59:01', '0');

-- ----------------------------
-- Table structure for dissolve_interval
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_interval`;
CREATE TABLE `dissolve_interval` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LastTryTime` datetime DEFAULT NULL COMMENT '最后尝试时间',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of dissolve_interval
-- ----------------------------
INSERT INTO `dissolve_interval` VALUES ('1', '2023-08-28 15:06:02');

-- ----------------------------
-- Table structure for equipment_area
-- ----------------------------
DROP TABLE IF EXISTS `equipment_area`;
CREATE TABLE `equipment_area` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `AreaName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '区域名称',
  `PointName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '点位名称',
  `LocationX` double(8,3) DEFAULT NULL COMMENT 'X位置',
  `LocationY` double(8,3) DEFAULT NULL COMMENT 'Y位置',
  `LocationZ` double(8,3) DEFAULT NULL COMMENT 'Z抓杯移动距离',
  `Enable` int DEFAULT NULL COMMENT '启用',
  `LocationZF` double(8,3) DEFAULT NULL COMMENT 'Z放杯距离',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of equipment_area
-- ----------------------------
INSERT INTO `equipment_area` VALUES ('1', 'SamplePosition', 'A1', '5.900', '8.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('2', 'SamplePosition', 'A2', '33.600', '8.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('3', 'SamplePosition', 'A3', '61.100', '8.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('4', 'SamplePosition', 'A4', '6.400', '67.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('5', 'SamplePosition', 'A5', '33.500', '68.400', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('6', 'SamplePosition', 'A6', '61.500', '67.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('7', 'SamplePosition', 'A7', '6.300', '125.700', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('8', 'SamplePosition', 'A8', '34.200', '125.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('9', 'SamplePosition', 'A9', '61.800', '126.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('10', 'SamplePosition', 'A10', '6.200', '184.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('11', 'SamplePosition', 'A11', '34.100', '183.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('12', 'SamplePosition', 'A12', '62.000', '184.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('13', 'SamplePosition', 'A13', '6.800', '242.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('14', 'SamplePosition', 'A14', '34.600', '242.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('15', 'SamplePosition', 'A15', '61.900', '242.700', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('16', 'SamplePosition', 'A16', '6.700', '300.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('17', 'SamplePosition', 'A17', '34.200', '300.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('18', 'SamplePosition', 'A18', '61.900', '300.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('19', 'SamplePosition', 'A19', '6.400', '358.400', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('20', 'SamplePosition', 'A20', '34.300', '358.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('21', 'SamplePosition', 'A21', '62.200', '358.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('22', 'SamplePosition', 'A22', '95.400', '10.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('23', 'SamplePosition', 'A23', '123.000', '10.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('24', 'SamplePosition', 'A24', '151.100', '9.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('25', 'SamplePosition', 'A25', '95.700', '68.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('26', 'SamplePosition', 'A26', '123.000', '68.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('27', 'SamplePosition', 'A27', '151.100', '68.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('28', 'SamplePosition', 'A28', '95.700', '126.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('29', 'SamplePosition', 'A29', '123.700', '126.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('30', 'SamplePosition', 'A30', '151.100', '126.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('31', 'SamplePosition', 'A31', '95.700', '184.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('32', 'SamplePosition', 'A32', '123.200', '184.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('33', 'SamplePosition', 'A33', '151.000', '184.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('34', 'SamplePosition', 'A34', '96.200', '242.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('35', 'SamplePosition', 'A35', '123.800', '242.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('36', 'SamplePosition', 'A36', '151.400', '242.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('37', 'SamplePosition', 'A37', '96.400', '301.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('38', 'SamplePosition', 'A38', '124.000', '300.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('39', 'SamplePosition', 'A39', '151.500', '300.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('40', 'SamplePosition', 'A40', '96.600', '359.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('41', 'SamplePosition', 'A41', '124.000', '358.700', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('42', 'SamplePosition', 'A42', '152.000', '358.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('43', 'SamplePosition', 'A43', '184.600', '10.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('44', 'SamplePosition', 'A44', '212.700', '9.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('45', 'SamplePosition', 'A45', '240.300', '9.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('46', 'SamplePosition', 'A46', '185.200', '67.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('47', 'SamplePosition', 'A47', '212.900', '68.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('48', 'SamplePosition', 'A48', '240.900', '68.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('49', 'SamplePosition', 'A49', '185.600', '126.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('50', 'SamplePosition', 'A50', '212.800', '126.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('51', 'SamplePosition', 'A51', '240.700', '126.100', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('52', 'SamplePosition', 'A52', '185.600', '184.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('53', 'SamplePosition', 'A53', '213.100', '183.900', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('54', 'SamplePosition', 'A54', '240.600', '184.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('55', 'SamplePosition', 'A55', '185.400', '243.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('56', 'SamplePosition', 'A56', '212.700', '243.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('57', 'SamplePosition', 'A57', '240.600', '243.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('58', 'SamplePosition', 'A58', '185.400', '300.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('59', 'SamplePosition', 'A59', '213.300', '300.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('60', 'SamplePosition', 'A60', '241.100', '301.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('61', 'SamplePosition', 'A61', '185.400', '360.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('62', 'SamplePosition', 'A62', '213.300', '359.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('63', 'SamplePosition', 'A63', '240.900', '359.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('79', 'DissolvePosition', 'R1', '288.100', '174.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('80', 'DissolvePosition', 'R2', '321.100', '173.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('81', 'DissolvePosition', 'R3', '354.000', '173.600', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('82', 'DissolvePosition', 'R4', '387.000', '173.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('83', 'DissolvePosition', 'R5', '288.000', '252.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('84', 'DissolvePosition', 'R6', '321.000', '252.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('85', 'DissolvePosition', 'R7', '354.100', '252.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('86', 'DissolvePosition', 'R8', '387.100', '252.200', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('87', 'DissolvePosition', 'R9', '288.700', '330.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('88', 'DissolvePosition', 'R10', '321.200', '330.800', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('89', 'DissolvePosition', 'R11', '354.400', '333.500', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('90', 'DissolvePosition', 'R12', '387.200', '331.000', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('94', 'AddLiquidPosition', 'L1', '288.100', '32.400', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('95', 'TitrationPosition', 'D1', '386.200', '32.300', '100.000', '1', '150.000');
INSERT INTO `equipment_area` VALUES ('96', 'TitrationPosition2', 'D2', '329.300', '32.200', '100.000', '1', '150.000');

-- ----------------------------
-- Table structure for equipment_task
-- ----------------------------
DROP TABLE IF EXISTS `equipment_task`;
CREATE TABLE `equipment_task` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `Source` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '原始地址',
  `RouteID` int DEFAULT NULL COMMENT '路由ID',
  `Status` int DEFAULT NULL COMMENT '任务状态',
  `RouteStep` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '路由步骤',
  `WaveKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '波次',
  `RouteType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '路由类型',
  `Record` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '记录',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建事件',
  `From` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '源地址',
  `To` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '目标地址',
  `Target` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '执行目标',
  `Amount` double(8,4) DEFAULT '0.0000' COMMENT '滴定数量',
  `Result` double(8,4) DEFAULT '0.0000' COMMENT '滴定结果',
  `CalibrationEnable` int DEFAULT NULL COMMENT '开启标定',
  `TaskType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '任务类型',
  `AcidBaseProp` int DEFAULT NULL COMMENT '酸碱性',
  `TaskDetailName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '样品描述',
  `SampleVolume` double(8,4) DEFAULT '0.0000' COMMENT '取样体积',
  `SampleMultiple` double(8,3) DEFAULT NULL COMMENT '取样倍数',
  `QuicklyTitration` int DEFAULT NULL COMMENT '快速滴定',
  `udf1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '扩展字段一',
  `udf2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '扩展字段二',
  `udf3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '扩展字段三',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15748 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of equipment_task
-- ----------------------------
INSERT INTO `equipment_task` VALUES ('15726', 'A7', '3', '4', 'TitrationGoback', '20230519001', 'Sample', 'ReleaseAxis', '2023-05-19 16:51:25', 'D1', 'A7', 'To', '0.1972', '-8.0000', '0', '空白', '1', '空白', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15727', 'A8', '4', '4', 'Titration2Goback', '20230519001', 'Sample', 'ReleaseAxis', '2023-05-19 16:51:25', 'D2', 'A8', 'To', '0.2636', '-8.0000', '0', '空白', '1', '空白', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15728', 'A4', '3', '4', 'TitrationGoback', '20230520001', 'Sample', 'ReleaseAxis', '2023-05-20 10:00:54', 'D1', 'A4', 'To', '0.6901', '0.5521', '1', '空白', '1', '空白', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15729', 'A5', '4', '4', 'Titration2Goback', '20230520001', 'Sample', 'ReleaseAxis', '2023-05-20 10:00:54', 'D2', 'A5', 'To', '0.4613', '0.3690', '1', '空白', '1', '空白', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15730', 'A7', '3', '4', 'TitrationGoback', '20230520001', 'Sample', 'ReleaseAxis', '2023-05-20 10:00:54', 'D1', 'A7', 'To', '3.9761', '3.1808', '0', '样品', '1', '2031123', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15731', 'A8', '3', '4', 'TitrationGoback', '20230520001', 'Sample', 'ReleaseAxis', '2023-05-20 10:00:54', 'D1', 'A8', 'To', '4.2389', '3.3912', '0', '样品', '1', '2031123', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15732', 'A9', '4', '4', 'Titration2Goback', '20230520001', 'Sample', 'ReleaseAxis', '2023-05-20 10:00:54', 'D2', 'A9', 'To', '4.1517', '3.3214', '0', '样品', '1', '2031123', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15733', 'A4', '0', '4', 'Titration', '20230520001', 'Sample', '', '2023-05-20 10:36:36', 'A4', 'A4', 'From', '9.9858', '0.0000', '0', '标定', '1', '标定', '0.0000', '0.000', '1', null, null, null);
INSERT INTO `equipment_task` VALUES ('15734', 'A5', '0', '4', 'Titration2', '20230520001', 'Sample', '', '2023-05-20 10:40:46', 'A5', 'A5', 'From', '9.9555', '0.0000', '0', '标定', '1', '标定', '0.0000', '0.000', '1', null, null, null);
INSERT INTO `equipment_task` VALUES ('15735', 'A5', '1', '10', 'AddLiquid', '20230828001', 'Sample', 'AddLiquidInterceptor', '2023-08-28 09:45:44', 'A5', 'L1', 'From', '0.0000', '0.0000', '0', '样品', '1', '08284438', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15736', 'A6', '1', '10', 'AddLiquid', '20230828001', 'Sample', null, '2023-08-28 09:45:44', 'A6', 'A6', null, '0.0000', '0.0000', '0', '样品', '1', '08284443', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15737', 'A8', '1', '10', 'AddLiquid', '20230828001', 'Sample', null, '2023-08-28 09:46:17', 'A8', 'A8', null, '0.0000', '0.0000', '0', '样品', '1', '08284610', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15738', 'A9', '1', '10', 'AddLiquid', '20230828001', 'Sample', null, '2023-08-28 09:46:33', 'A9', 'A9', null, '0.0000', '0.0000', '0', '样品', '1', '08284625', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15739', 'A28', '1', '10', 'AddLiquid', '20230828001', 'Sample', null, '2023-08-28 09:46:33', 'A28', 'A28', null, '0.0000', '0.0000', '0', '样品', '1', '08284628', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15740', 'A6', '1', '10', 'AddLiquid', '20230828002', 'Sample', 'AxisMovementByY', '2023-08-28 14:33:47', 'A6', 'L1', 'From', '0.0000', '0.0000', '0', '样品', '1', '08283309', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15741', 'A9', '1', '10', 'AddLiquid', '20230828002', 'Sample', null, '2023-08-28 14:33:47', 'A9', 'A9', null, '0.0000', '0.0000', '0', '样品', '1', '08283320', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15742', 'A12', '1', '10', 'AddLiquid', '20230828002', 'Sample', null, '2023-08-28 14:33:47', 'A12', 'A12', null, '0.0000', '0.0000', '0', '样品', '1', '08283329', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15743', 'A6', '1', '10', 'AddLiquid', '20230828003', 'Sample', 'AddLiquidInterceptor', '2023-08-28 14:42:53', 'A6', 'L1', 'From', '0.0000', '0.0000', '0', '样品', '1', '08284246', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15744', 'A8', '3', '4', 'TitrationGoback', '20230828004', 'Sample', 'ReleaseAxis', '2023-08-28 14:55:03', 'D1', 'A8', 'To', '7.0320', '5.6256', '0', '样品', '1', '08285444', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15745', 'A9', '3', '4', 'TitrationGoback', '20230828004', 'Sample', 'ReleaseAxis', '2023-08-28 14:55:03', 'D1', 'A9', 'To', '0.1643', '0.1314', '0', '样品', '1', '08285446', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15746', 'A28', '4', '4', 'Titration2Goback', '20230828004', 'Sample', 'ReleaseAxis', '2023-08-28 14:55:39', 'D2', 'A28', 'To', '0.0000', '0.0000', '0', '样品', '1', '08285523', '100.0000', '0.000', '0', null, null, null);
INSERT INTO `equipment_task` VALUES ('15747', 'A29', '4', '4', 'Titration2Goback', '20230828004', 'Sample', 'ReleaseAxis', '2023-08-28 14:55:39', 'D2', 'A29', 'To', '0.0000', '0.0000', '0', '样品', '1', '08285525', '100.0000', '0.000', '0', null, null, null);

-- ----------------------------
-- Table structure for execute_time
-- ----------------------------
DROP TABLE IF EXISTS `execute_time`;
CREATE TABLE `execute_time` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `TypeName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型名称',
  `Value` double(4,2) DEFAULT NULL COMMENT '值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of execute_time
-- ----------------------------
INSERT INTO `execute_time` VALUES ('1', 'DissolveTime', '8.00', '消解时间（min）');
INSERT INTO `execute_time` VALUES ('3', 'DissolveInterval', '1.00', '消解间隔（min）');

-- ----------------------------
-- Table structure for liquid_amount
-- ----------------------------
DROP TABLE IF EXISTS `liquid_amount`;
CREATE TABLE `liquid_amount` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LiquidName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '液体名称',
  `Capacity` double(8,5) DEFAULT NULL COMMENT '容量',
  `Amount` double(8,5) DEFAULT NULL COMMENT '数量',
  `ConvertRatio` int DEFAULT NULL COMMENT '转换比例',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of liquid_amount
-- ----------------------------
INSERT INTO `liquid_amount` VALUES ('1', 'Sodium1Oxalate', '10.00000', '0.04971', '2000', '草酸钠（滴定1）');
INSERT INTO `liquid_amount` VALUES ('2', 'Sodium2Oxalate', '10.00000', '0.04973', '2000', '草酸钠（滴定2）');
INSERT INTO `liquid_amount` VALUES ('3', 'Titration1PotassiumPermanganate', '10.00000', '0.03286', '2000', '高锰酸钾（滴定1）');
INSERT INTO `liquid_amount` VALUES ('4', 'Titration2PotassiumPermanganate', '10.00000', '0.03295', '2000', '高锰酸钾（滴定2）');

-- ----------------------------
-- Table structure for liquid_record
-- ----------------------------
DROP TABLE IF EXISTS `liquid_record`;
CREATE TABLE `liquid_record` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `Point` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TitrationPotassiumPermanganateStatus` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '滴定高锰酸钾自动加液状态',
  `AddliquidPotassiumPermanganateStatus` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '加液高锰酸鉮自动加液状态',
  `TitrationSodiumOxalateStatus` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '滴定草酸钠自动加液状态',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4401 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of liquid_record
-- ----------------------------

-- ----------------------------
-- Table structure for liquid_reserve
-- ----------------------------
DROP TABLE IF EXISTS `liquid_reserve`;
CREATE TABLE `liquid_reserve` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `LiquidName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Value` double(9,4) DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of liquid_reserve
-- ----------------------------
INSERT INTO `liquid_reserve` VALUES ('1', 'SodiumHydroxide', '0.0000', '氢氧化钠（ml）');
INSERT INTO `liquid_reserve` VALUES ('2', 'Vitriol', '0.0000', '硫酸（ml）');
INSERT INTO `liquid_reserve` VALUES ('3', 'SodiumOxalate', '0.0000', '草酸钠（ml）');
INSERT INTO `liquid_reserve` VALUES ('4', 'PotassiumPermanganate', '-100.0000', '高锰酸钾（ml）');

-- ----------------------------
-- Table structure for liquid_total
-- ----------------------------
DROP TABLE IF EXISTS `liquid_total`;
CREATE TABLE `liquid_total` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `LiquidName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Total` double(9,4) DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of liquid_total
-- ----------------------------
INSERT INTO `liquid_total` VALUES ('1', 'SodiumHydroxide', '89932.0000', '氢氧化钠（ml）');
INSERT INTO `liquid_total` VALUES ('2', 'Vitriol', '72899.5800', '硫酸（ml）');
INSERT INTO `liquid_total` VALUES ('3', 'SodiumOxalate', '66510.0000', '草酸钠（ml）');
INSERT INTO `liquid_total` VALUES ('4', 'PotassiumPermanganate', '41953.3464', '高锰酸钾（ml）');

-- ----------------------------
-- Table structure for liquid_volume
-- ----------------------------
DROP TABLE IF EXISTS `liquid_volume`;
CREATE TABLE `liquid_volume` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LiquidName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '液体名称',
  `ClearVolume` double(12,3) DEFAULT NULL COMMENT '清洗体积',
  `SampleVolume` double(12,3) DEFAULT NULL COMMENT '样品滴定体积',
  `Enable` int DEFAULT NULL COMMENT '启用',
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of liquid_volume
-- ----------------------------
INSERT INTO `liquid_volume` VALUES ('1', 'Sodium2Hydroxide', '16.000', '1.000', '1', '氢氧化钠（s）');
INSERT INTO `liquid_volume` VALUES ('2', 'AddLiquidVitriol', '20.000', '7.500', '1', '加液硫酸（s）');
INSERT INTO `liquid_volume` VALUES ('3', 'Titration1Vitriol', '10.000', '6.400', '1', '滴定1硫酸（s）');
INSERT INTO `liquid_volume` VALUES ('4', 'Titration2Vitriol', '16.000', '15.000', '1', '滴定2硫酸（s）');
INSERT INTO `liquid_volume` VALUES ('5', 'Sodium1Oxalate', '10.000', '10.000', '1', '草酸钠1（ml）');
INSERT INTO `liquid_volume` VALUES ('6', 'Sodium2Oxalate', '10.000', '10.000', '1', '草酸钠2（ml）');
INSERT INTO `liquid_volume` VALUES ('7', 'Titration1PotassiumPermanganate', '20.000', '10.000', '1', '高锰酸钾1（ml）');
INSERT INTO `liquid_volume` VALUES ('8', 'Titration2PotassiumPermanganate', '20.000', '10.000', '1', '高锰酸钾2（ml）');

-- ----------------------------
-- Table structure for motor_convert
-- ----------------------------
DROP TABLE IF EXISTS `motor_convert`;
CREATE TABLE `motor_convert` (
  `SeriKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `MotorName` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电机名称',
  `ConvertRatio` double(8,3) DEFAULT NULL COMMENT '转换数值',
  PRIMARY KEY (`SeriKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of motor_convert
-- ----------------------------
INSERT INTO `motor_convert` VALUES ('1', 'AxisX', '4000.000');
INSERT INTO `motor_convert` VALUES ('2', 'AxisY', '4000.000');
INSERT INTO `motor_convert` VALUES ('3', 'AxisZ', '4000.000');
INSERT INTO `motor_convert` VALUES ('4', 'AxisD', '4000.000');

-- ----------------------------
-- Table structure for motor_move_status
-- ----------------------------
DROP TABLE IF EXISTS `motor_move_status`;
CREATE TABLE `motor_move_status` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `MotorName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '电机名称',
  `CurrentPosition` double(8,3) DEFAULT NULL COMMENT '当前位置',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of motor_move_status
-- ----------------------------
INSERT INTO `motor_move_status` VALUES ('1', 'AxisX', '0.000', 'X轴');
INSERT INTO `motor_move_status` VALUES ('2', 'AxisY', '0.000', 'Y轴');
INSERT INTO `motor_move_status` VALUES ('3', 'AxisZ', '0.000', 'Z轴');
INSERT INTO `motor_move_status` VALUES ('4', 'AxisD', '0.000', 'D轴');

-- ----------------------------
-- Table structure for motor_speed
-- ----------------------------
DROP TABLE IF EXISTS `motor_speed`;
CREATE TABLE `motor_speed` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `DetailName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述名称',
  `SystemName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '系统名称',
  `Speed` int DEFAULT NULL COMMENT '速度',
  `AcSpeed` int DEFAULT NULL COMMENT '加速度',
  `DeSpeed` int DEFAULT NULL COMMENT '减速度',
  `ConnectAutoUpdate` int DEFAULT NULL COMMENT '连接成功后自动更新',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of motor_speed
-- ----------------------------
INSERT INTO `motor_speed` VALUES ('1', 'X轴', 'AxisX', '9', '10', '10', '1');
INSERT INTO `motor_speed` VALUES ('2', 'Y轴', 'AxisY', '9', '10', '10', '1');
INSERT INTO `motor_speed` VALUES ('3', 'Z轴', 'AxisZ', '9', '100', '100', '1');
INSERT INTO `motor_speed` VALUES ('4', '主滴定滴嘴', 'TitrationDropper', '9', '30', '30', '1');
INSERT INTO `motor_speed` VALUES ('5', '加液滴定滴嘴轴', 'AxisD', '8', '30', '30', '1');
INSERT INTO `motor_speed` VALUES ('6', '草酸钠1', 'Sodium1Oxalate', '3', '300', '500', '1');
INSERT INTO `motor_speed` VALUES ('7', '草酸钠2', 'Sodium2Oxalate', '3', '300', '500', '1');
INSERT INTO `motor_speed` VALUES ('8', '高锰酸钾1', 'Titration1PotassiumPermanganate', '2', '420', '420', '1');
INSERT INTO `motor_speed` VALUES ('9', '高锰酸钾2', 'Titration2PotassiumPermanganate', '2', '420', '420', '1');

-- ----------------------------
-- Table structure for pid
-- ----------------------------
DROP TABLE IF EXISTS `pid`;
CREATE TABLE `pid` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `TypeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '类型名称',
  `Ratio` double(8,3) NOT NULL COMMENT '比例',
  `Integral` int DEFAULT NULL COMMENT '积分',
  `Differential` int DEFAULT NULL COMMENT '微分',
  `IntegralDeafult` double(8,3) DEFAULT NULL COMMENT '积分默认值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of pid
-- ----------------------------
INSERT INTO `pid` VALUES ('1', 'DissolveHeating', '3.300', '94', '23', '14.200', '消解加热');
INSERT INTO `pid` VALUES ('2', 'TitrationHeating', '18.000', '12', '3', '72.500', '滴定加热');

-- ----------------------------
-- Table structure for position_hotlist
-- ----------------------------
DROP TABLE IF EXISTS `position_hotlist`;
CREATE TABLE `position_hotlist` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `PositionName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '位置名称',
  `CurrentOccupy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '当前占位',
  `Enable` int DEFAULT NULL COMMENT '启用',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of position_hotlist
-- ----------------------------
INSERT INTO `position_hotlist` VALUES ('1', 'R1', '', '1');
INSERT INTO `position_hotlist` VALUES ('2', 'R2', '', '1');
INSERT INTO `position_hotlist` VALUES ('3', 'R3', '', '1');
INSERT INTO `position_hotlist` VALUES ('4', 'R4', '', '1');
INSERT INTO `position_hotlist` VALUES ('5', 'R5', '', '1');
INSERT INTO `position_hotlist` VALUES ('6', 'R6', '', '1');
INSERT INTO `position_hotlist` VALUES ('7', 'R7', '', '1');
INSERT INTO `position_hotlist` VALUES ('8', 'R8', '', '1');
INSERT INTO `position_hotlist` VALUES ('9', 'R9', '', '1');
INSERT INTO `position_hotlist` VALUES ('10', 'R10', '', '1');
INSERT INTO `position_hotlist` VALUES ('11', 'R11', '', '1');
INSERT INTO `position_hotlist` VALUES ('12', 'R12', '', '1');
INSERT INTO `position_hotlist` VALUES ('13', 'L1', '', '1');
INSERT INTO `position_hotlist` VALUES ('14', 'D1', '', '1');
INSERT INTO `position_hotlist` VALUES ('15', 'D2', '', '1');

-- ----------------------------
-- Table structure for route
-- ----------------------------
DROP TABLE IF EXISTS `route`;
CREATE TABLE `route` (
  `Serialkey` int NOT NULL AUTO_INCREMENT,
  `TaskType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `RouteID` int DEFAULT NULL,
  `RouteType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
  PRIMARY KEY (`Serialkey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of route
-- ----------------------------
INSERT INTO `route` VALUES ('1', 'Sample', '1', 'AddLiquid', '加液');
INSERT INTO `route` VALUES ('2', 'Sample', '2', 'Dissolve', '消解');
INSERT INTO `route` VALUES ('3', 'Sample', '3', 'Titration', '滴定');
INSERT INTO `route` VALUES ('4', 'Sample', '4', 'Titration2', '滴定2');

-- ----------------------------
-- Table structure for routecache
-- ----------------------------
DROP TABLE IF EXISTS `routecache`;
CREATE TABLE `routecache` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `CreateTime` datetime DEFAULT '0001-01-01 00:00:00',
  `Source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `TaskKey` int DEFAULT NULL,
  `RouteID` int DEFAULT NULL,
  `RouteStep` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  `Priority` int DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30648 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of routecache
-- ----------------------------

-- ----------------------------
-- Table structure for routestep
-- ----------------------------
DROP TABLE IF EXISTS `routestep`;
CREATE TABLE `routestep` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `RouteID` int DEFAULT NULL,
  `Order` int DEFAULT NULL,
  `Step` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `From` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `To` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of routestep
-- ----------------------------
INSERT INTO `routestep` VALUES ('1', '1', '1', 'AddLiquid', 'Source', 'AddLiquidPosition', '加液');
INSERT INTO `routestep` VALUES ('2', '1', '2', 'AddLiquidGoback', 'AddLiquidPosition', 'Source', '加液返回');
INSERT INTO `routestep` VALUES ('3', '2', '1', 'Dissolve', 'Source', 'DissolvePosition', '消解');
INSERT INTO `routestep` VALUES ('4', '2', '2', 'DissolveGoback', 'DissolvePosition', 'TitrationPosition', '消解返回');
INSERT INTO `routestep` VALUES ('5', '3', '1', 'Titration', 'TitrationPosition', 'TitrationPosition', '滴定');
INSERT INTO `routestep` VALUES ('6', '3', '2', 'TitrationGoback', 'TitrationPosition', 'Source', '滴定返回');
INSERT INTO `routestep` VALUES ('7', '4', '1', 'Titration2', 'TitrationPosition2', 'TitrationPosition2', '滴定2');
INSERT INTO `routestep` VALUES ('8', '4', '2', 'Titration2Goback', 'TitrationPosition2', 'Source', '滴定2返回');

-- ----------------------------
-- Table structure for sampledetails
-- ----------------------------
DROP TABLE IF EXISTS `sampledetails`;
CREATE TABLE `sampledetails` (
  `Serialkey` int NOT NULL AUTO_INCREMENT,
  `AreaPosition` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '区域位置',
  `NodeName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点名称',
  `DetailInfo` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '详情信息',
  `SampleVolume` double(8,4) DEFAULT '0.0000' COMMENT '取样体积',
  `SampleMultiple` double(8,3) DEFAULT NULL COMMENT '取样倍数',
  `SampleType` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '样品类型',
  `AcidBaseProp` int DEFAULT NULL COMMENT '酸碱性',
  `IsCalibration` int DEFAULT NULL COMMENT '是否标定',
  `QuicklyTitration` int DEFAULT NULL COMMENT '快速滴定',
  `TaskStatus` int DEFAULT NULL COMMENT '任务状态',
  PRIMARY KEY (`Serialkey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of sampledetails
-- ----------------------------
INSERT INTO `sampledetails` VALUES ('1', 'Left', 'A1', '空白', '100.0000', '0.000', '空白', '1', '1', '0', '0');
INSERT INTO `sampledetails` VALUES ('2', 'Left', 'A2', '空白', '100.0000', '0.000', '空白', '1', '1', '0', '0');
INSERT INTO `sampledetails` VALUES ('3', 'Left', 'A3', '05063423', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('4', 'Left', 'A4', '空白', '100.0000', '0.000', '空白', '1', '1', '0', '0');
INSERT INTO `sampledetails` VALUES ('5', 'Left', 'A5', '08285105', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('6', 'Left', 'A6', '08284446', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('7', 'Left', 'A7', '2031123', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('8', 'Left', 'A8', '08285444', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('9', 'Left', 'A9', '08285446', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('10', 'Left', 'A10', '03065406', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('11', 'Left', 'A11', '03065407', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('12', 'Left', 'A12', '08283329', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('13', 'Left', 'A13', '03065409', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('14', 'Left', 'A14', '03065410', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('15', 'Left', 'A15', '03065411', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('16', 'Left', 'A16', '03065412', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('17', 'Left', 'A17', '03065413', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('18', 'Left', 'A18', '03065414', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('19', 'Left', 'A19', '03065415', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('20', 'Left', 'A20', '03065416', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('21', 'Left', 'A21', '03065417', '100.0000', '0.000', '样品', '2', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('22', 'Middle', 'A22', '03065418', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('23', 'Middle', 'A23', '03065419', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('24', 'Middle', 'A24', '03065420', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('25', 'Middle', 'A25', '03065421', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('26', 'Middle', 'A26', '03065422', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('27', 'Middle', 'A27', '03065423', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('28', 'Middle', 'A28', '08285523', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('29', 'Middle', 'A29', '08285525', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('30', 'Middle', 'A30', '03065426', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('31', 'Middle', 'A31', '03065427', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('32', 'Middle', 'A32', '03065428', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('33', 'Middle', 'A33', '03065429', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('34', 'Middle', 'A34', '03065430', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('35', 'Middle', 'A35', '03065431', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('36', 'Middle', 'A36', '03065432', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('37', 'Middle', 'A37', '03065433', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('38', 'Middle', 'A38', '03065434', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('39', 'Middle', 'A39', '03065435', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('40', 'Middle', 'A40', '03065436', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('41', 'Middle', 'A41', '03065437', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('42', 'Middle', 'A42', '03065438', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('43', 'Right', 'A43', '12292055', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('44', 'Right', 'A44', '12292056', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('45', 'Right', 'A45', '12292057', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('46', 'Right', 'A46', '12292058', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('47', 'Right', 'A47', '12292059', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('48', 'Right', 'A48', '12292060', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('49', 'Right', 'A49', '12292061', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('50', 'Right', 'A50', '12292062', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('51', 'Right', 'A51', '12292063', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('52', 'Right', 'A52', '12292064', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('53', 'Right', 'A53', '12292065', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('54', 'Right', 'A54', '12292066', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('55', 'Right', 'A55', '12292067', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('56', 'Right', 'A56', '12292068', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('57', 'Right', 'A57', '12292069', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('58', 'Right', 'A58', '12292070', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('59', 'Right', 'A59', '12292071', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('60', 'Right', 'A60', '12292072', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('61', 'Right', 'A61', '12292073', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('62', 'Right', 'A62', '12292074', '100.0000', '0.000', '样品', '1', '0', '0', '0');
INSERT INTO `sampledetails` VALUES ('63', 'Right', 'A63', '12292075', '100.0000', '0.000', '样品', '1', '0', '0', '0');

-- ----------------------------
-- Table structure for statemachine
-- ----------------------------
DROP TABLE IF EXISTS `statemachine`;
CREATE TABLE `statemachine` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `Name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `Status` int DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of statemachine
-- ----------------------------
INSERT INTO `statemachine` VALUES ('1', 'MotorLock', '0');
INSERT INTO `statemachine` VALUES ('2', 'SodiumOxalateLock', '0');
INSERT INTO `statemachine` VALUES ('3', 'Potassium1PermanganateLock', '0');
INSERT INTO `statemachine` VALUES ('4', 'Potassium2PermanganateLock', '0');
INSERT INTO `statemachine` VALUES ('5', 'MotorLockDropper', '0');
INSERT INTO `statemachine` VALUES ('6', 'Titration', '0');

-- ----------------------------
-- Table structure for task_priority
-- ----------------------------
DROP TABLE IF EXISTS `task_priority`;
CREATE TABLE `task_priority` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `Step` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作类型',
  `Priority` int DEFAULT NULL COMMENT '优先级',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of task_priority
-- ----------------------------
INSERT INTO `task_priority` VALUES ('1', 'AddLiquid', '200');
INSERT INTO `task_priority` VALUES ('2', 'AddLiquidGoback', '100');
INSERT INTO `task_priority` VALUES ('3', 'Dissolve', '300');
INSERT INTO `task_priority` VALUES ('4', 'DissolveGoback', '800');
INSERT INTO `task_priority` VALUES ('5', 'Titration', '700');
INSERT INTO `task_priority` VALUES ('6', 'Titration2', '600');
INSERT INTO `task_priority` VALUES ('7', 'TitrationGoback', '500');
INSERT INTO `task_priority` VALUES ('8', 'Titration2Goback', '400');

-- ----------------------------
-- Table structure for titration2_value
-- ----------------------------
DROP TABLE IF EXISTS `titration2_value`;
CREATE TABLE `titration2_value` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `TitrationType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '滴定类型',
  `RangeValue` double(5,2) DEFAULT NULL COMMENT '阈值',
  `BeforeWaitTime` int DEFAULT NULL COMMENT '滴定前等待时间',
  `ArriveCheckCount` int DEFAULT NULL COMMENT '到达阈值后的检查次数',
  `IntervalTime` int DEFAULT NULL COMMENT '间隔时间',
  `NormalMaxDropVolume` double(5,3) DEFAULT NULL COMMENT '正常最大滴定体积',
  `CalibrationMaxDropVolume` double(5,3) DEFAULT NULL COMMENT '标定最大滴定体积',
  `QuicklyTitrationValue` double(5,3) DEFAULT NULL COMMENT '快速滴定值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of titration2_value
-- ----------------------------
INSERT INTO `titration2_value` VALUES ('1', 'Sample', '1.80', '15', '28', '200', '1.000', '11.000', '2.000', '样品');
INSERT INTO `titration2_value` VALUES ('2', 'Blank', '1.50', '15', '28', '200', '1.500', '11.000', '9.000', '空白');

-- ----------------------------
-- Table structure for titration_value
-- ----------------------------
DROP TABLE IF EXISTS `titration_value`;
CREATE TABLE `titration_value` (
  `SerialKey` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `TitrationType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '滴定类型',
  `RangeValue` double(5,2) DEFAULT NULL COMMENT '阈值',
  `BeforeWaitTime` int DEFAULT NULL COMMENT '滴定前等待时间',
  `ArriveCheckCount` int DEFAULT NULL COMMENT '到达阈值后的检查次数',
  `IntervalTime` int DEFAULT NULL COMMENT '间隔时间',
  `NormalMaxDropVolume` double(5,3) DEFAULT NULL COMMENT '正常最大滴定体积',
  `CalibrationMaxDropVolume` double(5,3) DEFAULT NULL COMMENT '标定最大滴定体积',
  `QuicklyTitrationValue` double(5,3) DEFAULT NULL COMMENT '快速滴定值',
  `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of titration_value
-- ----------------------------
INSERT INTO `titration_value` VALUES ('1', 'Sample', '1.80', '15', '28', '200', '1.000', '11.000', '2.000', '样品');
INSERT INTO `titration_value` VALUES ('2', 'Blank', '1.50', '15', '28', '200', '1.500', '11.000', '9.000', '空白');

-- ----------------------------
-- Table structure for wavekey
-- ----------------------------
DROP TABLE IF EXISTS `wavekey`;
CREATE TABLE `wavekey` (
  `SerialKey` int NOT NULL AUTO_INCREMENT,
  `WaveKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '波次号',
  `FinishValue` int DEFAULT NULL COMMENT '完成值',
  `TotalValue` int DEFAULT NULL COMMENT '总数',
  `State` int DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1066 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of wavekey
-- ----------------------------
INSERT INTO `wavekey` VALUES ('1007', '20230228009', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1008', '20230228010', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1009', '20230228011', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1010', '20230228012', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1011', '20230228013', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1012', '20230228014', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1013', '20230228015', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1014', '20230228016', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1015', '20230228017', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1016', '20230301001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1017', '20230301002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1018', '20230301003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1019', '20230301004', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1020', '20230302001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1021', '20230302002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1022', '20230303001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1023', '20230303002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1024', '20230304001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1025', '20230304002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1026', '20230306001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1027', '20230306002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1028', '20230306003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1029', '20230306004', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1030', '20230306005', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1031', '20230306006', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1032', '20230306007', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1033', '20230306008', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1034', '20230306009', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1035', '20230309001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1036', '20230309002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1037', '20230309003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1038', '20230309004', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1039', '20230309005', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1040', '20230309006', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1041', '20230309007', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1042', '20230309008', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1043', '20230310001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1044', '20230310002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1045', '20230310003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1046', '20230311001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1047', '20230313001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1048', '20230323001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1049', '20230324001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1050', '20230325001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1051', '20230325002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1052', '20230325003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1053', '20230325004', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1054', '20230327001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1055', '20230327002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1056', '20230401001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1057', '20230403001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1058', '20230403002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1059', '20230506001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1060', '20230519001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1061', '20230520001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1062', '20230828001', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1063', '20230828002', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1064', '20230828003', '0', '0', '0');
INSERT INTO `wavekey` VALUES ('1065', '20230828004', '0', '0', '0');