/* 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');