online-education
/
ljh_online_education.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : ljh_online_education

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

 Date: 18/11/2020 18:20:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for acl_permission
-- ----------------------------
DROP TABLE IF EXISTS `acl_permission`;
CREATE TABLE `acl_permission`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '编号',
  `pid` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所属上级',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '类型(1:菜单,2:按钮)',
  `permission_value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限值',
  `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '访问路径',
  `component` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '组件路径',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_pid`(`pid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_permission
-- ----------------------------
INSERT INTO `acl_permission` VALUES ('1', '0', '全部数据', 0, NULL, NULL, NULL, NULL, NULL, 0, '2019-11-15 17:13:06', '2019-11-15 17:13:06');
INSERT INTO `acl_permission` VALUES ('1195268474480156673', '1', '权限管理', 1, NULL, '/acl', 'Layout', NULL, NULL, 0, '2019-11-15 17:13:06', '2019-11-18 13:54:25');
INSERT INTO `acl_permission` VALUES ('1195268616021139457', '1195268474480156673', '用户管理', 1, NULL, 'user/list', '/acl/user/list', NULL, NULL, 0, '2019-11-15 17:13:40', '2019-11-18 13:53:12');
INSERT INTO `acl_permission` VALUES ('1195268788138598401', '1195268474480156673', '角色管理', 1, NULL, 'role/list', '/acl/role/list', NULL, NULL, 0, '2019-11-15 17:14:21', '2019-11-15 17:14:21');
INSERT INTO `acl_permission` VALUES ('1195268893830864898', '1195268474480156673', '菜单管理', 1, NULL, 'menu/list', '/acl/menu/list', NULL, NULL, 0, '2019-11-15 17:14:46', '2019-11-15 17:14:46');
INSERT INTO `acl_permission` VALUES ('1195269143060602882', '1195268616021139457', '查看', 2, 'user.list', '', '', NULL, NULL, 0, '2019-11-15 17:15:45', '2019-11-17 21:57:16');
INSERT INTO `acl_permission` VALUES ('1195269295926206466', '1195268616021139457', '添加', 2, 'user.add', 'user/add', '/acl/user/form', NULL, NULL, 0, '2019-11-15 17:16:22', '2019-11-15 17:16:22');
INSERT INTO `acl_permission` VALUES ('1195269473479483394', '1195268616021139457', '修改', 2, 'user.update', 'user/update/:id', '/acl/user/form', NULL, NULL, 0, '2019-11-15 17:17:04', '2019-11-15 17:17:04');
INSERT INTO `acl_permission` VALUES ('1195269547269873666', '1195268616021139457', '删除', 2, 'user.remove', '', '', NULL, NULL, 0, '2019-11-15 17:17:22', '2019-11-15 17:17:22');
INSERT INTO `acl_permission` VALUES ('1195269821262782465', '1195268788138598401', '修改', 2, 'role.update', 'role/update/:id', '/acl/role/form', NULL, NULL, 0, '2019-11-15 17:18:27', '2019-11-15 17:19:53');
INSERT INTO `acl_permission` VALUES ('1195269903542444034', '1195268788138598401', '查看', 2, 'role.list', '', '', NULL, NULL, 0, '2019-11-15 17:18:47', '2019-11-15 17:18:47');
INSERT INTO `acl_permission` VALUES ('1195270037005197313', '1195268788138598401', '添加', 2, 'role.add', 'role/add', '/acl/role/form', NULL, NULL, 0, '2019-11-15 17:19:19', '2019-11-18 11:05:42');
INSERT INTO `acl_permission` VALUES ('1195270442602782721', '1195268788138598401', '删除', 2, 'role.remove', '', '', NULL, NULL, 0, '2019-11-15 17:20:55', '2019-11-15 17:20:55');
INSERT INTO `acl_permission` VALUES ('1195270621548568578', '1195268788138598401', '角色权限', 2, 'role.acl', 'role/distribution/:id', '/acl/role/roleForm', NULL, NULL, 0, '2019-11-15 17:21:38', '2019-11-15 17:21:38');
INSERT INTO `acl_permission` VALUES ('1195270744097742849', '1195268893830864898', '查看', 2, 'permission.list', '', '', NULL, NULL, 0, '2019-11-15 17:22:07', '2019-11-15 17:22:07');
INSERT INTO `acl_permission` VALUES ('1195270810560684034', '1195268893830864898', '添加', 2, 'permission.add', '', '', NULL, NULL, 0, '2019-11-15 17:22:23', '2019-11-15 17:22:23');
INSERT INTO `acl_permission` VALUES ('1195270862100291586', '1195268893830864898', '修改', 2, 'permission.update', '', '', NULL, NULL, 0, '2019-11-15 17:22:35', '2019-11-15 17:22:35');
INSERT INTO `acl_permission` VALUES ('1195270887933009922', '1195268893830864898', '删除', 2, 'permission.remove', '', '', NULL, NULL, 0, '2019-11-15 17:22:41', '2019-11-15 17:22:41');
INSERT INTO `acl_permission` VALUES ('1195349439240048642', '1', '讲师管理', 1, NULL, '/teacher', 'Layout', NULL, NULL, 0, '2019-11-15 22:34:49', '2019-11-15 22:34:49');
INSERT INTO `acl_permission` VALUES ('1195349699995734017', '1195349439240048642', '讲师列表', 1, NULL, 'list', '/edu/teacher/list', NULL, NULL, 0, '2019-11-15 22:35:52', '2019-11-15 22:35:52');
INSERT INTO `acl_permission` VALUES ('1195349810561781761', '1195349439240048642', '添加讲师', 1, NULL, 'create', '/edu/teacher/save', NULL, NULL, 0, '2019-11-15 22:36:18', '2019-11-15 22:36:18');
INSERT INTO `acl_permission` VALUES ('1195349876252971010', '1195349810561781761', '添加', 2, 'teacher.add', '', '', NULL, NULL, 0, '2019-11-15 22:36:34', '2019-11-15 22:36:34');
INSERT INTO `acl_permission` VALUES ('1195349979797753857', '1195349699995734017', '查看', 2, 'teacher.list', '', '', NULL, NULL, 0, '2019-11-15 22:36:58', '2019-11-15 22:36:58');
INSERT INTO `acl_permission` VALUES ('1195350117270261762', '1195349699995734017', '修改', 2, 'teacher.update', '/teacher/edit/:id', '/edu/teacher/save', NULL, NULL, 0, '2019-11-15 22:37:31', '2019-11-15 22:37:31');
INSERT INTO `acl_permission` VALUES ('1195350188359520258', '1195349699995734017', '删除', 2, 'teacher.remove', '', '', NULL, NULL, 0, '2019-11-15 22:37:48', '2019-11-15 22:37:48');
INSERT INTO `acl_permission` VALUES ('1195350299365969922', '1', '课程分类', 1, NULL, '/subject', 'Layout', NULL, NULL, 0, '2019-11-15 22:38:15', '2019-11-15 22:38:15');
INSERT INTO `acl_permission` VALUES ('1195350397751758850', '1195350299365969922', '课程分类列表', 1, NULL, 'list', '/edu/subject/list', NULL, NULL, 0, '2019-11-15 22:38:38', '2019-11-15 22:38:38');
INSERT INTO `acl_permission` VALUES ('1195350500512206850', '1195350299365969922', '导入课程分类', 1, NULL, 'import', '/edu/subject/import', NULL, NULL, 0, '2019-11-15 22:39:03', '2019-11-15 22:39:03');
INSERT INTO `acl_permission` VALUES ('1195350612172967938', '1195350397751758850', '查看', 2, 'subject.list', '', '', NULL, NULL, 0, '2019-11-15 22:39:29', '2019-11-15 22:39:29');
INSERT INTO `acl_permission` VALUES ('1195350687590748161', '1195350500512206850', '导入', 2, 'subject.import', '', '', NULL, NULL, 0, '2019-11-15 22:39:47', '2019-11-15 22:39:47');
INSERT INTO `acl_permission` VALUES ('1195350831744782337', '1', '课程管理', 1, NULL, '/course', 'Layout', NULL, NULL, 0, '2019-11-15 22:40:21', '2019-11-15 22:40:21');
INSERT INTO `acl_permission` VALUES ('1195350919074385921', '1195350831744782337', '课程列表', 1, NULL, 'list', '/edu/course/list', NULL, NULL, 0, '2019-11-15 22:40:42', '2019-11-15 22:40:42');
INSERT INTO `acl_permission` VALUES ('1195351020463296513', '1195350831744782337', '发布课程', 1, NULL, 'info', '/edu/course/info', NULL, NULL, 0, '2019-11-15 22:41:06', '2019-11-15 22:41:06');
INSERT INTO `acl_permission` VALUES ('1195351159672246274', '1195350919074385921', '完成发布', 2, 'course.publish', 'publish/:id', '/edu/course/publish', NULL, NULL, 0, '2019-11-15 22:41:40', '2019-11-15 22:44:01');
INSERT INTO `acl_permission` VALUES ('1195351326706208770', '1195350919074385921', '编辑课程', 2, 'course.update', '/course/info/:id', '/edu/course/info', NULL, NULL, 0, '2019-11-15 22:42:19', '2019-11-15 22:42:19');
INSERT INTO `acl_permission` VALUES ('1195351566221938690', '1195350919074385921', '编辑课程大纲', 2, 'chapter.update', '/course/chapter/:id', '/edu/course/chapter', NULL, NULL, 0, '2019-11-15 22:43:17', '2019-11-15 22:43:17');
INSERT INTO `acl_permission` VALUES ('1195352547621965825', '1', '主页轮播图管理', 1, NULL, '/banner', 'Layout', NULL, NULL, 0, '2019-11-15 22:47:11', '2019-11-18 10:51:46');
INSERT INTO `acl_permission` VALUES ('1195353051395624961', '1195353513549205505', '修改', 2, 'banner.update', '/banner/edit/:id', '/edu/banner/save', NULL, NULL, 0, '2019-11-15 22:49:11', '2019-11-18 10:52:05');
INSERT INTO `acl_permission` VALUES ('1195353513549205505', '1195352547621965825', '轮播图列表', 1, NULL, 'list', '/edu/banner/list', NULL, NULL, 0, '2019-11-15 22:51:01', '2019-11-18 10:51:29');
INSERT INTO `acl_permission` VALUES ('1195353672110673921', '1195353513549205505', '删除', 2, 'banner.remove', '', '', NULL, NULL, 0, '2019-11-15 22:51:39', '2019-11-15 22:51:39');
INSERT INTO `acl_permission` VALUES ('1196301740985311234', '1195268616021139457', '分配角色', 2, 'user.assgin', 'user/role/:id', '/acl/user/roleForm', NULL, NULL, 0, '2019-11-18 13:38:56', '2019-11-18 13:38:56');
INSERT INTO `acl_permission` VALUES ('1309034280877928449', '1195352547621965825', '轮播图添加', 1, NULL, 'save', '/edu/banner/save', NULL, NULL, 0, NULL, NULL);
INSERT INTO `acl_permission` VALUES ('1309034954801917953', '1309034280877928449', '添加', 2, 'banner.add', '', '', NULL, NULL, 0, NULL, NULL);

