/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80019 Source Host : localhost:3306 Source Schema : hypermanganate_database Target Server Type : MySQL Target Server Version : 80019 File Encoding : 65001 Date: 17/10/2021 18:19:43 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for batch -- ---------------------------- DROP TABLE IF EXISTS `batch`; CREATE TABLE `batch` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT, `Createtime` datetime(0) NULL DEFAULT NULL, `currentvalue` int(0) NOT NULL, PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of batch -- ---------------------------- INSERT INTO `batch` VALUES (19, '2021-10-16 14:12:22', 1); -- ---------------------------- -- Table structure for dissolve_date -- ---------------------------- DROP TABLE IF EXISTS `dissolve_date`; CREATE TABLE `dissolve_date` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `PositionName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '地址名称', `SampleLocalName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样品地址名称', `LastTryTime` datetime(0) NULL DEFAULT NULL COMMENT '最后尝试时间', `Start` int(0) NULL DEFAULT NULL COMMENT '执行', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of dissolve_date -- ---------------------------- INSERT INTO `dissolve_date` VALUES (1, 'R1', '', '2021-10-16 14:14:23', 0); INSERT INTO `dissolve_date` VALUES (2, 'R2', '', '2021-10-13 17:52:30', 0); INSERT INTO `dissolve_date` VALUES (3, 'R3', '', '2021-09-10 11:12:43', 0); INSERT INTO `dissolve_date` VALUES (4, 'R4', '', '0001-01-01 00:00:00', 0); INSERT INTO `dissolve_date` VALUES (5, 'R5', '', '0001-01-01 00:00:00', 0); INSERT INTO `dissolve_date` VALUES (6, 'R6', '', '0001-01-01 00:00:00', 0); INSERT INTO `dissolve_date` VALUES (7, 'R7', '', '0001-01-01 00:00:00', 0); INSERT INTO `dissolve_date` VALUES (8, 'R8', '', '0001-01-01 00:00:00', 0); INSERT INTO `dissolve_date` VALUES (9, 'R9', '', '0001-01-01 00:00:00', 0); -- ---------------------------- -- Table structure for dissolve_interval -- ---------------------------- DROP TABLE IF EXISTS `dissolve_interval`; CREATE TABLE `dissolve_interval` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `LastTryTime` datetime(0) NULL DEFAULT NULL COMMENT '最后尝试时间', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of dissolve_interval -- ---------------------------- INSERT INTO `dissolve_interval` VALUES (1, '2021-08-14 15:50:42'); -- ---------------------------- -- Table structure for equipment_area -- ---------------------------- DROP TABLE IF EXISTS `equipment_area`; CREATE TABLE `equipment_area` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键自增', `AreaName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域名称', `PointName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '点位名称', `LocationX` double(8, 3) NULL DEFAULT NULL COMMENT 'X位置', `LocationY` double(8, 3) NULL DEFAULT NULL COMMENT 'Y位置', `LocationZ` double(8, 3) NULL DEFAULT NULL COMMENT 'Z位置', `Enable` int(0) NULL DEFAULT NULL COMMENT '启用', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 90 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of equipment_area -- ---------------------------- INSERT INTO `equipment_area` VALUES (1, 'SamplePosition', 'A1', 3.700, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (2, 'SamplePosition', 'A2', 30.500, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (3, 'SamplePosition', 'A3', 57.300, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (4, 'SamplePosition', 'A4', 84.300, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (5, 'SamplePosition', 'A5', 111.300, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (6, 'SamplePosition', 'A6', 138.300, 6.200, 100.000, 1); INSERT INTO `equipment_area` VALUES (7, 'SamplePosition', 'A7', 7.957, 60.186, 100.000, 1); INSERT INTO `equipment_area` VALUES (8, 'SamplePosition', 'A8', 34.914, 60.203, 100.000, 1); INSERT INTO `equipment_area` VALUES (9, 'SamplePosition', 'A9', 61.871, 60.220, 100.000, 1); INSERT INTO `equipment_area` VALUES (10, 'SamplePosition', 'A10', 88.829, 60.237, 100.000, 1); INSERT INTO `equipment_area` VALUES (11, 'SamplePosition', 'A11', 115.786, 60.254, 100.000, 1); INSERT INTO `equipment_area` VALUES (12, 'SamplePosition', 'A12', 142.743, 60.271, 100.000, 1); INSERT INTO `equipment_area` VALUES (13, 'SamplePosition', 'A13', 8.014, 110.271, 100.000, 1); INSERT INTO `equipment_area` VALUES (14, 'SamplePosition', 'A14', 34.969, 110.306, 100.000, 1); INSERT INTO `equipment_area` VALUES (15, 'SamplePosition', 'A15', 61.923, 110.340, 100.000, 1); INSERT INTO `equipment_area` VALUES (16, 'SamplePosition', 'A16', 88.877, 110.374, 100.000, 1); INSERT INTO `equipment_area` VALUES (17, 'SamplePosition', 'A17', 115.831, 110.409, 100.000, 1); INSERT INTO `equipment_area` VALUES (18, 'SamplePosition', 'A18', 142.786, 110.443, 100.000, 1); INSERT INTO `equipment_area` VALUES (19, 'SamplePosition', 'A19', 8.071, 160.357, 100.000, 1); INSERT INTO `equipment_area` VALUES (20, 'SamplePosition', 'A20', 35.023, 160.409, 100.000, 1); INSERT INTO `equipment_area` VALUES (21, 'SamplePosition', 'A21', 61.974, 160.460, 100.000, 1); INSERT INTO `equipment_area` VALUES (22, 'SamplePosition', 'A22', 88.926, 160.511, 100.000, 1); INSERT INTO `equipment_area` VALUES (23, 'SamplePosition', 'A23', 115.877, 160.563, 100.000, 1); INSERT INTO `equipment_area` VALUES (24, 'SamplePosition', 'A24', 142.829, 160.614, 100.000, 1); INSERT INTO `equipment_area` VALUES (25, 'SamplePosition', 'A25', 8.129, 210.443, 100.000, 1); INSERT INTO `equipment_area` VALUES (26, 'SamplePosition', 'A26', 35.077, 210.511, 100.000, 1); INSERT INTO `equipment_area` VALUES (27, 'SamplePosition', 'A27', 62.026, 210.580, 100.000, 1); INSERT INTO `equipment_area` VALUES (28, 'SamplePosition', 'A28', 88.974, 210.649, 100.000, 1); INSERT INTO `equipment_area` VALUES (29, 'SamplePosition', 'A29', 115.923, 210.717, 100.000, 1); INSERT INTO `equipment_area` VALUES (30, 'SamplePosition', 'A30', 142.871, 210.786, 100.000, 1); INSERT INTO `equipment_area` VALUES (31, 'SamplePosition', 'A31', 8.186, 260.529, 100.000, 1); INSERT INTO `equipment_area` VALUES (32, 'SamplePosition', 'A32', 35.131, 260.614, 100.000, 1); INSERT INTO `equipment_area` VALUES (33, 'SamplePosition', 'A33', 62.077, 260.700, 100.000, 1); INSERT INTO `equipment_area` VALUES (34, 'SamplePosition', 'A34', 89.023, 260.786, 100.000, 1); INSERT INTO `equipment_area` VALUES (35, 'SamplePosition', 'A35', 115.969, 260.871, 100.000, 1); INSERT INTO `equipment_area` VALUES (36, 'SamplePosition', 'A36', 142.914, 260.957, 100.000, 1); INSERT INTO `equipment_area` VALUES (37, 'SamplePosition', 'A37', 8.243, 310.614, 100.000, 1); INSERT INTO `equipment_area` VALUES (38, 'SamplePosition', 'A38', 35.186, 310.717, 100.000, 1); INSERT INTO `equipment_area` VALUES (39, 'SamplePosition', 'A39', 62.129, 310.820, 100.000, 1); INSERT INTO `equipment_area` VALUES (40, 'SamplePosition', 'A40', 89.071, 310.923, 100.000, 1); INSERT INTO `equipment_area` VALUES (41, 'SamplePosition', 'A41', 116.014, 311.026, 100.000, 1); INSERT INTO `equipment_area` VALUES (42, 'SamplePosition', 'A42', 142.957, 311.129, 100.000, 1); INSERT INTO `equipment_area` VALUES (43, 'SamplePosition', 'A43', 8.300, 360.700, 100.000, 1); INSERT INTO `equipment_area` VALUES (44, 'SamplePosition', 'A44', 35.240, 360.820, 100.000, 1); INSERT INTO `equipment_area` VALUES (45, 'SamplePosition', 'A45', 62.180, 360.940, 100.000, 1); INSERT INTO `equipment_area` VALUES (46, 'SamplePosition', 'A46', 89.120, 361.060, 100.000, 1); INSERT INTO `equipment_area` VALUES (47, 'SamplePosition', 'A47', 116.060, 361.180, 100.000, 1); INSERT INTO `equipment_area` VALUES (48, 'SamplePosition', 'A48', 143.000, 361.300, 100.000, 1); INSERT INTO `equipment_area` VALUES (49, 'SamplePosition', 'A49', 172.700, 159.800, 100.000, 1); INSERT INTO `equipment_area` VALUES (50, 'SamplePosition', 'A50', 199.650, 159.700, 100.000, 1); INSERT INTO `equipment_area` VALUES (51, 'SamplePosition', 'A51', 226.600, 159.600, 100.000, 1); INSERT INTO `equipment_area` VALUES (52, 'SamplePosition', 'A52', 253.550, 159.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (53, 'SamplePosition', 'A53', 280.500, 159.400, 100.000, 1); INSERT INTO `equipment_area` VALUES (54, 'SamplePosition', 'A54', 172.825, 210.300, 100.000, 1); INSERT INTO `equipment_area` VALUES (55, 'SamplePosition', 'A55', 199.775, 210.125, 100.000, 1); INSERT INTO `equipment_area` VALUES (79, 'DissolvePosition', 'R1', 160.000, 18.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (80, 'DissolvePosition', 'R2', 227.800, 18.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (81, 'DissolvePosition', 'R3', 254.800, 18.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (82, 'DissolvePosition', 'R4', 281.800, 18.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (83, 'DissolvePosition', 'R5', 308.800, 18.500, 100.000, 1); INSERT INTO `equipment_area` VALUES (84, 'DissolvePosition', 'R6', 174.500, 94.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (85, 'DissolvePosition', 'R7', 201.500, 94.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (86, 'DissolvePosition', 'R8', 228.500, 94.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (87, 'DissolvePosition', 'R9', 255.500, 94.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (88, 'DewaterPosition', 'C1', 260.500, 30.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (89, 'TitrationPosition', 'D1', 300.000, 95.000, 100.000, 1); INSERT INTO `equipment_area` VALUES (90, 'AddLiquidPosition', 'L1', 300.000, 150.000, 100.000, 1); -- ---------------------------- -- Table structure for equipment_task -- ---------------------------- DROP TABLE IF EXISTS `equipment_task`; CREATE TABLE `equipment_task` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT, `WaveKey` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '波次', `Source` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '原始地址', `CreateTime` datetime(0) NULL DEFAULT NULL COMMENT '创建事件', `Status` int(0) NULL DEFAULT NULL COMMENT '任务状态', `From` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '源地址', `To` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目标地址', `Target` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '执行目标', `Amount` double(8, 3) NULL DEFAULT 0.000 COMMENT '滴定数量', `Result` double(8, 3) NULL DEFAULT NULL COMMENT '滴定结果', `CalibrationEnable` int(0) NULL DEFAULT NULL COMMENT '开启标定', `CalibrationAmount` double(8, 3) NULL DEFAULT NULL COMMENT '标定数量', `RouteID` int(0) NULL DEFAULT NULL COMMENT '路由ID', `RouteStep` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由步骤', `Record` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录', `RouteType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由类型', `TaskType` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务类型', `AcidBaseProp` int(0) NULL DEFAULT NULL COMMENT '酸碱性', `TaskDetailName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样品描述', `SampleVolume` double(8, 3) NULL DEFAULT NULL COMMENT '取样体积', `SampleMultiple` double(8, 3) NULL DEFAULT NULL COMMENT '取样倍数', `QuicklyTitration` int(0) NULL DEFAULT NULL COMMENT '快速滴定', `udf1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段一', `udf2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段二', `udf3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段三', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3306 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of equipment_task -- ---------------------------- INSERT INTO `equipment_task` VALUES (3291, '20211014004', 'A1', '2021-10-14 13:33:12', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10143310', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3292, '20211014004', 'A2', '2021-10-14 13:33:12', 4, 'A2', 'C1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'ReleaseAxis', 'Sample', '样品', 1, '10143308', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3293, '20211014004', 'A3', '2021-10-14 13:33:13', 4, 'A3', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10143305', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3294, '20211014005', 'A1', '2021-10-14 13:52:21', 4, 'A1', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10145210', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3295, '20211014005', 'A2', '2021-10-14 13:52:21', 4, 'A2', 'A2', NULL, 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', NULL, 'Sample', '样品', 1, '10145212', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3296, '20211014005', 'A3', '2021-10-14 13:52:21', 4, 'A3', 'A3', NULL, 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', NULL, 'Sample', '样品', 1, '10145213', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3297, '20211014006', 'A1', '2021-10-14 15:54:46', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10145439', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3298, '20211014006', 'A2', '2021-10-14 15:54:46', 4, 'A2', 'C1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'ReleaseAxis', 'Sample', '样品', 1, '10145441', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3299, '20211014006', 'A3', '2021-10-14 15:54:46', 4, 'A3', 'L1', 'To', 0.000, 0.000, 0, 0.000, 1, 'AddLiquid', 'AddLiquidH2SO4', 'Sample', '样品', 1, '10145443', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3300, '20211014007', 'A1', '2021-10-14 16:13:39', 4, 'D1', 'A1', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141335', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3301, '20211014007', 'A2', '2021-10-14 16:13:39', 4, 'D1', 'A2', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141332', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3302, '20211014007', 'A3', '2021-10-14 16:13:39', 4, 'D1', 'A3', 'To', 0.078, 0.000, 0, 0.000, 3, 'Goback', 'ReleaseAxis', 'Sample', '样品', 1, '10141337', 0.200, NULL, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3303, NULL, 'A1', '2021-10-16 11:41:19', 4, '', '', NULL, 0.000, 0.000, 0, 0.000, 4, 'Wash', NULL, 'Wash', '清洗', 0, NULL, 0.000, 0.000, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3304, NULL, 'A1', '2021-10-16 13:45:42', 4, '', '', NULL, 0.000, 0.000, 0, 0.000, 4, 'Wash', NULL, 'Wash', '清洗', 0, NULL, 0.000, 0.000, 0, NULL, NULL, NULL); INSERT INTO `equipment_task` VALUES (3305, '20211016001', 'A1', '2021-10-16 14:12:22', 4, 'C1', 'D1', 'To', 0.000, 0.000, 0, 0.000, 3, 'Titration', 'TitrationNa2C2O4', 'Sample', '样品', 1, '10161218', 100.000, 0.000, 0, NULL, NULL, NULL); -- ---------------------------- -- Table structure for execute_time -- ---------------------------- DROP TABLE IF EXISTS `execute_time`; CREATE TABLE `execute_time` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `TypeName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称', `Value` double(4, 2) NULL DEFAULT NULL COMMENT '值', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of execute_time -- ---------------------------- INSERT INTO `execute_time` VALUES (1, 'DissolveTime', 1.00, '消解时间（min）'); INSERT INTO `execute_time` VALUES (3, 'DissolveInterval', 5.00, '消解间隔（min）'); INSERT INTO `execute_time` VALUES (5, 'DewaterTime', 5.00, '除水时间（s）'); -- ---------------------------- -- Table structure for liquid_amount -- ---------------------------- DROP TABLE IF EXISTS `liquid_amount`; CREATE TABLE `liquid_amount` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `LiquidName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '液体名称', `Capacity` double(8, 5) NULL DEFAULT NULL COMMENT '容量', `Amount` double(8, 5) NULL DEFAULT NULL COMMENT '数量', `ConvertRatio` int(0) NULL DEFAULT NULL COMMENT '转换比例', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of liquid_amount -- ---------------------------- INSERT INTO `liquid_amount` VALUES (1, 'SodiumOxalate', 1.00000, 0.24765, 20000, '草酸钠'); INSERT INTO `liquid_amount` VALUES (2, 'AddLiquidPotassiumPermanganate', 1.00000, 0.07811, 20000, '高锰酸钾（加液）'); INSERT INTO `liquid_amount` VALUES (3, 'TitrationPotassiumPermanganate', 1.00000, 0.07811, 1000, '高锰酸钾（滴定）'); -- ---------------------------- -- Table structure for liquid_volume -- ---------------------------- DROP TABLE IF EXISTS `liquid_volume`; CREATE TABLE `liquid_volume` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `LiquidName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '液体名称', `ClearVolume` double(12, 3) NULL DEFAULT NULL COMMENT '清洗体积', `SampleVolume` double(12, 3) NULL DEFAULT NULL COMMENT '样品滴定体积', `Enable` int(0) NULL DEFAULT NULL COMMENT '启用', `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of liquid_volume -- ---------------------------- INSERT INTO `liquid_volume` VALUES (6, 'SodiumOxalate', 10.000, 3.000, 1, '草酸钠（ml）'); INSERT INTO `liquid_volume` VALUES (7, 'SodiumHydroxide', 10.000, 5.000, 1, '氢氧化钠（s）'); INSERT INTO `liquid_volume` VALUES (8, 'AddLiquidPotassiumPermanganate', 10.000, 1.000, 1, '加液位高锰酸钾（ml）'); INSERT INTO `liquid_volume` VALUES (9, 'AddLiquidVitriol', 10.000, 5.000, 1, '加液位硫酸（s）'); INSERT INTO `liquid_volume` VALUES (10, 'TitrationPotassiumPermanganate', 10.000, 1.000, 1, '滴定位高锰酸钾（ml）'); INSERT INTO `liquid_volume` VALUES (11, 'TitrationVitriol', 10.000, 5.000, 1, '滴定位硫酸（s）'); -- ---------------------------- -- Table structure for motor_convert -- ---------------------------- DROP TABLE IF EXISTS `motor_convert`; CREATE TABLE `motor_convert` ( `SeriKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `MotorName` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电机名称', `ConvertRatio` double(8, 3) NULL DEFAULT NULL COMMENT '转换数值', PRIMARY KEY (`SeriKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = 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); -- ---------------------------- -- Table structure for motor_move_status -- ---------------------------- DROP TABLE IF EXISTS `motor_move_status`; CREATE TABLE `motor_move_status` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `MotorName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电机名称', `CurrentPosition` double(8, 3) NULL DEFAULT NULL COMMENT '当前位置', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of motor_move_status -- ---------------------------- INSERT INTO `motor_move_status` VALUES (1, 'AxisX', 300.000, 'X轴'); INSERT INTO `motor_move_status` VALUES (2, 'AxisY', 95.000, 'Y轴'); INSERT INTO `motor_move_status` VALUES (3, 'AxisZ', 0.000, 'Z轴'); -- ---------------------------- -- Table structure for motor_speed -- ---------------------------- DROP TABLE IF EXISTS `motor_speed`; CREATE TABLE `motor_speed` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `DetailName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述名称', `SystemName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '系统名称', `Speed` int(0) NULL DEFAULT NULL COMMENT '速度', `AcSpeed` int(0) NULL DEFAULT NULL COMMENT '加速度', `DeSpeed` int(0) NULL DEFAULT NULL COMMENT '减速度', `ConnectAutoUpdate` int(0) NULL DEFAULT NULL COMMENT '连接成功后自动更新', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of motor_speed -- ---------------------------- INSERT INTO `motor_speed` VALUES (1, 'X轴', 'AxisX', 6, 420, 420, 1); INSERT INTO `motor_speed` VALUES (2, 'Y轴', 'AxisY', 8, 420, 420, 1); INSERT INTO `motor_speed` VALUES (3, 'Z轴', 'AxisZ', 8, 420, 420, 1); INSERT INTO `motor_speed` VALUES (4, '草酸钠', 'SodiumOxalate', 2, 420, 420, 1); INSERT INTO `motor_speed` VALUES (5, '加液位高锰酸钾', 'AddLiquidPotassiumPermanganate', 2, 420, 420, 1); INSERT INTO `motor_speed` VALUES (6, '滴定位高锰酸钾', 'TitrationPotassiumPermanganate', 3, 420, 420, 1); -- ---------------------------- -- Table structure for pid -- ---------------------------- DROP TABLE IF EXISTS `pid`; CREATE TABLE `pid` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `TypeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型名称', `Ratio` double(8, 3) NOT NULL COMMENT '比例', `Integral` int(0) NULL DEFAULT NULL COMMENT '积分', `Differential` int(0) NULL DEFAULT NULL COMMENT '微分', `IntegralDeafult` double(8, 3) NULL DEFAULT NULL COMMENT '积分默认值', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of pid -- ---------------------------- INSERT INTO `pid` VALUES (1, 'DissolveHeating', 15.500, 38, 9, 72.500, '消解加热'); INSERT INTO `pid` VALUES (2, 'TitrationHeating', 13.000, 12, 9, 72.500, '滴定加热'); -- ---------------------------- -- Table structure for position_hotlist -- ---------------------------- DROP TABLE IF EXISTS `position_hotlist`; CREATE TABLE `position_hotlist` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `PositionName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置名称', `CurrentOccupy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '当前占位', `Enable` int(0) NULL DEFAULT NULL COMMENT '启用', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = 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, 'C1', '', 1); INSERT INTO `position_hotlist` VALUES (11, 'D1', '', 1); INSERT INTO `position_hotlist` VALUES (12, 'L1', '', 1); -- ---------------------------- -- Table structure for route -- ---------------------------- DROP TABLE IF EXISTS `route`; CREATE TABLE `route` ( `Serialkey` int(0) NOT NULL AUTO_INCREMENT, `TaskType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `RouteID` int(0) NULL DEFAULT NULL, `RouteType` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (`Serialkey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of route -- ---------------------------- INSERT INTO `route` VALUES (1, 'Sample', 1, 'AddLiquid', NULL); INSERT INTO `route` VALUES (2, 'Sample', 2, 'Dissolve', NULL); INSERT INTO `route` VALUES (3, 'Sample', 3, 'Titration', NULL); INSERT INTO `route` VALUES (14, 'Wash', 4, 'Wash', ''); -- ---------------------------- -- Table structure for routecache -- ---------------------------- DROP TABLE IF EXISTS `routecache`; CREATE TABLE `routecache` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT, `CreateTime` datetime(0) NULL DEFAULT '0001-01-01 00:00:00', `Source` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `RouteID` int(0) NULL DEFAULT NULL, `RouteStep` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `Status` int(0) NULL DEFAULT NULL, PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 642 CHARACTER SET = 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(0) NOT NULL AUTO_INCREMENT, `RouteID` int(0) NULL DEFAULT NULL, `Order` int(0) NULL DEFAULT NULL, `Step` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `From` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `To` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of routestep -- ---------------------------- INSERT INTO `routestep` VALUES (1, 1, 1, 'AddLiquid', 'Source', 'AddLiquidPosition', NULL); INSERT INTO `routestep` VALUES (2, 1, 2, 'Goback', 'AddLiquidPosition', 'Source', NULL); INSERT INTO `routestep` VALUES (3, 2, 1, 'Dissolve', 'Source', 'DissolvePosition', NULL); INSERT INTO `routestep` VALUES (4, 2, 2, 'DissolveGoback', 'DissolvePosition', 'DewaterPosition', NULL); INSERT INTO `routestep` VALUES (5, 3, 1, 'Titration', 'DewaterPosition', 'TitrationPosition', NULL); INSERT INTO `routestep` VALUES (6, 3, 2, 'Goback', 'TitrationPosition', 'Source', NULL); INSERT INTO `routestep` VALUES (7, 4, 1, 'Wash', 'Source', 'Source', NULL); -- ---------------------------- -- Table structure for sampledetails -- ---------------------------- DROP TABLE IF EXISTS `sampledetails`; CREATE TABLE `sampledetails` ( `Serialkey` int(0) 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 NULL DEFAULT NULL COMMENT '详情信息', `SampleVolume` double(8, 3) NULL DEFAULT NULL COMMENT '取样体积', `SampleMultiple` double(8, 3) NULL DEFAULT NULL COMMENT '取样倍数', `SampleType` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样品类型', `AcidBaseProp` int(0) NULL DEFAULT NULL COMMENT '酸碱性', `IsCalibration` int(0) NULL DEFAULT NULL COMMENT '是否标定', `QuicklyTitration` int(0) NULL DEFAULT NULL COMMENT '快速滴定', `TaskStatus` int(0) NULL DEFAULT NULL COMMENT '任务状态', PRIMARY KEY (`Serialkey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sampledetails -- ---------------------------- INSERT INTO `sampledetails` VALUES (1, 'Left', 'A1', '10161218', 100.000, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (2, 'Left', 'A2', '10141332', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (3, 'Left', 'A3', '10151252', 10.000, 0.900, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (4, 'Left', 'A4', '10155538', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (5, 'Left', 'A5', '09140241', 0.200, 0.000, '样品', 2, 0, 0, 0); INSERT INTO `sampledetails` VALUES (6, 'Left', 'A6', '09100158', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (7, 'Left', 'A7', '09231931', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (8, 'Left', 'A8', '10134455', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (9, 'Left', 'A9', '09260543', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (10, 'Left', 'A10', '09145449', 0.200, 0.000, '样品', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (11, 'Left', 'A11', '09132445', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (12, 'Left', 'A12', '09231935', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (13, 'Left', 'A13', '09260545', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (14, 'Left', 'A14', '09233257', 0.200, 0.000, '样品', 1, 1, 0, 0); INSERT INTO `sampledetails` VALUES (15, 'Left', 'A15', '09101321', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (16, 'Left', 'A16', '09101324', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (17, 'Left', 'A17', '09101325', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (18, 'Left', 'A18', '09231937', 0.200, 0.000, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (19, 'Left', 'A19', '09101330', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (20, 'Left', 'A20', '09092350', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (21, 'Left', 'A21', '08195412', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (22, 'Left', 'A22', '09083526', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (23, 'Left', 'A23', '08195416', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (24, 'Left', 'A24', '08195423', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (25, 'Left', 'A25', '08195427', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (26, 'Left', 'A26', '08195430', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (27, 'Left', 'A27', '08195433', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (28, 'Left', 'A28', '08195436', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (29, 'Left', 'A29', '08195439', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (30, 'Left', 'A30', '08195441', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (31, 'Left', 'A31', '08195444', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (32, 'Left', 'A32', '08195448', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (33, 'Left', 'A33', '08195454', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (34, 'Left', 'A34', '08195459', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (35, 'Left', 'A35', '08195506', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (36, 'Right', 'A36', '09104113', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (37, 'Right', 'A37', '10151553', 10.000, 0.900, '样品', 1, 0, 0, 0); INSERT INTO `sampledetails` VALUES (38, 'Right', 'A38', '08195516', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (39, 'Right', 'A39', '08195521', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (40, 'Right', 'A40', '08195525', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (41, 'Right', 'A41', '09102853', 0.200, 0.000, '酸性', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (42, 'Right', 'A42', '08195534', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (43, 'Right', 'A43', '08195537', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (44, 'Right', 'A44', '08195540', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (45, 'Right', 'A45', '08195542', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (46, 'Right', 'A46', '08195545', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (47, 'Right', 'A47', '08195547', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (48, 'Right', 'A48', '08195550', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (49, 'Right', 'A49', '08195636', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (50, 'Right', 'A50', '08195640', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (51, 'Right', 'A51', '03185904', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (52, 'Right', 'A52', '03185915', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (53, 'Right', 'A53', '03185924', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (54, 'Right', 'A54', '03185933', 10.000, 0.000, '土样', NULL, 0, 0, 0); INSERT INTO `sampledetails` VALUES (55, 'Right', 'A55', '03185849', 10.000, 0.000, '土样', NULL, 0, 0, 0); -- ---------------------------- -- Table structure for statemachine -- ---------------------------- DROP TABLE IF EXISTS `statemachine`; CREATE TABLE `statemachine` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT, `Name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `Status` int(0) NULL DEFAULT NULL, PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of statemachine -- ---------------------------- INSERT INTO `statemachine` VALUES (1, 'MotorLock', 0); -- ---------------------------- -- Table structure for task_priority -- ---------------------------- DROP TABLE IF EXISTS `task_priority`; CREATE TABLE `task_priority` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键', `Step` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型', `Priority` int(0) NULL DEFAULT NULL COMMENT '优先级', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of task_priority -- ---------------------------- INSERT INTO `task_priority` VALUES (1, 'Titration', 500); INSERT INTO `task_priority` VALUES (2, 'DissolveGoback', 400); INSERT INTO `task_priority` VALUES (3, 'Dissolve', 300); INSERT INTO `task_priority` VALUES (7, 'Goback', 200); INSERT INTO `task_priority` VALUES (8, 'AddLiquid', 100); -- ---------------------------- -- Table structure for titration_value -- ---------------------------- DROP TABLE IF EXISTS `titration_value`; CREATE TABLE `titration_value` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT COMMENT '主键自增', `TitrationType` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '滴定类型', `RangeValue` double(5, 2) NULL DEFAULT NULL COMMENT '阈值', `BeforeWaitTime` int(0) NULL DEFAULT NULL COMMENT '滴定前等待时间', `ArriveCheckCount` int(0) NULL DEFAULT NULL COMMENT '到达阈值后的检查次数', `MaxDropVolume` double(5, 3) NULL DEFAULT NULL COMMENT '最大滴定体积', `QuicklyTitrationValue` double(5, 3) NULL DEFAULT NULL COMMENT '快速滴定值', `Description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of titration_value -- ---------------------------- INSERT INTO `titration_value` VALUES (1, 'Default', 50.00, 10, 10, 2.000, 15.000, '默认'); -- ---------------------------- -- Table structure for wavekey -- ---------------------------- DROP TABLE IF EXISTS `wavekey`; CREATE TABLE `wavekey` ( `SerialKey` int(0) NOT NULL AUTO_INCREMENT, `WaveKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '波次号', `FinishValue` int(0) NULL DEFAULT NULL COMMENT '完成值', `TotalValue` int(0) NULL DEFAULT NULL COMMENT '总数', `State` int(0) NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`SerialKey`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 235 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of wavekey -- ---------------------------- INSERT INTO `wavekey` VALUES (208, '20211010001', 0, 0, 0); INSERT INTO `wavekey` VALUES (209, '20211012001', 0, 0, 0); INSERT INTO `wavekey` VALUES (210, '20211012002', 0, 0, 0); INSERT INTO `wavekey` VALUES (211, '20211012003', 0, 0, 0); INSERT INTO `wavekey` VALUES (212, '20211013001', 0, 0, 0); INSERT INTO `wavekey` VALUES (213, '20211013002', 0, 0, 0); INSERT INTO `wavekey` VALUES (214, '20211013003', 0, 0, 0); INSERT INTO `wavekey` VALUES (215, '20211013004', 0, 0, 0); INSERT INTO `wavekey` VALUES (216, '20211013005', 0, 0, 0); INSERT INTO `wavekey` VALUES (217, '20211013006', 0, 0, 0); INSERT INTO `wavekey` VALUES (218, '20211013007', 0, 0, 0); INSERT INTO `wavekey` VALUES (219, '20211013008', 0, 0, 0); INSERT INTO `wavekey` VALUES (220, '20211013009', 0, 0, 0); INSERT INTO `wavekey` VALUES (221, '20211013010', 0, 0, 0); INSERT INTO `wavekey` VALUES (222, '20211013011', 0, 0, 0); INSERT INTO `wavekey` VALUES (223, '20211013012', 0, 0, 0); INSERT INTO `wavekey` VALUES (224, '20211013013', 0, 0, 0); INSERT INTO `wavekey` VALUES (225, '20211013014', 0, 0, 0); INSERT INTO `wavekey` VALUES (226, '20211013015', 0, 0, 0); INSERT INTO `wavekey` VALUES (227, '20211013016', 0, 0, 0); INSERT INTO `wavekey` VALUES (228, '20211014001', 0, 0, 0); INSERT INTO `wavekey` VALUES (229, '20211014002', 0, 0, 0); INSERT INTO `wavekey` VALUES (230, '20211014003', 0, 0, 0); INSERT INTO `wavekey` VALUES (231, '20211014004', 0, 0, 0); INSERT INTO `wavekey` VALUES (232, '20211014005', 0, 0, 0); INSERT INTO `wavekey` VALUES (233, '20211014006', 0, 0, 0); INSERT INTO `wavekey` VALUES (234, '20211014007', 0, 0, 0); INSERT INTO `wavekey` VALUES (235, '20211016001', 0, 0, 0); SET FOREIGN_KEY_CHECKS = 1;