web-statistics
/
Statistics.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 81.69.2.42
 Source Server Type    : MySQL
 Source Server Version : 80022
 Source Host           : 81.69.2.42:13306
 Source Schema         : Statistics

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

 Date: 08/06/2021 22:13:28
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for info
-- ----------------------------
DROP TABLE IF EXISTS `info`;
CREATE TABLE `info`  (
  `id` int(0) NOT NULL COMMENT '信息id',
  `val` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '内容',
  `time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `userid` int(0) NULL DEFAULT NULL COMMENT '目标用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作类型',
  `val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for record_info
-- ----------------------------
DROP TABLE IF EXISTS `record_info`;
CREATE TABLE `record_info`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作类型 查看 修改等',
  `val` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for record_login
-- ----------------------------
DROP TABLE IF EXISTS `record_login`;
CREATE TABLE `record_login`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `userid` int(0) NULL DEFAULT NULL COMMENT '用户id',
  `ip` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作ip',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for summary
-- ----------------------------
DROP TABLE IF EXISTS `summary`;
CREATE TABLE `summary`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `userid` int(0) NOT NULL COMMENT '用户ID',
  `time` datetime(0) NOT NULL COMMENT '时间',
  `course` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '课程',
  `branch` int(0) NOT NULL COMMENT '分',
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评语',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 766 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of summary
-- ----------------------------
INSERT INTO `summary` VALUES (324, 6, '2021-04-28 18:33:29', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (325, 7, '2021-04-28 18:33:29', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (326, 8, '2021-04-28 18:33:29', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (327, 9, '2021-04-28 18:33:29', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (328, 10, '2021-04-28 18:33:29', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (329, 11, '2021-04-28 18:33:29', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (330, 12, '2021-04-28 18:33:29', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (331, 13, '2021-04-28 18:33:29', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (332, 6, '2021-05-22 20:20:51', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (333, 7, '2021-05-22 20:20:51', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (334, 8, '2021-05-22 20:20:51', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (335, 9, '2021-05-22 20:20:51', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (336, 10, '2021-05-22 20:20:51', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (337, 11, '2021-05-22 20:20:51', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (338, 12, '2021-05-22 20:20:51', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (339, 13, '2021-05-22 20:20:51', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (340, 1, '2021-05-22 20:22:09', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (341, 1, '2021-05-22 20:22:09', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (342, 1, '2021-05-22 20:22:09', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (343, 1, '2021-05-22 20:22:09', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (344, 1, '2021-05-22 20:22:09', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (345, 1, '2021-05-22 20:22:09', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (346, 1, '2021-05-22 20:22:09', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (347, 1, '2021-05-22 20:22:09', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (348, 1, '2021-05-22 20:23:57', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (349, 1, '2021-05-22 20:23:57', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (350, 1, '2021-05-22 20:23:57', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (351, 1, '2021-05-22 20:23:57', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (352, 1, '2021-05-22 20:23:57', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (353, 1, '2021-05-22 20:23:57', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (354, 1, '2021-05-22 20:23:57', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (355, 1, '2021-05-22 20:23:57', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (356, 1, '2021-05-22 20:45:18', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (357, 1, '2021-05-22 20:45:19', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (358, 1, '2021-05-22 20:45:19', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (359, 1, '2021-05-22 20:45:19', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (360, 1, '2021-05-22 20:45:19', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (361, 1, '2021-05-22 20:45:19', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (362, 1, '2021-05-22 20:45:20', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (363, 1, '2021-05-22 20:45:20', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (364, 1, '2021-05-22 20:47:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (365, 1, '2021-05-22 20:47:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (366, 1, '2021-05-22 20:47:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (367, 1, '2021-05-22 20:47:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (368, 1, '2021-05-22 20:47:15', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (369, 1, '2021-05-22 20:47:15', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (370, 1, '2021-05-22 20:47:16', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (371, 1, '2021-05-22 20:47:16', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (372, 14, '2021-05-22 20:47:58', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (373, 15, '2021-05-22 20:47:59', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (374, 16, '2021-05-22 20:47:59', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (375, 17, '2021-05-22 20:47:59', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (376, 18, '2021-05-22 20:47:59', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (377, 19, '2021-05-22 20:48:00', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (378, 20, '2021-05-22 20:48:00', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (379, 21, '2021-05-22 20:48:00', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (380, 14, '2021-05-22 20:50:12', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (381, 15, '2021-05-22 20:50:12', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (382, 16, '2021-05-22 20:50:12', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (383, 17, '2021-05-22 20:50:12', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (384, 18, '2021-05-22 20:50:12', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (385, 19, '2021-05-22 20:50:12', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (386, 20, '2021-05-22 20:50:12', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (387, 21, '2021-05-22 20:50:12', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (388, 1, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (389, 1, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (390, 1, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (391, 1, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (392, 1, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (393, 1, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (394, 1, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (395, 1, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (396, 1, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (397, 1, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (398, 1, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (399, 1, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (400, 1, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (401, 1, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (402, 1, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (403, 1, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (404, 1, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (405, 1, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (406, 1, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (407, 1, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (408, 1, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (409, 1, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (410, 1, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (411, 1, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (412, 1, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (413, 1, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (414, 1, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (415, 1, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (416, 1, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (417, 1, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (418, 1, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (419, 1, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (420, 14, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (421, 15, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (422, 16, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (423, 17, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (424, 18, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (425, 19, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (426, 20, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (427, 21, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (428, 14, '2021-06-04 20:23:14', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (429, 15, '2021-06-04 20:23:14', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (430, 16, '2021-06-04 20:23:14', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (431, 17, '2021-06-04 20:23:14', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (432, 18, '2021-06-04 20:23:14', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (433, 19, '2021-06-04 20:23:14', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (434, 20, '2021-06-04 20:23:14', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (435, 21, '2021-06-04 20:23:14', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (436, 1, '2021-06-06 04:34:20', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (437, 1, '2021-06-06 04:34:20', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (438, 1, '2021-06-06 04:34:20', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (439, 1, '2021-06-06 04:34:20', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (440, 1, '2021-06-06 04:34:20', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (441, 1, '2021-06-06 04:34:20', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (442, 1, '2021-06-06 04:34:20', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (443, 1, '2021-06-06 04:34:20', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (444, 1, '2021-06-06 04:34:20', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (445, 1, '2021-06-06 04:34:20', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (446, 1, '2021-06-06 04:34:20', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (447, 1, '2021-06-06 04:34:20', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (448, 1, '2021-06-06 04:34:20', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (449, 1, '2021-06-06 04:34:20', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (450, 1, '2021-06-06 04:34:20', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (451, 1, '2021-06-06 04:34:20', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (452, 1, '2021-06-06 04:34:20', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (453, 1, '2021-06-06 04:34:20', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (454, 1, '2021-06-06 04:34:20', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (455, 1, '2021-06-06 04:34:20', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (456, 1, '2021-06-06 04:34:20', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (457, 1, '2021-06-06 04:34:20', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (458, 1, '2021-06-06 04:34:21', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (459, 1, '2021-06-06 04:34:21', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (460, 1, '2021-06-06 04:34:21', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (461, 1, '2021-06-06 04:34:21', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (462, 1, '2021-06-06 04:34:21', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (463, 1, '2021-06-06 04:34:21', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (464, 1, '2021-06-06 04:34:21', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (465, 1, '2021-06-06 04:34:21', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (466, 1, '2021-06-06 04:34:21', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (467, 1, '2021-06-06 04:34:21', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (468, 14, '2021-06-06 04:34:21', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (469, 15, '2021-06-06 04:34:21', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (470, 16, '2021-06-06 04:34:21', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (471, 17, '2021-06-06 04:34:21', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (472, 18, '2021-06-06 04:34:21', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (473, 19, '2021-06-06 04:34:21', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (474, 20, '2021-06-06 04:34:21', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (475, 21, '2021-06-06 04:34:21', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (476, 14, '2021-06-06 04:34:21', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (477, 15, '2021-06-06 04:34:21', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (478, 16, '2021-06-06 04:34:21', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (479, 17, '2021-06-06 04:34:21', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (480, 18, '2021-06-06 04:34:22', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (481, 19, '2021-06-06 04:34:22', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (482, 20, '2021-06-06 04:34:22', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (483, 21, '2021-06-06 04:34:22', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (484, 1, '2021-06-06 04:34:22', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (485, 1, '2021-06-06 04:34:22', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (486, 1, '2021-06-06 04:34:22', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (487, 1, '2021-06-06 04:34:22', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (488, 1, '2021-06-06 04:34:22', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (489, 1, '2021-06-06 04:34:22', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (490, 1, '2021-06-06 04:34:22', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (491, 1, '2021-06-06 04:34:22', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (492, 1, '2021-06-06 04:34:22', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (493, 1, '2021-06-06 04:34:22', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (494, 1, '2021-06-06 04:34:22', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (495, 1, '2021-06-06 04:34:22', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (496, 1, '2021-06-06 04:34:22', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (497, 1, '2021-06-06 04:34:22', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (498, 1, '2021-06-06 04:34:22', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (499, 1, '2021-06-06 04:34:22', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (500, 1, '2021-06-06 04:34:22', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (501, 1, '2021-06-06 04:34:22', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (502, 1, '2021-06-06 04:34:23', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (503, 1, '2021-06-06 04:34:23', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (504, 1, '2021-06-06 04:34:23', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (505, 1, '2021-06-06 04:34:23', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (506, 1, '2021-06-06 04:34:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (507, 1, '2021-06-06 04:34:23', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (508, 1, '2021-06-06 04:34:23', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (509, 1, '2021-06-06 04:34:23', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (510, 1, '2021-06-06 04:34:23', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (511, 1, '2021-06-06 04:34:23', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (512, 1, '2021-06-06 04:34:23', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (513, 1, '2021-06-06 04:34:23', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (514, 1, '2021-06-06 04:34:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (515, 1, '2021-06-06 04:34:23', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (516, 14, '2021-06-06 04:34:23', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (517, 15, '2021-06-06 04:34:23', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (518, 16, '2021-06-06 04:34:23', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (519, 17, '2021-06-06 04:34:23', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (520, 18, '2021-06-06 04:34:23', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (521, 19, '2021-06-06 04:34:23', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (522, 20, '2021-06-06 04:34:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (523, 21, '2021-06-06 04:34:23', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (524, 14, '2021-06-06 04:34:24', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (525, 15, '2021-06-06 04:34:24', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (526, 16, '2021-06-06 04:34:24', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (527, 17, '2021-06-06 04:34:24', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (528, 18, '2021-06-06 04:34:24', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (529, 19, '2021-06-06 04:34:24', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (530, 20, '2021-06-06 04:34:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (531, 21, '2021-06-06 04:34:24', 'java语言', 90, NULL);
INSERT INTO `summary` VALUES (532, 14, '2021-06-06 14:50:45', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (533, 15, '2021-06-06 14:50:45', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (534, 16, '2021-06-06 14:50:45', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (535, 17, '2021-06-06 14:50:45', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (536, 18, '2021-06-06 14:50:45', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (537, 19, '2021-06-06 14:50:45', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (538, 20, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (539, 21, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (540, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (541, 15, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (542, 16, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (543, 17, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (544, 18, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (545, 19, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (546, 20, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (547, 21, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (548, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (549, 15, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (550, 16, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (551, 17, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (552, 18, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (553, 19, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (554, 20, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (555, 21, '2021-06-06 14:50:45', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (556, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (557, 15, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (558, 16, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (559, 17, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (560, 18, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (561, 19, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (562, 20, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (563, 21, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (564, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (565, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (566, 15, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (567, 16, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (568, 17, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (569, 18, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (570, 19, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (571, 20, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (572, 21, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (573, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (574, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (575, 15, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (576, 16, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (577, 17, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (578, 18, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (579, 19, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (580, 20, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (581, 21, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (582, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (583, 14, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (584, 15, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (585, 16, '2021-06-06 14:50:45', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (586, 17, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (587, 18, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (588, 19, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (589, 20, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (590, 21, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (591, 14, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (592, 14, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (593, 15, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (594, 16, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (595, 17, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (596, 18, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (597, 19, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (598, 20, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (599, 21, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (600, 14, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (601, 14, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (602, 15, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (603, 16, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (604, 17, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (605, 18, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (606, 19, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (607, 20, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (608, 21, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (609, 14, '2021-06-06 14:50:46', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (610, 14, '2021-06-06 15:00:22', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (611, 15, '2021-06-06 15:00:22', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (612, 16, '2021-06-06 15:00:22', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (613, 17, '2021-06-06 15:00:22', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (614, 18, '2021-06-06 15:00:22', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (615, 19, '2021-06-06 15:00:23', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (616, 20, '2021-06-06 15:00:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (617, 21, '2021-06-06 15:00:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (618, 14, '2021-06-06 15:00:23', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (619, 15, '2021-06-06 15:00:23', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (620, 16, '2021-06-06 15:00:23', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (621, 17, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (622, 18, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (623, 19, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (624, 20, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (625, 21, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (626, 14, '2021-06-06 15:00:25', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (627, 15, '2021-06-06 15:00:25', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (628, 16, '2021-06-06 15:00:26', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (629, 17, '2021-06-06 15:00:26', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (630, 18, '2021-06-06 15:00:26', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (631, 19, '2021-06-06 15:00:27', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (632, 20, '2021-06-06 15:00:27', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (633, 21, '2021-06-06 15:00:27', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (634, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (635, 15, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (636, 16, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (637, 17, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (638, 18, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (639, 19, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (640, 20, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (641, 21, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (642, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (643, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (644, 15, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (645, 16, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (646, 17, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (647, 18, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (648, 19, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (649, 20, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (650, 21, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (651, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (652, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (653, 15, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (654, 16, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (655, 17, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (656, 18, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (657, 19, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (658, 20, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (659, 21, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (660, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (661, 14, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (662, 15, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (663, 16, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (664, 17, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (665, 18, '2021-06-06 15:00:27', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (666, 19, '2021-06-06 15:00:28', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (667, 20, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (668, 21, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (669, 14, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (670, 14, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (671, 15, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (672, 16, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (673, 17, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (674, 18, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (675, 19, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (676, 20, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (677, 21, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (678, 14, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (679, 14, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (680, 15, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (681, 16, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (682, 17, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (683, 18, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (684, 19, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (685, 20, '2021-06-06 15:00:29', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (686, 21, '2021-06-06 15:00:30', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (687, 14, '2021-06-06 15:00:30', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (688, 25, '2021-06-06 15:05:23', 'java语言', 20, NULL);
INSERT INTO `summary` VALUES (689, 16, '2021-06-06 15:05:23', 'java语言', 30, NULL);
INSERT INTO `summary` VALUES (690, 26, '2021-06-06 15:05:23', 'java语言', 40, NULL);
INSERT INTO `summary` VALUES (691, 18, '2021-06-06 15:05:23', 'java语言', 50, NULL);
INSERT INTO `summary` VALUES (692, 27, '2021-06-06 15:05:23', 'java语言', 60, NULL);
INSERT INTO `summary` VALUES (693, 20, '2021-06-06 15:05:23', 'java语言', 70, NULL);
INSERT INTO `summary` VALUES (694, 28, '2021-06-06 15:05:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (695, 29, '2021-06-06 15:05:23', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (696, 30, '2021-06-06 15:05:23', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (697, 31, '2021-06-06 15:05:23', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (698, 32, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (699, 33, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (700, 34, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (701, 35, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (702, 36, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (703, 37, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (704, 38, '2021-06-06 15:05:24', 'c语言', 80, NULL);
INSERT INTO `summary` VALUES (705, 39, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (706, 40, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (707, 41, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (708, 42, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (709, 43, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (710, 44, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (711, 45, '2021-06-06 15:05:24', 'java语言', 80, NULL);
INSERT INTO `summary` VALUES (712, 46, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (713, 47, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (714, 48, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (715, 49, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (716, 50, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (717, 51, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (718, 52, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (719, 53, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (720, 54, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (721, 55, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (722, 56, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (723, 57, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (724, 58, '2021-06-06 15:05:24', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (725, 59, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (726, 60, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (727, 61, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (728, 62, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (729, 63, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (730, 64, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (731, 65, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (732, 66, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (733, 67, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (734, 68, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (735, 69, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (736, 70, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (737, 71, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (738, 72, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (739, 73, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (740, 74, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (741, 75, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (742, 76, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (743, 77, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (744, 78, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (745, 79, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (746, 80, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (747, 81, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (748, 82, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (749, 83, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (750, 84, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (751, 85, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (752, 86, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (753, 87, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (754, 88, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (755, 89, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (756, 90, '2021-06-06 15:05:25', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (757, 91, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (758, 92, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (759, 93, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (760, 94, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (761, 95, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (762, 96, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (763, 97, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (764, 98, '2021-06-06 15:05:26', '大数据', 80, NULL);
INSERT INTO `summary` VALUES (765, 99, '2021-06-06 15:05:26', '大数据', 80, NULL);

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '工号',
  `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '姓名',
  `sex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '性别',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `type` tinyint(1) NOT NULL COMMENT '类型 1=学生 2=管理员',
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名称',
  `password` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '密码',
  `sex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '性别',
  `StudentID` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学号',
  `major` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '专业',
  `class` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '班级',
  `semester` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '学期',
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '评语',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 100 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 2, '小米', '1', '1', '1', '计算机', '1班', NULL, NULL);
INSERT INTO `user` VALUES (2, 3, 'q', '2', '1', '2', '2', '2', NULL, NULL);
INSERT INTO `user` VALUES (3, 1, 'q2', '2', '1', '2', '2', '2', NULL, NULL);
INSERT INTO `user` VALUES (4, 1, '1', '1', '1', '1', '1', '1', NULL, NULL);
INSERT INTO `user` VALUES (5, 1, 'a', '1', '1', 'a', 'a', 'a', NULL, NULL);
INSERT INTO `user` VALUES (14, 1, '张三', '0', '男', '1', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (15, 1, '李四', '0', '女', '2', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (16, 1, '张2', '0', '男', '12', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (17, 1, '李3', '0', '女', '2', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (18, 1, '张4', '0', '男', '13', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (19, 1, '李5', '0', '女', '2', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (20, 1, '张6', '0', '男', '1', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (21, 1, '李7', '0', '女', '2', '移动', '2班', '大一春学期', NULL);
INSERT INTO `user` VALUES (22, 1, '2', '2', '1', '2', '2', '2', NULL, NULL);
INSERT INTO `user` VALUES (23, 1, 'tdxing', '123456', '1', '5171912134', '计算机', '1701', NULL, NULL);
INSERT INTO `user` VALUES (24, 1, '3', '3', '1', '3', '3', '3', NULL, NULL);
INSERT INTO `user` VALUES (25, 1, '张1', '0', '男', '1', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (26, 1, '张3', '0', '男', '3', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (27, 1, '张5', '0', '男', '5', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (28, 1, '张7', '0', '男', '7', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (29, 1, '张8', '0', '女', '8', '移动', '2班', '大一春学期', NULL);
INSERT INTO `user` VALUES (30, 1, '张9', '0', '男', '9', '大数据', '1班', '大一春学期', NULL);
INSERT INTO `user` VALUES (31, 1, '张10', '0', '女', '10', '大数据', '2班', '大一春学期', NULL);
INSERT INTO `user` VALUES (32, 1, '张11', '0', '男', '11', '大数据', '3班', '大一春学期', NULL);
INSERT INTO `user` VALUES (33, 1, '张12', '0', '女', '12', '大数据', '4班', '大一春学期', NULL);
INSERT INTO `user` VALUES (34, 1, '张13', '0', '男', '13', '大数据', '5班', '大一春学期', NULL);
INSERT INTO `user` VALUES (35, 1, '张14', '0', '女', '14', '大数据', '6班', '大一春学期', NULL);
INSERT INTO `user` VALUES (36, 1, '张15', '0', '男', '15', '大数据', '7班', '大一春学期', NULL);
INSERT INTO `user` VALUES (37, 1, '张16', '0', '女', '16', '大数据', '8班', '大一春学期', NULL);
INSERT INTO `user` VALUES (38, 1, '张17', '0', '男', '17', '大数据', '9班', '大一春学期', NULL);
INSERT INTO `user` VALUES (39, 1, '张18', '0', '女', '18', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (40, 1, '张19', '0', '男', '19', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (41, 1, '张20', '0', '女', '20', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (42, 1, '张21', '0', '男', '21', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (43, 1, '张22', '0', '女', '22', '移动', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (44, 1, '张23', '0', '男', '23', '编程', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (45, 1, '张24', '0', '女', '24', '移动', '2班', '大一春学期', NULL);
INSERT INTO `user` VALUES (46, 1, '张25', '0', '男', '25', '大数据', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (47, 1, '张26', '0', '女', '26', '大数据', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (48, 1, '张27', '0', '男', '27', '大数据', '3班', '大二春学期', NULL);
INSERT INTO `user` VALUES (49, 1, '张28', '0', '女', '28', '大数据', '4班', '大二春学期', NULL);
INSERT INTO `user` VALUES (50, 1, '张29', '0', '男', '29', '大数据', '5班', '大二春学期', NULL);
INSERT INTO `user` VALUES (51, 1, '张30', '0', '女', '30', '大数据', '6班', '大二春学期', NULL);
INSERT INTO `user` VALUES (52, 1, '张31', '0', '男', '31', '大数据', '7班', '大二春学期', NULL);
INSERT INTO `user` VALUES (53, 1, '张32', '0', '女', '32', '大数据', '8班', '大二春学期', NULL);
INSERT INTO `user` VALUES (54, 1, '张33', '0', '男', '33', '大数据', '9班', '大二春学期', NULL);
INSERT INTO `user` VALUES (55, 1, '张34', '0', '男', '34', '大数据', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (56, 1, '张35', '0', '女', '35', '大数据', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (57, 1, '张36', '0', '男', '36', '大数据', '3班', '大二春学期', NULL);
INSERT INTO `user` VALUES (58, 1, '张37', '0', '女', '37', '大数据', '4班', '大二春学期', NULL);
INSERT INTO `user` VALUES (59, 1, '张38', '0', '男', '38', '大数据', '5班', '大二春学期', NULL);
INSERT INTO `user` VALUES (60, 1, '张39', '0', '女', '39', '大数据', '6班', '大二春学期', NULL);
INSERT INTO `user` VALUES (61, 1, '张40', '0', '男', '40', '大数据', '7班', '大二春学期', NULL);
INSERT INTO `user` VALUES (62, 1, '张41', '0', '女', '41', '大数据', '8班', '大二春学期', NULL);
INSERT INTO `user` VALUES (63, 1, '张42', '0', '男', '42', '大数据', '9班', '大二春学期', NULL);
INSERT INTO `user` VALUES (64, 1, '张43', '0', '男', '43', '大数据', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (65, 1, '张44', '0', '女', '44', '大数据', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (66, 1, '张45', '0', '男', '45', '大数据', '3班', '大二春学期', NULL);
INSERT INTO `user` VALUES (67, 1, '张46', '0', '女', '46', '大数据', '4班', '大二春学期', NULL);
INSERT INTO `user` VALUES (68, 1, '张47', '0', '男', '47', '大数据', '5班', '大二春学期', NULL);
INSERT INTO `user` VALUES (69, 1, '张48', '0', '女', '48', '大数据', '6班', '大二春学期', NULL);
INSERT INTO `user` VALUES (70, 1, '张49', '0', '男', '49', '大数据', '7班', '大二春学期', NULL);
INSERT INTO `user` VALUES (71, 1, '张50', '0', '女', '50', '大数据', '8班', '大二春学期', NULL);
INSERT INTO `user` VALUES (72, 1, '张51', '0', '男', '51', '大数据', '9班', '大二春学期', NULL);
INSERT INTO `user` VALUES (73, 1, '张52', '0', '男', '52', '大数据', '1班', '大二春学期', NULL);
INSERT INTO `user` VALUES (74, 1, '张53', '0', '女', '53', '大数据', '2班', '大二春学期', NULL);
INSERT INTO `user` VALUES (75, 1, '张54', '0', '男', '54', '大数据', '3班', '大二春学期', NULL);
INSERT INTO `user` VALUES (76, 1, '张55', '0', '女', '55', '大数据', '4班', '大二春学期', NULL);
INSERT INTO `user` VALUES (77, 1, '张56', '0', '男', '56', '大数据', '5班', '大二春学期', NULL);
INSERT INTO `user` VALUES (78, 1, '张57', '0', '女', '57', '大数据', '6班', '大二春学期', NULL);
INSERT INTO `user` VALUES (79, 1, '张58', '0', '男', '58', '大数据', '7班', '大二春学期', NULL);
INSERT INTO `user` VALUES (80, 1, '张59', '0', '女', '59', '大数据', '8班', '大二春学期', NULL);
INSERT INTO `user` VALUES (81, 1, '张60', '0', '男', '60', '大数据', '9班', '大二春学期', NULL);
INSERT INTO `user` VALUES (82, 1, '张61', '0', '男', '61', '大数据', '10班', '大二春学期', NULL);
INSERT INTO `user` VALUES (83, 1, '张62', '0', '女', '62', '大数据', '11班', '大二春学期', NULL);
INSERT INTO `user` VALUES (84, 1, '张63', '0', '男', '63', '大数据', '12班', '大二春学期', NULL);
INSERT INTO `user` VALUES (85, 1, '张64', '0', '女', '64', '大数据', '13班', '大二春学期', NULL);
INSERT INTO `user` VALUES (86, 1, '张65', '0', '男', '65', '大数据', '14班', '大二春学期', NULL);
INSERT INTO `user` VALUES (87, 1, '张66', '0', '女', '66', '大数据', '15班', '大二春学期', NULL);
INSERT INTO `user` VALUES (88, 1, '张67', '0', '男', '67', '大数据', '16班', '大二春学期', NULL);
INSERT INTO `user` VALUES (89, 1, '张68', '0', '女', '68', '大数据', '17班', '大二春学期', NULL);
INSERT INTO `user` VALUES (90, 1, '张69', '0', '男', '69', '大数据', '18班', '大二春学期', NULL);
INSERT INTO `user` VALUES (91, 1, '张70', '0', '男', '70', '大数据', '10班', '大一春学期', NULL);
INSERT INTO `user` VALUES (92, 1, '张71', '0', '女', '71', '大数据', '11班', '大一春学期', NULL);
INSERT INTO `user` VALUES (93, 1, '张72', '0', '男', '72', '大数据', '12班', '大一春学期', NULL);
INSERT INTO `user` VALUES (94, 1, '张73', '0', '女', '73', '大数据', '13班', '大一春学期', NULL);
INSERT INTO `user` VALUES (95, 1, '张74', '0', '男', '74', '大数据', '14班', '大一春学期', NULL);
INSERT INTO `user` VALUES (96, 1, '张75', '0', '女', '75', '大数据', '15班', '大一春学期', NULL);
INSERT INTO `user` VALUES (97, 1, '张76', '0', '男', '76', '大数据', '16班', '大一春学期', NULL);
INSERT INTO `user` VALUES (98, 1, '张77', '0', '女', '77', '大数据', '17班', '大一春学期', NULL);
INSERT INTO `user` VALUES (99, 1, '张78', '0', '男', '78', '大数据', '18班', '大一春学期', NULL);

SET FOREIGN_KEY_CHECKS = 1;