-- ----------------------------
-- Table structure for acl_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_role`;
CREATE TABLE `acl_role`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色id',
  `role_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `role_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色编码',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_role
-- ----------------------------
INSERT INTO `acl_role` VALUES ('1', '普通管理员', NULL, NULL, 0, '2019-11-11 13:09:32', '2019-11-18 10:27:18');
INSERT INTO `acl_role` VALUES ('1193757683205607426', '课程管理员', NULL, NULL, 0, '2019-11-11 13:09:45', '2019-11-18 10:25:44');
INSERT INTO `acl_role` VALUES ('1196300996034977794', 'test', NULL, NULL, 0, '2019-11-18 13:35:58', '2019-11-18 13:35:58');
INSERT INTO `acl_role` VALUES ('1308031977546436610', '课程和讲师管理', NULL, NULL, 0, '2020-09-21 21:15:00', '2020-09-21 21:15:00');

-- ----------------------------
-- Table structure for acl_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `acl_role_permission`;
CREATE TABLE `acl_role_permission`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `role_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `permission_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_permission_id`(`permission_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_role_permission
-- ----------------------------
INSERT INTO `acl_role_permission` VALUES ('1196301979754455041', '1', '1', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979792203778', '1', '1195268474480156673', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979821563906', '1', '1195268616021139457', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979842535426', '1', '1195269143060602882', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979855118338', '1', '1195269295926206466', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979880284161', '1', '1195269473479483394', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979913838593', '1', '1195269547269873666', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979926421506', '1', '1196301740985311234', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301979951587330', '1', '1195268788138598401', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980014501889', '1', '1195269821262782465', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980035473410', '1', '1195269903542444034', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980052250626', '1', '1195270037005197313', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980077416450', '1', '1195270442602782721', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980094193665', '1', '1195270621548568578', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980119359489', '1', '1195268893830864898', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980136136706', '1', '1195270744097742849', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980249382913', '1', '1195270810560684034', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980270354434', '1', '1195270862100291586', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980287131649', '1', '1195270887933009922', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980303908866', '1', '1195349439240048642', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980320686082', '1', '1195349699995734017', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980345851905', '1', '1195349979797753857', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980362629121', '1', '1195350117270261762', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980383600641', '1', '1195350188359520258', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980408766465', '1', '1195349810561781761', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980421349378', '1', '1195349876252971010', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980438126593', '1', '1195350299365969922', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980450709506', '1', '1195350397751758850', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980501041153', '1', '1195350612172967938', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980517818370', '1', '1195350500512206850', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980538789889', '1', '1195350687590748161', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980622675970', '1', '1195350831744782337', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980639453186', '1', '1195350919074385921', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980660424705', '1', '1195351159672246274', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980677201922', '1', '1195351326706208770', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980698173441', '1', '1195351566221938690', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980714950658', '1', '1195351020463296513', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980723339266', '1', '1195351862889254913', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980744310786', '1', '1195351968841568257', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980761088001', '1', '1195352215768633346', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980777865217', '1', '1195352054917074946', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980794642434', '1', '1195352127734386690', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980811419650', '1', '1195352547621965825', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980828196865', '1', '1195353513549205505', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980844974082', '1', '1195352856645701633', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980861751298', '1', '1195352909401657346', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980886917122', '1', '1195353051395624961', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980928860162', '1', '1195353672110673921', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980954025986', '1', '1195354076890370050', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980970803201', '1', '1195354153482555393', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196301980987580418', '1', '1195354315093282817', 1, '2019-11-18 13:39:53', '2019-11-18 13:39:53');
INSERT INTO `acl_role_permission` VALUES ('1196305293070077953', '1', '1', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293099438081', '1', '1195268474480156673', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293120409602', '1', '1195268616021139457', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293153964034', '1', '1195269143060602882', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293183324162', '1', '1195269295926206466', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293212684290', '1', '1195269473479483394', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293237850114', '1', '1195269547269873666', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293271404545', '1', '1196301740985311234', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293485314049', '1', '1195268788138598401', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293506285569', '1', '1195269821262782465', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293527257089', '1', '1195269903542444034', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293552422914', '1', '1195270037005197313', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293565005825', '1', '1195270442602782721', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293594365954', '1', '1195270621548568578', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293611143169', '1', '1195268893830864898', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293627920385', '1', '1195270744097742849', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293657280513', '1', '1195349439240048642', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293674057729', '1', '1195349699995734017', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293690834946', '1', '1195349979797753857', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293716000770', '1', '1195350117270261762', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293736972290', '1', '1195350188359520258', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293749555202', '1', '1195349810561781761', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293766332417', '1', '1195349876252971010', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293795692546', '1', '1195350299365969922', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293812469762', '1', '1195350397751758850', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293837635586', '1', '1195350612172967938', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293858607106', '1', '1195350500512206850', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293875384322', '1', '1195350687590748161', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293892161538', '1', '1195350831744782337', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293950881794', '1', '1195350919074385921', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305293976047617', '1', '1195351159672246274', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294127042561', '1', '1195351326706208770', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294156402690', '1', '1195351566221938690', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294177374209', '1', '1195351862889254913', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294194151425', '1', '1195351968841568257', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294223511554', '1', '1195352215768633346', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294240288770', '1', '1195352054917074946', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294248677377', '1', '1195352127734386690', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294248677378', '1', '1195352547621965825', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294319980546', '1', '1195353513549205505', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294319980547', '1', '1195352856645701633', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294319980548', '1', '1195352909401657346', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294378700802', '1', '1195353051395624961', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294378700803', '1', '1195353672110673921', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294458392577', '1', '1195354076890370050', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294483558402', '1', '1195354153482555393', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305294500335618', '1', '1195354315093282817', 1, '2019-11-18 13:53:03', '2019-11-18 13:53:03');
INSERT INTO `acl_role_permission` VALUES ('1196305566656139266', '1', '1', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566689693698', '1', '1195268474480156673', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566706470913', '1', '1195268616021139457', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566740025346', '1', '1195269143060602882', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566756802561', '1', '1195269295926206466', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566781968385', '1', '1195269473479483394', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566811328514', '1', '1195269547269873666', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566828105730', '1', '1196301740985311234', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566853271554', '1', '1195268788138598401', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566878437378', '1', '1195269821262782465', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566895214593', '1', '1195269903542444034', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566916186113', '1', '1195270037005197313', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566949740546', '1', '1195270442602782721', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566966517761', '1', '1195270621548568578', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305566991683585', '1', '1195268893830864898', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567012655106', '1', '1195270744097742849', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567029432322', '1', '1195270810560684034', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567042015233', '1', '1195270862100291586', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567100735490', '1', '1195270887933009922', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567117512705', '1', '1195349439240048642', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567142678530', '1', '1195349699995734017', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567155261442', '1', '1195349979797753857', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567172038658', '1', '1195350117270261762', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567188815873', '1', '1195350188359520258', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567218176001', '1', '1195349810561781761', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567234953217', '1', '1195349876252971010', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567251730434', '1', '1195350299365969922', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567272701954', '1', '1195350397751758850', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567289479170', '1', '1195350612172967938', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567310450690', '1', '1195350500512206850', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567327227905', '1', '1195350687590748161', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567448862722', '1', '1195350831744782337', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567478222850', '1', '1195350919074385921', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567495000065', '1', '1195351159672246274', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567520165889', '1', '1195351326706208770', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567541137409', '1', '1195351566221938690', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567570497538', '1', '1195351862889254913', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567587274754', '1', '1195351968841568257', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567604051970', '1', '1195352215768633346', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567633412098', '1', '1195352054917074946', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567683743745', '1', '1195352127734386690', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567721492481', '1', '1195352547621965825', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567742464002', '1', '1195353513549205505', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567771824129', '1', '1195352856645701633', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567792795650', '1', '1195352909401657346', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567809572866', '1', '1195353051395624961', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567843127298', '1', '1195353672110673921', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567868293122', '1', '1195354076890370050', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567885070338', '1', '1195354153482555393', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196305567910236162', '1', '1195354315093282817', 1, '2019-11-18 13:54:08', '2019-11-18 13:54:08');
INSERT INTO `acl_role_permission` VALUES ('1196312702601695234', '1', '1', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702652026881', '1', '1195268474480156673', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702668804098', '1', '1195268616021139457', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702698164226', '1', '1195269143060602882', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702723330049', '1', '1195269295926206466', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702744301569', '1', '1195269473479483394', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702765273089', '1', '1195269547269873666', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702790438913', '1', '1196301740985311234', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702945628161', '1', '1195268788138598401', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312702970793985', '1', '1195269821262782465', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703000154114', '1', '1195269903542444034', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703025319938', '1', '1195270037005197313', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703046291458', '1', '1195270442602782721', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703063068673', '1', '1195270621548568578', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703084040193', '1', '1195268893830864898', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703113400321', '1', '1195270744097742849', 0, '2019-11-18 14:22:29', '2019-11-18 14:22:29');
INSERT INTO `acl_role_permission` VALUES ('1196312703134371842', '1', '1195270810560684034', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703159537665', '1', '1195270862100291586', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703184703490', '1', '1195270887933009922', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703209869313', '1', '1195349439240048642', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703230840834', '1', '1195349699995734017', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703251812354', '1', '1195349979797753857', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703272783873', '1', '1195350117270261762', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703293755394', '1', '1195350188359520258', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703327309826', '1', '1195349810561781761', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703348281345', '1', '1195349876252971010', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703365058561', '1', '1195350299365969922', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703386030082', '1', '1195350397751758850', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703440556034', '1', '1195350612172967938', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703486693378', '1', '1195350500512206850', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703511859202', '1', '1195350687590748161', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703654465537', '1', '1195350831744782337', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703683825665', '1', '1195350919074385921', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703700602882', '1', '1195351159672246274', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703717380098', '1', '1195351326706208770', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703738351618', '1', '1195351566221938690', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703759323137', '1', '1195351020463296513', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703776100353', '1', '1195351862889254913', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703792877570', '1', '1195351968841568257', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703830626305', '1', '1195352215768633346', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703843209217', '1', '1195352054917074946', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703868375041', '1', '1195352127734386690', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703889346561', '1', '1195352547621965825', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703901929473', '1', '1195353513549205505', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703918706689', '1', '1195352856645701633', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703952261121', '1', '1195352909401657346', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703973232642', '1', '1195353051395624961', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312703990009857', '1', '1195353672110673921', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312704048730114', '1', '1195354076890370050', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312704069701633', '1', '1195354153482555393', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1196312704094867457', '1', '1195354315093282817', 0, '2019-11-18 14:22:30', '2019-11-18 14:22:30');
INSERT INTO `acl_role_permission` VALUES ('1308032063420616706', '1308031977546436610', '1', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063470948354', '1308031977546436610', '1195349439240048642', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063479336962', '1308031977546436610', '1195349699995734017', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063479336963', '1308031977546436610', '1195349979797753857', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063479336964', '1308031977546436610', '1195350117270261762', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063479336965', '1308031977546436610', '1195350188359520258', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063479336966', '1308031977546436610', '1195349810561781761', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063487725570', '1308031977546436610', '1195349876252971010', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063487725571', '1308031977546436610', '1195350831744782337', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063487725572', '1308031977546436610', '1195350919074385921', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063487725573', '1308031977546436610', '1195351159672246274', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063487725574', '1308031977546436610', '1195351326706208770', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063496114178', '1308031977546436610', '1195351566221938690', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');
INSERT INTO `acl_role_permission` VALUES ('1308032063496114179', '1308031977546436610', '1195351020463296513', 0, '2020-09-21 21:15:21', '2020-09-21 21:15:21');

-- ----------------------------
-- Table structure for acl_user
-- ----------------------------
DROP TABLE IF EXISTS `acl_user`;
CREATE TABLE `acl_user`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '会员id',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '微信openid',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '密码',
  `nick_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户签名',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_username`(`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_user
-- ----------------------------
INSERT INTO `acl_user` VALUES ('1', 'admin', '96e79218965eb72c92a549dd5a330112', 'admin', '', NULL, 0, '2019-11-01 10:39:47', '2019-11-01 10:39:47');
INSERT INTO `acl_user` VALUES ('1308031837037252610', 'ljh', 'e10adc3949ba59abbe56e057f20f883e', '林加浩', NULL, NULL, 0, '2020-09-21 21:14:27', '2020-09-21 21:14:27');
INSERT INTO `acl_user` VALUES ('1309160818436829185', 'test', 'e10adc3949ba59abbe56e057f20f883e', 'test', NULL, NULL, 0, '2020-09-25 00:00:37', '2020-09-25 00:00:37');

-- ----------------------------
-- Table structure for acl_user_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_user_role`;
CREATE TABLE `acl_user_role`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主键id',
  `role_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '角色id',
  `user_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '用户id',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_user_role
-- ----------------------------
INSERT INTO `acl_user_role` VALUES ('1308032117648773122', '1308031977546436610', '1308031837037252610', 0, '2020-09-21 21:15:34', '2020-09-21 21:15:34');

-- ----------------------------
-- Table structure for chatmessage
-- ----------------------------
DROP TABLE IF EXISTS `chatmessage`;
CREATE TABLE `chatmessage`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `my_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `friend_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `data` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `mine` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chatmessage
-- ----------------------------
INSERT INTO `chatmessage` VALUES ('1328959543551483905', '1302669158068101122', '1309429625126019073', '2020/11/18 15:13:40', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:13:41', '2020-11-18 15:13:41');
INSERT INTO `chatmessage` VALUES ('1328959544205795330', '1309429625126019073', '1302669158068101122', '2020/11/18 15:13:40', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:13:41', '2020-11-18 15:13:41');
INSERT INTO `chatmessage` VALUES ('1328959745444306945', '1309429625126019073', '1302669158068101122', '2020/11/18 15:14:28', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"55\"}', '2020-11-18 15:14:29', '2020-11-18 15:14:29');
INSERT INTO `chatmessage` VALUES ('1328959746375442433', '1302669158068101122', '1309429625126019073', '2020/11/18 15:14:28', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"55\"}', '2020-11-18 15:14:29', '2020-11-18 15:14:29');
INSERT INTO `chatmessage` VALUES ('1328962281836494849', '1309429625126019073', '1302669158068101122', '2020/11/18 15:24:32', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"555\"}', '2020-11-18 15:24:34', '2020-11-18 15:24:34');
INSERT INTO `chatmessage` VALUES ('1328962282243342338', '1302669158068101122', '1309429625126019073', '2020/11/18 15:24:32', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"555\"}', '2020-11-18 15:24:34', '2020-11-18 15:24:34');
INSERT INTO `chatmessage` VALUES ('1328962535642218498', '1302669158068101122', '1309429625126019073', '2020/11/18 15:25:34', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"/::g\"}', '2020-11-18 15:25:34', '2020-11-18 15:25:34');
INSERT INTO `chatmessage` VALUES ('1328962536166506498', '1309429625126019073', '1302669158068101122', '2020/11/18 15:25:34', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"/::g\"}', '2020-11-18 15:25:34', '2020-11-18 15:25:34');
INSERT INTO `chatmessage` VALUES ('1328962689090830338', '1309429625126019073', '1302669158068101122', '2020/11/18 15:26:10', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/:|-)\"}', '2020-11-18 15:26:11', '2020-11-18 15:26:11');
INSERT INTO `chatmessage` VALUES ('1328962689829027841', '1302669158068101122', '1309429625126019073', '2020/11/18 15:26:10', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/:|-)\"}', '2020-11-18 15:26:11', '2020-11-18 15:26:11');
INSERT INTO `chatmessage` VALUES ('1328963594376822786', '1195187659054329857', '1309429625126019073', '2020/11/18 15:29:46', 'true', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"55\"}', '2020-11-18 15:29:47', '2020-11-18 15:29:47');
INSERT INTO `chatmessage` VALUES ('1328963595240849409', '1309429625126019073', '1195187659054329857', '2020/11/18 15:29:46', '0', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"55\"}', '2020-11-18 15:29:47', '2020-11-18 15:29:47');
INSERT INTO `chatmessage` VALUES ('1328963608457101314', '1195187659054329857', '1309429625126019073', '2020/11/18 15:29:49', 'true', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"55\"}', '2020-11-18 15:29:50', '2020-11-18 15:29:50');
INSERT INTO `chatmessage` VALUES ('1328963609249824769', '1309429625126019073', '1195187659054329857', '2020/11/18 15:29:49', '0', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"55\"}', '2020-11-18 15:29:50', '2020-11-18 15:29:50');
INSERT INTO `chatmessage` VALUES ('1328964744647917570', '1195187659054329857', '1309429625126019073', '2020/11/18 15:34:20', 'true', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"555\"}', '2020-11-18 15:34:21', '2020-11-18 15:34:21');
INSERT INTO `chatmessage` VALUES ('1328964744962490369', '1309429625126019073', '1195187659054329857', '2020/11/18 15:34:20', '0', 'qy', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '{\"text\":\"555\"}', '2020-11-18 15:34:21', '2020-11-18 15:34:21');
INSERT INTO `chatmessage` VALUES ('1328964824696209409', '1302669158068101122', '1309429625126019073', '2020/11/18 15:34:39', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:34:40', '2020-11-18 15:34:40');
INSERT INTO `chatmessage` VALUES ('1328964825199525890', '1309429625126019073', '1302669158068101122', '2020/11/18 15:34:39', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:34:40', '2020-11-18 15:34:40');
INSERT INTO `chatmessage` VALUES ('1328965276053651457', '1302669158068101122', '1309429625126019073', '2020/11/18 15:36:27', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"5\"}', '2020-11-18 15:36:27', '2020-11-18 15:36:27');
INSERT INTO `chatmessage` VALUES ('1328965277035118594', '1309429625126019073', '1302669158068101122', '2020/11/18 15:36:27', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"5\"}', '2020-11-18 15:36:28', '2020-11-18 15:36:28');
INSERT INTO `chatmessage` VALUES ('1328967664852385793', '1302669158068101122', '1309429625126019073', '2020/11/18 15:45:56', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:45:57', '2020-11-18 15:45:57');
INSERT INTO `chatmessage` VALUES ('1328967665619943425', '1309429625126019073', '1302669158068101122', '2020/11/18 15:45:56', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"555\"}', '2020-11-18 15:45:57', '2020-11-18 15:45:57');
INSERT INTO `chatmessage` VALUES ('1328969767033356290', '1309429625126019073', '1302669158068101122', '2020/11/18 15:54:18', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"5\"}', '2020-11-18 15:54:18', '2020-11-18 15:54:18');
INSERT INTO `chatmessage` VALUES ('1328969767352123393', '1302669158068101122', '1309429625126019073', '2020/11/18 15:54:18', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"5\"}', '2020-11-18 15:54:18', '2020-11-18 15:54:18');
INSERT INTO `chatmessage` VALUES ('1328969812617052161', '1302669158068101122', '1309429625126019073', '2020/11/18 15:54:29', 'true', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"5\"}', '2020-11-18 15:54:29', '2020-11-18 15:54:29');
INSERT INTO `chatmessage` VALUES ('1328969812940013569', '1309429625126019073', '1302669158068101122', '2020/11/18 15:54:29', '0', '林加浩', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '{\"text\":\"5\"}', '2020-11-18 15:54:29', '2020-11-18 15:54:29');
INSERT INTO `chatmessage` VALUES ('1328972954331086849', '1309429625126019073', '1302669158068101122', '2020/11/18 16:6:57', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"55\"}', '2020-11-18 16:06:58', '2020-11-18 16:06:58');
INSERT INTO `chatmessage` VALUES ('1328972955220279298', '1302669158068101122', '1309429625126019073', '2020/11/18 16:6:57', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"55\"}', '2020-11-18 16:06:58', '2020-11-18 16:06:58');
INSERT INTO `chatmessage` VALUES ('1328982330131447809', '1309429625126019073', '1302669158068101122', '2020/11/18 16:44:12', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/::D\"}', '2020-11-18 16:44:13', '2020-11-18 16:44:13');
INSERT INTO `chatmessage` VALUES ('1328982330446020610', '1302669158068101122', '1309429625126019073', '2020/11/18 16:44:12', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/::D\"}', '2020-11-18 16:44:14', '2020-11-18 16:44:14');
INSERT INTO `chatmessage` VALUES ('1328984513979727874', '1309429625126019073', '1302669158068101122', '2020/11/18 16:52:53', 'true', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/:,@o\"}', '2020-11-18 16:52:54', '2020-11-18 16:52:54');
INSERT INTO `chatmessage` VALUES ('1328984514906669057', '1302669158068101122', '1309429625126019073', '2020/11/18 16:52:53', '0', 'ljh', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', '{\"text\":\"/:,@o\"}', '2020-11-18 16:52:54', '2020-11-18 16:52:54');

-- ----------------------------
-- Table structure for crm_banner
-- ----------------------------
DROP TABLE IF EXISTS `crm_banner`;
CREATE TABLE `crm_banner`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'ID',
  `title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '标题',
  `image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图片地址',
  `link_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '链接地址',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_name`(`title`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '首页banner表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of crm_banner
-- ----------------------------
INSERT INTO `crm_banner` VALUES ('1194607458461216769', 'test2', 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/cms/2019/11/13/8f80790d-d736-4842-a6a4-4dcb0d684d4e.jpg', '/teacher', 2, 0, '2019-11-13 21:26:27', '2019-11-14 09:12:15');
INSERT INTO `crm_banner` VALUES ('1301232992680693762', 'test123', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/03/4a3c56fa619d4bdeaca35029fed84588file.png', '/course', 3, 0, '2020-09-03 02:58:16', '2020-09-25 01:02:36');
INSERT INTO `crm_banner` VALUES ('1301233605757915137', 'test', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/03/d960bc210e8e43c68504f351009e67c7file.png', '/course', 3, 0, '2020-09-03 03:00:42', '2020-09-03 03:00:42');

-- ----------------------------
-- Table structure for edu_article
-- ----------------------------
DROP TABLE IF EXISTS `edu_article`;
CREATE TABLE `edu_article`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章id',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  `author` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '作者',
  `article_title` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章标题',
  `content` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '文章内容',
  `likes` int(11) NULL DEFAULT NULL COMMENT '收藏数',
  `visits` int(11) NULL DEFAULT NULL COMMENT '访问数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_article
-- ----------------------------
INSERT INTO `edu_article` VALUES ('1305177116328939522', '2020-09-14 00:10:48', '2020-09-26 09:59:09', '林加浩', '555', '<p>请在这里编写内容</p>', NULL, 37);
INSERT INTO `edu_article` VALUES ('1305178473148534786', '2020-09-14 00:16:12', '2020-09-26 02:40:15', '林加浩', 'testjava', '<p>55555</p>', NULL, 16);
INSERT INTO `edu_article` VALUES ('1305193894203412482', '2020-09-14 01:17:28', '2020-09-25 22:04:08', '林加浩', 'java学习方向', '<p>在博主认为，对于入门级学习java的最佳学习方法莫过于视频+博客+书籍+总结，前三者博主将淋漓尽致地挥毫于这篇博客文章中，至于总结在于个人，实际上越到后面你会发现学习的最好方式就是阅读参考官方文档其次就是国内的书籍，博客次之，这又是一个层次了，这里暂时不提后面再谈。博主将为各位入门java保驾护航，各位只管冲鸭！！！上天是公平的，只要不辜负时间，时间自然不会辜负你。</p><p>何谓学习？博主所理解的学习，它是一个过程，是一个不断<strong>累积</strong>、不断<strong>沉淀</strong>、不断<strong>总结</strong>、善于传达自己的<strong>个人见解</strong>以及<strong>乐于分享</strong>的过程。</p><h3><strong>文章目录</strong></h3><ul><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#Java_7\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">一、Java基础</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1Java_9\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、Java基础教学视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2Java_18\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、Java基础博客文章目录</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3Java_101\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、Java基础书籍</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#JavaWeb_108\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">二、关于JavaWeb基础</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1JavaWeb_115\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、JavaWeb基础教程视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2JavaWeb_123\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、关于JavaWeb博客文章</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_128\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">三、关于数据库</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1_131\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、关系型数据库教学视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2Redis_140\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、非关系性数据库Redis视频</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#JDK_146\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">四、关于JDK新特性</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_155\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">五、关于并发编程</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#NIO_161\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">六、关于NIO</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#ssm_165\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">七、关于ssm框架</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1spring_167\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、spring框架视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2Mybatis__171\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、Mybatis 框架视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3SpringMVC_175\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、SpringMVC框架视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#4SSM_177\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4、SSM框架博客文章</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#41spring_180\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4.1、spring框架</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#42Mybatis_190\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4.2、Mybatis框架</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#43SpringMVC_205\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4.3、SpringMVC框架</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#45SSM_215\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4.5、SSM框架整合文章</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_223\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">八、关于数据结构与算法</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1_225\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、数据结构与算法视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2_233\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、数据结构与算法博客文章</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3_257\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、数据结构与算法书籍</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#idea_264\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">九、关于开发工具idea</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#MavenGitSVNGradle_273\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十、关于项目管理工具Maven、Git、SVN、Gradle....</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_287\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十一、关于计算机网络原理</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_294\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十二、关于设计模式</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1_296\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、设计模式博客文章</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2_305\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、设计模式视频</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#ShiroLuceneSolr_314\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十三、关于中间件Shiro、Lucene、Solr...</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1_315\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、啥是中间件？</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2Shiro_323\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、Shiro</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3Lucene_327\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、Lucene</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#4Shiro_329\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4、Shiro</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#5Elasticsearch7X_331\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">5、Elasticsearch7.X</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#6Dubbo_333\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">6、Dubbo</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#JVM_337\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十四、关于JVM虚拟机</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1JVM_338\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、JVM博客文章</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2JVM_345\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、JVM视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3JVM_350\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、JVM书籍</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#RabbitMQRocketMQActiveMQ_356\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十五、关于消息中间件、RabbitMQ、RocketMQ、ActiveMQ</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1Kafka_358\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、Kafka</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2RabbitMQ_360\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、RabbitMQ</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3RocketMQ_364\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、RocketMQ</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#4ActiveMQ_368\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">4、ActiveMQ</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#dockerkubernetes_373\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十六、关于容器化技术docker、kubernetes</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_384\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十七、关于微服务框架</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1SpringBoot_387\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、SpringBoot视频</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2SpringCloud_392\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、SpringCloud视频</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_401\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十八、关于面试</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_409\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">十九、关于另一层次的学习</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#1_411\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">1、参阅官方文档</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#2_415\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">2、国内技术书籍</a></li><li class=\"ql-indent-1\"><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#3github_419\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">3、参阅博客文章、闲逛github</a></li><li><a href=\"https://blog.csdn.net/qq_44543508/article/details/102651841?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522159987266319724839854774%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&amp;request_id=159987266319724839854774&amp;biz_id=0&amp;utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v3~pc_rank_v3-6-102651841.pc_ecpm_v3_pc_rank_v3&amp;utm_term=java&amp;spm=1018.2118.3001.4187#_439\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(103, 149, 181);\">持续更新....</a></li></ul><p><br></p>', NULL, 8);
INSERT INTO `edu_article` VALUES ('1306582728740769793', '2020-09-17 21:16:12', '2020-09-17 21:16:12', '林加浩', 'test123', '<p>java7881收到</p>', NULL, NULL);
INSERT INTO `edu_article` VALUES ('1309504034983276545', '2020-09-25 22:44:26', '2020-09-25 22:44:26', 'ljh', 'java林加浩', '<p>test5555</p>', NULL, NULL);

-- ----------------------------
-- Table structure for edu_article_collect
-- ----------------------------
DROP TABLE IF EXISTS `edu_article_collect`;
CREATE TABLE `edu_article_collect`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `member_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `article_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gmt_create` datetime(0) NOT NULL,
  `gmt_modified` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_article_collect
-- ----------------------------
INSERT INTO `edu_article_collect` VALUES ('1306604181666152450', '1302669158068101122', '1305177116328939522', '2020-09-17 22:41:27', '2020-09-17 22:41:27');
INSERT INTO `edu_article_collect` VALUES ('1306604192911081474', '1302669158068101122', '1305178473148534786', '2020-09-17 22:41:30', '2020-09-17 22:41:30');
INSERT INTO `edu_article_collect` VALUES ('1309493875410104321', '1309429625126019073', '1305178473148534786', '2020-09-25 22:04:04', '2020-09-25 22:04:04');

-- ----------------------------
-- Table structure for edu_chapter
-- ----------------------------
DROP TABLE IF EXISTS `edu_chapter`;
CREATE TABLE `edu_chapter`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '章节ID',
  `course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程ID',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '章节名称',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '显示排序',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_id`(`course_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of edu_chapter
-- ----------------------------
INSERT INTO `edu_chapter` VALUES ('1', '14', '第一章：HTML', 0, '2019-01-01 12:27:40', '2019-01-01 12:55:30');
INSERT INTO `edu_chapter` VALUES ('1181729226915577857', '18', '第七章：I/O流', 70, '2019-10-09 08:32:58', '2019-10-09 08:33:20');
INSERT INTO `edu_chapter` VALUES ('1192252428399751169', '1192252213659774977', '第一章节', 0, '2019-11-07 09:28:25', '2019-11-07 09:28:25');
INSERT INTO `edu_chapter` VALUES ('1298907249237897218', '1298907209765302273', '第一章', 1, '2020-08-27 16:56:35', '2020-08-27 16:56:35');
INSERT INTO `edu_chapter` VALUES ('1299309978389094402', '1299309945119875074', '第一章', 1, '2020-08-28 19:36:54', '2020-08-28 19:36:54');
INSERT INTO `edu_chapter` VALUES ('1299310006755172353', '1299309945119875074', '第二章', 2, '2020-08-28 19:37:00', '2020-08-28 19:37:00');
INSERT INTO `edu_chapter` VALUES ('1300045384529276930', '1300045350794489858', '第一章', 1, '2020-08-30 20:19:08', '2020-08-30 20:19:08');
INSERT INTO `edu_chapter` VALUES ('1300045414803763202', '1300045350794489858', '第二章', 2, '2020-08-30 20:19:15', '2020-08-30 20:19:15');
INSERT INTO `edu_chapter` VALUES ('1300379126942670849', '1300377066998341633', '第一章', 1, '2020-08-31 18:25:18', '2020-08-31 18:25:18');
INSERT INTO `edu_chapter` VALUES ('15', '18', '第八章-javaweb', 8, '2019-01-01 12:27:40', '2020-08-27 01:22:24');
INSERT INTO `edu_chapter` VALUES ('3', '14', '第二章：CSS', 0, '2019-01-01 12:55:35', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('32', '18', '第二章：控制台输入和输出', 1, '2019-01-01 12:27:40', '2020-08-27 01:23:05');
INSERT INTO `edu_chapter` VALUES ('44', '18', '第三章：控制流', 0, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('48', '18', '第四章：类的定义', 0, '2019-01-01 12:27:40', '2019-01-01 12:27:40');
INSERT INTO `edu_chapter` VALUES ('63', '18', '第五章：数组', 0, '2019-01-01 12:27:40', '2019-01-01 12:27:40');

-- ----------------------------
-- Table structure for edu_comment
-- ----------------------------
DROP TABLE IF EXISTS `edu_comment`;
CREATE TABLE `edu_comment`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '讲师ID',
  `course_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程id',
  `teacher_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '讲师id',
  `member_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '会员id',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员头像',
  `content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '评论内容',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_id`(`course_id`) USING BTREE,
  INDEX `idx_teacher_id`(`teacher_id`) USING BTREE,
  INDEX `idx_member_id`(`member_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '评论' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_comment
-- ----------------------------
INSERT INTO `edu_comment` VALUES ('1194499162790211585', '1192252213659774977', '1189389726308478977', '1', '小三123', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '课程很好', 0, '2019-11-13 14:16:08', '2019-11-13 14:16:08');
INSERT INTO `edu_comment` VALUES ('1194898406466420738', '1192252213659774977', '1189389726308478977', '1', '小三123', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '11', 0, '2019-11-14 16:42:35', '2019-11-14 16:42:35');
INSERT INTO `edu_comment` VALUES ('1194898484388200450', '1192252213659774977', '1189389726308478977', '1', '小三123', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '111', 0, '2019-11-14 16:42:53', '2019-11-14 16:42:53');
INSERT INTO `edu_comment` VALUES ('1195251020861317122', '1192252213659774977', '1189389726308478977', '1', NULL, NULL, '2233', 0, '2019-11-15 16:03:45', '2019-11-15 16:03:45');
INSERT INTO `edu_comment` VALUES ('1195251382720700418', '1192252213659774977', '1189389726308478977', '1', NULL, NULL, '4455', 0, '2019-11-15 16:05:11', '2019-11-15 16:05:11');
INSERT INTO `edu_comment` VALUES ('1195252819177570306', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '55', 0, '2019-11-15 16:10:53', '2019-11-15 16:10:53');
INSERT INTO `edu_comment` VALUES ('1195252899448160258', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '55', 0, '2019-11-15 16:11:13', '2019-11-15 16:11:13');
INSERT INTO `edu_comment` VALUES ('1195252920587452417', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '223344', 0, '2019-11-15 16:11:18', '2019-11-15 16:11:18');
INSERT INTO `edu_comment` VALUES ('1195262128095559681', '14', '1189389726308478977', '1', '小三1231', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '11', 0, '2019-11-15 16:47:53', '2019-11-15 16:47:53');
INSERT INTO `edu_comment` VALUES ('1196264505170767874', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', '666666', 0, '2019-11-18 11:10:58', '2019-11-18 11:10:58');
INSERT INTO `edu_comment` VALUES ('1303013559826984961', '1192252213659774977', '1189389726308478977', '1302669158068101122', '小块坐', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '5555', 0, '2020-09-08 00:53:36', '2020-09-08 00:53:36');
INSERT INTO `edu_comment` VALUES ('1303014821343604737', '1192252213659774977', '1189389726308478977', '1302669158068101122', '小块坐', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', 'henhsajja', 0, '2020-09-08 00:58:37', '2020-09-08 00:58:37');
INSERT INTO `edu_comment` VALUES ('1303015264849309698', '1192252213659774977', '1189389726308478977', '1302669158068101122', '小块坐', 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '火山活动和', 0, '2020-09-08 01:00:23', '2020-09-08 01:00:23');

-- ----------------------------
-- Table structure for edu_course
-- ----------------------------
DROP TABLE IF EXISTS `edu_course`;
CREATE TABLE `edu_course`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程ID',
  `teacher_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程讲师ID',
  `subject_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程专业ID',
  `subject_parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程专业父级ID',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程标题',
  `price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '课程销售价格，设置为0则可免费观看',
  `lesson_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '总课时',
  `cover` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程封面图片路径',
  `buy_count` bigint(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '销售数量',
  `view_count` bigint(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '浏览数量',
  `version` bigint(20) UNSIGNED NOT NULL DEFAULT 1 COMMENT '乐观锁',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Draft' COMMENT '课程状态 Draft未发布  Normal已发布',
  `is_deleted` tinyint(3) NULL DEFAULT NULL COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_title`(`title`) USING BTREE,
  INDEX `idx_subject_id`(`subject_id`) USING BTREE,
  INDEX `idx_teacher_id`(`teacher_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of edu_course
-- ----------------------------
INSERT INTO `edu_course` VALUES ('1192252213659774977', '1189389726308478977', '1178214681139539969', '1178214681118568449', 'java基础课程：test', 0.01, 2, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 5, 667, 1, 'Normal', 0, '2019-11-07 09:27:33', '2020-09-28 13:37:47');
INSERT INTO `edu_course` VALUES ('1298907209765302273', '1296049640797384705', '1178214681139539969', '1178214681118568449', 'test-林加浩', 0.01, 20, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 1, 56, 1, 'Normal', NULL, '2020-08-27 16:56:26', '2020-09-28 13:47:34');
INSERT INTO `edu_course` VALUES ('1299309945119875074', '1296049640797384705', '1178214681139539969', '1178214681118568449', 'javaweb', 0.01, 20, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 2, 143, 1, 'Normal', NULL, '2020-08-28 19:36:46', '2020-09-28 13:47:50');
INSERT INTO `edu_course` VALUES ('1300045350794489858', '1296049640797384705', '1178585108407984130', '1178214681118568449', '测试java', 0.01, 250, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 0, 107, 1, 'Normal', NULL, '2020-08-30 20:19:00', '2020-09-11 21:44:23');
INSERT INTO `edu_course` VALUES ('1300377066998341633', '1296049640797384705', '1297868578892095489', '1297814409724297217', 'test-sentinel', 0.01, 250, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 0, 2, 1, 'Normal', NULL, '2020-08-31 18:17:07', '2020-09-29 10:57:14');
INSERT INTO `edu_course` VALUES ('14', '1189389726308478977', '1101348944971091969', '1101348944920760321', 'XHTML CSS2 JS整站制作教程课程学习', 0.01, 3, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 3, 55, 15, 'Normal', 0, '2018-04-02 18:33:34', '2020-09-11 21:44:34');
INSERT INTO `edu_course` VALUES ('15', '1189389726308478977', '1101348944971091969', '1101348944920760321', 'HTML5入门课程学习', 0.01, 23, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 0, 61, 17, 'Normal', 0, '2018-04-02 18:34:32', '2020-09-11 21:44:40');
INSERT INTO `edu_course` VALUES ('18', '1296049640797384705', '1178214681139539969', '1178214681118568449', 'Java精品课程', 0.01, 20, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 151, 744, 6, 'Normal', 0, '2018-04-02 21:28:46', '2020-09-09 09:43:17');
INSERT INTO `edu_course` VALUES ('string', 'string', 'string', NULL, 'string', 0.00, 0, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 0, 20, 1, 'Draft', NULL, '2020-08-25 01:34:05', '2020-09-10 17:43:30');

-- ----------------------------
-- Table structure for edu_course_collect
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_collect`;
CREATE TABLE `edu_course_collect`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '收藏ID',
  `course_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程讲师ID',
  `member_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程专业ID',
  `is_deleted` tinyint(3) NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程收藏' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of edu_course_collect
-- ----------------------------
INSERT INTO `edu_course_collect` VALUES ('1196269345666019330', '1192252213659774977', '1', 1, '2019-11-18 11:30:12', '2019-11-18 11:30:12');
INSERT INTO `edu_course_collect` VALUES ('1303991149945479169', '1192252213659774977', '1302669158068101122', 0, '2020-09-10 17:38:12', '2020-09-10 17:38:12');
INSERT INTO `edu_course_collect` VALUES ('1304414647750754305', '1299309945119875074', '1302669158068101122', 0, '2020-09-11 21:41:02', '2020-09-11 21:41:02');
INSERT INTO `edu_course_collect` VALUES ('1304415494404571138', '1300045350794489858', '1302669158068101122', 0, '2020-09-11 21:44:23', '2020-09-11 21:44:23');
INSERT INTO `edu_course_collect` VALUES ('1304415520371507202', '1300377066998341633', '1302669158068101122', 0, '2020-09-11 21:44:30', '2020-09-11 21:44:30');
INSERT INTO `edu_course_collect` VALUES ('1304415543238852610', '14', '1302669158068101122', 0, '2020-09-11 21:44:35', '2020-09-11 21:44:35');
INSERT INTO `edu_course_collect` VALUES ('1304415573010022401', '15', '1302669158068101122', 0, '2020-09-11 21:44:42', '2020-09-11 21:44:42');
INSERT INTO `edu_course_collect` VALUES ('1309507823647784961', '1192252213659774977', '1309429625126019073', 0, '2020-09-25 22:59:29', '2020-09-25 22:59:29');

-- ----------------------------
-- Table structure for edu_course_description
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_description`;
CREATE TABLE `edu_course_description`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程ID',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '课程简介',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程简介' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_course_description
-- ----------------------------
INSERT INTO `edu_course_description` VALUES ('1104870479077879809', '<p>11</p>', '2019-03-11 06:23:44', '2019-03-11 06:23:44');
INSERT INTO `edu_course_description` VALUES ('1192252213659774977', '<p>测试</p>', '2019-11-07 09:27:33', '2019-11-13 16:21:28');
INSERT INTO `edu_course_description` VALUES ('1298536785936150530', '<p>地方都是</p>', '2020-08-26 16:24:30', '2020-08-26 16:24:30');
INSERT INTO `edu_course_description` VALUES ('1298653807307165697', '<p>的发射点</p>', '2020-08-27 00:09:30', '2020-08-27 00:09:45');
INSERT INTO `edu_course_description` VALUES ('1298654502081040385', '<p>各地纷纷</p>', '2020-08-27 00:12:16', '2020-08-27 00:12:25');
INSERT INTO `edu_course_description` VALUES ('1298902696450854913', '<p>撒旦撒旦</p>', '2020-08-27 16:38:30', '2020-08-27 16:38:30');
INSERT INTO `edu_course_description` VALUES ('1298907209765302273', '<p>上帝发誓</p>', '2020-08-27 16:56:26', '2020-08-27 17:58:53');
INSERT INTO `edu_course_description` VALUES ('1299309945119875074', '<p>色的发放</p>', '2020-08-28 19:36:46', '2020-08-30 18:26:30');
INSERT INTO `edu_course_description` VALUES ('1300045350794489858', '<p>大苏打</p>', '2020-08-30 20:19:00', '2020-08-30 20:19:00');
INSERT INTO `edu_course_description` VALUES ('1300377066998341633', '<p>dfs&nbsp;</p>', '2020-08-31 18:17:07', '2020-09-29 10:39:43');
INSERT INTO `edu_course_description` VALUES ('14', '', '2019-03-13 06:04:43', '2019-03-13 06:05:33');
INSERT INTO `edu_course_description` VALUES ('15', '', '2019-03-13 06:03:33', '2019-03-13 06:04:22');
INSERT INTO `edu_course_description` VALUES ('18', '<p>本套Java视频完全针对零基础学员，课堂实录，自发布以来，好评如潮！Java视频中注重与学生互动，讲授幽默诙谐、细致入微，覆盖Java基础所有核心知识点，同类Java视频中也是代码量大、案例多、实战性强的。同时，本Java视频教程注重技术原理剖析，深入JDK源码，辅以代码实战贯穿始终，用实践驱动理论，并辅以必要的代码练习。</p>\n<p>------------------------------------</p>\n<p>视频特点：</p>\n<p>通过学习本Java视频教程，大家能够真正将Java基础知识学以致用、活学活用，构架Java编程思想，牢牢掌握\"源码级\"的Javase核心技术，并为后续JavaWeb等技术的学习奠定扎实基础。<br /><br />1.通俗易懂，细致入微：每个知识点高屋建瓴，深入浅出，简洁明了的说明问题<br />2.具实战性：全程真正代码实战，涵盖上百个企业应用案例及练习<br />3.深入：源码分析，更有 Java 反射、动态代理的实际应用等<br />4.登录尚硅谷官网，技术讲师免费在线答疑</p>', '2019-03-06 18:06:36', '2020-08-27 00:07:40');
INSERT INTO `edu_course_description` VALUES ('string', 'string', '2020-08-25 01:34:05', '2020-08-25 01:34:05');

-- ----------------------------
-- Table structure for edu_footprint
-- ----------------------------
DROP TABLE IF EXISTS `edu_footprint`;
CREATE TABLE `edu_footprint`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `member_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `iscollect` tinyint(4) NULL DEFAULT NULL,
  `gmt_create` datetime(0) NOT NULL,
  `article_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_footprint
-- ----------------------------
INSERT INTO `edu_footprint` VALUES ('1309493875988918273', '1309429625126019073', 1, '2020-09-25 22:04:04', '1305178473148534786');
INSERT INTO `edu_footprint` VALUES ('1309504035515953154', '1309429625126019073', 0, '2020-09-25 22:44:26', '1309504034983276545');

-- ----------------------------
-- Table structure for edu_subject
-- ----------------------------
DROP TABLE IF EXISTS `edu_subject`;
CREATE TABLE `edu_subject`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程类别ID',
  `title` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '类别名称',
  `parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序字段',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_parent_id`(`parent_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程科目' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of edu_subject
-- ----------------------------
INSERT INTO `edu_subject` VALUES ('1178214681118568449', '后端开发', '0', 1, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681139539969', 'Java', '1178214681118568449', 1, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681181483010', '前端开发', '0', 3, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681210843137', 'JavaScript', '1178214681181483010', 4, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681231814658', '云计算', '0', 5, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681252786178', 'Docker', '1178214681231814658', 5, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681294729217', 'Linux', '1178214681231814658', 6, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681324089345', '系统/运维', '0', 7, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681353449473', 'Linux', '1178214681324089345', 7, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681382809602', 'Windows', '1178214681324089345', 8, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681399586817', '数据库', '0', 9, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681428946945', 'MySQL', '1178214681399586817', 9, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681454112770', 'MongoDB', '1178214681399586817', 10, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681483472898', '大数据', '0', 11, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681504444418', 'Hadoop', '1178214681483472898', 11, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681529610242', 'Spark', '1178214681483472898', 12, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681554776066', '人工智能', '0', 13, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681584136193', 'Python', '1178214681554776066', 13, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681613496321', '编程语言', '0', 14, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178214681626079234', 'Java', '1178214681613496321', 14, '2019-09-29 15:47:25', '2019-09-29 15:47:25');
INSERT INTO `edu_subject` VALUES ('1178585108407984130', 'Python', '1178214681118568449', 2, '2019-09-30 16:19:22', '2019-09-30 16:19:22');
INSERT INTO `edu_subject` VALUES ('1178585108454121473', 'HTML/CSS', '1178214681181483010', 3, '2019-09-30 16:19:22', '2019-09-30 16:19:22');
INSERT INTO `edu_subject` VALUES ('1297814409141288962', '前端', '0', 0, '2020-08-24 16:34:02', '2020-08-24 16:34:02');
INSERT INTO `edu_subject` VALUES ('1297814409413918722', 'Vue', '1297814409141288962', 0, '2020-08-24 16:34:02', '2020-08-24 16:34:02');
INSERT INTO `edu_subject` VALUES ('1297814409724297217', '爬虫', '0', 0, '2020-08-24 16:34:02', '2020-08-24 16:34:02');
INSERT INTO `edu_subject` VALUES ('1297814409980149761', 'Python', '1297814409724297217', 0, '2020-08-24 16:34:02', '2020-08-24 16:34:02');
INSERT INTO `edu_subject` VALUES ('1297868578892095489', 'java', '1297814409724297217', 0, '2020-08-24 20:09:17', '2020-08-24 20:09:17');
INSERT INTO `edu_subject` VALUES ('1309175528797700097', 'Java', '1178214681483472898', 0, '2020-09-25 00:59:04', '2020-09-25 00:59:04');

-- ----------------------------
-- Table structure for edu_teacher
-- ----------------------------
DROP TABLE IF EXISTS `edu_teacher`;
CREATE TABLE `edu_teacher`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '讲师ID',
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '讲师姓名',
  `intro` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '讲师简介',
  `career` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '讲师资历,一句话说明讲师',
  `level` int(10) UNSIGNED NOT NULL COMMENT '头衔 1高级讲师 2首席讲师',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '讲师头像',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '讲师' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of edu_teacher
-- ----------------------------
INSERT INTO `edu_teacher` VALUES ('1189389726308478977', '晴天', '高级讲师简介', '高级讲师资历', 2, 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/de47ee9b-7fec-43c5-8173-13c5f7f689b2.png', 1, 0, '2019-10-30 11:53:03', '2019-10-30 11:53:03');
INSERT INTO `edu_teacher` VALUES ('1189390295668469762', '李刚', '高级讲师简介', '高级讲师', 2, 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/b8aa36a2-db50-4eca-a6e3-cc6e608355e0.png', 2, 0, '2019-10-30 11:55:19', '2019-11-12 13:37:52');
INSERT INTO `edu_teacher` VALUES ('1189426437876985857', '王二', '高级讲师简介', '高级讲师', 1, 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/11/08/e44a2e92-2421-4ea3-bb49-46f2ec96ef88.png', 0, 0, '2019-10-30 14:18:56', '2019-11-12 13:37:35');
INSERT INTO `edu_teacher` VALUES ('1189426464967995393', '王五', '高级讲师简介', '高级讲师', 1, 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/10/30/65423f14-49a9-4092-baf5-6d0ef9686a85.png', 0, 0, '2019-10-30 14:19:02', '2019-11-12 13:37:18');
INSERT INTO `edu_teacher` VALUES ('1192249914833055746', '李四', '高级讲师简介', '高级讲师', 1, 'https://online-teach-file.oss-cn-beijing.aliyuncs.com/teacher/2019/11/07/91871e25-fd83-4af6-845f-ea8d471d825d.png', 0, 0, '2019-11-07 09:18:25', '2019-11-12 13:37:01');
INSERT INTO `edu_teacher` VALUES ('1192327476087115778', '1222-12-12', '1111', '11', 1, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/20/3882f38e8932426b906d5ab9327c3924file.png', 0, 1, '2019-11-07 14:26:37', '2019-11-11 16:26:26');
INSERT INTO `edu_teacher` VALUES ('1296049640797384705', '林加浩', '撒大苏打', '本科', 1, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/20/3882f38e8932426b906d5ab9327c3924file.png', 1, 0, '2020-08-19 19:41:28', '2020-08-20 22:34:23');
INSERT INTO `edu_teacher` VALUES ('1296050159305732098', '蔺离石', '飒飒', '不是不是', 1, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/28/6162b77353b44de09657af74fed4c44dfile.png', 0, 0, '2020-08-19 19:43:32', '2020-09-28 13:54:06');
INSERT INTO `edu_teacher` VALUES ('1309175128354914305', 'ljhsss', 'sdasdsdasd', 'sdfsasd', 2, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/2984bc0749204e0b93c420f3ec70bcf0file.png', 3, 0, '2020-09-25 00:57:29', '2020-09-25 00:57:29');
INSERT INTO `edu_teacher` VALUES ('1309518002481201154', 'AD', '多年从事心理咨询工作，为近百家企业培养优秀的管理人才', '国内资深心灵导师，企业资深团队训练师', 1, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/7509905ea3f7423aa9af325a34233394file.png', 1, 0, '2020-09-25 23:39:56', '2020-09-25 23:39:56');

-- ----------------------------
-- Table structure for edu_video
-- ----------------------------
DROP TABLE IF EXISTS `edu_video`;
CREATE TABLE `edu_video`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '视频ID',
  `course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '课程ID',
  `chapter_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '章节ID',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '节点名称',
  `video_source_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '云端视频资源',
  `video_original_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始文件名称',
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序字段',
  `play_count` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '播放次数',
  `is_free` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否可以试听：0收费 1免费',
  `duration` float NOT NULL DEFAULT 0 COMMENT '视频时长（秒）',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Empty' COMMENT 'Empty未上传 Transcoding转码中  Normal正常',
  `size` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '视频源文件大小（字节）',
  `version` bigint(20) UNSIGNED NOT NULL DEFAULT 1 COMMENT '乐观锁',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_course_id`(`course_id`) USING BTREE,
  INDEX `idx_chapter_id`(`chapter_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '课程视频' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of edu_video
-- ----------------------------
INSERT INTO `edu_video` VALUES ('1182499307429339137', '18', '32', '第一节', '', '', 0, 0, 1, 0, '', 0, 1, '2019-10-11 11:32:59', '2019-10-11 11:57:38');
INSERT INTO `edu_video` VALUES ('1185312444399071234', '14', '1', '12', '', '', 0, 0, 0, 0, 'Empty', 0, 1, '2019-10-19 05:51:23', '2019-10-19 05:51:33');
INSERT INTO `edu_video` VALUES ('1189434737808990210', '18', '44', '测试', '', '', 1, 0, 0, 0, 'Empty', 0, 1, '2019-10-30 14:51:55', '2019-10-30 14:51:55');
INSERT INTO `edu_video` VALUES ('1189471423678939138', '18', '1181729226915577857', 'test', '2b887dc9584d4dc68908780ec57cd3b9', '视频', 1, 0, 0, 0, 'Empty', 0, 1, '2019-10-30 17:17:41', '2019-10-30 17:17:41');
INSERT INTO `edu_video` VALUES ('1189476403626409986', '18', '1181729226915577857', '22', '5155c73dc112475cbbddccf4723f7cef', '视频.mp4', 0, 0, 0, 0, 'Empty', 0, 1, '2019-10-30 17:37:29', '2019-10-30 17:37:29');
INSERT INTO `edu_video` VALUES ('1192252824606289921', '1192252213659774977', '1192252428399751169', '第一课时', '756cf06db9cb4f30be85a9758b19c645', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 0, 0, 0, 0, 'Empty', 0, 1, '2019-11-07 09:29:59', '2019-11-07 09:29:59');
INSERT INTO `edu_video` VALUES ('1192628092797730818', '1192252213659774977', '1192252428399751169', '第二课时', '2a02d726622f4c7089d44cb993c531e1', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 0, 0, 1, 0, 'Empty', 0, 1, '2019-11-08 10:21:10', '2019-11-08 10:21:22');
INSERT INTO `edu_video` VALUES ('1192632495013380097', '1192252213659774977', '1192252428399751169', '第三课时', '4e560c892fdf4fa2b42e0671aa42fa9d', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 0, 0, 1, 0, 'Empty', 0, 1, '2019-11-08 10:38:40', '2019-11-08 10:38:40');
INSERT INTO `edu_video` VALUES ('1194117638832111617', '1192252213659774977', '1192252428399751169', '第四课时', '4e560c892fdf4fa2b42e0671aa42fa9d', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 0, 0, 0, 0, 'Empty', 0, 1, '2019-11-12 13:00:05', '2019-11-12 13:00:05');
INSERT INTO `edu_video` VALUES ('1196263770832023554', '1192252213659774977', '1192252428399751169', '第五课时', '27d21158b0834cb5a8d50710937de330', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 5, 0, 0, 0, 'Empty', 0, 1, '2019-11-18 11:08:03', '2019-11-18 11:08:03');
INSERT INTO `edu_video` VALUES ('1298907288857292801', '1298907209765302273', '1298907249237897218', 'java入门', '', NULL, 1, 0, 0, 0, 'Empty', 0, 1, '2020-08-27 16:56:45', '2020-08-27 16:56:45');
INSERT INTO `edu_video` VALUES ('1300016836145901569', '1299309945119875074', '1299309978389094402', 'javaweb', 'a8d65e8d94974a6cb16f0c4b60867be7', '6 - What If I Want to Move Faster.mp4', 1, 1, 1, 0, 'Empty', 0, 1, '2020-08-30 18:25:42', '2020-08-30 18:37:21');
INSERT INTO `edu_video` VALUES ('1300018324893134850', '1299309945119875074', '1299309978389094402', 'java555555', 'ada8373ca258481b83fc294b8ce288cc', '6 - What If I Want to Move Faster.mp4', 2, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 18:31:36', '2020-08-30 18:34:38');
INSERT INTO `edu_video` VALUES ('1300021802407358465', '1299309945119875074', '1299309978389094402', '收到贵司的', '83ff7131e6d44fc8bc7a3330ec946098', '6 - What If I Want to Move Faster.mp4', 3, 1, 1, 0, 'Empty', 0, 1, '2020-08-30 18:45:26', '2020-08-30 18:45:26');
INSERT INTO `edu_video` VALUES ('1300045482839568385', '1300045350794489858', '', 'javweb', 'a6e8b1835ac64d8193a86b14e9c6670a', '6 - What If I Want to Move Faster.mp4', 1, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:19:31', '2020-08-30 20:19:31');
INSERT INTO `edu_video` VALUES ('1300045755192504321', '1300045350794489858', '1300045384529276930', 'javaweb', '3e8816164c1247fe8cf874211c443da0', '6 - What If I Want to Move Faster.mp4', 2, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:20:36', '2020-08-30 20:20:36');
INSERT INTO `edu_video` VALUES ('1300045898503483393', '1300045350794489858', '1300045384529276930', '实际就是', 'd6e14c58b5a9401e9c53d8a2db9d6fa8', '6 - What If I Want to Move Faster.mp4', 2, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:21:11', '2020-08-30 20:21:11');
INSERT INTO `edu_video` VALUES ('1300046080959901698', '1300045350794489858', '1300045384529276930', '的方式', '', '', 3, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:21:54', '2020-08-30 20:21:54');
INSERT INTO `edu_video` VALUES ('1300048124550635521', '1300045350794489858', '1300045384529276930', '发给第三方', '', '', 4, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:30:01', '2020-08-30 20:30:01');
INSERT INTO `edu_video` VALUES ('1300051125323460609', '1300045350794489858', '1300045384529276930', '的风格但是', '9d9b96cbaa964c91a565e88e9988821c', '6 - What If I Want to Move Faster.mp4', 5, 0, 0, 0, 'Empty', 0, 1, '2020-08-30 20:41:57', '2020-08-30 20:41:57');
INSERT INTO `edu_video` VALUES ('17', '18', '15', '第一节：Java简介', '196116a6fee742e1ba9f6c18f65bd8c1', '1', 1, 1000, 1, 100, 'Draft', 0, 1, '2019-01-01 13:08:57', '2019-10-11 11:26:39');
INSERT INTO `edu_video` VALUES ('18', '18', '15', '第二节：表达式和赋值语句', '2d99b08ca0214909899910c9ba042d47', '7 - How Do I Find Time for My ', 2, 999, 1, 100, 'Draft', 0, 1, '2019-01-01 13:09:02', '2019-03-08 03:30:27');
INSERT INTO `edu_video` VALUES ('19', '18', '15', '第三节：String类', '51120d59ddfd424cb5ab08b44fc8b23a', 'eae2b847ef8503b81f5d5593d769dde2.mp4', 3, 888, 0, 100, 'Draft', 0, 1, '2019-01-01 13:09:05', '2019-11-12 12:50:45');
INSERT INTO `edu_video` VALUES ('20', '18', '15', '第四节：程序风格', '2a38988892d84df598752226c50f3fa3', '00-day10总结.avi', 4, 666, 0, 100, 'Draft', 0, 1, '2019-01-01 13:09:05', '2019-10-11 09:20:09');

-- ----------------------------
-- Table structure for friends
-- ----------------------------
DROP TABLE IF EXISTS `friends`;
CREATE TABLE `friends`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `friend_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gmt_creat` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of friends
-- ----------------------------
INSERT INTO `friends` VALUES ('1302669158068101122', '1309429625126019073', NULL, '2020-11-18 14:15:44');
INSERT INTO `friends` VALUES ('1309429625126019073', '1302669158068101122', NULL, '2020-11-18 14:15:44');
INSERT INTO `friends` VALUES ('1309429625126019073', '1195187659054329857', NULL, '2020-11-18 15:29:27');
INSERT INTO `friends` VALUES ('1195187659054329857', '1309429625126019073', NULL, '2020-11-18 15:29:27');

-- ----------------------------
-- Table structure for friends_ask
-- ----------------------------
DROP TABLE IF EXISTS `friends_ask`;
CREATE TABLE `friends_ask`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `send_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `get_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gmt_create` datetime(0) NULL DEFAULT NULL,
  `gmt_modified` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for online_live
-- ----------------------------
DROP TABLE IF EXISTS `online_live`;
CREATE TABLE `online_live`  (
  `id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `member_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `live_title` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `push_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gmt_create` datetime(0) NOT NULL,
  `gmt_modified` datetime(0) NOT NULL,
  `introduce` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `watch_ip` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` tinyint(10) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of online_live
-- ----------------------------
INSERT INTO `online_live` VALUES ('1307681969135435777', '1302669158068101122', 'Java', 'http://linjiahao.xyz/live/123.flv', '2020-09-20 22:04:12', '2020-09-20 22:04:12', '撒旦达到', '123', 'http://linjiahao.xyz/live/123.m3u8', 0);

-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `order_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `course_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '课程id',
  `course_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程名称',
  `course_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '课程封面',
  `teacher_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '讲师名称',
  `member_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '会员id',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会员手机',
  `total_fee` decimal(10, 2) NULL DEFAULT 0.01 COMMENT '订单金额（分）',
  `pay_type` tinyint(3) NULL DEFAULT NULL COMMENT '支付类型（1：微信 2：支付宝）',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '订单状态',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `ux_order_no`(`order_no`) USING BTREE,
  INDEX `idx_course_id`(`course_id`) USING BTREE,
  INDEX `idx_member_id`(`member_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '订单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_order
-- ----------------------------
INSERT INTO `t_order` VALUES ('1303305253332008962', '20200908201241536', '1192252213659774977', 'java基础课程：test', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 'test', '1302669158068101122', '小块坐', '', 0.01, 1, '支付成功', 0, '2020-09-08 20:12:41', '2020-09-08 20:16:55');
INSERT INTO `t_order` VALUES ('1303307955239731201', '20200908202325527', '1300045350794489858', '测试java', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 'test', '1302669158068101122', '小块坐', '', 0.01, 1, '支付成功', 0, '2020-09-08 20:23:25', '2020-09-08 20:23:42');
INSERT INTO `t_order` VALUES ('1303325440844324865', '20200908213253781', '1299309945119875074', 'javaweb', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 'test', '1302669158068101122', '小块坐', '', 0.01, 1, '支付成功', 0, '2020-09-08 21:32:54', '2020-09-08 21:33:23');
INSERT INTO `t_order` VALUES ('1309202198078341122', '20200925024502843', '1192252213659774977', 'java基础课程：test', 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/08/27/29ba1226697b418980c870969f7151641.jpg', 'test', '1309199581816446978', 'ljh', '18200891281', 0.01, 1, '支付成功', 0, '2020-09-25 02:45:02', '2020-09-25 02:45:29');

-- ----------------------------
-- Table structure for t_pay_log
-- ----------------------------
DROP TABLE IF EXISTS `t_pay_log`;
CREATE TABLE `t_pay_log`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `order_no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单号',
  `pay_time` datetime(0) NULL DEFAULT NULL COMMENT '支付完成时间',
  `total_fee` decimal(10, 2) NULL DEFAULT 0.01 COMMENT '支付金额（分）',
  `transaction_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易流水号',
  `trade_state` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '交易状态',
  `pay_type` tinyint(3) NOT NULL DEFAULT 0 COMMENT '支付类型（1：微信 2：支付宝）',
  `attr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '其他属性',
  `is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_order_no`(`order_no`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '支付日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_pay_log
-- ----------------------------
INSERT INTO `t_pay_log` VALUES ('1309202311748173825', '20200925024502843', '2020-09-25 02:45:30', 0.01, '4200000758202009256533890898', 'SUCCESS', 1, '{\"transaction_id\":\"4200000758202009256533890898\",\"nonce_str\":\"SYyB8I4B2Mm0Oy6J\",\"trade_state\":\"SUCCESS\",\"bank_type\":\"OTHERS\",\"openid\":\"oHwsHuHKnybteEoUUypy7LWs8S5o\",\"sign\":\"E5D954E916A9C2DA9359CB74BF0ACFAD\",\"return_msg\":\"OK\",\"fee_type\":\"CNY\",\"mch_id\":\"1558950191\",\"cash_fee\":\"1\",\"out_trade_no\":\"20200925024502843\",\"cash_fee_type\":\"CNY\",\"appid\":\"wx74862e0dfcf69954\",\"total_fee\":\"1\",\"trade_state_desc\":\"支付成功\",\"trade_type\":\"NATIVE\",\"result_code\":\"SUCCESS\",\"attach\":\"\",\"time_end\":\"20200925024526\",\"is_subscribe\":\"N\",\"return_code\":\"SUCCESS\"}', 0, '2020-09-25 02:45:30', '2020-09-25 02:45:30');

-- ----------------------------
-- Table structure for ucenter_member
-- ----------------------------
DROP TABLE IF EXISTS `ucenter_member`;
CREATE TABLE `ucenter_member`  (
  `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '会员id',
  `openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '微信openid',
  `mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码',
  `nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `sex` tinyint(2) UNSIGNED NULL DEFAULT NULL COMMENT '性别 1 女，2 男',
  `age` tinyint(3) UNSIGNED NULL DEFAULT NULL COMMENT '年龄',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户头像',
  `sign` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户签名',
  `is_disabled` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否禁用 1（true）已禁用，  0（false）未禁用',
  `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime(0) NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime(0) NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会员表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of ucenter_member
-- ----------------------------
INSERT INTO `ucenter_member` VALUES ('1', NULL, '13700000001', '96e79218965eb72c92a549dd5a330112', '小三123', 1, 5, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-01 12:11:33', '2019-11-08 11:56:01');
INSERT INTO `ucenter_member` VALUES ('1080736474267144193', NULL, '13700000011', '96e79218965eb72c92a549dd5a330112', '用户XJtDfaYeKk', 1, 19, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-02 12:12:45', '2019-01-02 12:12:56');
INSERT INTO `ucenter_member` VALUES ('1080736474355224577', NULL, '13700000002', '96e79218965eb72c92a549dd5a330112', '用户wUrNkzAPrc', 1, 27, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-02 12:13:56', '2019-01-02 12:14:07');
INSERT INTO `ucenter_member` VALUES ('1086387099449442306', NULL, '13520191388', '96e79218965eb72c92a549dd5a330112', '用户XTMUeHDAoj', 2, 20, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099520745473', NULL, '13520191389', '96e79218965eb72c92a549dd5a330112', '用户vSdKeDlimn', 1, 21, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099608825858', NULL, '13520191381', '96e79218965eb72c92a549dd5a330112', '用户EoyWUVXQoP', 1, 18, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099701100545', NULL, '13520191382', '96e79218965eb72c92a549dd5a330112', '用户LcAYbxLNdN', 2, 24, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099776598018', NULL, '13520191383', '96e79218965eb72c92a549dd5a330112', '用户dZdjcgltnk', 2, 25, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1086387099852095490', NULL, '13520191384', '96e79218965eb72c92a549dd5a330112', '用户wNHGHlxUwX', 2, 23, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-01-19 06:17:23', '2019-01-19 06:17:23');
INSERT INTO `ucenter_member` VALUES ('1106746895272849410', 'o1R-t5u2TfEVeVjO9CPGdHPNw-to', NULL, NULL, '檀梵\'', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/zZfLXcetf2Rpsibq6HbPUWKgWSJHtha9y1XBeaqluPUs6BYicW1FJaVqj7U3ozHd3iaodGKJOvY2PvqYTuCKwpyfQ/132', NULL, 0, 0, '2019-03-16 10:39:57', '2019-03-16 10:39:57');
INSERT INTO `ucenter_member` VALUES ('1106822699956654081', NULL, NULL, NULL, NULL, NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-03-16 15:41:10', '2019-03-16 15:41:10');
INSERT INTO `ucenter_member` VALUES ('1106823035660357634', 'o1R-t5i4gENwHYRb5lVFy98Z0bdk', NULL, NULL, 'GaoSir', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJI53RcCuc1no02os6ZrattWGiazlPnicoZQ59zkS7phNdLEWUPDk8fzoxibAnXV1Sbx0trqXEsGhXPw/132', NULL, 0, 0, '2019-03-16 15:42:30', '2019-03-16 15:42:30');
INSERT INTO `ucenter_member` VALUES ('1106823041599492098', NULL, NULL, NULL, NULL, NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-03-16 15:42:32', '2019-03-16 15:42:32');
INSERT INTO `ucenter_member` VALUES ('1106823115788341250', 'o1R-t5l_3rnbZbn4jWwFdy6Gk6cg', NULL, NULL, '换个网名哇、', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/jJHyeM0EN2jhB70LntI3k8fEKe7W6CwykrKMgDJM4VZqCpcxibVibX397p0vmbKURGkLS4jxjGB0GpZfxCicgt07w/132', NULL, 0, 0, '2019-03-16 15:42:49', '2019-03-16 15:42:49');
INSERT INTO `ucenter_member` VALUES ('1106826046730227714', 'o1R-t5gyxumyBqt0CWcnh0S6Ya1g', NULL, NULL, '我是Helen', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKDRfib8wy7A2ltERKh4VygxdjVC1x5OaOb1t9hot4JNt5agwaVLdJLcD9vJCNcxkvQnlvLYIPfrZw/132', NULL, 0, 0, '2019-03-16 15:54:28', '2019-03-16 15:54:28');
INSERT INTO `ucenter_member` VALUES ('1106828185829490690', 'o1R-t5nNlou5lRwBVgGNJFm4rbc4', NULL, NULL, ' 虎头', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTKxCqRzuYWQmpwiaqQEjNxbC7WicebicXQusU306jgmfoOzUcFg1qaDq5BStiblwBjw5dUOblQ2gUicQOQ/132', NULL, 0, 0, '2019-03-16 16:02:58', '2019-03-16 16:02:58');
INSERT INTO `ucenter_member` VALUES ('1106830599651442689', 'o1R-t5hZHQB1cbX7HZJsiM727_SA', NULL, NULL, '是吴啊', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJ9CsqApybcs7f3Dyib9IxIh0sBqJb7LicbjU4WticJFF0PVwFvHgtbFdBwfmk3H2t3NyqmEmVx17tRA/132', NULL, 0, 0, '2019-03-16 16:12:34', '2019-03-16 16:12:34');
INSERT INTO `ucenter_member` VALUES ('1106830976199278593', 'o1R-t5meKOoyEJ3-IhWRCBKFcvzU', NULL, NULL, '我才是Helen', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83epMicP9UT6mVjYWdno0OJZkOXiajG0sllJTbGJ9DYiceej2XvbDSGCK8LCF7jv1PuG2uoYlePWic9XO8A/132', NULL, 0, 0, '2019-03-16 16:14:03', '2019-03-16 16:14:03');
INSERT INTO `ucenter_member` VALUES ('1106831936900415490', 'o1R-t5jXYSWakGtnUBnKbfVT5Iok', NULL, NULL, '文若姬', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/3HEmJwpSzguqqAyzmBwqT6aicIanswZibEOicQInQJI3ZY1qmu59icJC6N7SahKqWYv24GvX5KH2fibwt0mPWcTJ3fg/132', NULL, 0, 0, '2019-03-16 16:17:52', '2019-03-16 16:17:52');
INSERT INTO `ucenter_member` VALUES ('1106832491064442882', 'o1R-t5sud081Qsa2Vb2xSKgGnf_g', NULL, NULL, 'Peanut', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-03-16 16:20:04', '2019-03-16 16:20:04');
INSERT INTO `ucenter_member` VALUES ('1106833021442510849', 'o1R-t5lsGc3I8P5bDpHj7m_AIRvQ', NULL, NULL, '食物链终结者', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/MQ7qUmCprK9am16M1Ia1Cs3RK0qiarRrl9y8gsssBjIZeS2GwKSrnq7ZYhmrzuzDwBxSMMAofrXeLic9IBlW4M3Q/132', NULL, 0, 0, '2019-03-16 16:22:11', '2019-03-16 16:22:11');
INSERT INTO `ucenter_member` VALUES ('1191600824445046786', NULL, '15210078344', '96e79218965eb72c92a549dd5a330112', 'IT妖姬', 1, 5, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-11-05 14:19:10', '2019-11-08 18:04:43');
INSERT INTO `ucenter_member` VALUES ('1191616288114163713', NULL, '17866603606', 'e10adc3949ba59abbe56e057f20f883e', 'xiaowu', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-11-05 15:20:37', '2019-11-05 15:20:37');
INSERT INTO `ucenter_member` VALUES ('1195187659054329857', NULL, '15010546384', 'e10adc3949ba59abbe56e057f20f883e', 'qy', NULL, NULL, 'http://thirdwx.qlogo.cn/mmopen/vi_32/DYAIOgq83eoj0hHXhgJNOTSOFsS4uZs8x1ConecaVOB8eIl115xmJZcT4oCicvia7wMEufibKtTLqiaJeanU2Lpg3w/132', NULL, 0, 0, '2019-11-15 11:51:58', '2019-11-15 11:51:58');
INSERT INTO `ucenter_member` VALUES ('1302669158068101122', 'o3_SC5yAru5Xa3RCvdg12AHMX_QI', '18200891251', 'e10adc3949ba59abbe56e057f20f883e', '林加浩', 2, 23, 'http://thirdwx.qlogo.cn/mmopen/vi_32/EMZ1niaYzY7kbeLGE8zB4nNsXvsCZ0qIj89FLBbLvaQzacb58TGw6avv98B1DHgJicuiauIC210c4Mh3SiapbI4t3g/132', '哈哈哈哈哈', 0, 0, '2020-09-07 02:05:04', '2020-09-11 21:06:25');
INSERT INTO `ucenter_member` VALUES ('1309429625126019073', NULL, '18200891281', 'e10adc3949ba59abbe56e057f20f883e', 'ljh', 2, 22, 'http://ljh-online-education.oss-cn-shenzhen.aliyuncs.com/2020/09/25/43bce00ca935497ca44a4beba9829b451.jpg', 'jsjhdh', 0, 0, '2020-09-25 17:48:45', '2020-09-25 22:59:15');
INSERT INTO `ucenter_member` VALUES ('1328986828384096258', 'o3_SC55W3fc_dNeH2lpxkMUngHqQ', '', 'e10adc3949ba59abbe56e057f20f883e', 'Nacl_', NULL, NULL, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTI2PXYfK6MiaOe2DTBI9W1XLZxjqjC1m2y6DDWVLpRhAjjm4eQfkuLu7oI8q7utKYmsrMicsgGDiaYSw/132', NULL, 0, 0, '2020-11-18 17:02:06', '2020-11-18 17:02:06');

SET FOREIGN_KEY_CHECKS = 1;