/* Navicat Premium Dump SQL Source Server : fhxy-192.168.1.61-polardbx Source Server Type : MySQL Source Server Version : 80032 (8.0.32-X-Cluster-8.4.19-20241112) Source Host : 192.168.1.61:4886 Source Schema : pla-chem-sim-dev-2 Target Server Type : MySQL Target Server Version : 80032 (8.0.32-X-Cluster-8.4.19-20241112) File Encoding : 65001 Date: 15/08/2025 22:37:10 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for mx_sim -- ---------------------------- DROP TABLE IF EXISTS `mx_sim`; CREATE TABLE `mx_sim` ( `sim_id` bigint NOT NULL AUTO_INCREMENT COMMENT '模拟器ID', `seat_id` bigint NOT NULL DEFAULT 0 COMMENT '[废弃]座ID', `sim_type` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模拟器类型', `sim_state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '模拟器状态:[0]:初始化,[1]:在线,[2]:离线,[3]:[废弃]网关离线,[4]:[废弃]硬件故障异常,[5]:手动禁用', `sim_sn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模拟器序列号', `sim_num` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '模拟器设备通信编号-站ID', `last_sent_time` datetime NULL DEFAULT NULL COMMENT '最后一次成功发送报文时间', `last_received_time` datetime NULL DEFAULT NULL COMMENT '最后一次成功收到报文时间', `charging_count` int NULL DEFAULT 0 COMMENT '充电计数', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`sim_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 181 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'sim-模拟器表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of mx_sim -- ---------------------------- INSERT INTO `mx_sim` VALUES (1, 0, '0001', '2', '', '01', '2025-07-09 10:58:01', '2025-07-09 10:58:01', 0, NULL, NULL, NULL, '2025-07-10 16:57:58', ''); INSERT INTO `mx_sim` VALUES (2, 0, '0001', '2', '', '02', '2025-07-11 15:14:35', '2025-07-11 15:14:36', 0, NULL, NULL, NULL, '2025-07-11 15:14:36', ''); INSERT INTO `mx_sim` VALUES (3, 0, '0001', '2', '', '03', '2025-07-09 11:45:04', '2025-07-09 11:45:04', 0, NULL, NULL, NULL, '2025-07-09 11:45:04', ''); INSERT INTO `mx_sim` VALUES (4, 0, '0001', '2', '', '04', '2025-04-01 21:11:13', '2025-04-01 21:11:13', 0, NULL, NULL, NULL, '2025-04-01 21:11:13', ''); INSERT INTO `mx_sim` VALUES (5, 0, '0001', '2', '', '05', '2025-07-09 11:53:52', '2025-07-09 11:53:52', 0, NULL, NULL, NULL, '2025-07-09 11:53:52', ''); INSERT INTO `mx_sim` VALUES (6, 0, '0001', '2', '', '06', '2025-07-10 16:19:15', '2025-07-10 16:19:15', 0, NULL, NULL, NULL, '2025-07-10 16:19:15', ''); INSERT INTO `mx_sim` VALUES (7, 0, '0001', '2', '', '07', '2025-07-09 10:33:06', '2025-07-09 10:33:06', 0, NULL, NULL, NULL, '2025-07-09 10:33:06', ''); INSERT INTO `mx_sim` VALUES (8, 0, '0001', '2', '', '08', '2025-07-09 11:46:36', '2025-07-09 11:46:36', 0, NULL, NULL, NULL, '2025-07-09 11:46:36', ''); INSERT INTO `mx_sim` VALUES (9, 0, '0001', '2', '', '09', '2025-07-09 11:46:05', '2025-07-09 11:46:05', 0, NULL, NULL, NULL, '2025-07-09 11:46:05', ''); INSERT INTO `mx_sim` VALUES (10, 0, '0001', '2', '', '0A', '2025-07-09 11:42:13', '2025-07-09 11:42:14', 0, NULL, NULL, NULL, '2025-07-09 11:42:14', ''); INSERT INTO `mx_sim` VALUES (11, 0, '0001', '2', '', '0B', '2025-07-11 23:20:58', '2025-07-11 23:20:58', 0, NULL, NULL, NULL, '2025-07-11 23:20:58', ''); INSERT INTO `mx_sim` VALUES (12, 0, '0001', '2', '', '0C', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (13, 0, '0001', '2', '', '0D', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (14, 0, '0001', '2', '', '0E', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (15, 0, '0001', '2', '', '0F', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (16, 0, '0001', '2', '', '10', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (17, 0, '0001', '2', '', '11', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (18, 0, '0001', '2', '', '12', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (19, 0, '0001', '2', '', '13', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (20, 0, '0001', '2', '', '14', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (81, 0, '0002', '2', '', '51', '2025-06-27 10:42:04', '2025-06-27 10:42:04', 0, NULL, NULL, NULL, '2025-06-27 10:42:04', ''); INSERT INTO `mx_sim` VALUES (82, 0, '0002', '2', '', '52', '2025-06-27 10:41:51', '2025-06-27 10:41:51', 0, NULL, NULL, NULL, '2025-06-27 10:41:51', ''); INSERT INTO `mx_sim` VALUES (83, 0, '0002', '2', '', '53', '2025-06-20 08:57:42', '2025-06-20 08:57:42', 0, NULL, NULL, NULL, '2025-06-20 08:57:42', ''); INSERT INTO `mx_sim` VALUES (84, 0, '0002', '2', '', '54', '2025-06-27 10:42:18', '2025-06-27 10:42:18', 0, NULL, NULL, NULL, '2025-06-27 10:42:18', ''); INSERT INTO `mx_sim` VALUES (85, 0, '0002', '2', '', '55', '2025-06-27 10:42:09', '2025-06-27 10:42:09', 0, NULL, NULL, NULL, '2025-06-27 10:42:09', ''); INSERT INTO `mx_sim` VALUES (86, 0, '0002', '2', '', '56', '2025-06-27 10:41:47', '2025-06-27 10:41:47', 0, NULL, NULL, NULL, '2025-06-27 10:41:47', ''); INSERT INTO `mx_sim` VALUES (87, 0, '0002', '2', '', '57', '2025-03-30 17:15:55', '2025-03-30 17:15:55', 0, NULL, NULL, NULL, '2025-03-30 17:15:55', ''); INSERT INTO `mx_sim` VALUES (88, 0, '0002', '1', '', '58', '2025-06-27 10:42:23', '2025-06-27 10:42:23', 300, NULL, NULL, NULL, '2025-08-15 22:37:01', ''); INSERT INTO `mx_sim` VALUES (89, 0, '0002', '2', '', '59', '2025-06-20 09:05:44', '2025-06-20 09:05:45', 0, NULL, NULL, NULL, '2025-06-27 10:03:53', ''); INSERT INTO `mx_sim` VALUES (90, 0, '0002', '2', '', '5A', '2025-06-27 10:42:58', '2025-06-27 10:42:58', 0, NULL, NULL, NULL, '2025-06-27 10:42:58', ''); INSERT INTO `mx_sim` VALUES (91, 0, '0002', '2', '', '5B', '2025-06-20 09:20:00', '2025-06-20 09:08:18', 0, NULL, NULL, NULL, '2025-06-20 09:20:00', ''); INSERT INTO `mx_sim` VALUES (92, 0, '0002', '2', '', '5C', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (93, 0, '0002', '2', '', '5D', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (94, 0, '0002', '2', '', '5E', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (95, 0, '0002', '2', '', '5F', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (96, 0, '0002', '2', '', '60', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (97, 0, '0002', '2', '', '61', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (98, 0, '0002', '2', '', '62', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (99, 0, '0002', '2', '', '63', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (100, 0, '0002', '2', '', '64', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (161, 0, '0003', '2', '', 'A1', '2025-07-10 17:06:24', '2025-07-10 17:06:24', 0, NULL, NULL, NULL, '2025-07-10 17:06:24', ''); INSERT INTO `mx_sim` VALUES (162, 0, '0003', '2', '', 'A2', '2025-07-09 17:51:26', '2025-07-09 17:51:26', 0, NULL, NULL, NULL, '2025-07-09 17:51:26', ''); INSERT INTO `mx_sim` VALUES (163, 0, '0003', '2', '', 'A3', '2025-07-10 17:16:47', '2025-07-10 17:16:47', 0, NULL, NULL, NULL, '2025-07-10 17:16:47', ''); INSERT INTO `mx_sim` VALUES (164, 0, '0003', '2', '', 'A4', '2025-07-09 17:56:01', '2025-07-09 17:56:01', 0, NULL, NULL, NULL, '2025-07-09 17:56:01', ''); INSERT INTO `mx_sim` VALUES (165, 0, '0003', '1', '', 'A5', '2025-07-10 17:34:32', '2025-07-10 17:34:32', 0, NULL, NULL, NULL, '2025-08-15 22:17:20', ''); INSERT INTO `mx_sim` VALUES (166, 0, '0003', '2', '', 'A6', '2025-07-10 17:25:16', '2025-07-10 17:25:16', 0, NULL, NULL, NULL, '2025-07-10 17:25:56', ''); INSERT INTO `mx_sim` VALUES (167, 0, '0003', '2', '', 'A7', '2025-07-09 18:35:44', '2025-07-09 18:35:44', 0, NULL, NULL, NULL, '2025-07-10 12:47:31', ''); INSERT INTO `mx_sim` VALUES (168, 0, '0003', '2', '', 'A8', '2025-07-10 17:20:42', '2025-07-10 17:20:42', 0, NULL, NULL, NULL, '2025-07-10 17:20:42', ''); INSERT INTO `mx_sim` VALUES (169, 0, '0003', '2', '', 'A9', '2025-07-10 17:19:05', '2025-07-10 17:19:05', 0, NULL, NULL, NULL, '2025-07-10 17:19:05', ''); INSERT INTO `mx_sim` VALUES (170, 0, '0003', '2', '', 'AA', '2025-07-10 17:13:57', '2025-07-10 17:13:57', 0, NULL, NULL, NULL, '2025-07-10 17:13:57', ''); INSERT INTO `mx_sim` VALUES (171, 0, '0003', '2', '', 'AB', '2025-04-26 16:09:51', '2025-04-26 16:09:51', 0, NULL, NULL, NULL, '2025-04-26 16:35:32', ''); INSERT INTO `mx_sim` VALUES (172, 0, '0003', '2', '', 'AC', '2025-04-26 16:09:47', '2025-04-26 16:09:47', 0, NULL, NULL, NULL, '2025-04-26 16:09:47', ''); INSERT INTO `mx_sim` VALUES (173, 0, '0003', '2', '', 'AD', '2025-06-19 16:44:33', '2025-06-19 16:09:25', 0, NULL, NULL, NULL, '2025-06-19 16:44:33', ''); INSERT INTO `mx_sim` VALUES (174, 0, '0003', '2', '', 'AE', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (175, 0, '0003', '2', '', 'AF', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (176, 0, '0003', '2', '', 'B0', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (177, 0, '0003', '2', '', 'B1', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (178, 0, '0003', '2', '', 'B2', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (179, 0, '0003', '2', '', 'B3', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); INSERT INTO `mx_sim` VALUES (180, 0, '0003', '2', '', 'B4', NULL, NULL, 0, NULL, NULL, NULL, NULL, ''); SET FOREIGN_KEY_CHECKS = 1;