代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 80016
Source Host : localhost:3306
Source Database : guli
Target Server Type : MYSQL
Target Server Version : 80016
File Encoding : 65001
Date: 2021-05-06 09:03:01
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `acl_permission`
-- ----------------------------
DROP TABLE IF EXISTS `acl_permission`;
CREATE TABLE `acl_permission` (
`id` char(19) NOT NULL DEFAULT '' COMMENT '编号',
`pid` char(19) NOT NULL DEFAULT '' COMMENT '所属上级',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
`type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '类型(1:菜单,2:按钮)',
`permission_value` varchar(50) DEFAULT NULL COMMENT '权限值',
`path` varchar(100) DEFAULT NULL COMMENT '访问路径',
`component` varchar(100) DEFAULT NULL COMMENT '组件路径',
`icon` varchar(50) DEFAULT NULL COMMENT '图标',
`status` tinyint(4) DEFAULT NULL COMMENT '状态(0:禁止,1:正常)',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime DEFAULT NULL COMMENT '创建时间',
`gmt_modified` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限';
-- ----------------------------
-- Records of acl_permission
-- ----------------------------
-- ----------------------------
-- Table structure for `acl_role`
-- ----------------------------
DROP TABLE IF EXISTS `acl_role`;
CREATE TABLE `acl_role` (
`id` char(19) NOT NULL DEFAULT '' COMMENT '角色id',
`role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称',
`role_code` varchar(20) DEFAULT NULL COMMENT '角色编码',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of acl_role
-- ----------------------------
-- ----------------------------
-- Table structure for `acl_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `acl_role_permission`;
CREATE TABLE `acl_role_permission` (
`id` char(19) NOT NULL DEFAULT '',
`role_id` char(19) NOT NULL DEFAULT '',
`permission_id` char(19) NOT NULL DEFAULT '',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_permission_id` (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限';
-- ----------------------------
-- Records of acl_role_permission
-- ----------------------------
-- ----------------------------
-- Table structure for `acl_user`
-- ----------------------------
DROP TABLE IF EXISTS `acl_user`;
CREATE TABLE `acl_user` (
`id` char(19) NOT NULL COMMENT '会员id',
`username` varchar(20) NOT NULL DEFAULT '' COMMENT '微信openid',
`password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码',
`nick_name` varchar(50) DEFAULT NULL COMMENT '昵称',
`salt` varchar(255) DEFAULT NULL COMMENT '用户头像',
`token` varchar(100) DEFAULT NULL COMMENT '用户签名',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';
-- ----------------------------
-- Records of acl_user
-- ----------------------------
-- ----------------------------
-- Table structure for `acl_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `acl_user_role`;
CREATE TABLE `acl_user_role` (
`id` char(19) NOT NULL DEFAULT '' COMMENT '主键id',
`role_id` char(19) NOT NULL DEFAULT '0' COMMENT '角色id',
`user_id` char(19) NOT NULL DEFAULT '0' COMMENT '用户id',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of acl_user_role
-- ----------------------------
-- ----------------------------
-- Table structure for `crm_banner`
-- ----------------------------
DROP TABLE IF EXISTS `crm_banner`;
CREATE TABLE `crm_banner` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT 'ID',
`title` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '标题',
`image_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '图片地址',
`link_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_name` (`title`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='首页banner表';
-- ----------------------------
-- Records of crm_banner
-- ----------------------------
INSERT INTO `crm_banner` VALUES ('1194556896025845762', 'test1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/timg.png', '/course', '1', '0', '2019-11-13 18:05:32', '2019-11-18 10:28:22');
INSERT INTO `crm_banner` VALUES ('1194607458461216769', 'test2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/timg.png', '/teacher', '2', '0', '2019-11-13 21:26:27', '2019-11-14 09:12:15');
-- ----------------------------
-- Table structure for `edu_chapter`
-- ----------------------------
DROP TABLE IF EXISTS `edu_chapter`;
CREATE TABLE `edu_chapter` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '章节ID',
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程ID',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '章节名称',
`file_address` varchar(255) DEFAULT NULL,
`file_original_name` varchar(100) DEFAULT NULL,
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示排序',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_course_id` (`course_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='课程';
-- ----------------------------
-- Records of edu_chapter
-- ----------------------------
INSERT INTO `edu_chapter` VALUES ('1290213273794273282', '1280539862470008833', '第一章', null, null, '1', '2020-08-03 09:09:50', '2020-08-03 09:09:50');
INSERT INTO `edu_chapter` VALUES ('1290213310259552258', '1280539862470008833', '第二章', null, null, '2', '2020-08-03 09:09:59', '2020-08-03 09:09:59');
INSERT INTO `edu_chapter` VALUES ('1290213344568958978', '1280539862470008833', '第三章', null, null, '3', '2020-08-03 09:10:07', '2020-08-03 09:10:07');
INSERT INTO `edu_chapter` VALUES ('1329337718257229826', '1280539498081460225', '第一章', null, null, '0', '2020-11-19 08:16:25', '2020-11-19 08:16:25');
INSERT INTO `edu_chapter` VALUES ('1329337748091314178', '1280539498081460225', '第二章', null, null, '0', '2020-11-19 08:16:32', '2020-11-19 08:16:32');
INSERT INTO `edu_chapter` VALUES ('1331428439651000322', '1331428351889383426', '第一章 什么是线程池', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/04/24/2031bb2293154762993d95ba026bf2bd1993028469669.pdf', '1993028469669.pdf', '1', '2020-11-25 02:44:11', '2021-04-24 14:05:29');
INSERT INTO `edu_chapter` VALUES ('1355056338761175042', '1331428351889383426', '第二章 线程池的运行过程', null, null, '2', '2021-01-29 07:33:02', '2021-01-29 07:33:11');
INSERT INTO `edu_chapter` VALUES ('1355159245124804609', '1355159175214145538', '第一章 擎天柱', null, null, '2', '2021-01-29 14:21:56', '2021-01-29 14:21:56');
-- ----------------------------
-- Table structure for `edu_comment`
-- ----------------------------
DROP TABLE IF EXISTS `edu_comment`;
CREATE TABLE `edu_comment` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '讲师ID',
`course_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '课程id',
`teacher_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '讲师id',
`member_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '会员id',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '会员昵称',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '会员头像',
`content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '评论内容',
`is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_course_id` (`course_id`) USING BTREE,
KEY `idx_teacher_id` (`teacher_id`) USING BTREE,
KEY `idx_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='评论';
-- ----------------------------
-- Records of edu_comment
-- ----------------------------
INSERT INTO `edu_comment` VALUES ('1194499162790211585', '1280539862470008833', '1189389726308478977', '1', '小三123', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '课程很好', '0', '2019-11-13 14:16:08', '2019-11-13 14:16:08');
INSERT INTO `edu_comment` VALUES ('1194898406466420738', '1280539862470008833', '1189389726308478977', '1', '小三123', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '11', '0', '2019-11-14 16:42:35', '2019-11-14 16:42:35');
INSERT INTO `edu_comment` VALUES ('1194898484388200450', '1280539862470008833', '1189389726308478977', '1', '小三123', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '111', '0', '2019-11-14 16:42:53', '2019-11-14 16:42:53');
INSERT INTO `edu_comment` VALUES ('1195251020861317122', '1280539862470008833', '1189389726308478977', '1', null, 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '2233', '0', '2019-11-15 16:03:45', '2019-11-15 16:03:45');
INSERT INTO `edu_comment` VALUES ('1195251382720700418', '1280539862470008833', '1189389726308478977', '1', null, 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '4455', '0', '2019-11-15 16:05:11', '2019-11-15 16:05:11');
INSERT INTO `edu_comment` VALUES ('1195252819177570306', '1280539862470008833', '1189389726308478977', '1', '小三1231', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '55', '0', '2019-11-15 16:10:53', '2019-11-15 16:10:53');
INSERT INTO `edu_comment` VALUES ('1195252899448160258', '1280539862470008833', '1189389726308478977', '1', '小三1231', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '55', '0', '2019-11-15 16:11:13', '2019-11-15 16:11:13');
INSERT INTO `edu_comment` VALUES ('1195252920587452417', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '223344', '0', '2019-11-15 16:11:18', '2019-11-15 16:11:18');
INSERT INTO `edu_comment` VALUES ('1195262128095559681', '14', '1189389726308478977', '1', '小三1231', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '11', '0', '2019-11-15 16:47:53', '2019-11-15 16:47:53');
INSERT INTO `edu_comment` VALUES ('1196264505170767874', '1192252213659774977', '1189389726308478977', '1', '小三1231', 'https://ss0.bdstatic.com/70cFvHSh_Q1YnxGkpoWK1HF6hhy/it/u=3426236326,3401384550&fm=11&gp=0.jpg', '666666', '0', '2019-11-18 11:10:58', '2019-11-18 11:10:58');
INSERT INTO `edu_comment` VALUES ('1335489395863592961', '1280539862470008833', '', '', 'tttt', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '123456', '0', '2020-12-06 07:40:59', '2020-12-06 07:40:59');
INSERT INTO `edu_comment` VALUES ('1335490181930696705', '1280539862470008833', '', '1330805257311150081', 'xxx', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '123456', '0', '2020-12-06 07:44:06', '2020-12-06 07:44:06');
INSERT INTO `edu_comment` VALUES ('1335490766776057857', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '456', '0', '2020-12-06 07:46:26', '2020-12-06 07:46:26');
INSERT INTO `edu_comment` VALUES ('1335490811067908097', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/11/25/avatar-boy.png', '', '0', '2020-12-06 07:46:36', '2020-12-06 07:46:36');
INSERT INTO `edu_comment` VALUES ('1335492584188952577', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', '', '0', '2020-12-06 07:53:39', '2020-12-06 07:53:39');
INSERT INTO `edu_comment` VALUES ('1335492842742628354', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', '741', '0', '2020-12-06 07:54:41', '2020-12-06 07:54:41');
INSERT INTO `edu_comment` VALUES ('1335854833910992898', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', 'test评论', '0', '2020-12-07 07:53:06', '2020-12-07 07:53:06');
INSERT INTO `edu_comment` VALUES ('1336190585861599234', '1280539862470008833', '1189389726308478977', '1330805257311150081', 'string', 'string', 'string123456', '0', '2020-12-08 06:07:16', '2020-12-08 06:07:16');
INSERT INTO `edu_comment` VALUES ('1336719917109596161', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', '23', '0', '2020-12-09 17:10:38', '2020-12-09 17:10:38');
INSERT INTO `edu_comment` VALUES ('1336719951494500353', '1280539862470008833', '1279709402194030593', '1330805257311150081', 'xxx', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', '123456', '0', '2020-12-09 17:10:46', '2020-12-09 17:10:46');
-- ----------------------------
-- Table structure for `edu_course`
-- ----------------------------
DROP TABLE IF EXISTS `edu_course`;
CREATE TABLE `edu_course` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程ID',
`teacher_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '璇剧▼璁插笀ID',
`subject_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '璇剧▼涓撲笟ID',
`subject_parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '璇剧▼涓撲笟鐖剁骇ID',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_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 DEFAULT NULL COMMENT '璇剧▼灏侀潰鍥剧墖璺緞',
`buy_count` bigint(10) unsigned DEFAULT '0' COMMENT '閿€鍞暟閲?',
`view_count` bigint(10) unsigned DEFAULT '0' COMMENT '娴忚鏁伴噺',
`version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
`tea_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '课程老师类型：01为平台签约老师，02为平台用户',
`status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'Draft' COMMENT '课程状态 Draft未发布 Normal已发布',
`is_deleted` tinyint(3) DEFAULT NULL COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
`fav_count` bigint(10) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_title` (`title`) USING BTREE,
KEY `idx_subject_id` (`subject_id`) USING BTREE,
KEY `idx_teacher_id` (`teacher_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='课程';
-- ----------------------------
-- Records of edu_course
-- ----------------------------
INSERT INTO `edu_course` VALUES ('123', '123', '123', '123', 'tttt', '0.00', '0', null, '0', '0', '1', '01', 'Draft', '1', '2020-11-12 09:45:59', '2020-11-20 09:46:02', '0');
INSERT INTO `edu_course` VALUES ('1280539498081460225', '1278013808702451714', '1278228536427069441', '1278228536338989058', 'java基础', '0.00', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/707d63e996754cd2b7356d1f0c4dd747java1.jpg', '0', '0', '1', '01', 'Normal', '0', '2020-07-07 16:29:42', '2021-04-24 07:20:03', '1');
INSERT INTO `edu_course` VALUES ('1280539638313820162', '1279709402194030593', '1278228536825528321', '1278228536729059330', 'java进阶1', '21.00', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/0bcc9bc743d74ec89e077bb01b6c96ecjava2.jfif', '0', '0', '1', '01', 'Normal', '0', '2020-07-07 16:30:16', '2020-12-07 02:43:42', '0');
INSERT INTO `edu_course` VALUES ('1280539740721946625', '1280539369119195137', '1278228536825528321', '1278228536729059330', 'java实战', '30.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/4779f83a0c9c4cf78d8f137fcf662809java3.jpg', '0', '0', '1', '01', 'Normal', '0', '2020-07-07 16:30:40', '2021-04-24 07:19:50', '1');
INSERT INTO `edu_course` VALUES ('1280539862470008833', '1279709402194030593', '1278228536825528321', '1278228536729059330', 'redis基础', '40.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/4ddb1ff26a1f4b6ebbb8159b692ada9fredis1.jpg', '0', '22', '1', '01', 'Normal', '0', '2020-07-07 16:31:09', '2021-05-03 03:16:01', '1');
INSERT INTO `edu_course` VALUES ('1280539976219533314', '1279709402194030593', '1278228536917803009', '1278228536729059330', 'nginx', '50.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/d0ffc02f96b4474e908b243ab02ca670nginx1.jpg', '0', '0', '1', '01', 'Normal', '0', '2020-07-07 16:31:36', '2021-04-24 07:20:14', '1');
INSERT INTO `edu_course` VALUES ('1326150893103505409', '1279709402194030593', '1278228536561287170', '1278228536338989058', '课程添加测试', '20.00', '1', '/static/01.jpg', '0', '0', '1', '01', 'Draft', '1', '2020-11-10 13:13:06', '2020-11-10 13:13:06', '0');
INSERT INTO `edu_course` VALUES ('1328531347270123521', '1279709402194030593', '1278228536427069441', '1278228536338989058', '并发编程学习', '20.00', '20', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/591b756f08864edbbff2155b454537debinfa1.jpg', '0', '0', '1', '01', 'Draft', '0', '2020-11-17 02:52:11', '2021-04-24 07:20:20', '1');
INSERT INTO `edu_course` VALUES ('1328531384259690497', '1279709402194030593', '1278228536427069441', '1278228536338989058', '并发编程学习', '20.00', '20', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/a155c2a26b8945288341bc85947ab7a6binfa2.jpg', '0', '0', '1', '01', 'Draft', '0', '2020-11-17 02:52:20', '2020-12-07 02:46:51', '0');
INSERT INTO `edu_course` VALUES ('1328532715124817922', '1326773703576457218', '1278228536917803009', '1278228536729059330', 'ttttttttttttttt', '5.00', '10', '/static/01.jpg', '0', '0', '1', '01', 'Draft', null, '2020-11-17 02:57:37', '2020-11-17 02:57:37', '0');
INSERT INTO `edu_course` VALUES ('1331428351889383426', '1330805257311150081', '1278228536825528321', '1278228536729059330', '线程池', '20.00', '30', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/7f19f9bf53b9412da226277b9ccc43f3threadpool.jpg', '0', '0', '1', '02', 'Normal', '0', '2020-11-25 02:43:50', '2021-04-21 10:12:11', '0');
INSERT INTO `edu_course` VALUES ('1355068043599814658', '1330805257311150081', '1278228536825528321', '1278228536729059330', '开放课程', '3.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/01/29/0e42b5c580004610bd1b3e9d1e5b91081.jpg', '0', '0', '1', '02', 'Normal', '1', '2021-01-29 08:19:32', '2021-01-29 09:08:28', '0');
INSERT INTO `edu_course` VALUES ('1355159175214145538', '1330805257311150081', '1278228536427069441', '1278228536338989058', '擎天柱', '2.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/01/29/61be00ac635b406aa614214cf69bd0b01.jpg', '0', '0', '1', '02', 'Normal', '0', '2021-01-29 14:21:40', '2021-01-29 14:22:45', '0');
INSERT INTO `edu_course` VALUES ('1355159845346484225', '1330805257311150081', '1278228536825528321', '1278228536729059330', '霸天虎', '2.00', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/01/29/bcd9c6bb316243488b6fdd87c9432b9e1.jpg', '0', '0', '1', '02', 'Normal', '0', '2021-01-29 14:24:19', '2021-01-29 14:24:26', '0');
INSERT INTO `edu_course` VALUES ('1384794705616904194', '1330805257311150081', '1278228536917803009', '1278228536729059330', '人工智能', '0.00', '20', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/04/21/b041c7b928f44bbcb0bcfe9925970a0f2.jpg', '0', '0', '1', '02', 'Normal', '0', '2021-04-21 09:02:41', '2021-04-21 09:02:47', '0');
INSERT INTO `edu_course` VALUES ('1384795266634424321', '1330805257311150081', '1278228536917803009', '1278228536729059330', '大数据开发', '0.00', '20', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2021/04/21/df8d23698a084ff8aacd6871410a42b92.jpg', '0', '0', '1', '02', 'Normal', '0', '2021-04-21 09:04:54', '2021-04-21 09:05:00', '0');
-- ----------------------------
-- Table structure for `edu_course_begin`
-- ----------------------------
DROP TABLE IF EXISTS `edu_course_begin`;
CREATE TABLE `edu_course_begin` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程id',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`begin_cou_num` int(10) NOT NULL COMMENT '开课次数',
`now_cou` int(10) NOT NULL COMMENT '当前第几次开课',
`begin_time` datetime NOT NULL COMMENT '开始时间',
`end_time` datetime NOT NULL COMMENT '结束时间',
`gmt_create` datetime NOT NULL COMMENT '插入时间',
`gmt_modified` datetime NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of edu_course_begin
-- ----------------------------
-- ----------------------------
-- 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_0900_ai_ci NOT NULL COMMENT '收藏ID',
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程讲师ID',
`member_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '课程专业ID',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='课程收藏';
-- ----------------------------
-- 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');
-- ----------------------------
-- 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_0900_ai_ci NOT NULL COMMENT '课程ID',
`description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '课程简介',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='课程简介';
-- ----------------------------
-- Records of edu_course_description
-- ----------------------------
INSERT INTO `edu_course_description` VALUES ('1280539498081460225', '<p>java基础java基础</p>', '2020-07-07 16:29:42', '2020-12-07 02:43:28');
INSERT INTO `edu_course_description` VALUES ('1280539638313820162', '<p>java进阶1</p>', '2020-07-07 16:30:16', '2020-12-07 02:43:42');
INSERT INTO `edu_course_description` VALUES ('1280539740721946625', '<p>java实战java实战</p>', '2020-07-07 16:30:40', '2020-12-07 02:43:55');
INSERT INTO `edu_course_description` VALUES ('1280539862470008833', '<p>redis基础redis基础</p>', '2020-07-07 16:31:09', '2020-12-07 02:46:11');
INSERT INTO `edu_course_description` VALUES ('1280539976219533314', '<p>nginxnginx</p>', '2020-07-07 16:31:36', '2020-12-07 02:46:23');
INSERT INTO `edu_course_description` VALUES ('1328531347270123521', '<p>并发编程学习并发编程学习并发编程学习并发编程学习并发编程学习</p>', '2020-11-17 02:52:11', '2020-12-07 02:46:40');
INSERT INTO `edu_course_description` VALUES ('1328531384259690497', '<p>并发编程学习并发编程学习并发编程学习并发编程学习并发编程学习</p>', '2020-11-17 02:52:20', '2020-12-07 02:46:51');
INSERT INTO `edu_course_description` VALUES ('1328532715124817922', '<p>test</p>\n<p>test</p>', '2020-11-17 02:57:37', '2020-11-17 02:57:37');
INSERT INTO `edu_course_description` VALUES ('1331428351889383426', '<p>线程池是重要的并发编程的知识</p>', '2020-11-25 02:43:51', '2021-04-21 10:12:11');
INSERT INTO `edu_course_description` VALUES ('1355159175214145538', '', '2021-01-29 14:21:40', '2021-01-29 14:21:40');
INSERT INTO `edu_course_description` VALUES ('1355159845346484225', '', '2021-01-29 14:24:19', '2021-01-29 14:24:19');
INSERT INTO `edu_course_description` VALUES ('1384794705616904194', '', '2021-04-21 09:02:41', '2021-04-21 09:02:41');
INSERT INTO `edu_course_description` VALUES ('1384795266634424321', '', '2021-04-21 09:04:54', '2021-04-21 09:04:54');
INSERT INTO `edu_course_description` VALUES ('1384812034165776386', '', '2021-04-21 10:11:32', '2021-04-21 10:11:32');
INSERT INTO `edu_course_description` VALUES ('1385862162425069569', '', '2021-04-24 07:44:22', '2021-04-24 07:44:28');
-- ----------------------------
-- Table structure for `edu_favorites`
-- ----------------------------
DROP TABLE IF EXISTS `edu_favorites`;
CREATE TABLE `edu_favorites` (
`id` char(19) NOT NULL,
`ucen_id` char(19) NOT NULL,
`course_id` char(19) NOT NULL,
`isfavorites` char(2) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- ----------------------------
-- Records of edu_favorites
-- ----------------------------
INSERT INTO `edu_favorites` VALUES ('1385827891052281857', '1330805257311150081', '1280539862470008833', '1');
INSERT INTO `edu_favorites` VALUES ('1385855987990151169', '1330805257311150081', '1280539740721946625', '1');
INSERT INTO `edu_favorites` VALUES ('1385856041824043009', '1330805257311150081', '1280539498081460225', '1');
INSERT INTO `edu_favorites` VALUES ('1385856088577949697', '1330805257311150081', '1280539976219533314', '1');
INSERT INTO `edu_favorites` VALUES ('1385856114234507265', '1330805257311150081', '1328531347270123521', '1');
-- ----------------------------
-- Table structure for `edu_qa`
-- ----------------------------
DROP TABLE IF EXISTS `edu_qa`;
CREATE TABLE `edu_qa` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ucenter_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ucenter_name` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`q_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`context` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`view_count` bigint(10) NOT NULL,
`reponse_conut` bigint(10) NOT NULL,
`gmt_create` datetime NOT NULL,
`gmt_modified` datetime NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of edu_qa
-- ----------------------------
INSERT INTO `edu_qa` VALUES ('1384455409366089730', '1280539862470008833', '1330805257311150081', 'xxx', '问题1', '内容', '0', '0', '2021-04-20 10:34:26', '2021-04-20 10:34:26');
INSERT INTO `edu_qa` VALUES ('1384458167154524161', '1280539862470008833', '1330805257311150081', 'xxx', '问题2', '内容2', '0', '0', '2021-04-20 10:45:24', '2021-04-20 10:45:24');
INSERT INTO `edu_qa` VALUES ('1384458191007531009', '1280539862470008833', '1330805257311150081', 'xxx', '问题3', '内容3', '0', '0', '2021-04-20 10:45:29', '2021-04-20 10:45:29');
INSERT INTO `edu_qa` VALUES ('1384458208799768578', '1280539862470008833', '1330805257311150081', 'xxx', '问题4', '内容4', '0', '0', '2021-04-20 10:45:34', '2021-04-20 10:45:34');
INSERT INTO `edu_qa` VALUES ('1384458226076106754', '1280539862470008833', '1330805257311150081', 'xxx', '问题5', '内容5', '0', '0', '2021-04-20 10:45:38', '2021-04-20 10:45:38');
INSERT INTO `edu_qa` VALUES ('1384458245739003905', '1280539862470008833', '1330805257311150081', 'xxx', '问题6', '内容6', '0', '0', '2021-04-20 10:45:42', '2021-04-20 10:45:42');
INSERT INTO `edu_qa` VALUES ('1384458261522169857', '1280539862470008833', '1330805257311150081', 'xxx', '问题7', '内容7', '0', '0', '2021-04-20 10:45:46', '2021-04-20 10:45:46');
INSERT INTO `edu_qa` VALUES ('1384458276621664258', '1280539862470008833', '1330805257311150081', 'xxx', '问题8', '内容8', '0', '0', '2021-04-20 10:45:50', '2021-04-20 10:45:50');
INSERT INTO `edu_qa` VALUES ('1384458296741740546', '1280539862470008833', '1330805257311150081', 'xxx', '问题9', '内容9', '0', '0', '2021-04-20 10:45:55', '2021-04-20 10:45:55');
INSERT INTO `edu_qa` VALUES ('1384458314731110402', '1280539862470008833', '1330805257311150081', 'xxx', '问题10', '内容10', '0', '0', '2021-04-20 10:45:59', '2021-04-20 10:45:59');
INSERT INTO `edu_qa` VALUES ('1384458726292996097', '1280539862470008833', '1330805257311150081', 'xxx', '问题11', '内容11', '14', '0', '2021-04-20 10:47:37', '2021-04-22 06:27:23');
INSERT INTO `edu_qa` VALUES ('1384780467183714305', '1280539862470008833', '1330805257311150081', 'xxx', 'redis关于分布式锁是怎么实现的', 'redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的', '0', '0', '2021-04-21 08:06:06', '2021-04-21 08:06:06');
INSERT INTO `edu_qa` VALUES ('1384782142766219265', '1280539862470008833', '1330805257311150081', 'xxx', 'redis关于分布式锁是怎么实现的', 'redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的', '0', '0', '2021-04-21 08:12:46', '2021-04-21 08:12:46');
INSERT INTO `edu_qa` VALUES ('1384782332873048065', '1280539862470008833', '1330805257311150081', 'xxx', 'redis关于分布式锁是怎么实现的', 'redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的', '0', '0', '2021-04-21 08:13:31', '2021-04-21 08:13:31');
INSERT INTO `edu_qa` VALUES ('1384783555009347586', '1280539862470008833', '1330805257311150081', 'xxx', 'redis的基本数据类型有那些', null, '1', '0', '2021-04-21 08:18:22', '2021-04-22 04:25:49');
INSERT INTO `edu_qa` VALUES ('1384784510203363330', '1280539862470008833', '1330805257311150081', 'xxx', 'redis的跳跃表', 'redis的跳跃表redis的跳跃表redis的跳跃表redis的跳跃表redis的跳跃表redis的跳跃表redis的跳跃表', '9', '0', '2021-04-21 08:22:10', '2021-04-22 06:28:05');
INSERT INTO `edu_qa` VALUES ('string', 'string', 'string', 'string', 'string', 'string', '0', '0', '2021-04-20 09:57:08', '2021-04-20 09:57:08');
-- ----------------------------
-- Table structure for `edu_qa_com`
-- ----------------------------
DROP TABLE IF EXISTS `edu_qa_com`;
CREATE TABLE `edu_qa_com` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ucenter_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`ucenter_name` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`qa_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`context` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`qa_com_like` int(10) DEFAULT NULL,
`comment_count` int(10) DEFAULT NULL,
`parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`gmt_create` datetime NOT NULL,
`gmt_modified` datetime NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of edu_qa_com
-- ----------------------------
INSERT INTO `edu_qa_com` VALUES ('1384766785657704449', 'string', 'string', 'string', 'string', 'string', '0', '0', '0', '2021-04-21 07:11:44', '2021-04-21 07:11:44');
INSERT INTO `edu_qa_com` VALUES ('1384770058481504257', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复1', '0', '0', '0', '2021-04-21 07:24:44', '2021-04-21 07:24:44');
INSERT INTO `edu_qa_com` VALUES ('1384770379849076738', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复1', '0', '0', '0', '2021-04-21 07:26:01', '2021-04-21 07:26:01');
INSERT INTO `edu_qa_com` VALUES ('1384771864280371201', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复2', '0', '0', '0', '2021-04-21 07:31:55', '2021-04-21 07:31:55');
INSERT INTO `edu_qa_com` VALUES ('1384771885197365249', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复3', '0', '0', '0', '2021-04-21 07:32:00', '2021-04-21 07:32:00');
INSERT INTO `edu_qa_com` VALUES ('1384771896366796801', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复4', '0', '0', '0', '2021-04-21 07:32:03', '2021-04-21 07:32:03');
INSERT INTO `edu_qa_com` VALUES ('1384771908299591681', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复5', '0', '0', '0', '2021-04-21 07:32:05', '2021-04-21 07:32:05');
INSERT INTO `edu_qa_com` VALUES ('1384771927706636289', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复6', '0', '0', '0', '2021-04-21 07:32:10', '2021-04-21 07:32:10');
INSERT INTO `edu_qa_com` VALUES ('1384772086922416130', '1280539862470008833', '1330805257311150081', 'xxx', '1384458726292996097', '回复7', '0', '0', '0', '2021-04-21 07:32:48', '2021-04-21 07:32:48');
INSERT INTO `edu_qa_com` VALUES ('1384780546334425089', '1280539862470008833', '1330805257311150081', 'xxx', '1384780467183714305', 'redis关于分布式锁是怎么实现的redis关于分布式锁是怎么实现的', '0', '0', '0', '2021-04-21 08:06:25', '2021-04-21 08:06:25');
-- ----------------------------
-- Table structure for `edu_subject`
-- ----------------------------
DROP TABLE IF EXISTS `edu_subject`;
CREATE TABLE `edu_subject` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程类别ID',
`title` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '类别名称',
`parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '父ID',
`sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
`gmt_create` datetime NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_parent_id` (`parent_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='课程科目';
-- ----------------------------
-- Records of edu_subject
-- ----------------------------
INSERT INTO `edu_subject` VALUES ('1278228536338989058', '前端开发', '0', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536427069441', 'vue', '1278228536338989058', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536561287170', 'JavaScript', '1278228536338989058', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536649367553', 'jquery', '1278228536338989058', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536729059330', '后端开发', '0', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536825528321', 'java', '1278228536729059330', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536917803009', 'c++', '1278228536729059330', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228536993300481', '数据库开发', '0', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1278228537064603650', 'mysql', '1278228536993300481', '0', '2020-07-01 07:26:46', '2020-07-01 07:26:46');
INSERT INTO `edu_subject` VALUES ('1328254125267247105', 'redis', '1278228536993300481', '0', '2020-11-16 08:30:36', '2020-11-16 08:30:36');
-- ----------------------------
-- Table structure for `edu_teacher`
-- ----------------------------
DROP TABLE IF EXISTS `edu_teacher`;
CREATE TABLE `edu_teacher` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '讲师ID',
`name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '讲师姓名',
`intro` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '讲师简介',
`career` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '讲师资历,一句话说明讲师',
`level` int(10) unsigned NOT NULL COMMENT '头衔 1高级讲师 2首席讲师',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_name` (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='讲师';
-- ----------------------------
-- Records of edu_teacher
-- ----------------------------
INSERT INTO `edu_teacher` VALUES ('1', '测试0303', 'intro1', 'career1', '1', null, '3', '1', '2020-06-18 22:34:02', '2020-06-30 08:53:06');
INSERT INTO `edu_teacher` VALUES ('1276901519605628929', '测试0202', 'string1', 'string1', '2', 'string', '1', '1', '2020-06-27 15:33:41', '2020-06-30 08:51:55');
INSERT INTO `edu_teacher` VALUES ('1277877745451274241', '测试1010', '博士后', '博士', '2', null, '2', '1', '2020-06-30 08:12:51', '2020-06-30 08:12:51');
INSERT INTO `edu_teacher` VALUES ('1278013808702451714', '石专', '硕士', '硕士', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/a9453f9f0b524d549288e71bc066e85dfile.png', '1', '0', '2020-06-30 17:13:31', '2020-12-07 02:52:25');
INSERT INTO `edu_teacher` VALUES ('1279709402194030593', '廖志', '博士', '博士', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/a47ff8fae277463e93571716ddb165d6file.png', '1', '0', '2020-07-05 09:31:12', '2020-12-07 02:51:51');
INSERT INTO `edu_teacher` VALUES ('1280539054236016641', 'wxy', '博士后博士后', '博士后', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/a34a1d4ac79745baa6a2c2b07911fc50file.png', '1', '0', '2020-07-07 16:27:56', '2020-12-07 02:41:05');
INSERT INTO `edu_teacher` VALUES ('1280539369119195137', 'dfm', '硕士', '硕士', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/588a7602b4f04ec1b85fc07878e8d43dfile.png', '2', '0', '2020-07-07 16:29:12', '2020-12-07 02:39:36');
INSERT INTO `edu_teacher` VALUES ('1326773703576457218', '范志专', '789456123', '博士', '1', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/12a6948870334c80aed0710ef585a99cfile.png', '3', '0', '2020-11-12 06:27:56', '2020-12-07 02:39:17');
INSERT INTO `edu_teacher` VALUES ('1330759123125424129', '石帆', '石帆重庆科技首席讲师，为4606做出巨大贡献', '博士后', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/30b9c6b81ce1416b9ee4c25734252ce3file.png', '1', '0', '2020-11-23 06:24:34', '2020-12-07 02:56:32');
INSERT INTO `edu_teacher` VALUES ('1335773105032806401', '范志', '从事java开发5年，具有高并发，分布式项目经验', '清华硕士', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/9c1398c8d205495d85d287c178612e16file.png', '1', '0', '2020-12-07 02:28:20', '2020-12-07 02:28:20');
INSERT INTO `edu_teacher` VALUES ('1335774359456858114', '张帝', '从事java技术开发10年', '海归博士', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/07/0e9c9101a3ec41589f0fbf2ca5d791bffile.png', '2', '0', '2020-12-07 02:33:19', '2020-12-07 02:33:19');
INSERT INTO `edu_teacher` VALUES ('1336146834183217154', '张帆', 'edu首席讲师', '博士', '2', 'https://edu-llzh.oss-cn-shenzhen.aliyuncs.com/2020/12/08/cbb415566c534b27bf4e38ec34ecec24file.png', '1', '0', '2020-12-08 03:13:24', '2020-12-08 03:13:24');
INSERT INTO `edu_teacher` VALUES ('8', 'string', 'string', 'string', '0', 'string', '0', '1', '2020-11-11 00:00:00', '2020-11-11 00:00:00');
-- ----------------------------
-- Table structure for `edu_video`
-- ----------------------------
DROP TABLE IF EXISTS `edu_video`;
CREATE TABLE `edu_video` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '视频ID',
`course_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程ID',
`chapter_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '章节ID',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '节点名称',
`video_source_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '云端视频资源',
`video_original_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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_0900_ai_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 NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_course_id` (`course_id`) USING BTREE,
KEY `idx_chapter_id` (`chapter_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='课程视频';
-- ----------------------------
-- Records of edu_video
-- ----------------------------
INSERT INTO `edu_video` VALUES ('1290213828579057665', '1280539862470008833', '1290213273794273282', '第一节', '9e4d5befee9247d8aaec564aae771bab', '6 - What If I Want to Move Faster.mp4', '1', '0', '1', '0', 'Empty', '0', '1', '2020-08-03 09:12:02', '2020-08-03 09:12:02');
INSERT INTO `edu_video` VALUES ('1290213916550389762', '1280539862470008833', '1290213310259552258', '第一节', '526240ce496541cfa38a9600bdf27ef7', '6 - What If I Want to Move Faster.mp4', '1', '0', '0', '0', 'Empty', '0', '1', '2020-08-03 09:12:23', '2020-08-03 09:12:23');
INSERT INTO `edu_video` VALUES ('1290213980878430209', '1280539862470008833', '1290213344568958978', '第一节', '7c52179ff6644708a2211ae2601693f4', '6 - What If I Want to Move Faster.mp4', '1', '0', '0', '0', 'Empty', '0', '1', '2020-08-03 09:12:39', '2020-08-03 09:12:39');
INSERT INTO `edu_video` VALUES ('1290215395998851074', '1280539862470008833', '1290213273794273282', '第二节', 'd9724ffdc1ce4444915df217482103a1', '6 - What If I Want to Move Faster.mp4', '2', '0', '0', '0', 'Empty', '0', '1', '2020-08-03 09:18:16', '2020-08-03 09:18:16');
INSERT INTO `edu_video` VALUES ('1331428634921017345', '1331428351889383426', '1331428439651000322', '第一节 线程池', '6dd5015095bd466f9e397a65b7576d2a', '45824fb7-173b39d2742.mp4', '1', '0', '1', '0', 'Empty', '0', '1', '2020-11-25 02:44:58', '2020-11-25 02:44:58');
INSERT INTO `edu_video` VALUES ('1331428719167807489', '1331428351889383426', '1331428439651000322', '第二节 线程池二', '', '', '2', '0', '0', '0', 'Empty', '0', '1', '2020-11-25 02:45:18', '2021-01-29 07:44:40');
INSERT INTO `edu_video` VALUES ('1355056552582598657', '1331428351889383426', '1355056338761175042', '第一节 线程池的运行', '', '', '1', '0', '1', '0', 'Empty', '0', '1', '2021-01-29 07:33:53', '2021-01-29 08:18:44');
INSERT INTO `edu_video` VALUES ('1355159430441738241', '1355159175214145538', '1355159245124804609', '第一节 擎天柱大战威震天', '692d789962ce44269e4c98888d06b0b2', '6 - What If I Want to Move Faster.mp4', '1', '0', '1', '0', 'Empty', '0', '1', '2021-01-29 14:22:41', '2021-01-29 14:22:41');
-- ----------------------------
-- Table structure for `ucenter_member`
-- ----------------------------
DROP TABLE IF EXISTS `ucenter_member`;
CREATE TABLE `ucenter_member` (
`id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '会员id',
`openid` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '微信openid',
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '' COMMENT '手机号',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
`nickname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '昵称',
`sex` tinyint(2) unsigned DEFAULT NULL COMMENT '性别 1 女，2 男',
`age` tinyint(3) unsigned DEFAULT NULL COMMENT '年龄',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户头像',
`sign` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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 NOT NULL COMMENT '创建时间',
`gmt_modified` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='会员表';
-- ----------------------------
-- Records of ucenter_member
-- ----------------------------
INSERT INTO `ucenter_member` VALUES ('1', '123', '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', '96e79218965eb72c92a549dd5a330112', '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', '96e79218965eb72c92a549dd5a330112', '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 ('1290662971210534914', 'o3_SC52x9WrDc-AYBBMAX6ZsNRbQ', '', null, '阿白', null, null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', null, '0', '0', '2020-08-04 14:56:46', '2020-08-04 14:56:46');
INSERT INTO `ucenter_member` VALUES ('1330805257311150081', null, '17784727198', 'e10adc3949ba59abbe56e057f20f883e', 'xxx', null, null, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q3auHgzwzM5icylGiczX3GW22cV5x8C6bhOzZA6ZuVQzdxJCke8D2SEkJD9utcMUiaRuiabkw7wVFHlxvJ9hPITf9w/132', null, '0', '0', '2020-11-23 09:27:53', '2020-11-23 09:27:53');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手