You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
test1/ticketing-master/sql/ticketing.sql

376 lines
48 KiB

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

/*
Navicat Premium Data Transfer
Source Server : 阿里云@39.108.5.98
Source Server Type : MySQL
Source Server Version : 50173
Source Host : 39.108.5.98:3306
Source Schema : ticketing
Target Server Type : MySQL
Target Server Version : 50173
File Encoding : 65001
Date: 23/11/2019 23:17:02
*/
SET NAMES utf8mb4; -- 设置客户端连接的字符集为utf8mb4
SET FOREIGN_KEY_CHECKS = 0; -- 禁用外键约束检查,以便在导入数据时不受外键约束限制
-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`; -- 如果admins表存在则删除
CREATE TABLE `admins` (
`adminid` int(4) NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员姓名',
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员密码',
`creattime` datetime NOT NULL COMMENT '创建时间',
`flag` int(1) NOT NULL COMMENT '管理员权限',
`isuse` int(1) NOT NULL COMMENT '管理员状态',
`logintime` datetime NOT NULL COMMENT '登录时间',
PRIMARY KEY (`adminid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- 定义表结构
-- ----------------------------
-- Records of admins
-- ----------------------------
INSERT INTO `admins` VALUES ... -- 插入初始管理员数据
-- 省略了member、pmember、prep、train表的结构定义和数据插入语句
-- ----------------------------
-- Table structure for train
-- ----------------------------
DROP TABLE IF EXISTS `train`; -- 如果train表存在则删除
CREATE TABLE `train` (
`trainid` int(4) NOT NULL AUTO_INCREMENT COMMENT '序号',
`trainnumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '车次',
`startstation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '起始站',
`endstation` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '终点站',
`starttime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发车时间',
`endtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '到站时间',
`price` int(4) NOT NULL COMMENT '车票价格',
`seatnumber` int(4) NOT NULL COMMENT '座位数量',
`addtime` datetime NOT NULL COMMENT '添加时间',
PRIMARY KEY (`trainid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 335 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- 定义表结构
-- ----------------------------
-- Records of train
-- ----------------------------
-- 插入初始列车数据
INSERT INTO `train` VALUES (22, 'K322', '北京', '天津', '2019-09-01 15:30:00', '2019-09-01 16:50:00', 200, 991, '2019-09-13 23:37:52');
INSERT INTO `train` VALUES (23, 'T23', '南昌', '九江', '2019-09-20 12:12:00', '2019-09-27 12:12:00', 1000, 97, '2019-09-19 00:03:03');
INSERT INTO `train` VALUES (24, 'T23', '柬埔寨', '西海', '2019-09-28 12:21:00', '2019-09-28 12:12:00', 999, 18, '2019-09-19 00:08:16');
INSERT INTO `train` VALUES (25, 'K110', '山东', '江苏', '2019-09-30 12:00:00', '2019-09-30 14:20:00', 185, 498, '2019-09-28 17:39:45');
INSERT INTO `train` VALUES (26, 'K85', '江苏', '福建', '2019-09-30 16:30:00', '2019-09-30 21:00:00', 230, 499, '2019-09-28 18:48:18');
INSERT INTO `train` VALUES (27, 'K85', '江西', '广州', '2019-09-30 12:00:00', '2019-09-30 14:55:00', 427, 499, '2019-09-28 18:49:30');
INSERT INTO `train` VALUES (28, 'D2312', '海南', '安徽', '2019-09-30 13:44:00', '2019-09-30 17:45:00', 300, 994, '2019-09-28 18:50:21');
INSERT INTO `train` VALUES (29, 'K31', '北京1', '天津1', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 201, 1001, '2019-11-18 17:29:45');
INSERT INTO `train` VALUES (30, 'K32', '北京2', '天津2', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 202, 1002, '2019-11-18 17:29:45');
INSERT INTO `train` VALUES (31, 'K33', '北京3', '天津3', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 203, 1003, '2019-11-18 17:29:46');
INSERT INTO `train` VALUES (32, 'K34', '北京4', '天津4', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 204, 1004, '2019-11-18 17:29:46');
INSERT INTO `train` VALUES (33, 'K35', '北京5', '天津5', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 205, 1005, '2019-11-18 17:29:46');
INSERT INTO `train` VALUES (34, 'K36', '北京6', '天津6', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 206, 1006, '2019-11-18 17:29:46');
INSERT INTO `train` VALUES (35, 'K37', '北京7', '天津7', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 207, 1007, '2019-11-18 17:29:47');
INSERT INTO `train` VALUES (36, 'K38', '北京8', '天津8', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 208, 1008, '2019-11-18 17:29:47');
INSERT INTO `train` VALUES (37, 'K39', '北京9', '天津9', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 209, 1009, '2019-11-18 17:29:47');
INSERT INTO `train` VALUES (38, 'K310', '北京10', '天津10', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 210, 1010, '2019-11-18 17:29:47');
INSERT INTO `train` VALUES (39, 'K311', '北京11', '天津11', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 211, 1011, '2019-11-18 17:29:48');
INSERT INTO `train` VALUES (40, 'K312', '北京12', '天津12', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 212, 1012, '2019-11-18 17:29:48');
INSERT INTO `train` VALUES (41, 'K313', '北京13', '天津13', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 213, 1013, '2019-11-18 17:29:48');
INSERT INTO `train` VALUES (42, 'K314', '北京14', '天津14', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 214, 1014, '2019-11-18 17:29:48');
INSERT INTO `train` VALUES (43, 'K315', '北京15', '天津15', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 215, 1015, '2019-11-18 17:29:49');
INSERT INTO `train` VALUES (44, 'K316', '北京16', '天津16', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 216, 1016, '2019-11-18 17:29:49');
INSERT INTO `train` VALUES (45, 'K317', '北京17', '天津17', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 217, 1017, '2019-11-18 17:29:49');
INSERT INTO `train` VALUES (46, 'K318', '北京18', '天津18', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 218, 1018, '2019-11-18 17:29:49');
INSERT INTO `train` VALUES (47, 'K319', '北京19', '天津19', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 219, 1019, '2019-11-18 17:29:50');
INSERT INTO `train` VALUES (48, 'K320', '北京20', '天津20', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 220, 1020, '2019-11-18 17:29:50');
INSERT INTO `train` VALUES (49, 'K321', '北京21', '天津21', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 221, 1021, '2019-11-18 17:29:50');
INSERT INTO `train` VALUES (50, 'K322', '北京22', '天津22', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 222, 1022, '2019-11-18 17:29:50');
INSERT INTO `train` VALUES (51, 'K323', '北京23', '天津23', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 223, 1023, '2019-11-18 17:29:50');
INSERT INTO `train` VALUES (52, 'K324', '北京24', '天津24', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 224, 1024, '2019-11-18 17:29:51');
INSERT INTO `train` VALUES (53, 'K325', '北京25', '天津25', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 225, 1025, '2019-11-18 17:29:51');
INSERT INTO `train` VALUES (54, 'K326', '北京26', '天津26', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 226, 1026, '2019-11-18 17:29:51');
INSERT INTO `train` VALUES (55, 'K327', '北京27', '天津27', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 227, 1027, '2019-11-18 17:29:52');
INSERT INTO `train` VALUES (56, 'K328', '北京28', '天津28', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 228, 1028, '2019-11-18 17:29:52');
INSERT INTO `train` VALUES (57, 'K329', '北京29', '天津29', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 229, 1029, '2019-11-18 17:29:52');
INSERT INTO `train` VALUES (58, 'K330', '北京30', '天津30', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 230, 1030, '2019-11-18 17:29:52');
INSERT INTO `train` VALUES (59, 'K331', '北京31', '天津31', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 231, 1031, '2019-11-18 17:29:52');
INSERT INTO `train` VALUES (60, 'K332', '北京32', '天津32', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 232, 1032, '2019-11-18 17:29:53');
INSERT INTO `train` VALUES (61, 'K333', '北京33', '天津33', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 233, 1033, '2019-11-18 17:29:53');
INSERT INTO `train` VALUES (62, 'K334', '北京34', '天津34', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 234, 1034, '2019-11-18 17:29:53');
INSERT INTO `train` VALUES (63, 'K335', '北京35', '天津35', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 235, 1035, '2019-11-18 17:29:54');
INSERT INTO `train` VALUES (64, 'K336', '北京36', '天津36', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 236, 1036, '2019-11-18 17:29:54');
INSERT INTO `train` VALUES (65, 'K337', '北京37', '天津37', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 237, 1037, '2019-11-18 17:29:54');
INSERT INTO `train` VALUES (66, 'K338', '北京38', '天津38', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 238, 1038, '2019-11-18 17:29:54');
INSERT INTO `train` VALUES (67, 'K339', '北京39', '天津39', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 239, 1039, '2019-11-18 17:29:55');
INSERT INTO `train` VALUES (68, 'K340', '北京40', '天津40', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 240, 1040, '2019-11-18 17:29:55');
INSERT INTO `train` VALUES (69, 'K341', '北京41', '天津41', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 241, 1041, '2019-11-18 17:29:55');
INSERT INTO `train` VALUES (70, 'K342', '北京42', '天津42', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 242, 1042, '2019-11-18 17:29:55');
INSERT INTO `train` VALUES (71, 'K343', '北京43', '天津43', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 243, 1043, '2019-11-18 17:29:56');
INSERT INTO `train` VALUES (72, 'K344', '北京44', '天津44', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 244, 1044, '2019-11-18 17:29:56');
INSERT INTO `train` VALUES (73, 'K345', '北京45', '天津45', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 245, 1045, '2019-11-18 17:29:56');
INSERT INTO `train` VALUES (74, 'K346', '北京46', '天津46', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 246, 1046, '2019-11-18 17:29:56');
INSERT INTO `train` VALUES (75, 'K347', '北京47', '天津47', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 247, 1047, '2019-11-18 17:29:56');
INSERT INTO `train` VALUES (76, 'K348', '北京48', '天津48', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 248, 1048, '2019-11-18 17:29:57');
INSERT INTO `train` VALUES (77, 'K349', '北京49', '天津49', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 249, 1049, '2019-11-18 17:29:57');
INSERT INTO `train` VALUES (78, 'K350', '北京50', '天津50', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 250, 1050, '2019-11-18 17:29:57');
INSERT INTO `train` VALUES (79, 'K351', '北京51', '天津51', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 251, 1051, '2019-11-18 17:29:57');
INSERT INTO `train` VALUES (80, 'K352', '北京52', '天津52', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 252, 1052, '2019-11-18 17:29:58');
INSERT INTO `train` VALUES (81, 'K353', '北京53', '天津53', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 253, 1053, '2019-11-18 17:29:58');
INSERT INTO `train` VALUES (82, 'K354', '北京54', '天津54', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 254, 1054, '2019-11-18 17:29:58');
INSERT INTO `train` VALUES (83, 'K355', '北京55', '天津55', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 255, 1055, '2019-11-18 17:29:58');
INSERT INTO `train` VALUES (84, 'K356', '北京56', '天津56', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 256, 1056, '2019-11-18 17:29:58');
INSERT INTO `train` VALUES (85, 'K357', '北京57', '天津57', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 257, 1057, '2019-11-18 17:29:59');
INSERT INTO `train` VALUES (86, 'K358', '北京58', '天津58', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 258, 1058, '2019-11-18 17:29:59');
INSERT INTO `train` VALUES (87, 'K359', '北京59', '天津59', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 259, 1059, '2019-11-18 17:29:59');
INSERT INTO `train` VALUES (88, 'K360', '北京60', '天津60', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 260, 1060, '2019-11-18 17:29:59');
INSERT INTO `train` VALUES (89, 'K361', '北京61', '天津61', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 261, 1061, '2019-11-18 17:30:00');
INSERT INTO `train` VALUES (90, 'K362', '北京62', '天津62', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 262, 1062, '2019-11-18 17:30:00');
INSERT INTO `train` VALUES (91, 'K363', '北京63', '天津63', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 263, 1063, '2019-11-18 17:30:00');
INSERT INTO `train` VALUES (92, 'K364', '北京64', '天津64', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 264, 1064, '2019-11-18 17:30:00');
INSERT INTO `train` VALUES (93, 'K365', '北京65', '天津65', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 265, 1065, '2019-11-18 17:30:01');
INSERT INTO `train` VALUES (94, 'K366', '北京66', '天津66', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 266, 1066, '2019-11-18 17:30:01');
INSERT INTO `train` VALUES (95, 'K367', '北京67', '天津67', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 267, 1067, '2019-11-18 17:30:01');
INSERT INTO `train` VALUES (96, 'K368', '北京68', '天津68', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 268, 1068, '2019-11-18 17:30:01');
INSERT INTO `train` VALUES (97, 'K369', '北京69', '天津69', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 269, 1069, '2019-11-18 17:30:02');
INSERT INTO `train` VALUES (98, 'K370', '北京70', '天津70', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 270, 1070, '2019-11-18 17:30:02');
INSERT INTO `train` VALUES (99, 'K371', '北京71', '天津71', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 271, 1071, '2019-11-18 17:30:02');
INSERT INTO `train` VALUES (100, 'K372', '北京72', '天津72', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 272, 1072, '2019-11-18 17:30:02');
INSERT INTO `train` VALUES (101, 'K373', '北京73', '天津73', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 273, 1073, '2019-11-18 17:30:03');
INSERT INTO `train` VALUES (102, 'K374', '北京74', '天津74', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 274, 1074, '2019-11-18 17:30:03');
INSERT INTO `train` VALUES (103, 'K375', '北京75', '天津75', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 275, 1075, '2019-11-18 17:30:03');
INSERT INTO `train` VALUES (104, 'K376', '北京76', '天津76', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 276, 1076, '2019-11-18 17:30:03');
INSERT INTO `train` VALUES (105, 'K377', '北京77', '天津77', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 277, 1077, '2019-11-18 17:30:03');
INSERT INTO `train` VALUES (106, 'K378', '北京78', '天津78', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 278, 1078, '2019-11-18 17:30:04');
INSERT INTO `train` VALUES (107, 'K379', '北京79', '天津79', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 279, 1079, '2019-11-18 17:30:04');
INSERT INTO `train` VALUES (108, 'K380', '北京80', '天津80', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 280, 1080, '2019-11-18 17:30:04');
INSERT INTO `train` VALUES (109, 'K381', '北京81', '天津81', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 281, 1081, '2019-11-18 17:30:05');
INSERT INTO `train` VALUES (110, 'K382', '北京82', '天津82', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 282, 1082, '2019-11-18 17:30:05');
INSERT INTO `train` VALUES (111, 'K383', '北京83', '天津83', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 283, 1083, '2019-11-18 17:30:05');
INSERT INTO `train` VALUES (112, 'K384', '北京84', '天津84', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 284, 1084, '2019-11-18 17:30:05');
INSERT INTO `train` VALUES (113, 'K385', '北京85', '天津85', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 285, 1085, '2019-11-18 17:30:06');
INSERT INTO `train` VALUES (114, 'K386', '北京86', '天津86', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 286, 1086, '2019-11-18 17:30:06');
INSERT INTO `train` VALUES (115, 'K387', '北京87', '天津87', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 287, 1087, '2019-11-18 17:30:06');
INSERT INTO `train` VALUES (116, 'K388', '北京88', '天津88', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 288, 1088, '2019-11-18 17:30:06');
INSERT INTO `train` VALUES (117, 'K389', '北京89', '天津89', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 289, 1089, '2019-11-18 17:30:07');
INSERT INTO `train` VALUES (118, 'K390', '北京90', '天津90', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 290, 1090, '2019-11-18 17:30:07');
INSERT INTO `train` VALUES (119, 'K391', '北京91', '天津91', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 291, 1091, '2019-11-18 17:30:07');
INSERT INTO `train` VALUES (120, 'K392', '北京92', '天津92', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 292, 1092, '2019-11-18 17:30:07');
INSERT INTO `train` VALUES (121, 'K393', '北京93', '天津93', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 293, 1093, '2019-11-18 17:30:08');
INSERT INTO `train` VALUES (122, 'K394', '北京94', '天津94', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 294, 1094, '2019-11-18 17:30:08');
INSERT INTO `train` VALUES (123, 'K395', '北京95', '天津95', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 295, 1095, '2019-11-18 17:30:08');
INSERT INTO `train` VALUES (124, 'K396', '北京96', '天津96', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 296, 1096, '2019-11-18 17:30:08');
INSERT INTO `train` VALUES (125, 'K397', '北京97', '天津97', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 297, 1097, '2019-11-18 17:30:09');
INSERT INTO `train` VALUES (126, 'K398', '北京98', '天津98', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 298, 1098, '2019-11-18 17:30:09');
INSERT INTO `train` VALUES (127, 'K399', '北京99', '天津99', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 299, 1099, '2019-11-18 17:30:09');
INSERT INTO `train` VALUES (128, 'K3100', '北京100', '天津100', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 300, 1100, '2019-11-18 17:30:09');
INSERT INTO `train` VALUES (129, 'K3101', '北京101', '天津101', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 301, 1101, '2019-11-18 17:30:10');
INSERT INTO `train` VALUES (130, 'K3102', '北京102', '天津102', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 302, 1102, '2019-11-18 17:30:10');
INSERT INTO `train` VALUES (131, 'K3103', '北京103', '天津103', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 303, 1103, '2019-11-18 17:30:10');
INSERT INTO `train` VALUES (132, 'K3104', '北京104', '天津104', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 304, 1104, '2019-11-18 17:30:10');
INSERT INTO `train` VALUES (133, 'K3105', '北京105', '天津105', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 305, 1105, '2019-11-18 17:30:10');
INSERT INTO `train` VALUES (134, 'K3106', '北京106', '天津106', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 306, 1106, '2019-11-18 17:30:11');
INSERT INTO `train` VALUES (135, 'K3107', '北京107', '天津107', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 307, 1107, '2019-11-18 17:30:11');
INSERT INTO `train` VALUES (136, 'K3108', '北京108', '天津108', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 308, 1108, '2019-11-18 17:30:11');
INSERT INTO `train` VALUES (137, 'K3109', '北京109', '天津109', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 309, 1109, '2019-11-18 17:30:12');
INSERT INTO `train` VALUES (138, 'K3110', '北京110', '天津110', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 310, 1110, '2019-11-18 17:30:12');
INSERT INTO `train` VALUES (139, 'K3111', '北京111', '天津111', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 311, 1111, '2019-11-18 17:30:12');
INSERT INTO `train` VALUES (140, 'K3112', '北京112', '天津112', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 312, 1112, '2019-11-18 17:30:12');
INSERT INTO `train` VALUES (141, 'K3113', '北京113', '天津113', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 313, 1113, '2019-11-18 17:30:12');
INSERT INTO `train` VALUES (142, 'K3114', '北京114', '天津114', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 314, 1114, '2019-11-18 17:30:13');
INSERT INTO `train` VALUES (143, 'K3115', '北京115', '天津115', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 315, 1115, '2019-11-18 17:30:13');
INSERT INTO `train` VALUES (144, 'K3116', '北京116', '天津116', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 316, 1116, '2019-11-18 17:30:13');
INSERT INTO `train` VALUES (145, 'K3117', '北京117', '天津117', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 317, 1117, '2019-11-18 17:30:13');
INSERT INTO `train` VALUES (146, 'K3118', '北京118', '天津118', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 318, 1118, '2019-11-18 17:30:14');
INSERT INTO `train` VALUES (147, 'K3119', '北京119', '天津119', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 319, 1119, '2019-11-18 17:30:14');
INSERT INTO `train` VALUES (148, 'K3120', '北京120', '天津120', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 320, 1120, '2019-11-18 17:30:14');
INSERT INTO `train` VALUES (149, 'K3121', '北京121', '天津121', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 321, 1121, '2019-11-18 17:30:14');
INSERT INTO `train` VALUES (150, 'K3122', '北京122', '天津122', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 322, 1122, '2019-11-18 17:30:14');
INSERT INTO `train` VALUES (151, 'K3123', '北京123', '天津123', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 323, 1123, '2019-11-18 17:30:15');
INSERT INTO `train` VALUES (152, 'K3124', '北京124', '天津124', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 324, 1124, '2019-11-18 17:30:15');
INSERT INTO `train` VALUES (153, 'K3125', '北京125', '天津125', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 325, 1125, '2019-11-18 17:30:15');
INSERT INTO `train` VALUES (154, 'K3126', '北京126', '天津126', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 326, 1126, '2019-11-18 17:30:15');
INSERT INTO `train` VALUES (155, 'K3127', '北京127', '天津127', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 327, 1127, '2019-11-18 17:30:16');
INSERT INTO `train` VALUES (156, 'K3128', '北京128', '天津128', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 328, 1128, '2019-11-18 17:30:16');
INSERT INTO `train` VALUES (157, 'K3129', '北京129', '天津129', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 329, 1129, '2019-11-18 17:30:16');
INSERT INTO `train` VALUES (158, 'K3130', '北京130', '天津130', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 330, 1130, '2019-11-18 17:30:16');
INSERT INTO `train` VALUES (159, 'K3131', '北京131', '天津131', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 331, 1131, '2019-11-18 17:30:17');
INSERT INTO `train` VALUES (160, 'K3132', '北京132', '天津132', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 332, 1132, '2019-11-18 17:30:17');
INSERT INTO `train` VALUES (161, 'K3133', '北京133', '天津133', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 333, 1133, '2019-11-18 17:30:17');
INSERT INTO `train` VALUES (162, 'K3134', '北京134', '天津134', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 334, 1134, '2019-11-18 17:30:17');
INSERT INTO `train` VALUES (163, 'K3135', '北京135', '天津135', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 335, 1135, '2019-11-18 17:30:18');
INSERT INTO `train` VALUES (164, 'K3136', '北京136', '天津136', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 336, 1136, '2019-11-18 17:30:18');
INSERT INTO `train` VALUES (165, 'K3137', '北京137', '天津137', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 337, 1137, '2019-11-18 17:30:18');
INSERT INTO `train` VALUES (166, 'K3138', '北京138', '天津138', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 338, 1138, '2019-11-18 17:30:18');
INSERT INTO `train` VALUES (167, 'K3139', '北京139', '天津139', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 339, 1139, '2019-11-18 17:30:19');
INSERT INTO `train` VALUES (168, 'K3140', '北京140', '天津140', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 340, 1140, '2019-11-18 17:30:19');
INSERT INTO `train` VALUES (169, 'K3141', '北京141', '天津141', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 341, 1141, '2019-11-18 17:30:19');
INSERT INTO `train` VALUES (170, 'K3142', '北京142', '天津142', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 342, 1142, '2019-11-18 17:30:19');
INSERT INTO `train` VALUES (171, 'K3143', '北京143', '天津143', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 343, 1143, '2019-11-18 17:30:20');
INSERT INTO `train` VALUES (172, 'K3144', '北京144', '天津144', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 344, 1144, '2019-11-18 17:30:20');
INSERT INTO `train` VALUES (173, 'K3145', '北京145', '天津145', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 345, 1145, '2019-11-18 17:30:20');
INSERT INTO `train` VALUES (174, 'K3146', '北京146', '天津146', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 346, 1146, '2019-11-18 17:30:20');
INSERT INTO `train` VALUES (175, 'K3147', '北京147', '天津147', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 347, 1147, '2019-11-18 17:30:20');
INSERT INTO `train` VALUES (176, 'K3148', '北京148', '天津148', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 348, 1148, '2019-11-18 17:30:21');
INSERT INTO `train` VALUES (177, 'K3149', '北京149', '天津149', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 349, 1149, '2019-11-18 17:30:21');
INSERT INTO `train` VALUES (178, 'K3150', '北京150', '天津150', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 350, 1149, '2019-11-18 17:30:21');
INSERT INTO `train` VALUES (179, 'K3151', '北京151', '天津151', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 351, 1151, '2019-11-18 17:30:21');
INSERT INTO `train` VALUES (180, 'K3152', '北京152', '天津152', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 352, 1152, '2019-11-18 17:30:22');
INSERT INTO `train` VALUES (181, 'K3153', '北京153', '天津153', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 353, 1153, '2019-11-18 17:30:22');
INSERT INTO `train` VALUES (182, 'K3154', '北京154', '天津154', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 354, 1154, '2019-11-18 17:30:22');
INSERT INTO `train` VALUES (183, 'K3155', '北京155', '天津155', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 355, 1155, '2019-11-18 17:30:22');
INSERT INTO `train` VALUES (184, 'K3156', '北京156', '天津156', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 356, 1156, '2019-11-18 17:30:23');
INSERT INTO `train` VALUES (185, 'K3157', '北京157', '天津157', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 357, 1157, '2019-11-18 17:30:23');
INSERT INTO `train` VALUES (186, 'K3158', '北京158', '天津158', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 358, 1158, '2019-11-18 17:30:23');
INSERT INTO `train` VALUES (187, 'K3159', '北京159', '天津159', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 359, 1159, '2019-11-18 17:30:23');
INSERT INTO `train` VALUES (188, 'K3160', '北京160', '天津160', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 360, 1160, '2019-11-18 17:30:23');
INSERT INTO `train` VALUES (189, 'K3161', '北京161', '天津161', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 361, 1161, '2019-11-18 17:30:24');
INSERT INTO `train` VALUES (190, 'K3162', '北京162', '天津162', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 362, 1162, '2019-11-18 17:30:24');
INSERT INTO `train` VALUES (191, 'K3163', '北京163', '天津163', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 363, 1163, '2019-11-18 17:30:24');
INSERT INTO `train` VALUES (192, 'K3164', '北京164', '天津164', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 364, 1164, '2019-11-18 17:30:24');
INSERT INTO `train` VALUES (193, 'K3165', '北京165', '天津165', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 365, 1165, '2019-11-18 17:30:25');
INSERT INTO `train` VALUES (194, 'K3166', '北京166', '天津166', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 366, 1166, '2019-11-18 17:30:25');
INSERT INTO `train` VALUES (195, 'K3167', '北京167', '天津167', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 367, 1167, '2019-11-18 17:30:25');
INSERT INTO `train` VALUES (196, 'K3168', '北京168', '天津168', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 368, 1168, '2019-11-18 17:30:25');
INSERT INTO `train` VALUES (197, 'K3169', '北京169', '天津169', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 369, 1169, '2019-11-18 17:30:26');
INSERT INTO `train` VALUES (198, 'K3170', '北京170', '天津170', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 370, 1170, '2019-11-18 17:30:26');
INSERT INTO `train` VALUES (199, 'K3171', '北京171', '天津171', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 371, 1171, '2019-11-18 17:30:26');
INSERT INTO `train` VALUES (200, 'K3172', '北京172', '天津172', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 372, 1172, '2019-11-18 17:30:26');
INSERT INTO `train` VALUES (201, 'K3173', '北京173', '天津173', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 373, 1173, '2019-11-18 17:30:26');
INSERT INTO `train` VALUES (202, 'K3174', '北京174', '天津174', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 374, 1174, '2019-11-18 17:30:27');
INSERT INTO `train` VALUES (203, 'K3175', '北京175', '天津175', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 375, 1175, '2019-11-18 17:30:27');
INSERT INTO `train` VALUES (204, 'K3176', '北京176', '天津176', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 376, 1176, '2019-11-18 17:30:27');
INSERT INTO `train` VALUES (205, 'K3177', '北京177', '天津177', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 377, 1177, '2019-11-18 17:30:27');
INSERT INTO `train` VALUES (206, 'K3178', '北京178', '天津178', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 378, 1178, '2019-11-18 17:30:28');
INSERT INTO `train` VALUES (207, 'K3179', '北京179', '天津179', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 379, 1179, '2019-11-18 17:30:28');
INSERT INTO `train` VALUES (208, 'K3180', '北京180', '天津180', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 380, 1180, '2019-11-18 17:30:28');
INSERT INTO `train` VALUES (209, 'K3181', '北京181', '天津181', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 381, 1181, '2019-11-18 17:30:28');
INSERT INTO `train` VALUES (210, 'K3182', '北京182', '天津182', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 382, 1182, '2019-11-18 17:30:28');
INSERT INTO `train` VALUES (211, 'K3183', '北京183', '天津183', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 383, 1183, '2019-11-18 17:30:29');
INSERT INTO `train` VALUES (213, 'K3185', '北京185', '天津185', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 385, 1185, '2019-11-18 17:30:29');
INSERT INTO `train` VALUES (214, 'K3186', '北京186', '天津186', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 386, 1186, '2019-11-18 17:30:29');
INSERT INTO `train` VALUES (215, 'K3187', '北京187', '天津187', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 387, 1187, '2019-11-18 17:30:30');
INSERT INTO `train` VALUES (216, 'K3188', '北京188', '天津188', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 388, 1188, '2019-11-18 17:30:30');
INSERT INTO `train` VALUES (217, 'K3189', '北京189', '天津189', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 389, 1189, '2019-11-18 17:30:30');
INSERT INTO `train` VALUES (218, 'K3190', '北京190', '天津190', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 390, 1190, '2019-11-18 17:30:30');
INSERT INTO `train` VALUES (219, 'K3191', '北京191', '天津191', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 391, 1191, '2019-11-18 17:30:31');
INSERT INTO `train` VALUES (220, 'K3192', '北京192', '天津192', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 392, 1192, '2019-11-18 17:30:31');
INSERT INTO `train` VALUES (221, 'K3193', '北京193', '天津193', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 393, 1193, '2019-11-18 17:30:31');
INSERT INTO `train` VALUES (222, 'K3194', '北京194', '天津194', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 394, 1194, '2019-11-18 17:30:31');
INSERT INTO `train` VALUES (223, 'K3195', '北京195', '天津195', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 395, 1195, '2019-11-18 17:30:31');
INSERT INTO `train` VALUES (224, 'K3196', '北京196', '天津196', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 396, 1196, '2019-11-18 17:30:32');
INSERT INTO `train` VALUES (225, 'K3197', '北京197', '天津197', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 397, 1197, '2019-11-18 17:30:32');
INSERT INTO `train` VALUES (226, 'K3198', '北京198', '天津198', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 398, 1198, '2019-11-18 17:30:32');
INSERT INTO `train` VALUES (227, 'K3199', '北京199', '天津199', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 399, 1199, '2019-11-18 17:30:32');
INSERT INTO `train` VALUES (228, 'K3200', '北京200', '天津200', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 400, 1200, '2019-11-18 17:30:33');
INSERT INTO `train` VALUES (229, 'K3201', '北京201', '天津201', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 401, 1201, '2019-11-18 17:30:33');
INSERT INTO `train` VALUES (230, 'K3202', '北京202', '天津202', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 402, 1202, '2019-11-18 17:30:33');
INSERT INTO `train` VALUES (231, 'K3203', '北京203', '天津203', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 403, 1203, '2019-11-18 17:30:33');
INSERT INTO `train` VALUES (232, 'K3204', '北京204', '天津204', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 404, 1204, '2019-11-18 17:30:34');
INSERT INTO `train` VALUES (233, 'K3205', '北京205', '天津205', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 405, 1205, '2019-11-18 17:30:34');
INSERT INTO `train` VALUES (234, 'K3206', '北京206', '天津206', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 406, 1206, '2019-11-18 17:30:34');
INSERT INTO `train` VALUES (235, 'K3207', '北京207', '天津207', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 407, 1207, '2019-11-18 17:30:34');
INSERT INTO `train` VALUES (236, 'K3208', '北京208', '天津208', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 408, 1208, '2019-11-18 17:30:35');
INSERT INTO `train` VALUES (237, 'K3209', '北京209', '天津209', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 409, 1209, '2019-11-18 17:30:35');
INSERT INTO `train` VALUES (238, 'K3210', '北京210', '天津210', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 410, 1210, '2019-11-18 17:30:35');
INSERT INTO `train` VALUES (239, 'K3211', '北京211', '天津211', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 411, 1211, '2019-11-18 17:30:35');
INSERT INTO `train` VALUES (240, 'K3212', '北京212', '天津212', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 412, 1212, '2019-11-18 17:30:35');
INSERT INTO `train` VALUES (241, 'K3213', '北京213', '天津213', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 413, 1213, '2019-11-18 17:30:36');
INSERT INTO `train` VALUES (242, 'K3214', '北京214', '天津214', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 414, 1214, '2019-11-18 17:30:36');
INSERT INTO `train` VALUES (243, 'K3215', '北京215', '天津215', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 415, 1215, '2019-11-18 17:30:37');
INSERT INTO `train` VALUES (244, 'K3216', '北京216', '天津216', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 416, 1216, '2019-11-18 17:30:37');
INSERT INTO `train` VALUES (245, 'K3217', '北京217', '天津217', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 417, 1217, '2019-11-18 17:30:37');
INSERT INTO `train` VALUES (246, 'K3218', '北京218', '天津218', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 418, 1218, '2019-11-18 17:30:37');
INSERT INTO `train` VALUES (247, 'K3219', '北京219', '天津219', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 419, 1219, '2019-11-18 17:30:38');
INSERT INTO `train` VALUES (248, 'K3220', '北京220', '天津220', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 420, 1220, '2019-11-18 17:30:38');
INSERT INTO `train` VALUES (249, 'K3221', '北京221', '天津221', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 421, 1221, '2019-11-18 17:30:38');
INSERT INTO `train` VALUES (250, 'K3222', '北京222', '天津222', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 422, 1222, '2019-11-18 17:30:38');
INSERT INTO `train` VALUES (251, 'K3223', '北京223', '天津223', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 423, 1223, '2019-11-18 17:30:39');
INSERT INTO `train` VALUES (252, 'K3224', '北京224', '天津224', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 424, 1224, '2019-11-18 17:30:39');
INSERT INTO `train` VALUES (253, 'K3225', '北京225', '天津225', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 425, 1225, '2019-11-18 17:30:39');
INSERT INTO `train` VALUES (254, 'K3226', '北京226', '天津226', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 426, 1226, '2019-11-18 17:30:39');
INSERT INTO `train` VALUES (255, 'K3227', '北京227', '天津227', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 427, 1227, '2019-11-18 17:30:39');
INSERT INTO `train` VALUES (256, 'K3228', '北京228', '天津228', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 428, 1228, '2019-11-18 17:30:40');
INSERT INTO `train` VALUES (257, 'K3229', '北京229', '天津229', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 429, 1229, '2019-11-18 17:30:40');
INSERT INTO `train` VALUES (258, 'K3230', '北京230', '天津230', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 430, 1230, '2019-11-18 17:30:40');
INSERT INTO `train` VALUES (259, 'K3231', '北京231', '天津231', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 431, 1231, '2019-11-18 17:30:40');
INSERT INTO `train` VALUES (260, 'K3232', '北京232', '天津232', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 432, 1232, '2019-11-18 17:30:41');
INSERT INTO `train` VALUES (261, 'K3233', '北京233', '天津233', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 433, 1233, '2019-11-18 17:30:41');
INSERT INTO `train` VALUES (262, 'K3234', '北京234', '天津234', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 434, 1234, '2019-11-18 17:30:41');
INSERT INTO `train` VALUES (263, 'K3235', '北京235', '天津235', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 435, 1235, '2019-11-18 17:30:41');
INSERT INTO `train` VALUES (264, 'K3236', '北京236', '天津236', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 436, 1236, '2019-11-18 17:30:42');
INSERT INTO `train` VALUES (265, 'K3237', '北京237', '天津237', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 437, 1237, '2019-11-18 17:30:42');
INSERT INTO `train` VALUES (266, 'K3238', '北京238', '天津238', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 438, 1238, '2019-11-18 17:30:42');
INSERT INTO `train` VALUES (267, 'K3239', '北京239', '天津239', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 439, 1239, '2019-11-18 17:30:42');
INSERT INTO `train` VALUES (268, 'K3240', '北京240', '天津240', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 440, 1240, '2019-11-18 17:30:43');
INSERT INTO `train` VALUES (269, 'K3241', '北京241', '天津241', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 441, 1241, '2019-11-18 17:30:43');
INSERT INTO `train` VALUES (270, 'K3242', '北京242', '天津242', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 442, 1242, '2019-11-18 17:30:43');
INSERT INTO `train` VALUES (271, 'K3243', '北京243', '天津243', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 443, 1243, '2019-11-18 17:30:43');
INSERT INTO `train` VALUES (272, 'K3244', '北京244', '天津244', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 444, 1244, '2019-11-18 17:30:44');
INSERT INTO `train` VALUES (273, 'K3245', '北京245', '天津245', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 445, 1245, '2019-11-18 17:30:44');
INSERT INTO `train` VALUES (274, 'K3246', '北京246', '天津246', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 446, 1246, '2019-11-18 17:30:44');
INSERT INTO `train` VALUES (275, 'K3247', '北京247', '天津247', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 447, 1247, '2019-11-18 17:30:44');
INSERT INTO `train` VALUES (276, 'K3248', '北京248', '天津248', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 448, 1248, '2019-11-18 17:30:44');
INSERT INTO `train` VALUES (277, 'K3249', '北京249', '天津249', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 449, 1249, '2019-11-18 17:30:45');
INSERT INTO `train` VALUES (278, 'K3250', '北京250', '天津250', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 450, 1250, '2019-11-18 17:30:45');
INSERT INTO `train` VALUES (279, 'K3251', '北京251', '天津251', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 451, 1251, '2019-11-18 17:30:45');
INSERT INTO `train` VALUES (280, 'K3252', '北京252', '天津252', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 452, 1252, '2019-11-18 17:30:45');
INSERT INTO `train` VALUES (281, 'K3253', '北京253', '天津253', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 453, 1253, '2019-11-18 17:30:46');
INSERT INTO `train` VALUES (282, 'K3254', '北京254', '天津254', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 454, 1254, '2019-11-18 17:30:46');
INSERT INTO `train` VALUES (283, 'K3255', '北京255', '天津255', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 455, 1255, '2019-11-18 17:30:46');
INSERT INTO `train` VALUES (284, 'K3256', '北京256', '天津256', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 456, 1256, '2019-11-18 17:30:46');
INSERT INTO `train` VALUES (285, 'K3257', '北京257', '天津257', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 457, 1257, '2019-11-18 17:30:47');
INSERT INTO `train` VALUES (286, 'K3258', '北京258', '天津258', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 458, 1258, '2019-11-18 17:30:47');
INSERT INTO `train` VALUES (287, 'K3259', '北京259', '天津259', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 459, 1259, '2019-11-18 17:30:47');
INSERT INTO `train` VALUES (288, 'K3260', '北京260', '天津260', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 460, 1260, '2019-11-18 17:30:47');
INSERT INTO `train` VALUES (289, 'K3261', '北京261', '天津261', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 461, 1261, '2019-11-18 17:30:47');
INSERT INTO `train` VALUES (290, 'K3262', '北京262', '天津262', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 462, 1262, '2019-11-18 17:30:48');
INSERT INTO `train` VALUES (291, 'K3263', '北京263', '天津263', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 463, 1263, '2019-11-18 17:30:48');
INSERT INTO `train` VALUES (292, 'K3264', '北京264', '天津264', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 464, 1264, '2019-11-18 17:30:48');
INSERT INTO `train` VALUES (293, 'K3265', '北京265', '天津265', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 465, 1265, '2019-11-18 17:30:48');
INSERT INTO `train` VALUES (294, 'K3266', '北京266', '天津266', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 466, 1266, '2019-11-18 17:30:49');
INSERT INTO `train` VALUES (295, 'K3267', '北京267', '天津267', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 467, 1267, '2019-11-18 17:30:49');
INSERT INTO `train` VALUES (296, 'K3268', '北京268', '天津268', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 468, 1268, '2019-11-18 17:30:49');
INSERT INTO `train` VALUES (297, 'K3269', '北京269', '天津269', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 469, 1269, '2019-11-18 17:30:49');
INSERT INTO `train` VALUES (298, 'K3270', '北京270', '天津270', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 470, 1270, '2019-11-18 17:30:50');
INSERT INTO `train` VALUES (299, 'K3271', '北京271', '天津271', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 471, 1271, '2019-11-18 17:30:50');
INSERT INTO `train` VALUES (300, 'K3272', '北京272', '天津272', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 472, 1272, '2019-11-18 17:30:50');
INSERT INTO `train` VALUES (301, 'K3273', '北京273', '天津273', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 473, 1273, '2019-11-18 17:30:50');
INSERT INTO `train` VALUES (302, 'K3274', '北京274', '天津274', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 474, 1274, '2019-11-18 17:30:51');
INSERT INTO `train` VALUES (303, 'K3275', '北京275', '天津275', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 475, 1275, '2019-11-18 17:30:51');
INSERT INTO `train` VALUES (304, 'K3276', '北京276', '天津276', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 476, 1276, '2019-11-18 17:30:51');
INSERT INTO `train` VALUES (305, 'K3277', '北京277', '天津277', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 477, 1277, '2019-11-18 17:30:51');
INSERT INTO `train` VALUES (306, 'K3278', '北京278', '天津278', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 478, 1278, '2019-11-18 17:30:52');
INSERT INTO `train` VALUES (307, 'K3279', '北京279', '天津279', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 479, 1279, '2019-11-18 17:30:52');
INSERT INTO `train` VALUES (308, 'K3280', '北京280', '天津280', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 480, 1280, '2019-11-18 17:30:52');
INSERT INTO `train` VALUES (309, 'K3281', '北京281', '天津281', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 481, 1281, '2019-11-18 17:30:52');
INSERT INTO `train` VALUES (310, 'K3282', '北京282', '天津282', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 482, 1282, '2019-11-18 17:30:53');
INSERT INTO `train` VALUES (311, 'K3283', '北京283', '天津283', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 483, 1283, '2019-11-18 17:30:53');
INSERT INTO `train` VALUES (312, 'K3284', '北京284', '天津284', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 484, 1284, '2019-11-18 17:30:53');
INSERT INTO `train` VALUES (313, 'K3285', '北京285', '天津285', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 485, 1285, '2019-11-18 17:30:53');
INSERT INTO `train` VALUES (314, 'K3286', '北京286', '天津286', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 486, 1286, '2019-11-18 17:30:54');
INSERT INTO `train` VALUES (315, 'K3287', '北京287', '天津287', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 487, 1287, '2019-11-18 17:30:54');
INSERT INTO `train` VALUES (316, 'K3288', '北京288', '天津288', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 488, 1288, '2019-11-18 17:30:54');
INSERT INTO `train` VALUES (317, 'K3289', '北京289', '天津289', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 489, 1289, '2019-11-18 17:30:54');
INSERT INTO `train` VALUES (318, 'K3290', '北京290', '天津290', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 490, 1290, '2019-11-18 17:30:55');
INSERT INTO `train` VALUES (319, 'K3291', '北京291', '天津291', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 491, 1291, '2019-11-18 17:30:55');
INSERT INTO `train` VALUES (320, 'K3292', '北京292', '天津292', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 492, 1292, '2019-11-18 17:30:55');
INSERT INTO `train` VALUES (321, 'K3293', '北京293', '天津293', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 493, 1293, '2019-11-18 17:30:55');
INSERT INTO `train` VALUES (322, 'K3294', '北京294', '天津294', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 494, 1294, '2019-11-18 17:30:56');
INSERT INTO `train` VALUES (323, 'K3295', '北京295', '天津295', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 495, 1295, '2019-11-18 17:30:56');
INSERT INTO `train` VALUES (324, 'K3296', '北京296', '天津296', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 496, 1296, '2019-11-18 17:30:56');
INSERT INTO `train` VALUES (325, 'K3297', '北京297', '天津297', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 497, 1297, '2019-11-18 17:30:56');
INSERT INTO `train` VALUES (326, 'K3298', '北京298', '天津298', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 498, 1298, '2019-11-18 17:30:57');
INSERT INTO `train` VALUES (327, 'K3299', '北京299', '天津299', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 499, 1299, '2019-11-18 17:30:57');
INSERT INTO `train` VALUES (328, 'K3300', '北京300', '天津300', '2020-01-01 15:30:00', '2020-01-02 16:50:00', 500, 1300, '2019-11-18 17:30:57');
INSERT INTO `train` VALUES (329, 'T23', '南昌', '安徽', '2019-11-22 12:12:00', '2019-11-14 12:12:00', 20, 498, '2019-11-18 18:23:36');
INSERT INTO `train` VALUES (330, 'K8511', '海南', '九江', '2019-11-01 12:12:00', '2019-11-13 12:12:00', 20022, 499, '2019-11-18 23:37:00');
INSERT INTO `train` VALUES (331, 'D23121', '南昌', '福建', '2020-01-08 23:59:00', '2020-01-31 01:59:00', 20, 995, '2019-11-18 23:40:23');
INSERT INTO `train` VALUES (332, 'D2312A', '江苏', '福建', '2019-12-31 01:53:00', '2019-12-31 14:03:00', 1000, 98, '2019-11-18 23:44:01');
INSERT INTO `train` VALUES (334, 'D2311', '成都', '珠海', '2019-11-30 12:12:00', '2019-11-30 16:09:00', 200, 500, '2019-11-22 10:55:51');
SET FOREIGN_KEY_CHECKS = 1;