online_learning_platform/db_onlinestudy2.sql

/*
 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', '你好，原动力老师', '<p>这是原动力老师的课程培训</p>', 0, 11, '用户1', '开放');
INSERT INTO `forum` VALUES (1719644488022, '2024-06-29 15:01:27', '通知：今天是原动力课程答辩专场', '<p>大家好，<span style=\"background-color: #ffffff; color: #222222; font-family: arial; font-size: 18px;\">我明白你会来，所以我等。对于过去，不可忘记，但要放下。因为有明天，今天永远只是起跑线。生活简单就迷人，人心简单就幸福；学会简单其实就不简单。在这个世间，总有一些我们无法完成的事情，无法占有的感情，一些无法抵达的地方，无法修复的缺陷。</span></p>', 0, 11, '用户1', '开放');
INSERT INTO `forum` VALUES (1719644504664, '2024-06-29 15:01:43', '你快乐吗', '<p><span style=\"color: #222222; font-family: arial; font-size: 18px; background-color: #ffffff;\">有人说，遇到对的那个人，不是强烈的动心，而是长久的安心。你知道，&ldquo;他不会走&rdquo;，无论你多么落魄多么不修边幅，他也不会走。你无需装得多么优秀，多么可人，他喜欢的就是你现在这样最自然的样子。</span></p>', 0, 11, '用户1', '开放');
INSERT INTO `forum` VALUES (1719648943140, '2024-06-29 16:15:43', '你好老师', '<p>请输入内容</p>', 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;