You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
ExamSphere/test.sql

191 lines
16 KiB

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- 主机: 127.0.0.1:3306
-- 生成日期: 2024-12-25 03:42:26
-- 服务器版本: 8.0.31
-- PHP 版本: 7.4.33
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- 数据库: `test`
--
-- --------------------------------------------------------
--
-- 表的结构 `answer`
--
DROP TABLE IF EXISTS `answer`;
CREATE TABLE IF NOT EXISTS `answer` (
`id` bigint NOT NULL AUTO_INCREMENT,
`exam_id` bigint DEFAULT NULL,
`user_id` bigint DEFAULT NULL,
`teacher_id` bigint DEFAULT NULL,
`answers` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
`score` varchar(255) DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`question_ids` varchar(255) DEFAULT NULL,
`is_score` varchar(255) DEFAULT NULL,
`submit_Time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 转存表中的数据 `answer`
--
INSERT INTO `answer` (`id`, `exam_id`, `user_id`, `teacher_id`, `answers`, `score`, `name`, `question_ids`, `is_score`, `submit_Time`) VALUES
(195, 4, 4, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '10', '考试2', '1', '已评分', '2024-12-16 16:44:33'),
(197, 5, 4, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":\"0\",\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":6,\"name\":\"什么是CSS?\",\"type\":\"单选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]}]', '50', '考试3', '1,2,4,5,6', '已评分', '2024-12-16 22:12:23'),
(198, 4, 1, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '10', '考试2', '1', '已评分', '2024-12-17 15:11:42'),
(202, 5, 1, 3, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":6,\"name\":\"什么是CSS?\",\"type\":\"单选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '50', '考试3', '1,2,4,5,6', '未评分', '2024-12-17 15:31:22'),
(203, 3, 4, 2, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\"]},{\"id\":5,\"name\":\"以下哪些是Python的数据类型?\",\"type\":\"多选题\",\"options\":[\"A. Cascading Style Sheets\",\"B. Centralized Style Sheets\",\"C. Creative Style Sheets\",\"D. Computer Style Sheets\"],\"answer\":\"ABCD\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"A\",\"B\",\"C\",\"D\"]},{\"id\":25,\"name\":\"简述一下计算机的组成原理?\",\"type\":\"主观题\",\"options\":[],\"answer\":\"123\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":\"9\",\"userAnswers\":[\"123\"]},{\"id\":24,\"name\":\"1+1=\",\"type\":\"单选题\",\"options\":[\"A1\",\"B2\",\"C3\",\"D4\"],\"answer\":\"B\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"B\"]},{\"id\":21,\"name\":\"1+1=?\",\"type\":\"填空题\",\"options\":[],\"answer\":\"2\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"2\"]},{\"id\":19,\"name\":\"1\",\"type\":\"单选题\",\"options\":[\"A1\",\"B1\",\"C1\",\"D1\"],\"answer\":\"D\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":10,\"userAnswers\":[\"D\"]}]', '79', '123', '1,2,4,5,25,24,21,19', '已评分', '2024-12-19 13:50:44'),
(204, 13, 4, 2, '[{\"id\":1,\"name\":\"什么是数据库?\",\"type\":\"单选题\",\"options\":[\"A. 数据存储\",\"B. 数据库\",\"C. 数据表\",\"D. 数据项\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":2,\"name\":\"以下哪种语言是面向对象的?\",\"type\":\"单选题\",\"options\":[\"A. Java\",\"B. C\",\"C. Assembly\",\"D. Python\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]},{\"id\":4,\"name\":\"HTML是什么的缩写?\",\"type\":\"单选题\",\"options\":[\"A. HyperText Markup Language\",\"B. HyperText Modeling Language\",\"C. HyperText Management Language\",\"D. HyperText Method Language\"],\"answer\":\"A\",\"score\":10,\"userId\":null,\"user\":null,\"userScore\":0,\"userAnswers\":[\"A\"]}]', '30', '试卷10', '1,2,4', '已评分', '2024-12-24 23:40:56');
-- --------------------------------------------------------
--
-- 表的结构 `comment`
--
DROP TABLE IF EXISTS `comment`;
CREATE TABLE IF NOT EXISTS `comment` (
`id` bigint NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`content` varchar(255) DEFAULT NULL,
`time` datetime(6) DEFAULT NULL,
`parent_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 转存表中的数据 `comment`
--
INSERT INTO `comment` (`id`, `username`, `content`, `time`, `parent_id`) VALUES
(6, 'chx', '123', '2024-12-23 14:24:17.637000', NULL),
(7, 'chx', '456', '2024-12-23 15:59:38.945000', NULL),
(8, 'chx2', '@chx 46', '2024-12-23 16:00:06.741000', 6);
-- --------------------------------------------------------
--
-- 表的结构 `exam`
--
DROP TABLE IF EXISTS `exam`;
CREATE TABLE IF NOT EXISTS `exam` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '考试标题',
`img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '封面图',
`start_time` datetime DEFAULT NULL COMMENT '考试开始时间',
`end_time` datetime DEFAULT NULL COMMENT '考试结束时间',
`question_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '试题列表',
`total` int DEFAULT NULL COMMENT '考试总分',
`user_id` int DEFAULT NULL COMMENT '用户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='考试表' ROW_FORMAT=DYNAMIC;
--
-- 转存表中的数据 `exam`
--
INSERT INTO `exam` (`id`, `title`, `img`, `start_time`, `end_time`, `question_ids`, `total`, `user_id`) VALUES
(2, '测试', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-05-29 00:00:00', '2024-12-16 16:42:00', '1,2,4,5,6', 50, 2),
(3, '123', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-06-08 08:00:00', '2024-12-20 19:51:00', '1,2,4,5,25,24,21,19', 110, 2),
(4, '考试2', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-11-05 03:55:00', '2024-12-31 12:00:00', '1', 10, 3),
(5, '考试3', 'https://cdn.pixabay.com/photo/2015/04/23/22/00/tree-736885__480.jpg', '2024-11-05 03:55:00', '2024-12-31 19:12:00', '1,2,4,5,6', 50, 3);
-- --------------------------------------------------------
--
-- 表的结构 `question`
--
DROP TABLE IF EXISTS `question`;
CREATE TABLE IF NOT EXISTS `question` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '题目文本',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '题型',
`options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '选择题选项',
`answer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '正确答案',
`score` int DEFAULT NULL COMMENT '分值',
`user_id` int DEFAULT NULL COMMENT '用户ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='试题表' ROW_FORMAT=DYNAMIC;
--
-- 转存表中的数据 `question`
--
INSERT INTO `question` (`id`, `name`, `type`, `options`, `answer`, `score`, `user_id`) VALUES
(1, '什么是数据库?', '单选题', '[\"A. 数据存储\", \"B. 数据库\", \"C. 数据表\", \"D. 数据项\"]', 'A', 10, 3),
(2, '以下哪种语言是面向对象的?', '单选题', '[\"A. Java\", \"B. C\", \"C. Assembly\", \"D. Python\"]', 'A', 10, 3),
(4, 'HTML是什么的缩写?', '单选题', '[\"A. HyperText Markup Language\", \"B. HyperText Modeling Language\", \"C. HyperText Management Language\", \"D. HyperText Method Language\"]', 'A', 10, 3),
(5, '以下哪些是Python的数据类型?', '多选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'ABCD', 10, 3),
(6, '什么是CSS?', '单选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'A', 10, 3),
(9, 'React是哪家公司开发的?', '多选题', '[\"A. Facebook\", \"B. Google\", \"C. Microsoft\", \"D. Apple\"]', 'ABCD', 10, 3),
(10, '机器学习的主要分类有哪些?', '多选题', '[\"A. Cascading Style Sheets\", \"B. Centralized Style Sheets\", \"C. Creative Style Sheets\", \"D. Computer Style Sheets\"]', 'ABCD', 10, 3),
(13, '1+2=', '单选题', '[\"A. 1\", \"B. 2\", \"C. 3\", \"D. 4\"]', 'C', 10, 3),
(14, '1+1+1+1=', '单选题', '[\"A. 1\", \"B. 2\", \"C. 3\", \"D. 4\"]', 'D', 10, 3),
(15, '1+0=', '单选题', '[\"A. 1\", \"B. 22222\", \"C. 3\", \"D. 4\"]\n', '2', 10, 3),
(16, '10+10=', '单选题', '[\"A. 1\", \"B. 22222\", \"C. 3\", \"D. 20\"]\n', 'D', 10, 3),
(17, '1+2+3=?', '单选题', '[\"A. 1\", \"B. 6\", \"C. 3\", \"D. 20\"]', 'D', 10, 3),
(18, '1+10=?', '单选题', '[\"A11\",\"B22\",\"C22\",\"D113\"]', 'D', 10, 3),
(19, '1', '单选题', '[\"A1\",\"B1\",\"C1\",\"D1\"]', 'D', 10, 3),
(20, '1+1=2对吗', '判断题', '', '', 10, 3),
(21, '1+1=?', '填空题', '{\"0\":\"A\",\"1\":\"B\",\"2\":\"C\",\"3\":\"D\"}', '2', 10, 3),
(22, '1+1=2?', '判断题', '', '', 10, 3),
(23, '1+1+1=3?', '判断题', '', '', 10, 3),
(24, '1+1=', '单选题', '[\"A1\",\"B2\",\"C3\",\"D4\"]', 'B', 10, 3),
(25, '简述一下计算机的组成原理?', '主观题', NULL, '计算机的组成原理', 10, 3);
-- --------------------------------------------------------
--
-- 表的结构 `user`
--
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
`id` bigint NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(100) NOT NULL,
`role` varchar(20) NOT NULL COMMENT '用户角色student, teacher, admin',
`email` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`avatar` varchar(255) DEFAULT NULL,
`gender` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- 转存表中的数据 `user`
--
INSERT INTO `user` (`id`, `username`, `password`, `role`, `email`, `mobile`, `avatar`, `gender`, `address`) VALUES
(1, 'student', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'student', NULL, NULL, 'http://localhost:8080/file/download?name=bf0d4510-f8db-4afb-bf9e-4fa76da41b4e_user.png', '', ''),
(2, 'teacher', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'teacher', NULL, NULL, NULL, NULL, NULL),
(3, 'admin', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'admin', NULL, NULL, NULL, NULL, NULL),
(4, 'chx', '$2a$10$fclE/Dgq1Ej5fEG9cNwIZu.Me0aFCbGy3naccAZOa/Fa/1tBAsZGq', 'student', '12313156', '1233456', 'http://localhost:8080/file/download?name=c5ab3687-2f15-428e-a8e9-4e07bb1ef56d_user.png', '', '北京市 市辖区 东城区'),
(18, 'chx2', '$2a$10$TtgftGGLDzMgy7TOPbnBJuXZpybkFApZMaZPA8yPg3iqeMJR8CZNm', 'student', NULL, NULL, 'http://localhost:8080/file/download?name=24d23157-044d-46b2-b6f2-759ce9e6d287_背景1.jpg', NULL, '');
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;