/* Navicat MySQL Data Transfer Source Server : B310 Source Server Type : MySQL Source Server Version : 80026 Source Host : 192.168.31.189:3306 Source Schema : MIVA_DB Target Server Type : MySQL Target Server Version : 80026 File Encoding : 65001 Date: 22/02/2022 13:47:32 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for CarData -- ---------------------------- DROP TABLE IF EXISTS `CarData`; CREATE TABLE `CarData` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `NoLoad` int(0) NOT NULL COMMENT '空载载荷', `DynamicLoad` int(0) NOT NULL COMMENT '动态载荷', `Grade` int(0) NOT NULL COMMENT '拥挤等级 1-4', `Num` int(0) NOT NULL COMMENT '识别数量', `dataTime` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'label', `PId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '列车编号', `CarId` int(0) NOT NULL COMMENT '唯一Id', `enableFlag` int(0) NOT NULL COMMENT '是否启用', `addTime` datetime(0) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `carriageCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '车厢编号', PRIMARY KEY (`Id`) USING BTREE, UNIQUE INDEX `CarId`(`CarId`) USING BTREE COMMENT '唯一Id' ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of CarData -- ---------------------------- INSERT INTO `CarData` VALUES (1, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢2', '0401', 180, 1, '2021-11-03 11:29:57', '2021-11-19 17:38:17', '040202'); INSERT INTO `CarData` VALUES (3, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢1', '0401', 177, 1, '2021-11-02 17:14:44', '2021-11-19 17:38:11', '040201'); INSERT INTO `CarData` VALUES (4, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢3', '0401', 199, 1, '2021-11-17 10:09:33', '2021-11-19 17:38:25', '040203'); INSERT INTO `CarData` VALUES (5, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢4', '0401', 200, 1, '2021-11-22 09:47:20', '2021-11-22 09:47:20', '040204'); INSERT INTO `CarData` VALUES (6, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢5', '0401', 201, 1, '2021-11-22 09:47:38', '2021-11-22 09:47:38', '040205'); INSERT INTO `CarData` VALUES (7, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢6', '0401', 202, 1, '2021-11-22 09:47:51', '2021-11-22 09:47:51', '040206'); INSERT INTO `CarData` VALUES (8, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢7', '0401', 203, 1, '2021-11-22 10:05:21', '2021-11-22 10:05:21', '040207'); INSERT INTO `CarData` VALUES (9, 0, 0, 1, 0, '2022-02-22 05:44:09', '车厢8', '0401', 204, 1, '2021-11-22 10:05:34', '2021-11-22 10:05:34', '040208'); -- ---------------------------- -- Table structure for DataSources -- ---------------------------- DROP TABLE IF EXISTS `DataSources`; CREATE TABLE `DataSources` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `CarId` int(0) NOT NULL, `Uri` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `RecognitionRange` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `Play` int(0) NOT NULL, `Del` int(0) NOT NULL, `DataTime` datetime(0) NULL DEFAULT NULL, `Num` int(0) NOT NULL, `PId` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `dv_Id` int(0) NOT NULL, `addTime` datetime(0) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `IP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '摄像头IP', `finish` int(0) NULL DEFAULT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of DataSources -- ---------------------------- INSERT INTO `DataSources` VALUES (44, 177, 'rtsp://admin:admin123@192.168.160.68:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040201', '摄像头1', 26, '2021-11-16 16:10:03', '2021-11-18 14:22:06', '192.168.160.68', 1); INSERT INTO `DataSources` VALUES (45, 177, 'rtsp://admin:admin123@192.168.160.18:554/cam/realmonitor?channel=1&subtype=0', '[]', 0, 0, '2022-01-05 13:48:03', 0, '040201', '摄像头2', 32, '2021-11-22 09:50:01', '2021-12-28 11:38:59', '192.168.160.60', 0); INSERT INTO `DataSources` VALUES (46, 180, 'rtsp://admin:admin123@192.168.160.80:554/cam/realmonitor?channel=1&subtype=0', '[{\"pointType\":\"straight\",\"type\":\"M\",\"point\":{\"x\":185,\"y\":175},\"relationPoints\":[185,175],\"keyPointIndex\":0},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":346,\"y\":108},\"relationPoints\":[185,175,346,108,346,108],\"keyPointIndex\":1},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":366,\"y\":235},\"relationPoints\":[346,108,366,235,366,235],\"keyPointIndex\":2},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":272,\"y\":262},\"relationPoints\":[366,235,272,262,272,262],\"keyPointIndex\":3}]', 1, 0, '2022-02-22 05:44:13', 0, '040202', '摄像头1', 27, '2021-11-16 16:17:22', '2021-11-16 17:40:13', '192.168.160.80', 1); INSERT INTO `DataSources` VALUES (47, 180, 'rtsp://admin:admin123@192.168.160.77:554/cam/realmonitor?channel=1&subtype=0', '[{\"pointType\":\"straight\",\"type\":\"M\",\"point\":{\"x\":189,\"y\":99},\"relationPoints\":[189,99],\"keyPointIndex\":0},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":379,\"y\":115},\"relationPoints\":[189,99,379,115,379,115],\"keyPointIndex\":1},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":364,\"y\":238},\"relationPoints\":[379,115,364,238,364,238],\"keyPointIndex\":2},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":234,\"y\":290},\"relationPoints\":[364,238,234,290,234,290],\"keyPointIndex\":3},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":196,\"y\":182},\"relationPoints\":[234,290,196,182,196,182],\"keyPointIndex\":4}]', 1, 0, '2022-02-22 05:44:13', 0, '040202', '摄像头2', 30, '2021-11-17 11:27:23', '2021-12-15 17:25:15', '192.168.160.77', 1); INSERT INTO `DataSources` VALUES (48, 199, 'rtsp://admin:admin123@192.168.160.77:554/cam/realmonitor?channel=1&subtype=0', '[{\"pointType\":\"straight\",\"type\":\"M\",\"point\":{\"x\":182,\"y\":107},\"relationPoints\":[182,107],\"keyPointIndex\":0},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":420,\"y\":115},\"relationPoints\":[182,107,420,115,420,115],\"keyPointIndex\":1},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":397,\"y\":284},\"relationPoints\":[420,115,397,284,397,284],\"keyPointIndex\":2},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":250,\"y\":209},\"relationPoints\":[397,284,250,209,250,209],\"keyPointIndex\":3}]', 1, 0, '2022-02-22 05:44:13', 0, '040203', '摄像头1', 29, '2021-11-17 11:25:34', '2021-11-19 16:19:01', '192.168.160.77', 1); INSERT INTO `DataSources` VALUES (49, 199, 'rtsp://admin:admin123@192.168.160.73:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040203', '摄像头2', 33, '2021-11-22 09:50:53', '2021-11-22 09:50:53', '192.168.160.73', 1); INSERT INTO `DataSources` VALUES (50, 200, 'rtsp://admin:admin123@192.168.160.72:554/cam/realmonitor?channel=1&subtype=0', '[{\"pointType\":\"straight\",\"type\":\"M\",\"point\":{\"x\":130,\"y\":76},\"relationPoints\":[130,76],\"keyPointIndex\":0},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":418,\"y\":89},\"relationPoints\":[130,76,418,89,418,89],\"keyPointIndex\":1},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":388,\"y\":263},\"relationPoints\":[418,89,388,263,388,263],\"keyPointIndex\":2},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":204,\"y\":251},\"relationPoints\":[388,263,204,251,204,251],\"keyPointIndex\":3}]', 1, 0, '2022-02-22 05:44:13', 0, '040204', '摄像头1', 34, '2021-11-22 09:51:40', '2021-11-22 09:51:40', '192.168.160.72', 1); INSERT INTO `DataSources` VALUES (51, 200, 'rtsp://admin:admin123@192.168.160.70:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040204', '摄像头2', 35, '2021-11-22 09:52:21', '2021-11-22 09:52:21', '192.168.160.70', 1); INSERT INTO `DataSources` VALUES (52, 201, 'rtsp://admin:admin123@192.168.160.60:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040205', '摄像头1', 36, '2021-11-22 09:53:17', '2021-11-22 09:53:17', '192.168.160.60', 1); INSERT INTO `DataSources` VALUES (53, 201, 'rtsp://admin:admin123@192.168.160.25:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040205', '摄像头2', 37, '2021-11-22 09:54:09', '2021-11-22 09:54:09', '192.168.160.25', 1); INSERT INTO `DataSources` VALUES (54, 202, 'rtsp://admin:admin123@192.168.160.24:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040206', '摄像头1', 38, '2021-11-22 09:54:52', '2021-11-22 09:54:52', '192.168.160.24', 1); INSERT INTO `DataSources` VALUES (55, 202, 'rtsp://admin:admin123@192.168.160.14:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040206', '摄像2', 39, '2021-11-22 09:55:48', '2021-11-22 09:55:48', '192.168.160.14', 1); INSERT INTO `DataSources` VALUES (56, 203, 'rtsp://admin:admin123@192.168.160.6:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040207', '摄像头1', 40, '2021-11-22 10:06:37', '2021-11-22 10:06:37', '192.168.160.6', 1); INSERT INTO `DataSources` VALUES (57, 203, 'rtsp://admin:admin123@192.168.160.10:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040207', '摄像头2', 41, '2021-11-22 10:07:27', '2021-11-26 09:14:06', '192.168.160.10', 1); INSERT INTO `DataSources` VALUES (58, 204, 'rtsp://admin:admin123@192.168.160.12:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040208', '摄像头1', 42, '2021-11-22 10:09:40', '2021-11-22 10:09:40', '192.168.160.12', 1); INSERT INTO `DataSources` VALUES (59, 204, 'rtsp://admin:admin123@192.168.160.18:554/cam/realmonitor?channel=1&subtype=0', '[]', 1, 0, '2022-02-22 05:44:13', 0, '040208', '摄像头2', 43, '2021-11-22 10:10:23', '2021-11-22 10:10:23', '192.168.160.18', 1); INSERT INTO `DataSources` VALUES (69, 177, 'rtsp://admin:admin123@192.168.160.60:554/cam/realmonitor?channel=1&subtype=0', '[]', 0, 0, '2022-01-05 13:48:04', 0, '040201', '摄像3', 59, '2021-12-28 14:29:48', '2021-12-28 14:29:48', '192.168.160.60', 0); INSERT INTO `DataSources` VALUES (70, 177, 'rtsp://admin:admin123@192.168.160.39:554/cam/realmonitor?channel=1&subtype=0', '[{\"pointType\":\"straight\",\"type\":\"M\",\"point\":{\"x\":155,\"y\":80},\"relationPoints\":[155,80],\"keyPointIndex\":0},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":385,\"y\":97},\"relationPoints\":[155,80,385,97,385,97],\"keyPointIndex\":1},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":403,\"y\":234},\"relationPoints\":[385,97,403,234,403,234],\"keyPointIndex\":2},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":215,\"y\":260},\"relationPoints\":[403,234,215,260,215,260],\"keyPointIndex\":3},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":136,\"y\":215},\"relationPoints\":[215,260,136,215,136,215],\"keyPointIndex\":4},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":117,\"y\":134},\"relationPoints\":[136,215,117,134,117,134],\"keyPointIndex\":5},{\"pointType\":\"straight\",\"type\":\"C\",\"point\":{\"x\":151,\"y\":81},\"relationPoints\":[117,134,151,81,151,81],\"keyPointIndex\":6}]', 1, 0, '2022-02-22 05:44:13', 0, '040201', '摄像头4', 60, '2021-12-29 14:09:24', '2021-12-29 14:09:24', '', 1); -- ---------------------------- -- Table structure for DeviceState -- ---------------------------- DROP TABLE IF EXISTS `DeviceState`; CREATE TABLE `DeviceState` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `CpuUsage` int(0) NOT NULL, `GpuUsage` int(0) NOT NULL, `MemoryUsage` int(0) NOT NULL, `CpuTemp` int(0) NOT NULL, `GpuTemp` int(0) NOT NULL, `FdUsage` int(0) NOT NULL, `AUXTemp` int(0) NOT NULL, `A0Temp` int(0) NOT NULL, `ThermalTemp` int(0) NOT NULL, `updateTime` datetime(0) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of DeviceState -- ---------------------------- INSERT INTO `DeviceState` VALUES (1, 0, 0, 3000, 0, 0, 1678, 0, 0, 0, '2022-02-22 05:45:04'); -- ---------------------------- -- Table structure for InferRecord -- ---------------------------- DROP TABLE IF EXISTS `InferRecord`; CREATE TABLE `InferRecord` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `time` datetime(0) NOT NULL, `InferTime` int(0) NOT NULL, `OutPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `batch_size` int(0) NOT NULL, `out_size` int(0) NOT NULL, `Finish` int(0) NOT NULL, `Del` int(0) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for MivaConfig -- ---------------------------- DROP TABLE IF EXISTS `MivaConfig`; CREATE TABLE `MivaConfig` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户', `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `privateKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密钥', `outType` int(0) NULL DEFAULT NULL COMMENT '输入类型', `outPath` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '输出路径', `outEnable` int(0) NULL DEFAULT NULL COMMENT '输出使能', `ClearType` int(0) NULL DEFAULT NULL COMMENT '清除机制 ', `recordMax` int(0) NULL DEFAULT NULL COMMENT '记录的最大阈值', `validTime` int(0) NULL DEFAULT NULL COMMENT '保持时间', `MemoryThreshold` int(0) NULL DEFAULT NULL, `TempThreshold` int(0) NULL DEFAULT NULL, `FdThreshold` int(0) NULL DEFAULT NULL, `ResetThreshold` int(0) NULL DEFAULT NULL, `ResetSwitch` int(0) NULL DEFAULT NULL, `TimeoutThreshold` int(0) NULL DEFAULT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of MivaConfig -- ---------------------------- INSERT INTO `MivaConfig` VALUES (1, 'nettyUser2', NULL, NULL, 0, './video/', 0, 1, 3, 1, 0, 0, 1678, 0, 0, 0); -- ---------------------------- -- Table structure for PeakValleyConfig -- ---------------------------- DROP TABLE IF EXISTS `PeakValleyConfig`; CREATE TABLE `PeakValleyConfig` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `addTime` datetime(0) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `createBy` int(0) NULL DEFAULT NULL, `updateBy` int(0) NULL DEFAULT NULL, `attr1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `attr2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `attr3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `appId` int(0) NULL DEFAULT NULL, `pvcId` int(0) NULL DEFAULT NULL, `startTime` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `endTime` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `timeType` int(0) NULL DEFAULT NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of PeakValleyConfig -- ---------------------------- INSERT INTO `PeakValleyConfig` VALUES (1, '2021-11-04 09:24:33', '2021-11-05 15:29:55', 2, 2, '', '', '', 2, 20, '08:24', '10:24', 2, ''); INSERT INTO `PeakValleyConfig` VALUES (2, '2021-11-04 09:24:33', '2021-11-22 17:48:43', 2, 2, '', '', '', 2, 21, '10:25', '19:48', 1, ''); -- ---------------------------- -- Table structure for SystemConfig -- ---------------------------- DROP TABLE IF EXISTS `SystemConfig`; CREATE TABLE `SystemConfig` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `addTime` datetime(0) NULL DEFAULT NULL, `updateTime` datetime(0) NULL DEFAULT NULL, `createBy` int(0) NULL DEFAULT NULL, `updateBy` int(0) NULL DEFAULT NULL, `attr1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `attr2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `attr3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `appId` int(0) NULL DEFAULT NULL, `configId` int(0) NULL DEFAULT NULL, `conKey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `conValue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `active` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of SystemConfig -- ---------------------------- INSERT INTO `SystemConfig` VALUES (1, '2021-10-11 17:36:54', '2021-12-30 09:26:37', 2, 2, '', '', '', 2, 2, 'crowdingDegreeConfig', '[{\"timeType\":\"2\",\"cdLevel1Min\":\"0\",\"cdLevel1Max\":\"100\",\"cdLevel2Min\":\"101\",\"cdLevel2Max\":\"400\",\"cdLevel3Min\":\"401\",\"cdLevel3Max\":\"999\"},{\"timeType\":\"1\",\"cdLevel1Min\":\"0\",\"cdLevel1Max\":\"10\",\"cdLevel2Min\":\"11\",\"cdLevel2Max\":\"201\",\"cdLevel3Min\":\"202\",\"cdLevel3Max\":\"999\"}]', '', ''); -- ---------------------------- -- Table structure for TrainInfo -- ---------------------------- DROP TABLE IF EXISTS `TrainInfo`; CREATE TABLE `TrainInfo` ( `Id` int(0) NOT NULL AUTO_INCREMENT, `carId` int(0) NOT NULL, `carCode` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `carName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `enableFlag` int(0) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of TrainInfo -- ---------------------------- INSERT INTO `TrainInfo` VALUES (20, 156, '0401', '列车', 1); SET FOREIGN_KEY_CHECKS = 1;