/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50727
 Source Host           : localhost:3306
 Source Schema         : mooc

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

 Date: 14/05/2021 23:56:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `context` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `hour` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `video` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 574608072602038273 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (1, 'Python', 'Python', '1', '0', '一般', '20', 'pic/1.jpg', 'video/1.ogg');
INSERT INTO `course` VALUES (2, 'Python入门', 'Python入门', '0', '0', '还行', '10', 'pic/2.jpg', 'video/2.ogg');
INSERT INTO `course` VALUES (3, '1024设计', '1024设计', '1', '1', '还行', '5', 'pic/3.jpg', 'video/3.ogg');
INSERT INTO `course` VALUES (4, 'Python爬虫', 'Python爬虫技巧', '0', '1', '还行', '12', 'pic/4.jpg', 'video/4.ogg');
INSERT INTO `course` VALUES (5, 'java', 'java基础入门', '1', '0', '一般', '14', 'pic/5.jpg', 'video/5.ogg');
INSERT INTO `course` VALUES (6, 'Python爬虫2', 'Python爬虫2', '0', '0', '一般', '15', 'pic/6.jpg', 'video/6.ogg');
INSERT INTO `course` VALUES (7, '123', '123123', '1', '0', NULL, NULL, 'pic/7.jpg', 'video/7.ogg');
INSERT INTO `course` VALUES (8, '12123', '123123', '1', '0', NULL, NULL, 'pic/8.jpg', 'video/8.ogg');
INSERT INTO `course` VALUES (574325373412847616, 'test6', 'jianjie6', '1', '0', NULL, NULL, 'pic/574325373412847616.jpg', 'video/574325373412847616.ogg');
INSERT INTO `course` VALUES (574448718041067520, '帅哥', 'this is a good lesson', '0', '0', NULL, NULL, 'pic/574448718041067520.jpg', 'video/574448718041067520.ogg');
INSERT INTO `course` VALUES (574608072602038272, 'test12', 'jianjie12afadfad', '1', '0', '一般', NULL, 'pic/574608072602038272.jpg', 'video/574608072602038272.ogg');

