SHJX_GM/SHJX.Service.Resource/DataBase/soil_equipment_data.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : soil_equipment_data

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 14/06/2021 19:39:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cooling_date
-- ----------------------------
DROP TABLE IF EXISTS `cooling_date`;
CREATE TABLE `cooling_date`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `PositionName` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `LastTryTime` datetime(0) NULL DEFAULT NULL,
  `Start` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cooling_date
-- ----------------------------
INSERT INTO `cooling_date` VALUES (1, 'A1', '2021-05-21 13:57:26', 0);
INSERT INTO `cooling_date` VALUES (2, 'A2', '2021-05-31 15:09:19', 0);
INSERT INTO `cooling_date` VALUES (3, 'A3', '2021-05-29 13:22:07', 0);
INSERT INTO `cooling_date` VALUES (4, 'A4', '2021-05-21 14:07:11', 0);
INSERT INTO `cooling_date` VALUES (5, 'A5', '2021-05-19 09:42:55', 0);
INSERT INTO `cooling_date` VALUES (6, 'A6', '2021-05-19 09:45:49', 0);
INSERT INTO `cooling_date` VALUES (7, 'A7', '2021-05-19 09:50:05', 0);
INSERT INTO `cooling_date` VALUES (8, 'A8', '2021-05-15 15:55:47', 0);
INSERT INTO `cooling_date` VALUES (9, 'A9', '2021-05-15 14:37:22', 0);
INSERT INTO `cooling_date` VALUES (10, 'A10', '2021-05-15 14:41:29', 0);
INSERT INTO `cooling_date` VALUES (11, 'A11', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (12, 'A12', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (13, 'A13', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (14, 'A14', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (15, 'A15', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (16, 'A16', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (17, 'A17', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (18, 'A18', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (19, 'A19', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (20, 'A20', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (21, 'A21', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (22, 'A22', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (23, 'A23', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (24, 'A24', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (25, 'A25', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (26, 'A26', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (27, 'A27', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (28, 'A28', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (29, 'A29', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (30, 'A30', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (31, 'A31', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (32, 'A32', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (33, 'A33', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (34, 'A34', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (35, 'A35', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (36, 'A36', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (37, 'A37', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (38, 'A38', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (39, 'A39', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (40, 'A40', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (41, 'A41', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (42, 'A42', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (43, 'A43', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (44, 'A44', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (45, 'A45', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (46, 'A46', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (47, 'A47', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (48, 'A48', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (49, 'A49', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (50, 'A50', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (51, 'A51', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (52, 'A52', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (53, 'A53', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (54, 'A54', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (55, 'A55', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (56, 'A56', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (57, 'A57', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (58, 'A58', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (59, 'A59', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (60, 'A60', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (61, 'A61', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (62, 'A62', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (63, 'A63', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (64, 'A64', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (65, 'A65', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (66, 'A66', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (67, 'A67', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (68, 'A68', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (69, 'A69', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (70, 'A70', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (71, 'A71', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (72, 'A72', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (73, 'A73', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (74, 'A74', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (75, 'A75', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (76, 'A76', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (77, 'A77', '0001-01-01 00:00:00', 0);
INSERT INTO `cooling_date` VALUES (78, 'A78', '0001-01-01 00:00:00', 0);

-- ----------------------------
-- Table structure for dissolve_date
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_date`;
CREATE TABLE `dissolve_date`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `PositionName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `SampleLocalName` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `LastTryTime` datetime(0) NULL DEFAULT NULL,
  `Start` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dissolve_date
-- ----------------------------
INSERT INTO `dissolve_date` VALUES (1, 'R1', '', '2021-05-31 15:11:09', 0);
INSERT INTO `dissolve_date` VALUES (2, 'R2', '', '2021-05-31 15:07:03', 0);
INSERT INTO `dissolve_date` VALUES (3, 'R3', '', '2021-05-07 17:01:36', 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);

-- ----------------------------
-- Table structure for dissolve_interval
-- ----------------------------
DROP TABLE IF EXISTS `dissolve_interval`;
CREATE TABLE `dissolve_interval`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `LastTryTime` datetime(0) NULL DEFAULT NULL,
  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-05-31 15:10:40');

-- ----------------------------
-- Table structure for equipment_areas
-- ----------------------------
DROP TABLE IF EXISTS `equipment_areas`;
CREATE TABLE `equipment_areas`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `AreaName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `PointName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `LocationX` double(8, 3) NULL DEFAULT NULL,
  `LocationY` double(8, 3) NULL DEFAULT NULL,
  `LocationZ` double(8, 3) NULL DEFAULT NULL,
  `Enable` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of equipment_areas
-- ----------------------------
INSERT INTO `equipment_areas` VALUES (1, 'SamplePosition', 'A1', 0.000, 0.000, 1.000, 1);
INSERT INTO `equipment_areas` VALUES (2, 'SamplePosition', 'A2', 22.200, 37.000, 178.000, 1);
INSERT INTO `equipment_areas` VALUES (3, 'SamplePosition', 'A3', 49.500, 37.000, 178.000, 1);
INSERT INTO `equipment_areas` VALUES (4, 'SamplePosition', 'A4', 76.500, 37.000, 178.000, 1);
INSERT INTO `equipment_areas` VALUES (5, 'SamplePosition', 'A5', 103.500, 37.000, 178.000, 1);
INSERT INTO `equipment_areas` VALUES (6, 'SamplePosition', 'A6', 130.500, 37.000, 178.000, 1);
INSERT INTO `equipment_areas` VALUES (7, 'SamplePosition', 'A7', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (8, 'SamplePosition', 'A8', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (9, 'SamplePosition', 'A9', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (10, 'SamplePosition', 'A10', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (11, 'SamplePosition', 'A11', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (12, 'SamplePosition', 'A12', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (13, 'SamplePosition', 'A13', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (14, 'SamplePosition', 'A14', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (15, 'SamplePosition', 'A15', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (16, 'SamplePosition', 'A16', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (17, 'SamplePosition', 'A17', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (18, 'SamplePosition', 'A18', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (19, 'SamplePosition', 'A19', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (20, 'SamplePosition', 'A20', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (21, 'SamplePosition', 'A21', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (22, 'SamplePosition', 'A22', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (23, 'SamplePosition', 'A23', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (24, 'SamplePosition', 'A24', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (25, 'SamplePosition', 'A25', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (26, 'SamplePosition', 'A26', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (27, 'SamplePosition', 'A27', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (28, 'SamplePosition', 'A28', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (29, 'SamplePosition', 'A29', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (30, 'SamplePosition', 'A30', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (31, 'SamplePosition', 'A31', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (32, 'SamplePosition', 'A32', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (33, 'SamplePosition', 'A33', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (34, 'SamplePosition', 'A34', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (35, 'SamplePosition', 'A35', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (36, 'SamplePosition', 'A36', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (37, 'SamplePosition', 'A37', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (38, 'SamplePosition', 'A38', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (39, 'SamplePosition', 'A39', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (40, 'SamplePosition', 'A40', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (41, 'SamplePosition', 'A41', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (42, 'SamplePosition', 'A42', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (43, 'SamplePosition', 'A43', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (44, 'SamplePosition', 'A44', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (45, 'SamplePosition', 'A45', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (46, 'SamplePosition', 'A46', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (47, 'SamplePosition', 'A47', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (48, 'SamplePosition', 'A48', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (49, 'SamplePosition', 'A49', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (50, 'SamplePosition', 'A50', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (51, 'SamplePosition', 'A51', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (52, 'SamplePosition', 'A52', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (53, 'SamplePosition', 'A53', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (54, 'SamplePosition', 'A54', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (55, 'SamplePosition', 'A55', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (56, 'SamplePosition', 'A56', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (57, 'SamplePosition', 'A57', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (58, 'SamplePosition', 'A58', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (59, 'SamplePosition', 'A59', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (60, 'SamplePosition', 'A60', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (61, 'SamplePosition', 'A61', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (62, 'SamplePosition', 'A62', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (63, 'SamplePosition', 'A63', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (64, 'SamplePosition', 'A64', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (65, 'SamplePosition', 'A65', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (66, 'SamplePosition', 'A66', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (67, 'SamplePosition', 'A67', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (68, 'SamplePosition', 'A68', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (69, 'SamplePosition', 'A69', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (70, 'SamplePosition', 'A70', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (71, 'SamplePosition', 'A71', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (72, 'SamplePosition', 'A72', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (73, 'SamplePosition', 'A73', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (74, 'SamplePosition', 'A74', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (75, 'SamplePosition', 'A75', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (76, 'SamplePosition', 'A76', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (77, 'SamplePosition', 'A77', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (78, 'SamplePosition', 'A78', 0.000, 0.000, 0.000, 1);
INSERT INTO `equipment_areas` VALUES (79, 'BowlCoverPosition', 'B1', 174.000, 126.600, 164.000, 1);
INSERT INTO `equipment_areas` VALUES (80, 'BowlCoverPosition', 'B2', 201.000, 126.600, 164.000, 1);
INSERT INTO `equipment_areas` VALUES (81, 'BowlCoverPosition', 'B3', 228.000, 126.600, 164.000, 1);
INSERT INTO `equipment_areas` VALUES (82, 'BowlCoverPosition', 'B4', 255.000, 126.600, 164.000, 1);
INSERT INTO `equipment_areas` VALUES (83, 'BowlCoverPosition', 'B5', 282.000, 126.600, 164.000, 1);
INSERT INTO `equipment_areas` VALUES (84, 'DissolvePosition', 'R1', 196.800, 50.000, 175.000, 1);
INSERT INTO `equipment_areas` VALUES (85, 'DissolvePosition', 'R2', 223.800, 50.000, 175.000, 1);
INSERT INTO `equipment_areas` VALUES (86, 'DissolvePosition', 'R3', 250.800, 50.000, 175.000, 1);
INSERT INTO `equipment_areas` VALUES (87, 'DissolvePosition', 'R4', 277.800, 50.000, 175.000, 1);
INSERT INTO `equipment_areas` VALUES (88, 'UnKnown', 'R5', 304.800, 50.000, 175.000, 1);
INSERT INTO `equipment_areas` VALUES (89, 'TitrationPosition', 'D1', 330.000, 209.000, 185.000, 1);
INSERT INTO `equipment_areas` VALUES (90, 'AddLiquidPosition', 'L1', 330.800, 337.000, 185.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 '目标地址',
  `Amount` double(8, 3) NULL DEFAULT 0.000 COMMENT '滴定数量',
  `Result` double(8, 3) NULL DEFAULT NULL COMMENT '滴定结果',
  `Route` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由',
  `RouteStep` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由步骤',
  `DetailStep` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由步骤ID',
  `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 '任务类型',
  `TaskDetailName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样品描述',
  `GetSampleQuality` double(8, 3) 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 = 2877 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of equipment_task
-- ----------------------------

-- ----------------------------
-- Table structure for execute_time
-- ----------------------------
DROP TABLE IF EXISTS `execute_time`;
CREATE TABLE `execute_time`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `TypeName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Value` double(4, 2) 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of execute_time
-- ----------------------------
INSERT INTO `execute_time` VALUES (1, 'DissolveTime', 5.00, '消解时间');
INSERT INTO `execute_time` VALUES (2, 'CoolingTime', 5.00, '冷却时间');
INSERT INTO `execute_time` VALUES (3, 'DissolveInterval', 2.00, '消解间隔');
INSERT INTO `execute_time` VALUES (4, 'PreemptionTime', 1.50, '提前预占时间');

-- ----------------------------
-- Table structure for liquid_amount
-- ----------------------------
DROP TABLE IF EXISTS `liquid_amount`;
CREATE TABLE `liquid_amount`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `LiquidName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Amount` double(8, 5) 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 = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_amount
-- ----------------------------
INSERT INTO `liquid_amount` VALUES (1, 'PotassiumDichromate', 0.12350, '重铬酸钾');
INSERT INTO `liquid_amount` VALUES (2, 'FAS', 0.06388, '硫酸亚铁铵');

-- ----------------------------
-- Table structure for liquid_volume
-- ----------------------------
DROP TABLE IF EXISTS `liquid_volume`;
CREATE TABLE `liquid_volume`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `LiquidName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '液体名称',
  `ClearVolume` double(12, 3) NULL DEFAULT NULL COMMENT '清洗体积',
  `WashVolume` double(12, 3) NULL DEFAULT NULL COMMENT '润洗体积',
  `SampleVolume` double(12, 3) NULL DEFAULT NULL COMMENT '样品滴定体积',
  `Enable` int(0) NULL DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of liquid_volume
-- ----------------------------
INSERT INTO `liquid_volume` VALUES (1, 'Water', 14.000, 14.000, 5.000, 1, '水（s）');
INSERT INTO `liquid_volume` VALUES (2, 'Indicator', 15.000, 15.000, 1.000, 1, '试亚铁灵（s）');
INSERT INTO `liquid_volume` VALUES (3, 'PotassiumDichromate', 5.000, 5.000, 10.000, 1, '重铬酸钾（ml）');
INSERT INTO `liquid_volume` VALUES (4, 'FAS', 5.000, 5.000, 5.000, 1, '硫酸亚铁铵（ml）');

-- ----------------------------
-- Table structure for motor_move
-- ----------------------------
DROP TABLE IF EXISTS `motor_move`;
CREATE TABLE `motor_move`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `MoveType` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `MovePoint` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `PreemptionPoint` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CurrentStatus` int(0) 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 = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_move
-- ----------------------------
INSERT INTO `motor_move` VALUES (1, 'AddLiquid', '', '', 0, '加液');
INSERT INTO `motor_move` VALUES (2, 'Dissolve', '', '', 0, '消解');
INSERT INTO `motor_move` VALUES (3, 'Titration', '', '', 0, '滴定');
INSERT INTO `motor_move` VALUES (4, 'Cooling', '', '', 0, '冷却');

-- ----------------------------
-- 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,
  `MotorName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CurrentPosition` double(8, 3) NULL DEFAULT NULL,
  `MotorStatus` int(0) NULL DEFAULT NULL,
  `ConvertRatio` double(8, 3) 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 = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_move_status
-- ----------------------------
INSERT INTO `motor_move_status` VALUES (1, 'MotorX', 0.000, 1, 4000.000, 'X轴');
INSERT INTO `motor_move_status` VALUES (2, 'MotorY', 0.000, 1, 4000.000, 'Y轴');
INSERT INTO `motor_move_status` VALUES (3, 'MotorZ', 0.000, 1, 4000.000, 'Z轴');

-- ----------------------------
-- Table structure for motor_move_step
-- ----------------------------
DROP TABLE IF EXISTS `motor_move_step`;
CREATE TABLE `motor_move_step`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `MoveType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CurrentType` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `NextType` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CurrentStep` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `NextStep` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `IsInit` varchar(2) 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 = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of motor_move_step
-- ----------------------------
INSERT INTO `motor_move_step` VALUES (1, 'CoolingMove', 'From', 'From', 'MotorX', 'MotorY', 'Y', NULL);
INSERT INTO `motor_move_step` VALUES (2, 'CoolingMove', 'From', 'From', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (3, 'CoolingMove', 'From', 'From', 'MotorZ', 'AW_ManiGrab', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (4, 'CoolingMove', 'From', 'From', 'AW_ManiGrab', 'AddWater', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (5, 'CoolingMove', 'From', 'From', 'AddWater', 'AW_ManiLoosen', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (6, 'CoolingMove', 'From', 'From', 'AW_ManiLoosen', 'MotorZ_Rise', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (7, 'CoolingMove', 'From', 'From', 'MotorZ_Rise', 'ManiGrab', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (8, 'CoolingMove', 'From', 'From', 'ManiGrab', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (9, 'CoolingMove', 'From', 'To', 'MotorZ_GoBack', 'MotorX', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (10, 'CoolingMove', 'To', 'To', 'MotorX', 'MotorY', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (11, 'CoolingMove', 'To', 'To', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (12, 'CoolingMove', 'To', 'To', 'MotorZ', 'ManiLoosen', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (13, 'CoolingMove', 'To', 'To', 'ManiLoosen', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (14, 'CoolingMove', 'To', 'To', 'MotorZ_GoBack', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (15, 'MotorMove|MotorGoBack', 'From', 'From', 'MotorX', 'MotorY', 'Y', NULL);
INSERT INTO `motor_move_step` VALUES (16, 'MotorMove|MotorGoBack', 'From', 'From', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (17, 'MotorMove|MotorGoBack', 'From', 'From', 'MotorZ', 'ManiGrab', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (18, 'MotorMove|MotorGoBack', 'From', 'From', 'ManiGrab', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (19, 'MotorMove|MotorGoBack', 'From', 'To', 'MotorZ_GoBack', 'MotorX', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (20, 'MotorMove|MotorGoBack', 'To', 'To', 'MotorX', 'MotorY', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (21, 'MotorMove|MotorGoBack', 'To', 'To', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (22, 'MotorMove|MotorGoBack', 'To', 'To', 'MotorZ', 'ManiLoosen', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (23, 'MotorMove|MotorGoBack', 'To', 'To', 'ManiLoosen', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (24, 'MotorMove|MotorGoBack', 'To', 'To', 'MotorZ_GoBack', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (25, 'BowlCoverMove', 'To', 'To', 'MotorX', 'MotorY', 'Y', NULL);
INSERT INTO `motor_move_step` VALUES (26, 'BowlCoverMove', 'To', 'To', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (27, 'BowlCoverMove', 'To', 'To', 'MotorZ', 'ManiGrab', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (28, 'BowlCoverMove', 'To', 'To', 'ManiGrab', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (29, 'BowlCoverMove', 'To', 'To', 'MotorZ_GoBack', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (30, 'BowlCoverGoBack', 'To', 'To', 'MotorX', 'MotorY', 'Y', NULL);
INSERT INTO `motor_move_step` VALUES (31, 'BowlCoverGoBack', 'To', 'To', 'MotorY', 'MotorZ', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (32, 'BowlCoverGoBack', 'To', 'To', 'MotorZ', 'ManiLoosen', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (33, 'BowlCoverGoBack', 'To', 'To', 'ManiLoosen', 'MotorZ_GoBack', 'N', NULL);
INSERT INTO `motor_move_step` VALUES (34, 'BowlCoverGoBack', 'To', 'To', 'MotorZ_GoBack', 'MotorZ_GoBack', 'N', NULL);

-- ----------------------------
-- Table structure for motor_speed
-- ----------------------------
DROP TABLE IF EXISTS `motor_speed`;
CREATE TABLE `motor_speed`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `DetailName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `SystemName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Speed` double NULL DEFAULT NULL,
  `AcSpeed` double NULL DEFAULT NULL,
  `DeSpeed` double NULL DEFAULT NULL,
  `ConnectAutoUpdate` int(0) 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 motor_speed
-- ----------------------------
INSERT INTO `motor_speed` VALUES (1, 'X轴', 'MotorX', 10, 20, 300, 1);
INSERT INTO `motor_speed` VALUES (2, 'Y轴', 'MotorY', 8, 20, 300, 1);
INSERT INTO `motor_speed` VALUES (3, 'Z轴', 'MotorZ', 8, 20, 300, 1);
INSERT INTO `motor_speed` VALUES (4, '重铬酸钾', 'PotassiumDichromate', 1, 20, 300, 1);
INSERT INTO `motor_speed` VALUES (5, '硫酸亚铁铵', 'FAS', 2, 20, 300, 1);

-- ----------------------------
-- Table structure for pid
-- ----------------------------
DROP TABLE IF EXISTS `pid`;
CREATE TABLE `pid`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `TypeName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Ratio` double(8, 3) NOT NULL,
  `Integral` int(0) NULL DEFAULT NULL,
  `Differential` int(0) NULL DEFAULT NULL,
  `IntegralDeafult` double(8, 3) 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of pid
-- ----------------------------
INSERT INTO `pid` VALUES (1, 'Heating', 15.500, 38, 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,
  `PositionName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `CurrentOccupy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Enable` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of position_hotlist
-- ----------------------------
INSERT INTO `position_hotlist` VALUES (1, 'B1', '', 1);
INSERT INTO `position_hotlist` VALUES (2, 'B2', '', 1);
INSERT INTO `position_hotlist` VALUES (3, 'B3', '', 1);
INSERT INTO `position_hotlist` VALUES (4, 'B4', '', 1);
INSERT INTO `position_hotlist` VALUES (5, 'B5', '', 1);
INSERT INTO `position_hotlist` VALUES (6, 'R1', '', 1);
INSERT INTO `position_hotlist` VALUES (7, 'R2', '', 1);
INSERT INTO `position_hotlist` VALUES (8, 'R3', '', 1);
INSERT INTO `position_hotlist` VALUES (9, 'R4', '', 1);
INSERT INTO `position_hotlist` VALUES (10, 'R5', '', 1);
INSERT INTO `position_hotlist` VALUES (11, 'D1', '', 1);
INSERT INTO `position_hotlist` VALUES (12, 'L1', '', 1);

-- ----------------------------
-- 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,
  `NodeName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `DetailInfo` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `SampleQuality` double(8, 3) NULL DEFAULT NULL,
  `SampleType` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `TaskStatus` int(0) NULL DEFAULT NULL,
  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', '06010821', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (2, 'Left', 'A2', '05161104', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (3, 'Left', 'A3', '05161106', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (4, 'Left', 'A4', '空白', 0.000, '空白', 0);
INSERT INTO `sampledetails` VALUES (5, 'Left', 'A5', '06044254', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (6, 'Left', 'A6', '05310101', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (7, 'Left', 'A7', '05310059', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (8, 'Left', 'A8', '05191114', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (9, 'Left', 'A9', '05164242', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (10, 'Left', 'A10', '05150112', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (11, 'Left', 'A11', '06104234', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (12, 'Left', 'A12', '05163303', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (13, 'Left', 'A13', '05100902', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (14, 'Left', 'A14', '05100903', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (15, 'Left', 'A15', '03201933', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (16, 'Left', 'A16', '空白', 10.000, '空白', 0);
INSERT INTO `sampledetails` VALUES (17, 'Left', 'A17', '空白', 1.000, '空白', 0);
INSERT INTO `sampledetails` VALUES (18, 'Left', 'A18', '06041139', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (19, 'Left', 'A19', '03204141', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (20, 'Left', 'A20', '03204144', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (21, 'Left', 'A21', '03204146', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (22, 'Left', 'A22', '03171034', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (23, 'Left', 'A23', '03174617', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (24, 'Left', 'A24', '05161813', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (25, 'Left', 'A25', '03182347', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (26, 'Left', 'A26', '03182352', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (27, 'Left', 'A27', '03182354', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (28, 'Left', 'A28', '03182356', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (29, 'Left', 'A29', '03182358', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (30, 'Left', 'A30', '03182400', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (31, 'Left', 'A31', '03182414', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (32, 'Left', 'A32', '03182420', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (33, 'Left', 'A33', '03182426', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (34, 'Left', 'A34', '03182433', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (35, 'Left', 'A35', '03182438', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (36, 'Left', 'A36', '03182444', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (37, 'Left', 'A37', '03182416', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (38, 'Left', 'A38', '03182422', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (39, 'Left', 'A39', '03182428', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (40, 'Left', 'A40', '03182435', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (41, 'Left', 'A41', '03182440', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (42, 'Left', 'A42', '03182446', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (43, 'Left', 'A43', '03182418', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (44, 'Left', 'A44', '03182424', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (45, 'Left', 'A45', '03182430', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (46, 'Left', 'A46', '03182436', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (47, 'Left', 'A47', '03182442', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (48, 'Left', 'A48', '03182447', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (49, 'Right', 'A49', '05203604', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (50, 'Right', 'A50', '03185846', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (51, 'Right', 'A51', '03185904', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (52, 'Right', 'A52', '03185915', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (53, 'Right', 'A53', '03185924', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (54, 'Right', 'A54', '03185933', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (55, 'Right', 'A55', '03185849', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (56, 'Right', 'A56', '03185856', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (57, 'Right', 'A57', '03185906', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (58, 'Right', 'A58', '03185916', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (59, 'Right', 'A59', '03185925', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (60, 'Right', 'A60', '03185936', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (61, 'Right', 'A61', '03185851', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (62, 'Right', 'A62', '03185858', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (63, 'Right', 'A63', '03185908', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (64, 'Right', 'A64', '03185918', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (65, 'Right', 'A65', '03185927', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (66, 'Right', 'A66', '03185938', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (67, 'Right', 'A67', '03185853', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (68, 'Right', 'A68', '03185859', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (69, 'Right', 'A69', '03185911', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (70, 'Right', 'A70', '03185920', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (71, 'Right', 'A71', '03185929', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (72, 'Right', 'A72', '03185939', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (73, 'Right', 'A73', '03185855', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (74, 'Right', 'A74', '03185901', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (75, 'Right', 'A75', '03185913', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (76, 'Right', 'A76', '03185922', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (77, 'Right', 'A77', '03185931', 10.000, '土样', 0);
INSERT INTO `sampledetails` VALUES (78, 'Right', 'A78', '03185941', 10.000, '土样', 0);

-- ----------------------------
-- Table structure for task_priority
-- ----------------------------
DROP TABLE IF EXISTS `task_priority`;
CREATE TABLE `task_priority`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `OperateType` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Priority` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of task_priority
-- ----------------------------
INSERT INTO `task_priority` VALUES (1, 'Dissolve', 500);
INSERT INTO `task_priority` VALUES (2, 'Titration', 400);
INSERT INTO `task_priority` VALUES (3, 'AddLiquid', 300);
INSERT INTO `task_priority` VALUES (4, 'Cooling', 200);

-- ----------------------------
-- Table structure for task_route
-- ----------------------------
DROP TABLE IF EXISTS `task_route`;
CREATE TABLE `task_route`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `OpKey` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `RouteType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `NextRoute` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `From` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `To` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `IsInit` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of task_route
-- ----------------------------
INSERT INTO `task_route` VALUES (1, 'Sample', 'AddLiquid', 'Dissolve', 'SamplePosition', 'AddLiquidPosition', 'Y', NULL);
INSERT INTO `task_route` VALUES (2, 'Sample', 'Dissolve', 'Cooling', 'SamplePosition', 'DissolvePosition', 'N', NULL);
INSERT INTO `task_route` VALUES (3, 'Sample', 'Cooling', 'Titration', 'SamplePosition', 'SamplePosition', 'N', NULL);
INSERT INTO `task_route` VALUES (4, 'Sample', 'Titration', 'Titration', 'SamplePosition', 'TitrationPosition', 'N', NULL);
INSERT INTO `task_route` VALUES (33, 'Calibration', 'Titration', 'Titration', 'SamplePosition', 'TitrationPosition', 'Y', NULL);

-- ----------------------------
-- Table structure for task_routestep
-- ----------------------------
DROP TABLE IF EXISTS `task_routestep`;
CREATE TABLE `task_routestep`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `OpKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Route` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `Step` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `NextStep` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `IsInit` varchar(2) 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 = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of task_routestep
-- ----------------------------
INSERT INTO `task_routestep` VALUES (1, 'Sample', 'AddLiquid', 'MotorMove', 'AddLiquid', 'Y', NULL);
INSERT INTO `task_routestep` VALUES (2, 'Sample', 'AddLiquid', 'AddLiquid', 'MotorGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (3, 'Sample', 'AddLiquid', 'MotorGoBack', 'MotorGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (4, 'Sample', 'Dissolve', 'MotorMove', 'DissolveInterval', 'Y', NULL);
INSERT INTO `task_routestep` VALUES (5, 'Sample', 'Dissolve', 'DissolveInterval', 'BowlCoverMove', 'N', NULL);
INSERT INTO `task_routestep` VALUES (6, 'Sample', 'Dissolve', 'BowlCoverMove', 'BowlCoverGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (7, 'Sample', 'Dissolve', 'BowlCoverGoBack', 'DissolveTime', 'N', NULL);
INSERT INTO `task_routestep` VALUES (8, 'Sample', 'Dissolve', 'DissolveTime', 'Dissolve', 'N', NULL);
INSERT INTO `task_routestep` VALUES (9, 'Sample', 'Dissolve', 'Dissolve', 'MotorGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (10, 'Sample', 'Dissolve', 'MotorGoBack', 'MotorGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (11, 'Sample', 'Cooling', 'Cooling', 'CoolingMove', 'Y', NULL);
INSERT INTO `task_routestep` VALUES (12, 'Sample', 'Cooling', 'CoolingMove', 'CoolingMove', 'N', NULL);
INSERT INTO `task_routestep` VALUES (14, 'Sample', 'Titration', 'MotorMove', 'TitrationIndicator', 'Y', NULL);
INSERT INTO `task_routestep` VALUES (15, 'Sample', 'Titration', 'TitrationIndicator', 'Titration', 'N', NULL);
INSERT INTO `task_routestep` VALUES (16, 'Sample', 'Titration', 'Titration', 'MotorGoBack', 'N', NULL);
INSERT INTO `task_routestep` VALUES (17, 'Sample', 'Titration', 'MotorGoBack', 'MotorGoBack', 'N', NULL);

-- ----------------------------
-- 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 '滴定前等待时间',
  `AfterWaitTime` int(0) NULL DEFAULT NULL COMMENT '滴定后等待时间',
  `MaxDropVolume` 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', 5.00, 10, 15, 5.000, '默认');

-- ----------------------------
-- Table structure for wavekey
-- ----------------------------
DROP TABLE IF EXISTS `wavekey`;
CREATE TABLE `wavekey`  (
  `SerialKey` int(0) NOT NULL AUTO_INCREMENT,
  `CreateTime` datetime(0) NULL DEFAULT NULL,
  `WaveKey` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`SerialKey`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wavekey
-- ----------------------------

-- ----------------------------
-- Procedure structure for P_ClearTask
-- ----------------------------
DROP PROCEDURE IF EXISTS `P_ClearTask`;
delimiter ;;
CREATE PROCEDURE `P_ClearTask`(num INT)
BEGIN
	delete from equipment_task where DATEDIFF(NOW(),CreateTime)>num and status='4';
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;