MIVA/source/sql/test.sql

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