-- ----------------------------
-- Table structure for ipset
-- ----------------------------
DROP TABLE IF EXISTS `ipset`;
CREATE TABLE `ipset`  (
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `firsttime` datetime(0) NULL DEFAULT NULL,
  `bantime` datetime(0) NULL DEFAULT NULL,
  `totime` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`ip`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ipset
-- ----------------------------
INSERT INTO `ipset` VALUES ('0:0:0:0:0:0:0:1', NULL, NULL, '2018-10-27 20:00:34', NULL, '2021-05-10 02:11:04');
INSERT INTO `ipset` VALUES ('127.0.0.1', '0', '恶意登陆管理员账号！', '2018-10-16 11:57:36', '2117-10-16 19:16:14', '2021-05-10 02:10:54');
INSERT INTO `ipset` VALUES ('172.162.1.125', '0', '多次测试未知账户！', '2018-10-16 18:34:05', '2018-10-16 18:39:14', '2018-10-16 18:34:05');
INSERT INTO `ipset` VALUES ('172.162.1.40', '0', '恶意登陆管理员账号！', '2018-10-16 14:11:35', '2117-10-16 19:00:29', '2018-10-16 19:05:29');
INSERT INTO `ipset` VALUES ('172.162.1.41', '0', '多次测试未知账户！', '2018-10-16 12:00:48', '2018-10-17 19:21:21', '2018-10-16 19:20:43');
INSERT INTO `ipset` VALUES ('172.162.1.42', '0', '多次测试未知账户！', '2018-10-16 14:09:01', '2018-10-17 18:57:18', '2018-10-17 19:22:21');
INSERT INTO `ipset` VALUES ('172.162.1.43', '0', '多次测试未知账户！', '2018-10-16 12:00:30', '2018-10-16 19:24:00', '2018-10-16 14:04:47');
INSERT INTO `ipset` VALUES ('172.162.1.44', '1', '多次测试未知账户！', '2018-10-16 15:09:06', '2018-10-16 19:26:04', '2018-10-16 19:19:24');
INSERT INTO `ipset` VALUES ('172.162.1.87', '1', '多次测试未知账户！', '2018-10-16 19:08:26', '2018-10-16 19:25:58', '2018-10-16 19:09:36');

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `userid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` datetime(0) NULL DEFAULT NULL,
  `executor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 298 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES (1, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2018-10-15 15:13:46', NULL);
INSERT INTO `log` VALUES (2, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2018-10-15 15:15:57', 'admin');
INSERT INTO `log` VALUES (3, '20151612204', 'admin', '充值500元', '0:0:0:0:0:0:0:1', '2018-10-15 15:16:53', 'admin');
INSERT INTO `log` VALUES (4, '201808231058301205', '1823544517', '充值10000元', '0:0:0:0:0:0:0:1', '2018-10-15 15:18:02', 'admin');
INSERT INTO `log` VALUES (5, '201808231058301205', '1823544517', '屏蔽用户登录', '0:0:0:0:0:0:0:1', '2018-10-15 15:18:12', 'admin');
INSERT INTO `log` VALUES (6, '201808231058301205', '1823544517', '恢复用户登录', '0:0:0:0:0:0:0:1', '2018-10-15 15:19:10', 'admin');
INSERT INTO `log` VALUES (7, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-15 15:19:15', NULL);
INSERT INTO `log` VALUES (8, '201808231058301205', '1823544517', '订阅课程:1024设计', '127.0.0.1', '2018-10-15 15:19:20', NULL);
INSERT INTO `log` VALUES (9, '201808231058301205', '1823544517', '购买会员：一年', '127.0.0.1', '2018-10-15 15:31:58', NULL);
INSERT INTO `log` VALUES (10, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-15 16:12:09', NULL);
INSERT INTO `log` VALUES (11, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2018-10-15 21:45:02', 'admin');
INSERT INTO `log` VALUES (12, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-15 21:49:02', NULL);
INSERT INTO `log` VALUES (13, NULL, NULL, '下架课程：Python', '0:0:0:0:0:0:0:1', '2018-10-15 21:49:27', 'admin');
INSERT INTO `log` VALUES (14, NULL, NULL, '上架课程：Python', '0:0:0:0:0:0:0:1', '2018-10-15 21:49:37', 'admin');
INSERT INTO `log` VALUES (15, NULL, NULL, '下架课程：Python', '0:0:0:0:0:0:0:1', '2018-10-15 21:49:44', 'admin');
INSERT INTO `log` VALUES (16, NULL, NULL, '尝试登录账号:asdawdasdwqweqwrqwe，密码错误', '127.0.0.1', '2018-10-16 10:08:03', NULL);
INSERT INTO `log` VALUES (17, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 10:08:48', 'admin');
INSERT INTO `log` VALUES (18, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-16 10:10:17', NULL);
INSERT INTO `log` VALUES (19, '201810161045371069', 'abc', '普通注册', '172.162.1.44', '2018-10-16 10:37:45', NULL);
INSERT INTO `log` VALUES (20, '201810161045371069', 'abc', '登录', '172.162.1.44', '2018-10-16 10:38:12', NULL);
INSERT INTO `log` VALUES (21, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:38:27', NULL);
INSERT INTO `log` VALUES (22, '201810161045371069', 'abc', '订阅课程:1024设计', '172.162.1.44', '2018-10-16 10:39:07', NULL);
INSERT INTO `log` VALUES (23, '201810161045371069', 'abc', '个人信息更改', '172.162.1.44', '2018-10-16 10:40:49', NULL);
INSERT INTO `log` VALUES (24, '201810161045371069', 'abc', '个人信息更改', '172.162.1.44', '2018-10-16 10:40:57', NULL);
INSERT INTO `log` VALUES (25, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-16 10:41:17', NULL);
INSERT INTO `log` VALUES (26, '201810161045371069', 'abc', '取消课程：1024设计', '172.162.1.44', '2018-10-16 10:41:32', NULL);
INSERT INTO `log` VALUES (27, '201810161045371069', 'abc', '个人信息更改', '172.162.1.44', '2018-10-16 10:43:15', NULL);
INSERT INTO `log` VALUES (28, '201810161045371069', 'abc', '充值10000元', '127.0.0.1', '2018-10-16 10:44:50', 'admin');
INSERT INTO `log` VALUES (29, '201810161045371069', 'abc', '购买会员：一年', '172.162.1.44', '2018-10-16 10:45:04', NULL);
INSERT INTO `log` VALUES (30, '201810161045371069', 'abc', '购买会员：半年', '172.162.1.44', '2018-10-16 10:45:07', NULL);
INSERT INTO `log` VALUES (31, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:45:11', NULL);
INSERT INTO `log` VALUES (32, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:45:13', NULL);
INSERT INTO `log` VALUES (33, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:45:15', NULL);
INSERT INTO `log` VALUES (34, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:45:16', NULL);
INSERT INTO `log` VALUES (35, '201810161045371069', 'abc', '购买会员：半年', '172.162.1.44', '2018-10-16 10:46:02', NULL);
INSERT INTO `log` VALUES (36, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:46:05', NULL);
INSERT INTO `log` VALUES (37, '201810161045371069', 'abc', '购买会员：一个月', '172.162.1.44', '2018-10-16 10:46:07', NULL);
INSERT INTO `log` VALUES (38, '201810161045371069', 'abc', '注销', '172.162.1.44', '2018-10-16 10:46:24', NULL);
INSERT INTO `log` VALUES (39, NULL, NULL, '尝试登录账号:admin，密码错误', '172.162.1.44', '2018-10-16 10:46:52', NULL);
INSERT INTO `log` VALUES (40, '20151612204', 'admin', '注销', '127.0.0.1', '2018-10-16 10:47:40', 'admin');
INSERT INTO `log` VALUES (41, NULL, NULL, '尝试登录账号:admin，密码错误', '127.0.0.1', '2018-10-16 10:47:50', NULL);
INSERT INTO `log` VALUES (42, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 10:48:09', 'admin');
INSERT INTO `log` VALUES (43, '201808231058301205', '1823544517', '登录', '172.162.1.42', '2018-10-16 14:09:19', NULL);
INSERT INTO `log` VALUES (44, '201808231058301205', '1823544517', '订阅课程:Python爬虫', '172.162.1.42', '2018-10-16 14:09:32', NULL);
INSERT INTO `log` VALUES (45, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 14:34:55', 'admin');
INSERT INTO `log` VALUES (46, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 14:47:31', 'admin');
INSERT INTO `log` VALUES (47, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 15:02:14', 'admin');
INSERT INTO `log` VALUES (48, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 15:06:45', 'admin');
INSERT INTO `log` VALUES (49, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 15:07:24', 'admin');
INSERT INTO `log` VALUES (50, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-16 15:22:23', NULL);
INSERT INTO `log` VALUES (51, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 15:27:01', 'admin');
INSERT INTO `log` VALUES (52, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-16 15:27:30', NULL);
INSERT INTO `log` VALUES (53, '201808231058301205', '1823544517', '发表评论，在\'null\'', '127.0.0.1', '2018-10-16 15:27:45', NULL);
INSERT INTO `log` VALUES (54, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 15:29:20', 'admin');
INSERT INTO `log` VALUES (55, '201808231058301205', '1823544517', '登录', '127.0.0.1', '2018-10-16 15:30:13', NULL);
INSERT INTO `log` VALUES (56, '201808231058301205', '1823544517', '发表评论，在\'Python爬虫\'', '127.0.0.1', '2018-10-16 15:30:22', NULL);
INSERT INTO `log` VALUES (57, '201810161045371069', 'abc', '登录', '172.162.1.44', '2018-10-16 15:34:59', NULL);
INSERT INTO `log` VALUES (58, '201810161045371069', 'abc', '订阅课程:1024设计', '172.162.1.44', '2018-10-16 15:35:05', NULL);
INSERT INTO `log` VALUES (59, '201810161045371069', 'abc', '发表评论，在\'1024设计\'', '172.162.1.44', '2018-10-16 15:35:30', NULL);
INSERT INTO `log` VALUES (60, '201810161045371069', 'abc', '取消课程：1024设计', '172.162.1.44', '2018-10-16 15:36:28', NULL);
INSERT INTO `log` VALUES (61, '201810161045371069', 'abc', '屏蔽用户登录', '127.0.0.1', '2018-10-16 15:36:47', 'admin');
INSERT INTO `log` VALUES (62, '201810161045371069', 'abc', '订阅课程:Python入门', '172.162.1.44', '2018-10-16 15:37:03', NULL);
INSERT INTO `log` VALUES (63, '201810161045371069', 'abc', '注销', '172.162.1.44', '2018-10-16 15:37:11', NULL);
INSERT INTO `log` VALUES (64, '201810161045371069', 'abc', '恢复用户登录', '127.0.0.1', '2018-10-16 15:37:22', 'admin');
INSERT INTO `log` VALUES (65, '201810161045371069', 'abc', '登录', '172.162.1.44', '2018-10-16 15:37:27', NULL);
INSERT INTO `log` VALUES (66, '201808231058301205', '1823544517', '注销', '127.0.0.1', '2018-10-16 15:42:47', NULL);
INSERT INTO `log` VALUES (67, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:11:30', 'admin');
INSERT INTO `log` VALUES (68, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:12:28', 'admin');
INSERT INTO `log` VALUES (69, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:27:45', 'admin');
INSERT INTO `log` VALUES (70, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:28:48', 'admin');
INSERT INTO `log` VALUES (71, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:29:32', 'admin');
INSERT INTO `log` VALUES (72, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:31:06', 'admin');
INSERT INTO `log` VALUES (73, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:40:19', 'admin');
INSERT INTO `log` VALUES (74, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:44:57', 'admin');
INSERT INTO `log` VALUES (75, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:47:35', 'admin');
INSERT INTO `log` VALUES (76, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 17:48:23', 'admin');
INSERT INTO `log` VALUES (77, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 18:18:24', 'admin');
INSERT INTO `log` VALUES (78, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 18:21:29', 'admin');
INSERT INTO `log` VALUES (79, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 18:27:53', 'admin');
INSERT INTO `log` VALUES (80, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 18:53:35', 'admin');
INSERT INTO `log` VALUES (81, NULL, NULL, '尝试登录账号:96321，密码错误', '172.162.1.40', '2018-10-16 19:01:02', NULL);
INSERT INTO `log` VALUES (82, NULL, NULL, '尝试登录账号:96321，密码错误', '172.162.1.40', '2018-10-16 19:01:24', NULL);
INSERT INTO `log` VALUES (83, '201810161901381601', '96321', '普通注册', '172.162.1.40', '2018-10-16 19:01:38', NULL);
INSERT INTO `log` VALUES (84, '201810161901381601', '96321', '屏蔽用户登录', '127.0.0.1', '2018-10-16 19:01:50', 'admin');
INSERT INTO `log` VALUES (85, '201810161901381601', '96321', '恢复用户登录', '127.0.0.1', '2018-10-16 19:01:55', 'admin');
INSERT INTO `log` VALUES (86, '201810161901381601', '96321', '登录', '172.162.1.40', '2018-10-16 19:02:03', NULL);
INSERT INTO `log` VALUES (87, '201810161901381601', '96321', '个人信息更改', '172.162.1.40', '2018-10-16 19:02:33', NULL);
INSERT INTO `log` VALUES (88, '201810161901381601', '96321', '订阅课程:Python入门', '172.162.1.40', '2018-10-16 19:02:41', NULL);
INSERT INTO `log` VALUES (89, '201810161901381601', '96321', '发表评论，在\'Python入门\'', '172.162.1.40', '2018-10-16 19:02:56', NULL);
INSERT INTO `log` VALUES (90, '201810161901381601', '96321', '取消课程：Python入门', '172.162.1.40', '2018-10-16 19:03:08', NULL);
INSERT INTO `log` VALUES (91, '201810161901381601', '96321', '购买会员：一个月', '172.162.1.40', '2018-10-16 19:03:40', NULL);
INSERT INTO `log` VALUES (92, '201810161901381601', '96321', '订阅课程:Python爬虫2', '172.162.1.40', '2018-10-16 19:03:46', NULL);
INSERT INTO `log` VALUES (93, '201810161901381601', '96321', '发表评论，在\'Python爬虫2\'', '172.162.1.40', '2018-10-16 19:03:55', NULL);
INSERT INTO `log` VALUES (94, '201810161901381601', '96321', '个人信息更改', '172.162.1.40', '2018-10-16 19:04:36', NULL);
INSERT INTO `log` VALUES (95, '201810161901381601', '96321', '注销', '172.162.1.40', '2018-10-16 19:05:29', NULL);
INSERT INTO `log` VALUES (96, '20151612204', 'admin', '登录', '172.162.1.44', '2018-10-16 19:15:49', 'admin');
INSERT INTO `log` VALUES (97, '20151612204', 'admin', '登录', '172.162.1.44', '2018-10-16 19:18:37', 'admin');
INSERT INTO `log` VALUES (98, '20151612204', 'admin', '登录', '172.162.1.44', '2018-10-16 19:19:04', 'admin');
INSERT INTO `log` VALUES (99, '20151612204', 'admin', '登录', '172.162.1.41', '2018-10-16 19:20:27', 'admin');
INSERT INTO `log` VALUES (100, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-16 19:20:55', 'admin');
INSERT INTO `log` VALUES (101, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-17 15:50:41', NULL);
INSERT INTO `log` VALUES (102, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-17 15:51:46', 'admin');
INSERT INTO `log` VALUES (103, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-17 15:52:31', NULL);
INSERT INTO `log` VALUES (104, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-17 18:55:21', 'admin');
INSERT INTO `log` VALUES (105, NULL, NULL, '尝试登录账号:admin，密码错误', '0:0:0:0:0:0:0:1', '2018-10-27 20:01:49', NULL);
INSERT INTO `log` VALUES (106, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2018-10-27 20:01:57', 'admin');
INSERT INTO `log` VALUES (107, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 10:30:06', 'admin');
INSERT INTO `log` VALUES (108, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 10:46:37', 'admin');
INSERT INTO `log` VALUES (109, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 14:30:47', 'admin');
INSERT INTO `log` VALUES (110, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 14:35:21', 'admin');
INSERT INTO `log` VALUES (111, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 14:48:57', 'admin');
INSERT INTO `log` VALUES (112, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 14:51:52', 'admin');
INSERT INTO `log` VALUES (113, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 14:52:54', 'admin');
INSERT INTO `log` VALUES (114, NULL, NULL, '删除课程：张三', '127.0.0.1', '2018-10-29 14:53:07', 'admin');
INSERT INTO `log` VALUES (115, NULL, NULL, '删除课程：张三', '127.0.0.1', '2018-10-29 14:53:16', 'admin');
INSERT INTO `log` VALUES (116, NULL, NULL, '删除课程：张三', '127.0.0.1', '2018-10-29 14:53:22', 'admin');
INSERT INTO `log` VALUES (117, NULL, NULL, '删除课程：张三', '127.0.0.1', '2018-10-29 14:53:29', 'admin');
INSERT INTO `log` VALUES (118, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 15:22:11', 'admin');
INSERT INTO `log` VALUES (119, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 15:23:42', 'admin');
INSERT INTO `log` VALUES (120, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 15:24:57', 'admin');
INSERT INTO `log` VALUES (121, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 15:51:24', 'admin');
INSERT INTO `log` VALUES (122, '20151612204', 'admin', '登录', '127.0.0.1', '2018-10-29 15:53:23', 'admin');
INSERT INTO `log` VALUES (123, NULL, NULL, '上架课程：123123', '127.0.0.1', '2018-10-29 15:54:04', 'admin');
INSERT INTO `log` VALUES (124, NULL, NULL, '下架课程：123123', '127.0.0.1', '2018-10-29 15:54:17', 'admin');
INSERT INTO `log` VALUES (125, NULL, NULL, '删除课程：123123', '127.0.0.1', '2018-10-29 15:54:34', 'admin');
INSERT INTO `log` VALUES (126, '20151612204', 'admin', '发表评论，在\'Python入门\'', '127.0.0.1', '2018-10-29 16:09:50', NULL);
INSERT INTO `log` VALUES (127, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2020-11-29 18:00:48', NULL);
INSERT INTO `log` VALUES (128, '20151612204', 'admin', '订阅课程:1024设计', '0:0:0:0:0:0:0:1', '2020-11-29 18:00:52', NULL);
INSERT INTO `log` VALUES (129, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2020-12-08 17:59:04', NULL);
INSERT INTO `log` VALUES (130, NULL, NULL, '尝试登录账号:system，密码错误', '0:0:0:0:0:0:0:1', '2020-12-08 18:04:09', NULL);
INSERT INTO `log` VALUES (131, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2020-12-08 18:04:24', 'admin');
INSERT INTO `log` VALUES (132, '201808231058301205', '1823544517', '登录', '0:0:0:0:0:0:0:1', '2021-01-31 23:13:28', NULL);
INSERT INTO `log` VALUES (133, '201808231058301205', '1823544517', '订阅课程:Python入门', '0:0:0:0:0:0:0:1', '2021-01-31 23:13:37', NULL);
INSERT INTO `log` VALUES (134, '201808231058301205', '1823544517', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-01-31 23:23:05', NULL);
INSERT INTO `log` VALUES (135, '202103111152161222', 'Andrew', '普通注册', '0:0:0:0:0:0:0:1', '2021-03-11 11:52:16', NULL);
INSERT INTO `log` VALUES (136, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-11 11:52:35', NULL);
INSERT INTO `log` VALUES (137, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 15:42:42', NULL);
INSERT INTO `log` VALUES (138, '202103111152161222', 'Andrew', '订阅课程:Python爬虫', '0:0:0:0:0:0:0:1', '2021-03-12 15:43:58', NULL);
INSERT INTO `log` VALUES (139, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 17:26:09', NULL);
INSERT INTO `log` VALUES (140, '202103111152161222', 'Andrew', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-03-12 17:33:00', NULL);
INSERT INTO `log` VALUES (141, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 17:39:05', NULL);
INSERT INTO `log` VALUES (142, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 17:45:46', NULL);
INSERT INTO `log` VALUES (143, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 17:49:40', NULL);
INSERT INTO `log` VALUES (144, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 17:54:25', NULL);
INSERT INTO `log` VALUES (145, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 17:59:23', NULL);
INSERT INTO `log` VALUES (146, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 17:59:52', NULL);
INSERT INTO `log` VALUES (147, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 17:59:52', NULL);
INSERT INTO `log` VALUES (148, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 17:59:52', NULL);
INSERT INTO `log` VALUES (149, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:00:12', NULL);
INSERT INTO `log` VALUES (150, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:00:24', NULL);
INSERT INTO `log` VALUES (151, '202103111152161222', 'Andrew', '注销', '0:0:0:0:0:0:0:1', '2021-03-12 18:01:00', NULL);
INSERT INTO `log` VALUES (152, NULL, NULL, '尝试登录账号:Andrew，密码错误', '0:0:0:0:0:0:0:1', '2021-03-12 18:01:08', NULL);
INSERT INTO `log` VALUES (153, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 18:01:16', NULL);
INSERT INTO `log` VALUES (154, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:01:33', NULL);
INSERT INTO `log` VALUES (155, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:06:53', NULL);
INSERT INTO `log` VALUES (156, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:07:06', NULL);
INSERT INTO `log` VALUES (157, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:13:56', NULL);
INSERT INTO `log` VALUES (158, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:14:53', NULL);
INSERT INTO `log` VALUES (159, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:15:26', NULL);
INSERT INTO `log` VALUES (160, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:16:08', NULL);
INSERT INTO `log` VALUES (161, '202103111152161222', 'Andrew', '个人信息更改', '0:0:0:0:0:0:0:1', '2021-03-12 18:18:01', NULL);
INSERT INTO `log` VALUES (162, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-12 18:18:50', NULL);
INSERT INTO `log` VALUES (163, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-25 00:36:06', NULL);
INSERT INTO `log` VALUES (164, NULL, NULL, '尝试登录账号:admin，密码错误', '0:0:0:0:0:0:0:1', '2021-03-25 00:36:36', NULL);
INSERT INTO `log` VALUES (165, NULL, NULL, '尝试登录账号:admin，密码错误', '0:0:0:0:0:0:0:1', '2021-03-25 00:36:45', NULL);
INSERT INTO `log` VALUES (166, NULL, NULL, '尝试登录账号:admin，密码错误', '0:0:0:0:0:0:0:1', '2021-03-25 00:37:01', NULL);
INSERT INTO `log` VALUES (167, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-25 00:38:08', 'admin');
INSERT INTO `log` VALUES (168, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-25 01:08:38', NULL);
INSERT INTO `log` VALUES (169, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-03-26 21:06:48', NULL);
INSERT INTO `log` VALUES (170, '202103111152161222', 'Andrew', '订阅课程:1024设计', '0:0:0:0:0:0:0:1', '2021-03-26 21:06:58', NULL);
INSERT INTO `log` VALUES (171, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-26 21:08:41', 'admin');
INSERT INTO `log` VALUES (172, NULL, NULL, '上架课程：123', '0:0:0:0:0:0:0:1', '2021-03-26 21:14:53', 'admin');
INSERT INTO `log` VALUES (173, NULL, NULL, '上架课程：Python', '0:0:0:0:0:0:0:1', '2021-03-26 21:14:54', 'admin');
INSERT INTO `log` VALUES (174, NULL, NULL, '上架课程：12123', '0:0:0:0:0:0:0:1', '2021-03-26 21:14:55', 'admin');
INSERT INTO `log` VALUES (175, NULL, NULL, '下架课程：12123', '0:0:0:0:0:0:0:1', '2021-03-26 21:14:55', 'admin');
INSERT INTO `log` VALUES (176, NULL, NULL, '上架课程：12123', '0:0:0:0:0:0:0:1', '2021-03-26 21:14:56', 'admin');
INSERT INTO `log` VALUES (177, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-29 00:52:42', 'admin');
INSERT INTO `log` VALUES (178, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-29 16:23:03', 'admin');
INSERT INTO `log` VALUES (179, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-29 16:26:37', NULL);
INSERT INTO `log` VALUES (180, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-29 16:27:00', 'admin');
INSERT INTO `log` VALUES (181, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 00:46:07', 'admin');
INSERT INTO `log` VALUES (182, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 00:54:51', NULL);
INSERT INTO `log` VALUES (183, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 00:55:04', 'admin');
INSERT INTO `log` VALUES (184, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 01:03:23', 'admin');
INSERT INTO `log` VALUES (185, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 01:05:16', 'admin');
INSERT INTO `log` VALUES (186, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 16:50:21', 'admin');
INSERT INTO `log` VALUES (187, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 16:54:26', 'admin');
INSERT INTO `log` VALUES (188, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 16:58:51', 'admin');
INSERT INTO `log` VALUES (189, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 17:11:23', NULL);
INSERT INTO `log` VALUES (190, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-30 17:44:19', NULL);
INSERT INTO `log` VALUES (191, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 01:29:38', NULL);
INSERT INTO `log` VALUES (192, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 01:30:19', 'admin');
INSERT INTO `log` VALUES (193, NULL, NULL, '上架课程：test6', '0:0:0:0:0:0:0:1', '2021-03-31 01:30:26', 'admin');
INSERT INTO `log` VALUES (194, NULL, NULL, '上架课程：test11', '0:0:0:0:0:0:0:1', '2021-03-31 01:30:30', 'admin');
INSERT INTO `log` VALUES (195, '20151612204', 'admin', '订阅课程:test6', '0:0:0:0:0:0:0:1', '2021-03-31 01:30:36', NULL);
INSERT INTO `log` VALUES (196, NULL, NULL, '上架课程：test11', '0:0:0:0:0:0:0:1', '2021-03-31 01:35:25', 'admin');
INSERT INTO `log` VALUES (197, NULL, NULL, '上架课程：帅哥', '0:0:0:0:0:0:0:1', '2021-03-31 01:36:23', 'admin');
INSERT INTO `log` VALUES (198, '20151612204', 'admin', '订阅课程:帅哥', '0:0:0:0:0:0:0:1', '2021-03-31 01:36:29', NULL);
INSERT INTO `log` VALUES (199, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 01:54:23', 'admin');
INSERT INTO `log` VALUES (200, '201809061055001264', 'aaa', '删除用户', '0:0:0:0:0:0:0:1', '2021-03-31 02:10:25', 'admin');
INSERT INTO `log` VALUES (201, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 10:41:31', 'admin');
INSERT INTO `log` VALUES (202, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 10:56:13', NULL);
INSERT INTO `log` VALUES (203, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 10:56:23', 'admin');
INSERT INTO `log` VALUES (204, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:04:49', NULL);
INSERT INTO `log` VALUES (205, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:05:10', 'admin');
INSERT INTO `log` VALUES (206, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:06:11', 'admin');
INSERT INTO `log` VALUES (207, NULL, NULL, '上架课程：test12', '0:0:0:0:0:0:0:1', '2021-03-31 12:08:53', 'admin');
INSERT INTO `log` VALUES (208, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:27:47', 'admin');
INSERT INTO `log` VALUES (209, '20151612204', 'admin', '注销', '0:0:0:0:0:0:0:1', '2021-03-31 12:30:00', 'admin');
INSERT INTO `log` VALUES (210, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:30:10', NULL);
INSERT INTO `log` VALUES (211, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 12:38:52', NULL);
INSERT INTO `log` VALUES (212, '20151612204', 'admin', '购买会员：半年', '0:0:0:0:0:0:0:1', '2021-03-31 13:07:50', NULL);
INSERT INTO `log` VALUES (213, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 13:35:53', 'admin');
INSERT INTO `log` VALUES (214, NULL, NULL, '上架课程：test12', '0:0:0:0:0:0:0:1', '2021-03-31 13:36:09', 'admin');
INSERT INTO `log` VALUES (215, '20151612204', 'admin', '订阅课程:test12', '0:0:0:0:0:0:0:1', '2021-03-31 13:36:14', NULL);
INSERT INTO `log` VALUES (216, '20151612204', 'admin', '发表评论，在\'test12\'', '0:0:0:0:0:0:0:1', '2021-03-31 13:36:22', NULL);
INSERT INTO `log` VALUES (217, '20151612204', 'admin', '发表评论，在\'test12\'', '0:0:0:0:0:0:0:1', '2021-03-31 13:36:34', NULL);
INSERT INTO `log` VALUES (218, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-03-31 14:39:23', NULL);
INSERT INTO `log` VALUES (219, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-02 22:03:56', NULL);
INSERT INTO `log` VALUES (220, '20151612204', 'admin', '订阅课程:邓紫棋', '0:0:0:0:0:0:0:1', '2021-04-02 22:10:09', NULL);
INSERT INTO `log` VALUES (221, '20151612204', 'admin', '取消课程：Python', '0:0:0:0:0:0:0:1', '2021-04-02 22:38:55', NULL);
INSERT INTO `log` VALUES (222, '20151612204', 'admin', '订阅课程:Python', '0:0:0:0:0:0:0:1', '2021-04-02 22:39:00', NULL);
INSERT INTO `log` VALUES (223, '20151612204', 'admin', '取消课程：邓紫棋', '0:0:0:0:0:0:0:1', '2021-04-02 22:56:18', NULL);
INSERT INTO `log` VALUES (224, '20151612204', 'admin', '订阅课程:邓紫棋', '0:0:0:0:0:0:0:1', '2021-04-02 22:56:24', NULL);
INSERT INTO `log` VALUES (225, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 00:49:58', NULL);
INSERT INTO `log` VALUES (226, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 00:58:55', NULL);
INSERT INTO `log` VALUES (227, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 13:52:15', NULL);
INSERT INTO `log` VALUES (228, '20151612204', 'admin', '发表评论，在\'邓紫棋\'', '0:0:0:0:0:0:0:1', '2021-04-03 13:52:29', NULL);
INSERT INTO `log` VALUES (229, '20151612204', 'admin', '发表评论，在\'邓紫棋\'', '0:0:0:0:0:0:0:1', '2021-04-03 13:53:57', NULL);
INSERT INTO `log` VALUES (230, '20151612204', 'admin', '发表评论，在\'邓紫棋\'', '0:0:0:0:0:0:0:1', '2021-04-03 13:54:23', NULL);
INSERT INTO `log` VALUES (231, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 13:56:19', 'admin');
INSERT INTO `log` VALUES (232, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 14:32:07', NULL);
INSERT INTO `log` VALUES (233, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 17:49:46', NULL);
INSERT INTO `log` VALUES (234, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 17:50:59', 'admin');
INSERT INTO `log` VALUES (235, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 17:52:14', NULL);
INSERT INTO `log` VALUES (236, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 17:52:26', 'admin');
INSERT INTO `log` VALUES (237, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 18:55:30', NULL);
INSERT INTO `log` VALUES (238, '20151612204', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-03 22:11:19', NULL);
INSERT INTO `log` VALUES (239, NULL, NULL, '上架课程：IU', '0:0:0:0:0:0:0:1', '2021-04-03 22:54:01', 'admin');
INSERT INTO `log` VALUES (240, '20151612204', 'admin', '订阅课程:IU', '0:0:0:0:0:0:0:1', '2021-04-03 22:54:07', NULL);
INSERT INTO `log` VALUES (241, 's', 'admin', '登录', '127.0.0.1', '2021-04-04 23:13:49', 'admin');
INSERT INTO `log` VALUES (242, 's', 'admin', '登录', '127.0.0.1', '2021-04-08 23:59:27', 'admin');
INSERT INTO `log` VALUES (243, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-09 22:24:28', NULL);
INSERT INTO `log` VALUES (244, 's', 'admin', '订阅课程:Python', '0:0:0:0:0:0:0:1', '2021-04-09 22:35:54', NULL);
INSERT INTO `log` VALUES (245, 's', 'admin', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:27', NULL);
INSERT INTO `log` VALUES (246, 's', 'admin', '购买会员：半年', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:30', NULL);
INSERT INTO `log` VALUES (247, 's', 'admin', '购买会员：一年', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:32', NULL);
INSERT INTO `log` VALUES (248, 's', 'admin', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:42', NULL);
INSERT INTO `log` VALUES (249, 's', 'admin', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:42', NULL);
INSERT INTO `log` VALUES (250, 's', 'admin', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-04-09 22:40:47', NULL);
INSERT INTO `log` VALUES (251, 's', 'admin', '订阅课程:IU', '0:0:0:0:0:0:0:1', '2021-04-09 22:41:15', NULL);
INSERT INTO `log` VALUES (252, 's', 'admin', '订阅课程:Python入门', '0:0:0:0:0:0:0:1', '2021-04-09 22:43:47', NULL);
INSERT INTO `log` VALUES (253, 's', 'admin', '取消课程：IU', '0:0:0:0:0:0:0:1', '2021-04-09 22:45:23', NULL);
INSERT INTO `log` VALUES (254, 's', 'admin', '订阅课程:邓紫棋', '0:0:0:0:0:0:0:1', '2021-04-09 22:57:44', NULL);
INSERT INTO `log` VALUES (255, 's', 'admin', '订阅课程:1024设计', '0:0:0:0:0:0:0:1', '2021-04-09 23:07:53', NULL);
INSERT INTO `log` VALUES (256, 's', 'admin', '订阅课程:IU', '0:0:0:0:0:0:0:1', '2021-04-09 23:14:41', NULL);
INSERT INTO `log` VALUES (257, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-10 00:09:40', NULL);
INSERT INTO `log` VALUES (258, 's', 'admin', '购买会员：一个月', '0:0:0:0:0:0:0:1', '2021-04-10 00:13:21', NULL);
INSERT INTO `log` VALUES (259, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-10 00:33:43', 'admin');
INSERT INTO `log` VALUES (260, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-10 01:22:23', NULL);
INSERT INTO `log` VALUES (261, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-11 00:45:26', 'admin');
INSERT INTO `log` VALUES (262, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-11 16:43:03', 'admin');
INSERT INTO `log` VALUES (263, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-04-11 16:45:16', NULL);
INSERT INTO `log` VALUES (264, '202103111152161222', 'Andrew', '订阅课程:Python', '0:0:0:0:0:0:0:1', '2021-04-11 16:53:01', NULL);
INSERT INTO `log` VALUES (265, '202103111152161222', 'Andrew', '注销', '0:0:0:0:0:0:0:1', '2021-04-11 17:11:43', NULL);
INSERT INTO `log` VALUES (266, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-11 17:12:05', 'admin');
INSERT INTO `log` VALUES (267, NULL, NULL, '尝试登录账号:adminssss，密码错误', '0:0:0:0:0:0:0:1', '2021-04-12 15:33:18', NULL);
INSERT INTO `log` VALUES (268, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-04-12 16:30:11', NULL);
INSERT INTO `log` VALUES (269, '202103111152161222', 'Andrew', '登录', '0:0:0:0:0:0:0:1', '2021-04-12 20:12:07', NULL);
INSERT INTO `log` VALUES (270, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-12 20:13:35', 'admin');
INSERT INTO `log` VALUES (271, NULL, NULL, '下架课程：1024设计', '0:0:0:0:0:0:0:1', '2021-04-12 20:30:33', 'admin');
INSERT INTO `log` VALUES (272, NULL, NULL, '下架课程：Python爬虫', '0:0:0:0:0:0:0:1', '2021-04-12 20:30:37', 'admin');
INSERT INTO `log` VALUES (273, 's', 'admin', '取消课程：Python入门', '0:0:0:0:0:0:0:1', '2021-04-12 20:34:42', NULL);
INSERT INTO `log` VALUES (274, 's', 'admin', '订阅课程:Python入门', '0:0:0:0:0:0:0:1', '2021-04-12 20:34:43', NULL);
INSERT INTO `log` VALUES (275, 's', 'admin', '取消课程：Python入门', '0:0:0:0:0:0:0:1', '2021-04-12 20:35:31', NULL);
INSERT INTO `log` VALUES (276, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-12 22:40:09', NULL);
INSERT INTO `log` VALUES (277, 's', 'admin', '订阅课程:Python入门', '0:0:0:0:0:0:0:1', '2021-04-12 23:02:13', NULL);
INSERT INTO `log` VALUES (278, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-16 19:00:16', NULL);
INSERT INTO `log` VALUES (279, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-16 19:41:14', NULL);
INSERT INTO `log` VALUES (280, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-04-16 19:57:07', NULL);
INSERT INTO `log` VALUES (281, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-09 23:08:11', 'admin');
INSERT INTO `log` VALUES (282, NULL, NULL, '上架课程：内容出圈新玩法', '0:0:0:0:0:0:0:1', '2021-05-09 23:08:45', 'admin');
INSERT INTO `log` VALUES (283, 's', 'admin', '订阅课程:内容出圈新玩法', '0:0:0:0:0:0:0:1', '2021-05-09 23:09:08', NULL);
INSERT INTO `log` VALUES (284, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 00:16:34', 'admin');
INSERT INTO `log` VALUES (285, NULL, NULL, '删除课程：test11', '0:0:0:0:0:0:0:1', '2021-05-10 00:27:49', 'admin');
INSERT INTO `log` VALUES (286, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 00:37:27', NULL);
INSERT INTO `log` VALUES (287, NULL, NULL, '删除播客：张二', '0:0:0:0:0:0:0:1', '2021-05-10 00:37:43', 'admin');
INSERT INTO `log` VALUES (288, 's', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 01:25:27', NULL);
INSERT INTO `log` VALUES (289, 's', 'admin', '取消课程：Python', '0:0:0:0:0:0:0:1', '2021-05-10 01:26:30', NULL);
INSERT INTO `log` VALUES (290, 's', 'admin', '订阅课程:IU', '0:0:0:0:0:0:0:1', '2021-05-10 01:30:30', NULL);
INSERT INTO `log` VALUES (291, '201710214225', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 01:31:54', NULL);
INSERT INTO `log` VALUES (292, '201710214225', 'admin', '订阅课程:邓紫棋', '0:0:0:0:0:0:0:1', '2021-05-10 01:33:26', NULL);
INSERT INTO `log` VALUES (293, '201710214225', 'admin', '订阅课程:内容出圈新玩法', '0:0:0:0:0:0:0:1', '2021-05-10 01:33:31', NULL);
INSERT INTO `log` VALUES (294, '201710214225', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 01:47:36', NULL);
INSERT INTO `log` VALUES (295, '201710214225', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 01:49:15', NULL);
INSERT INTO `log` VALUES (296, '201710214225', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 01:55:38', NULL);
INSERT INTO `log` VALUES (297, '201710214225', 'admin', '登录', '0:0:0:0:0:0:0:1', '2021-05-10 02:11:00', NULL);

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message`  (
  `courseid` bigint(20) NOT NULL DEFAULT 0,
  `userid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES (3, '201808240857431128');
INSERT INTO `message` VALUES (6, '201808231058301205');
INSERT INTO `message` VALUES (4, '20151612204');
INSERT INTO `message` VALUES (5, '20151612204');
INSERT INTO `message` VALUES (2, '201809030750151429');
INSERT INTO `message` VALUES (2, '20151612204');
INSERT INTO `message` VALUES (2, '201809061049051592');
INSERT INTO `message` VALUES (2, '201808240857431128');
INSERT INTO `message` VALUES (6, '201808240857431128');
INSERT INTO `message` VALUES (4, '201809030750151429');
INSERT INTO `message` VALUES (5, '201808240857431128');
INSERT INTO `message` VALUES (1, '201809061049051592');
INSERT INTO `message` VALUES (3, '201808231058301205');
INSERT INTO `message` VALUES (4, '201808231058301205');
INSERT INTO `message` VALUES (2, '201810161045371069');
INSERT INTO `message` VALUES (6, '201810161901381601');
INSERT INTO `message` VALUES (3, '20151612204');
INSERT INTO `message` VALUES (2, '201808231058301205');
INSERT INTO `message` VALUES (4, '202103111152161222');
INSERT INTO `message` VALUES (3, '202103111152161222');
INSERT INTO `message` VALUES (574325373412847616, '20151612204');
INSERT INTO `message` VALUES (574448718041067520, '20151612204');
INSERT INTO `message` VALUES (574608072602038272, '20151612204');
INSERT INTO `message` VALUES (1, '20151612204');
INSERT INTO `message` VALUES (1721102, '20151612204');
INSERT INTO `message` VALUES (575857552953454592, '20151612204');
INSERT INTO `message` VALUES (3, '201710214225');
INSERT INTO `message` VALUES (1, '202103111152161222');
INSERT INTO `message` VALUES (2, '201710214225');
INSERT INTO `message` VALUES (1721102, '201710214225');
INSERT INTO `message` VALUES (588907340661796864, '201710214225');

-- ----------------------------
-- Table structure for music
-- ----------------------------
DROP TABLE IF EXISTS `music`;
CREATE TABLE `music`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `context` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `price` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `hour` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mp3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 588907340661796865 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of music
-- ----------------------------
INSERT INTO `music` VALUES (1721102, '邓紫棋', '龙卷风', '1', '0', '一般', '20', 'pic/1721102.jpg', 'music/1721102.mp3');
INSERT INTO `music` VALUES (575857552953454592, 'IU', 'someday', '1', '0', NULL, NULL, 'pic/575857552953454592.jpg', 'music/575857552953454592.mp3');
INSERT INTO `music` VALUES (588907340661796864, '内容出圈新玩法', '戴莹', '0', '0', NULL, NULL, 'pic/588907340661796864.jpg', 'music/588907340661796864.mp3');

-- ----------------------------
-- Table structure for review
-- ----------------------------
DROP TABLE IF EXISTS `review`;
CREATE TABLE `review`  (
  `reviewid` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `context` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `courseid` bigint(20) NULL DEFAULT NULL,
  `username` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` datetime(0) NULL DEFAULT NULL,
  `lable` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sex` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip` int(50) NULL DEFAULT NULL,
  PRIMARY KEY (`reviewid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of review
-- ----------------------------
INSERT INTO `review` VALUES ('201809060327341776', 'fgfdgdsgg', 2, 'zzz', '2018-09-06 15:34:27', '4', 'Female', 1);
INSERT INTO `review` VALUES ('201809060414381493', '钱花的有点多', 1, '雷宇锋', '2018-09-06 16:38:14', '0', NULL, 1);
INSERT INTO `review` VALUES ('201809060423031483', '这课不错', 4, 'admin', '2018-09-06 16:03:23', '2', 'Male', 1);
INSERT INTO `review` VALUES ('201809060444041617', '刷好评', 4, 'adm', '2018-09-06 16:04:44', '4', NULL, 0);
INSERT INTO `review` VALUES ('201809060450041302', '刷好评', 4, 'adm', '2018-09-06 16:04:50', '4', NULL, 0);
INSERT INTO `review` VALUES ('201809060452031217', '这还不错', 4, 'adm', '2018-09-06 16:03:52', '3', NULL, 0);
INSERT INTO `review` VALUES ('201809060457021559', '这课不错', 5, 'admin', '2018-09-06 16:02:57', '2', 'Male', 1);
INSERT INTO `review` VALUES ('201810151532321876', '测试测试！！！', 6, '1823544517', '2018-10-15 15:32:32', '3', 'Male', 1);
INSERT INTO `review` VALUES ('201810151554191404', 'en ?', 3, '1823544517', '2018-10-15 15:19:54', '2', 'Male', 1);
INSERT INTO `review` VALUES ('201810161036391342', '美太太', 3, 'abc', '2018-10-16 10:39:36', '4', 'Female', 1);
INSERT INTO `review` VALUES ('201810161522301059', '测试', 4, '1823544517', '2018-10-16 15:30:22', '4', 'Male', 1);
INSERT INTO `review` VALUES ('201810161530351701', 'en    很不错', 3, 'abc', '2018-10-16 15:35:30', '0', 'Female', 1);
INSERT INTO `review` VALUES ('201810161545271907', '测试测试', 4, '1823544517', '2018-10-16 15:27:45', '4', 'Male', 1);
INSERT INTO `review` VALUES ('201810161902561206', '', 2, '96321', '2018-10-16 19:02:56', '4', 'Male', 1);
INSERT INTO `review` VALUES ('201810161903551373', '6666', 6, '96321', '2018-10-16 19:03:55', '4', 'Male', 1);
INSERT INTO `review` VALUES ('201810291609501589', '还行', 2, 'admin', '2018-10-29 16:09:50', '4', 'Male', 1);
INSERT INTO `review` VALUES ('202103311336221228', '', 574608072602038272, 'admin', '2021-03-31 13:36:22', '1', 'Male', 1);
INSERT INTO `review` VALUES ('202103311336331695', '感觉还是可以的', 574608072602038272, 'admin', '2021-03-31 13:36:33', '4', 'Male', 1);
INSERT INTO `review` VALUES ('202104031352291005', '我觉得可以', 1721102, 'admin', '2021-04-03 13:52:29', '1', 'Male', 1);
INSERT INTO `review` VALUES ('202104031354231576', '学习笔记', 1721102, 'admin', '2021-04-03 13:54:23', '4', 'Male', 1);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mail` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vx` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mission` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `buycase` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mycase` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `collect` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `education` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vip` datetime(0) NULL DEFAULT NULL,
  `fristtime` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('201710214225', 'Male', '18235447109', '[email protected]', '1111', 'WYF', 'admin', 'admin', 'admin', NULL, NULL, '449000', '高中/中专', '2036-03-01 19:57:53', NULL);
INSERT INTO `user` VALUES ('201808100710171565', 'Female', '18235447109', '[email protected]', NULL, NULL, 'admin1', 'admin', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-10 19:17:10');
INSERT INTO `user` VALUES ('201808100930501831', 'Male', '18235447109', '[email protected]', '1111111111111111111', '张三', 'zhangsan', 'asdasd', NULL, NULL, NULL, '0', '本科/大专', '2019-09-01 20:41:04', '2018-08-10 09:50:30');
INSERT INTO `user` VALUES ('201808101154331492', 'Female', '1111111111111', '[email protected]', NULL, NULL, 'zhazhabi', 'zxcvbnm', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-10 11:33:54');
INSERT INTO `user` VALUES ('201808230425131682', NULL, '123456789', '125486', '15846', 'bad', 'bb', '123456', NULL, NULL, NULL, '500', '研究生以上', NULL, '2018-08-23 16:13:25');
INSERT INTO `user` VALUES ('201808230439101712', NULL, NULL, NULL, NULL, NULL, '18235445172', '1111', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-23 16:10:39');
INSERT INTO `user` VALUES ('201808231058301205', 'Male', '12345689', '[email protected]', '784554asdd', '雷', '1823544517', '123654', NULL, '0', NULL, '6500', '本科/大专', '2021-03-03 23:23:06', '2018-08-23 10:30:58');
INSERT INTO `user` VALUES ('201808240857431128', 'Female', '12345678907assa', '[email protected]', '4dgde', 'zzzgf', 'zzz', '12345', NULL, NULL, NULL, '0', '研究生以上', '2023-01-06 15:33:03', '2018-08-24 08:43:57');
INSERT INTO `user` VALUES ('201808241105291520', NULL, NULL, NULL, NULL, NULL, '1823544517111111111111', '123456', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-24 11:29:05');
INSERT INTO `user` VALUES ('201808241117291016', NULL, NULL, NULL, NULL, NULL, '182354451722222222222', '123456', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-24 11:29:17');
INSERT INTO `user` VALUES ('201808241149281125', NULL, NULL, NULL, NULL, NULL, '18235445171111', '123456', NULL, NULL, NULL, '500', NULL, NULL, '2018-08-24 11:28:49');
INSERT INTO `user` VALUES ('201809030750151429', NULL, NULL, NULL, NULL, NULL, 'adm', '123', NULL, NULL, NULL, '500', NULL, NULL, '2018-09-03 19:15:50');
INSERT INTO `user` VALUES ('201809061018111546', 'Male', '110', '[email protected]', 'js666', 'js', 'js', 'js666', NULL, NULL, NULL, '10000', '研究生以上', '2020-03-06 10:15:16', '2018-09-06 10:11:18');
INSERT INTO `user` VALUES ('201809061049051592', NULL, NULL, NULL, NULL, NULL, '雷宇锋', '110', NULL, NULL, NULL, '0', NULL, '2018-12-06 16:37:39', '2018-09-06 10:05:49');
INSERT INTO `user` VALUES ('201809061051011416', NULL, NULL, NULL, NULL, NULL, 'sdsd', '123', NULL, NULL, NULL, '500', NULL, NULL, '2018-09-06 10:01:51');
INSERT INTO `user` VALUES ('201809061108071033', 'Female', '12123', '[email protected]', NULL, NULL, '111', 'qweqwe', NULL, NULL, NULL, '500', NULL, NULL, '2018-09-06 11:07:08');
INSERT INTO `user` VALUES ('201810161045371069', 'Female', '13096613748', '872486471', '1223', '去玩儿', 'abc', '123456', NULL, '0', NULL, '0', '研究生以上', '2021-05-16 10:38:27', '2018-10-16 10:37:45');
INSERT INTO `user` VALUES ('201810161901381601', 'Male', '96321', '96321', '96321', '96321', '96321', '96321', NULL, '0', NULL, '0', '研究生以上', '2018-11-16 19:03:40', '2018-10-16 19:01:38');
INSERT INTO `user` VALUES ('202103111152161222', 'Male', '18922100410', '[email protected]', '18922100410', 'jf', 'Andrew', 'jief', NULL, NULL, NULL, '0', '本科/大专', '2021-04-12 17:33:01', '2021-03-11 11:52:16');

SET FOREIGN_KEY_CHECKS = 1;