/* Navicat Premium Data Transfer Source Server : bstest Source Server Type : MySQL Source Server Version : 50719 (5.7.19) Source Host : localhost:3306 Source Schema : db_onlinestudy2 Target Server Type : MySQL Target Server Version : 50719 (5.7.19) File Encoding : 65001 Date: 01/06/2024 12:20:57 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for chat -- ---------------------------- DROP TABLE IF EXISTS `chat`; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) NULL DEFAULT NULL COMMENT '管理员id', `ask` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '提问', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复', `isreply` int(11) NULL DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719649116563 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户服务' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of chat -- ---------------------------- INSERT INTO `chat` VALUES (111, '2024-05-09 15:46:56', 1, 1, '提问1', '回复1', 1); INSERT INTO `chat` VALUES (112, '2024-05-09 15:46:56', 2, 2, '提问2', '回复2', 2); INSERT INTO `chat` VALUES (113, '2024-05-09 15:46:56', 3, 3, '提问3', '回复3', 3); INSERT INTO `chat` VALUES (114, '2024-05-09 15:46:56', 4, 4, '提问4', '回复4', 4); INSERT INTO `chat` VALUES (115, '2024-05-09 15:46:56', 5, 5, '提问5', '回复5', 5); INSERT INTO `chat` VALUES (116, '2024-05-09 15:46:56', 6, 6, '提问6', '回复6', 6); INSERT INTO `chat` VALUES (1716391308571, '2024-05-22 23:21:48', 11, NULL, '你好2024', NULL, 0); INSERT INTO `chat` VALUES (1716391367173, '2024-05-22 23:22:46', 11, NULL, '等等', NULL, 0); INSERT INTO `chat` VALUES (1719575308686, '2024-06-28 19:48:28', 11, NULL, 'nihao ', NULL, 0); INSERT INTO `chat` VALUES (1719649116562, '2024-06-29 16:18:36', 11, NULL, '你好 原动力老师', NULL, 1); -- ---------------------------- -- Table structure for config -- ---------------------------- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称', `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of config -- ---------------------------- INSERT INTO `config` VALUES (1, 'picture1', 'http://localhost:8080/springbootus5uu/upload/picture1.jpg'); INSERT INTO `config` VALUES (2, 'picture2', 'http://localhost:8080/springbootus5uu/upload/picture2.jpg'); INSERT INTO `config` VALUES (3, 'picture3', 'http://localhost:8080/springbootus5uu/upload/picture3.jpg'); INSERT INTO `config` VALUES (6, 'homepage', NULL); -- ---------------------------- -- Table structure for discusskechengxinxi -- ---------------------------- DROP TABLE IF EXISTS `discusskechengxinxi`; CREATE TABLE `discusskechengxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `refid` bigint(20) NOT NULL COMMENT '关联表id', `userid` bigint(20) NOT NULL COMMENT '用户id', `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719576962987 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程信息评论表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of discusskechengxinxi -- ---------------------------- INSERT INTO `discusskechengxinxi` VALUES (191, '2024-05-09 15:46:56', 1, 1, '用户名1', '评论内容1', '回复内容1'); INSERT INTO `discusskechengxinxi` VALUES (192, '2024-05-09 15:46:56', 2, 2, '用户名2', '评论内容2', '回复内容2'); INSERT INTO `discusskechengxinxi` VALUES (193, '2024-05-09 15:46:56', 3, 3, '用户名3', '评论内容3', '回复内容3'); INSERT INTO `discusskechengxinxi` VALUES (194, '2024-05-09 15:46:56', 4, 4, '用户名4', '评论内容4', '回复内容4'); INSERT INTO `discusskechengxinxi` VALUES (195, '2024-05-09 15:46:56', 5, 5, '用户名5', '评论内容5', '回复内容5'); INSERT INTO `discusskechengxinxi` VALUES (196, '2024-05-09 15:46:56', 6, 6, '用户名6', '评论内容6', '回复内容6'); INSERT INTO `discusskechengxinxi` VALUES (1716641773701, '2024-05-25 20:56:13', 21, 11, '用户1', '1', NULL); INSERT INTO `discusskechengxinxi` VALUES (1719576962986, '2024-06-28 20:16:02', 1719569568935, 11, '用户1', '你好 美女', NULL); -- ---------------------------- -- Table structure for exampaper -- ---------------------------- DROP TABLE IF EXISTS `exampaper`; CREATE TABLE `exampaper` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试卷名称', `time` int(11) NOT NULL COMMENT '考试时长(分钟)', `status` int(11) NOT NULL DEFAULT 0 COMMENT '试卷状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719577746590 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '试卷表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of exampaper -- ---------------------------- INSERT INTO `exampaper` VALUES (1704258836877, '2024-05-08 13:13:56', 'Java考试', 45, 1); INSERT INTO `exampaper` VALUES (1719577746589, '2024-06-28 20:29:06', 'python考试', 30, 1); -- ---------------------------- -- Table structure for examquestion -- ---------------------------- DROP TABLE IF EXISTS `examquestion`; CREATE TABLE `examquestion` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `paperid` bigint(20) NOT NULL COMMENT '所属试卷id（外键）', `papername` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试卷名称', `questionname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试题名称', `options` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '选项，json字符串', `score` bigint(20) NULL DEFAULT 0 COMMENT '分值', `answer` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正确答案', `analysis` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '答案解析', `type` bigint(20) NULL DEFAULT 0 COMMENT '试题类型，0：单选题 1：多选题 2：判断题 3：填空题（暂不考虑多项填空）', `sequence` bigint(20) NULL DEFAULT 100 COMMENT '试题排序，值越大排越前面', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719577850093 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '试题表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of examquestion -- ---------------------------- INSERT INTO `examquestion` VALUES (1704258970375, '2024-05-08 13:16:10', 1704258836877, 'Java考试', 'java属于编译型还是解释型语言？', '[{\"text\":\"A.编译型\",\"code\":\"A\"},{\"text\":\"B.解释型\",\"code\":\"B\"}]', 5, 'A', 'java属于编译型语言', 0, 1); INSERT INTO `examquestion` VALUES (1719577850092, '2024-06-28 20:30:49', 1719577746589, 'python考试', 'python是什么', '[{\"text\":\"A.一门编程语言\",\"code\":\"A\"},{\"text\":\"B.它是一个美女\",\"code\":\"B\"}]', 5, 'A', 'python是一门脚本编程语言，它不是一个人，更不是一个美女', 0, 1); -- ---------------------------- -- Table structure for examrecord -- ---------------------------- DROP TABLE IF EXISTS `examrecord`; CREATE TABLE `examrecord` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `paperid` bigint(20) NOT NULL COMMENT '试卷id（外键）', `papername` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试卷名称', `questionid` bigint(20) NOT NULL COMMENT '试题id（外键）', `questionname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '试题名称', `options` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '选项，json字符串', `score` bigint(20) NULL DEFAULT 0 COMMENT '分值', `answer` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '正确答案', `analysis` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '答案解析', `myscore` bigint(20) NOT NULL DEFAULT 0 COMMENT '试题得分', `myanswer` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考生答案', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719648991774 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '考试记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of examrecord -- ---------------------------- INSERT INTO `examrecord` VALUES (1719647729250, '2024-06-29 15:55:29', 11, NULL, 1704258836877, 'Java考试', 1704258970375, 'java属于编译型还是解释型语言？', '[{\"text\":\"A.编译型\",\"code\":\"A\"},{\"text\":\"B.解释型\",\"code\":\"B\"}]', 5, 'A', 'java属于编译型语言', 5, 'A'); INSERT INTO `examrecord` VALUES (1719648991773, '2024-06-29 16:16:31', 11, NULL, 1719577746589, 'python考试', 1719577850092, 'python是什么', '[{\"text\":\"A.一门编程语言\",\"code\":\"A\"},{\"text\":\"B.它是一个美女\",\"code\":\"B\"}]', 5, 'A', 'python是一门脚本编程语言，它不是一个人，更不是一个美女', 5, 'A'); -- ---------------------------- -- Table structure for forum -- ---------------------------- DROP TABLE IF EXISTS `forum`; CREATE TABLE `forum` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '帖子标题', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '帖子内容', `parentid` bigint(20) NULL DEFAULT NULL COMMENT '父节点id', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `isdone` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719648954345 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学习交流' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of forum -- ---------------------------- INSERT INTO `forum` VALUES (1719594606563, '2024-06-29 01:10:05', '你好，原动力老师', '

这是原动力老师的课程培训

', 0, 11, '用户1', '开放'); INSERT INTO `forum` VALUES (1719644488022, '2024-06-29 15:01:27', '通知：今天是原动力课程答辩专场', '

大家好，我明白你会来，所以我等。对于过去，不可忘记，但要放下。因为有明天，今天永远只是起跑线。生活简单就迷人，人心简单就幸福；学会简单其实就不简单。在这个世间，总有一些我们无法完成的事情，无法占有的感情，一些无法抵达的地方，无法修复的缺陷。

', 0, 11, '用户1', '开放'); INSERT INTO `forum` VALUES (1719644504664, '2024-06-29 15:01:43', '你快乐吗', '

有人说，遇到对的那个人，不是强烈的动心，而是长久的安心。你知道，“他不会走”，无论你多么落魄多么不修边幅，他也不会走。你无需装得多么优秀，多么可人，他喜欢的就是你现在这样最自然的样子。

', 0, 11, '用户1', '开放'); INSERT INTO `forum` VALUES (1719648943140, '2024-06-29 16:15:43', '你好老师', '

请输入内容

', 0, 11, '用户1', '开放'); INSERT INTO `forum` VALUES (1719648954344, '2024-06-29 16:15:53', NULL, '你好', 1719648943140, 11, '用户1', NULL); -- ---------------------------- -- Table structure for goumaidekecheng -- ---------------------------- DROP TABLE IF EXISTS `goumaidekecheng`; CREATE TABLE `goumaidekecheng` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `kechengmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称', `leixing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型', `xueke` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学科', `feiyong` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号', `goumaishijian` datetime NULL DEFAULT NULL COMMENT '购买时间', `sfsh` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '否' COMMENT '是否审核', `shhf` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '审核回复', `ispay` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '是否支付', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719575044076 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购买的课程' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of goumaidekecheng -- ---------------------------- INSERT INTO `goumaidekecheng` VALUES (51, '2024-05-09 15:46:56', '课程名称1', '类型1', '学科1', '费用1', '用户账号1', '2024-05-09 15:46:56', '是', '', '已支付'); INSERT INTO `goumaidekecheng` VALUES (52, '2024-05-09 15:46:56', '课程名称2', '类型2', '学科2', '费用2', '用户账号2', '2024-05-09 15:46:56', '是', '', '未支付'); INSERT INTO `goumaidekecheng` VALUES (53, '2024-05-09 15:46:56', '课程名称3', '类型3', '学科3', '费用3', '用户账号3', '2024-05-09 15:46:56', '是', '', '未支付'); INSERT INTO `goumaidekecheng` VALUES (54, '2024-05-09 15:46:56', '课程名称4', '类型4', '学科4', '费用4', '用户账号4', '2024-05-09 15:46:56', '是', '', '未支付'); INSERT INTO `goumaidekecheng` VALUES (55, '2024-05-09 15:46:56', '课程名称5', '类型5', '学科5', '费用5', '用户账号5', '2024-05-09 15:46:56', '是', '', '未支付'); INSERT INTO `goumaidekecheng` VALUES (56, '2024-05-09 15:46:56', '课程名称6', '类型6', '学科6', '费用6', '用户账号6', '2024-05-09 15:46:56', '是', '', '未支付'); INSERT INTO `goumaidekecheng` VALUES (1719502466836, '2024-06-27 23:34:26', '课程名称1', '类型1', '学科1', '费用1', '用户1', '2024-06-27 23:34:24', '是', NULL, '已支付'); INSERT INTO `goumaidekecheng` VALUES (1719575044075, '2024-06-28 19:44:03', '爬虫设计项目', '类型1', '学科1', '0.01', '用户1', '2024-06-28 19:44:00', '否', NULL, '未支付'); -- ---------------------------- -- Table structure for kechengleixing -- ---------------------------- DROP TABLE IF EXISTS `kechengleixing`; CREATE TABLE `kechengleixing` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `leixing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719577566501 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程类型' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of kechengleixing -- ---------------------------- INSERT INTO `kechengleixing` VALUES (31, '2024-05-09 15:46:56', '类型1'); INSERT INTO `kechengleixing` VALUES (32, '2024-05-09 15:46:56', '类型2'); INSERT INTO `kechengleixing` VALUES (33, '2024-05-09 15:46:56', '类型3'); INSERT INTO `kechengleixing` VALUES (34, '2024-05-09 15:46:56', '类型4'); INSERT INTO `kechengleixing` VALUES (35, '2024-05-09 15:46:56', '类型5'); INSERT INTO `kechengleixing` VALUES (36, '2024-05-09 15:46:56', '类型6'); INSERT INTO `kechengleixing` VALUES (1719577556599, '2024-06-28 20:25:55', 'java'); INSERT INTO `kechengleixing` VALUES (1719577566500, '2024-06-28 20:26:05', 'python'); -- ---------------------------- -- Table structure for kechengxinxi -- ---------------------------- DROP TABLE IF EXISTS `kechengxinxi`; CREATE TABLE `kechengxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `kechengmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称', `leixing` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型', `xueke` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学科', `shipin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频', `laoshixingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '老师姓名', `feiyong` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '费用', `kechengtupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程图片', `fabushijian` date NULL DEFAULT NULL COMMENT '发布时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719577500683 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '课程信息' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of kechengxinxi -- ---------------------------- INSERT INTO `kechengxinxi` VALUES (21, '2024-05-09 15:46:56', '课程名称1', '类型1', '学科1', 'http://localhost:8080/springbootus5uu/upload/1719592846491.mp4', '老师姓名1', '费用1', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian1.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (22, '2024-05-09 15:46:56', '课程名称2', '类型2', '学科2', '', '老师姓名2', '费用2', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian2.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (23, '2024-05-09 15:46:56', '课程名称3', '类型3', '学科3', '', '老师姓名3', '费用3', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian3.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (24, '2024-05-09 15:46:56', '课程名称4', '类型4', '学科4', '', '老师姓名4', '费用4', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian4.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (25, '2024-05-09 15:46:56', '课程名称5', '类型5', '学科5', '', '老师姓名5', '费用5', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian5.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (26, '2024-05-09 15:46:56', '课程名称6', '类型6', '学科6', '', '老师姓名6', '费用6', 'http://localhost:8080/springbootus5uu/upload/kechengxinxi_kechengtupian6.jpg', '2024-05-09'); INSERT INTO `kechengxinxi` VALUES (1719569568935, '2024-06-28 18:12:48', '爬虫设计项目', '类型1', '学科1', 'http://localhost:8080/springbootus5uu/upload/1719574835675.mp4', '林老师', '0.01', 'http://localhost:8080/springbootus5uu/upload/1719574827279.jpg', '2024-06-28'); INSERT INTO `kechengxinxi` VALUES (1719577500682, '2024-06-28 20:25:00', '一起来看流星雨', NULL, NULL, 'http://localhost:8080/springbootus5uu/upload/1719577473121.mp4', '黄老师', '20', 'http://localhost:8080/springbootus5uu/upload/1719577481833.jpg', '2024-06-28'); -- ---------------------------- -- Table structure for messages -- ---------------------------- DROP TABLE IF EXISTS `messages`; CREATE TABLE `messages` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '留言人id', `username` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '留言内容', `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719577160521 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '留言板' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of messages -- ---------------------------- INSERT INTO `messages` VALUES (181, '2024-05-09 15:46:56', 1, '用户名1', '留言内容1', '回复内容1'); INSERT INTO `messages` VALUES (182, '2024-05-09 15:46:56', 2, '用户名2', '留言内容2', '回复内容2'); INSERT INTO `messages` VALUES (183, '2024-05-09 15:46:56', 3, '用户名3', '留言内容3', '回复内容3'); INSERT INTO `messages` VALUES (184, '2024-05-09 15:46:56', 4, '用户名4', '留言内容4', '回复内容4'); INSERT INTO `messages` VALUES (185, '2024-05-09 15:46:56', 5, '用户名5', '留言内容5', '回复内容5'); INSERT INTO `messages` VALUES (186, '2024-05-09 15:46:56', 6, '用户名6', '留言内容6', '回复内容6'); INSERT INTO `messages` VALUES (1719577160520, '2024-06-28 20:19:20', 11, '用户1', '原动力老师，一起打王者吗', '好啊'); -- ---------------------------- -- Table structure for news -- ---------------------------- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题', `introduction` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '简介', `picture` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片', `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 177 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '教育资讯' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of news -- ---------------------------- INSERT INTO `news` VALUES (171, '2024-05-09 15:46:56', '标题1', '简介1', 'http://localhost:8080/springbootus5uu/upload/news_picture1.jpg', '内容1'); INSERT INTO `news` VALUES (172, '2024-05-09 15:46:56', '标题2', '简介2', 'http://localhost:8080/springbootus5uu/upload/news_picture2.jpg', '内容2'); INSERT INTO `news` VALUES (173, '2024-05-09 15:46:56', '标题3', '简介3', 'http://localhost:8080/springbootus5uu/upload/news_picture3.jpg', '内容3'); INSERT INTO `news` VALUES (174, '2024-05-09 15:46:56', '标题4', '简介4', 'http://localhost:8080/springbootus5uu/upload/news_picture4.jpg', '内容4'); INSERT INTO `news` VALUES (175, '2024-05-09 15:46:56', '标题5', '简介5', 'http://localhost:8080/springbootus5uu/upload/news_picture5.jpg', '内容5'); INSERT INTO `news` VALUES (176, '2024-05-09 15:46:56', '标题6', '简介6', 'http://localhost:8080/springbootus5uu/upload/news_picture6.jpg', '内容6'); -- ---------------------------- -- Table structure for shipindianbo -- ---------------------------- DROP TABLE IF EXISTS `shipindianbo`; CREATE TABLE `shipindianbo` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `shipinmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频名称', `shipin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频', `shipinjianjie` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '视频简介', `laiyuan` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源', `shangchuanshijian` datetime NULL DEFAULT NULL COMMENT '上传时间', `fengmian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号', `userid` bigint(20) NULL DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719594052796 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '视频点播' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of shipindianbo -- ---------------------------- INSERT INTO `shipindianbo` VALUES (71, '2024-05-09 15:46:56', '视频名称1', 'http://localhost:8080/springbootus5uu/upload/1620547330699.mp4', '视频简介1', '来源1', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian1.jpg', '用户1', 1); INSERT INTO `shipindianbo` VALUES (72, '2024-05-09 15:46:56', '视频名称2', '', '视频简介2', '来源2', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian2.jpg', '用户账号2', 2); INSERT INTO `shipindianbo` VALUES (73, '2024-05-09 15:46:56', '视频名称3', '', '视频简介3', '来源3', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian3.jpg', '用户账号3', 3); INSERT INTO `shipindianbo` VALUES (74, '2024-05-09 15:46:56', '视频名称4', '', '视频简介4', '来源4', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian4.jpg', '用户账号4', 4); INSERT INTO `shipindianbo` VALUES (75, '2024-05-09 15:46:56', '视频名称5', '', '视频简介5', '来源5', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian5.jpg', '用户账号5', 5); INSERT INTO `shipindianbo` VALUES (76, '2024-05-09 15:46:56', '视频名称6', '', '视频简介6', '来源6', '2024-05-09 15:46:56', 'http://localhost:8080/springbootus5uu/upload/shipindianbo_fengmian6.jpg', '用户账号6', 6); INSERT INTO `shipindianbo` VALUES (1719594052795, '2024-06-29 01:00:52', 'python全栈开发', 'http://localhost:8080/springbootus5uu/upload/1719593931733.mp4', 'Python全栈课程是一门综合性课程，专注于培养开发者使用Python语言及其强大的框架，如Django和Flask，来构建完整的Web应用程序。课程内容涵盖前端技术（HTML/CSS/JavaScript），后端逻辑，数据库设计（SQL和NoSQL），RESTful API开发，以及应用的测试、部署和维护。通过实践项目，学生将学习如何整合前后端，使用版本控制工具，以及实现安全和性能优化的最佳实践。', '来源于林哥哥', '2024-06-29 00:58:31', 'http://localhost:8080/springbootus5uu/upload/1719593948830.jpeg', '用户1', NULL); -- ---------------------------- -- Table structure for storeup -- ---------------------------- DROP TABLE IF EXISTS `storeup`; CREATE TABLE `storeup` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `refid` bigint(20) NULL DEFAULT NULL COMMENT '收藏id', `tablename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名', `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏名称', `picture` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏图片', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719580041624 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of storeup -- ---------------------------- INSERT INTO `storeup` VALUES (1719580041623, '2024-06-28 21:07:20', 11, 1719569568935, 'kechengxinxi', '爬虫设计项目', 'http://localhost:8080/springbootus5uu/upload/1719574827279.jpg'); -- ---------------------------- -- Table structure for token -- ---------------------------- DROP TABLE IF EXISTS `token`; CREATE TABLE `token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `tablename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名', `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色', `token` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of token -- ---------------------------- INSERT INTO `token` VALUES (1, 11, '用户1', 'yonghu', '用户', 'frw54j1o3rqf4f8ub116m3ithaewj7m3', '2024-05-09 15:48:33', '2024-06-29 17:00:53'); INSERT INTO `token` VALUES (2, 1, 'abo', 'users', '管理员', 'egwlk7i1g993jwe8c0qywsjquloe672h', '2024-05-09 15:49:17', '2024-06-29 17:19:11'); INSERT INTO `token` VALUES (3, 1718521148821, 'test01', 'yonghu', '用户', 'ztk6o006kxnw3eyoy5gkld74lh0kcf66', '2024-06-16 14:59:34', '2024-06-22 11:50:26'); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名', `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '管理员' COMMENT '角色', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, 'ldsadmin', '123456', '管理员', '2024-05-09 15:46:56'); -- ---------------------------- -- Table structure for wodebiji -- ---------------------------- DROP TABLE IF EXISTS `wodebiji`; CREATE TABLE `wodebiji` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `biaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题', `neirong` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '内容', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '我的笔记' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of wodebiji -- ---------------------------- INSERT INTO `wodebiji` VALUES (81, '2024-05-09 15:46:56', '标题1', '内容1', '用户账号1'); INSERT INTO `wodebiji` VALUES (82, '2024-05-09 15:46:56', '标题2', '内容2', '用户账号2'); INSERT INTO `wodebiji` VALUES (83, '2024-05-09 15:46:56', '标题3', '内容3', '用户账号3'); INSERT INTO `wodebiji` VALUES (84, '2024-05-09 15:46:56', '标题4', '内容4', '用户账号4'); INSERT INTO `wodebiji` VALUES (85, '2024-05-09 15:46:56', '标题5', '内容5', '用户账号5'); INSERT INTO `wodebiji` VALUES (86, '2024-05-09 15:46:56', '标题6', '内容6', '用户账号6'); -- ---------------------------- -- Table structure for wodekecheng -- ---------------------------- DROP TABLE IF EXISTS `wodekecheng`; CREATE TABLE `wodekecheng` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `kechengmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '课程名称', `zhangjie` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '章节', `wenjian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '我的课程' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of wodekecheng -- ---------------------------- INSERT INTO `wodekecheng` VALUES (91, '2024-05-09 15:46:56', '课程名称1', '章节1', 'http://localhost:8080/springbootus5uu/upload/1716641701905.mp4', '用户账号1'); INSERT INTO `wodekecheng` VALUES (92, '2024-05-09 15:46:56', '课程名称2', '章节2', '', '用户账号2'); INSERT INTO `wodekecheng` VALUES (93, '2024-05-09 15:46:56', '课程名称3', '章节3', '', '用户账号3'); INSERT INTO `wodekecheng` VALUES (94, '2024-05-09 15:46:56', '课程名称4', '章节4', '', '用户账号4'); INSERT INTO `wodekecheng` VALUES (95, '2024-05-09 15:46:56', '课程名称5', '章节5', '', '用户账号5'); INSERT INTO `wodekecheng` VALUES (96, '2024-05-09 15:46:56', '课程名称6', '章节6', '', '用户账号6'); -- ---------------------------- -- Table structure for xiaoxitongzhi -- ---------------------------- DROP TABLE IF EXISTS `xiaoxitongzhi`; CREATE TABLE `xiaoxitongzhi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `tongzhibiaoti` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通知标题', `tongzhineirong` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '通知内容', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号', `fasongshijian` datetime NULL DEFAULT NULL COMMENT '发送时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 107 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息通知' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xiaoxitongzhi -- ---------------------------- INSERT INTO `xiaoxitongzhi` VALUES (101, '2024-05-09 15:46:56', '通知标题1', '通知内容1', '用户账号1', '2024-05-09 15:46:56'); INSERT INTO `xiaoxitongzhi` VALUES (102, '2024-05-09 15:46:56', '通知标题2', '通知内容2', '用户账号2', '2024-05-09 15:46:56'); INSERT INTO `xiaoxitongzhi` VALUES (103, '2024-05-09 15:46:56', '通知标题3', '通知内容3', '用户账号3', '2024-05-09 15:46:56'); INSERT INTO `xiaoxitongzhi` VALUES (104, '2024-05-09 15:46:56', '通知标题4', '通知内容4', '用户账号4', '2024-05-09 15:46:56'); INSERT INTO `xiaoxitongzhi` VALUES (105, '2024-05-09 15:46:56', '通知标题5', '通知内容5', '用户账号5', '2024-05-09 15:46:56'); INSERT INTO `xiaoxitongzhi` VALUES (106, '2024-05-09 15:46:56', '通知标题6', '通知内容6', '用户账号6', '2024-05-09 15:46:56'); -- ---------------------------- -- Table structure for xueke -- ---------------------------- DROP TABLE IF EXISTS `xueke`; CREATE TABLE `xueke` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xueke` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学科', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '学科' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of xueke -- ---------------------------- INSERT INTO `xueke` VALUES (41, '2024-05-09 15:46:56', '学科1'); INSERT INTO `xueke` VALUES (42, '2024-05-09 15:46:56', '学科2'); INSERT INTO `xueke` VALUES (43, '2024-05-09 15:46:56', '学科3'); INSERT INTO `xueke` VALUES (44, '2024-05-09 15:46:56', '学科4'); INSERT INTO `xueke` VALUES (45, '2024-05-09 15:46:56', '学科5'); INSERT INTO `xueke` VALUES (46, '2024-05-09 15:46:56', '学科6'); -- ---------------------------- -- Table structure for yonghu -- ---------------------------- DROP TABLE IF EXISTS `yonghu`; CREATE TABLE `yonghu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号', `mima` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `yonghuxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名', `xingbie` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别', `shouji` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机', `youxiang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `touxiang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `yonghuzhanghao`(`yonghuzhanghao`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1719596660501 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of yonghu -- ---------------------------- INSERT INTO `yonghu` VALUES (11, '2024-05-09 15:46:56', '用户1', '123456', '用户姓名1', '男', '13823888881', '773890001@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang1.jpg'); INSERT INTO `yonghu` VALUES (12, '2024-05-09 15:46:56', '用户2', '123456', '用户姓名2', '男', '13823888882', '773890002@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang2.jpg'); INSERT INTO `yonghu` VALUES (13, '2024-05-09 15:46:56', '用户3', '123456', '用户姓名3', '男', '13823888883', '773890003@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang3.jpg'); INSERT INTO `yonghu` VALUES (14, '2024-05-09 15:46:56', '用户4', '123456', '用户姓名4', '男', '13823888884', '773890004@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang4.jpg'); INSERT INTO `yonghu` VALUES (15, '2024-05-09 15:46:56', '用户5', '123456', '用户姓名5', '男', '13823888885', '773890005@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang5.jpg'); INSERT INTO `yonghu` VALUES (16, '2024-05-09 15:46:56', '用户6', '123456', '用户姓名6', '男', '13823888886', '773890006@qq.com', 'http://localhost:8080/springbootus5uu/upload/yonghu_touxiang6.jpg'); INSERT INTO `yonghu` VALUES (1718521148821, '2024-06-16 14:59:08', 'test01', '123456', '张三', NULL, '18888888123', '18888888123@qq.com', 'http://localhost:8080/springbootus5uu/upload/1719597302779.jpeg'); INSERT INTO `yonghu` VALUES (1719596660500, '2024-06-29 01:44:20', '用户8', '123456', '林冬哥', NULL, '15555444444', 'lds951@163.com', NULL); -- ---------------------------- -- Table structure for zhiyeguihua -- ---------------------------- DROP TABLE IF EXISTS `zhiyeguihua`; CREATE TABLE `zhiyeguihua` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `ziwofenxi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自我分析', `quelimubiao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '确立目标', `huanjingpingjia` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '环境评价', `zhiyedingwei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '职业定位', `shishicelve` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实施策略', `pingguyufankui` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '评估与反馈', `fengmian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面', `xingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名', `xingbie` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别', `nianling` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年龄', `muqianzhiye` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '目前职业', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '职业规划' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of zhiyeguihua -- ---------------------------- INSERT INTO `zhiyeguihua` VALUES (61, '2024-05-09 15:46:56', '自我分析1', '确立目标1', '环境评价1', '职业定位1', '实施策略1', '评估与反馈1', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian1.jpg', '姓名1', '男', '年龄1', '目前职业1'); INSERT INTO `zhiyeguihua` VALUES (62, '2024-05-09 15:46:56', '自我分析2', '确立目标2', '环境评价2', '职业定位2', '实施策略2', '评估与反馈2', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian2.jpg', '姓名2', '男', '年龄2', '目前职业2'); INSERT INTO `zhiyeguihua` VALUES (63, '2024-05-09 15:46:56', '自我分析3', '确立目标3', '环境评价3', '职业定位3', '实施策略3', '评估与反馈3', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian3.jpg', '姓名3', '男', '年龄3', '目前职业3'); INSERT INTO `zhiyeguihua` VALUES (64, '2024-05-09 15:46:56', '自我分析4', '确立目标4', '环境评价4', '职业定位4', '实施策略4', '评估与反馈4', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian4.jpg', '姓名4', '男', '年龄4', '目前职业4'); INSERT INTO `zhiyeguihua` VALUES (65, '2024-05-09 15:46:56', '自我分析5', '确立目标5', '环境评价5', '职业定位5', '实施策略5', '评估与反馈5', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian5.jpg', '姓名5', '男', '年龄5', '目前职业5'); INSERT INTO `zhiyeguihua` VALUES (66, '2024-05-09 15:46:56', '自我分析6', '确立目标6', '环境评价6', '职业定位6', '实施策略6', '评估与反馈6', 'http://localhost:8080/springbootus5uu/upload/zhiyeguihua_fengmian6.jpg', '姓名6', '男', '年龄6', '目前职业6'); SET FOREIGN_KEY_CHECKS = 1;