考试系统（基于vue3和springboot3前后端分离）

create database if not exists project_exam_system charset utf8mb4; use project_exam_system; /* Navicat MySQL Data Transfer Source Server : MySQL84 Source Server Type : MySQL Source Server Version : 80400 Source Host : localhost:3308 Source Schema : project_exam_system Target Server Type : MySQL Target Server Version : 80400 File Encoding : 65001 Date: 23/08/2024 22:15:34 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `userName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `password` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `notes` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP, `createOr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `editTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `editOr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `isDel` tinyint(1) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES (1, 'admin', 'admin', 'admin', NULL, '2024-08-20 21:13:45', NULL, '2024-08-20 21:13:45', NULL, 0); -- ---------------------------- -- Table structure for category -- ---------------------------- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int NOT NULL, `title` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `notes` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `createTime` datetime NULL DEFAULT CURRENT_TIMESTAMP, `createOr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `editTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `editOr` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `isDel` tinyint(1) NULL DEFAULT 0, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '题型管理管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of category -- ---------------------------- INSERT INTO `category` VALUES (1001, '单选题', '单选题', '2024-08-20 21:13:45', NULL, '2024-08-20 21:13:45', NULL, 0); INSERT INTO `category` VALUES (1002, '填空题', '填空题', '2024-08-20 21:13:45', NULL, '2024-08-20 21:13:45', NULL, 0); INSERT INTO `category` VALUES (1003, '判断题', '判断题', '2024-08-20 21:13:45', NULL, '2024-08-20 21:13:45', NULL, 0); INSERT INTO `category` VALUES (1004, '简答题', '简答题', '2024-08-20 21:13:45', NULL, '2024-08-20 21:13:45', NULL, 0); -- ---------------------------- -- Table structure for com_city -- ---------------------------- DROP TABLE IF EXISTS `com_city`; CREATE TABLE `com_city` ( `id` bigint NOT NULL COMMENT 'ID', `parentId` bigint NULL DEFAULT NULL COMMENT '父ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '名称', `areaCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区域编码', `center` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '区域中心点经纬度', `cityCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '城市代码', `level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '行政区划级别', `orderNum` int NULL DEFAULT NULL COMMENT '排序', `allPath` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '行政地区路径ID1,ID2,ID3,ID4', `createOr` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建者', `createTime` datetime(6) NULL DEFAULT NULL COMMENT '创建时间', `editOr` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '更新者', `editTime` datetime(6) NULL DEFAULT NULL COMMENT '更新时间', `isDel` bit(1) NULL DEFAULT b'0' COMMENT '删除标志 true0/false1 删除/未删除', PRIMARY KEY (`id`) USING BTREE, INDEX `parentId`(`parentId`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of com_city -- ---------------------------- INSERT INTO `com_city` VALUES (1010000000, 0, '广东省', '440000', '113.280637,23.125178', '0754', 'province', 0, '0,1010000000', 'admin', '2021-06-07 15:05:31.387000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010100000, 1010000000, '汕头市', '440500', '116.708463,23.37102', '0754', 'city', 0, '0,1010000000,1010100000', 'admin', '2021-06-07 15:05:31.433000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101000, 1010100000, '潮阳区', '440513', '116.602602,23.262336', '0754', 'district', 0, '0,1010000000,1010100000,1010101000', 'admin', '2021-06-07 15:05:31.447000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101001, 1010101000, '和平镇', '440513', '116.519,23.2664', '0754', 'street', 0, '0,1010000000,1010100000,1010101000,1010101001', 'admin', '2021-06-07 15:05:31.448000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101002, 1010101000, '西胪镇', '440513', '116.457,23.3479', '0754', 'street', 1, '0,1010000000,1010100000,1010101000,1010101002', 'admin', '2021-06-07 15:05:31.449000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101003, 1010101000, '金浦街道', '440513', '116.568,23.2222', '0754', 'street', 2, '0,1010000000,1010100000,1010101000,1010101003', 'admin', '2021-06-07 15:05:31.450000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101004, 1010101000, '河溪镇', '440513', '116.553,23.3607', '0754', 'street', 3, '0,1010000000,1010100000,1010101000,1010101004', 'admin', '2021-06-07 15:05:31.450000', 'admin', '2021-06-28 15:46:33.877000', b'0'); INSERT INTO `com_city` VALUES (1010101005, 1010101000, '铜盂镇', '440513', '116.378,23.3286', '0754', 'street', 4, '0,1010000000,1010100000,1010101000,1010101005', 'admin', '2021-06-07 15:05:31.451000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101006, 1010101000, '谷饶镇', '440513', '116.389,23.4243', '0754', 'street', 5, '0,1010000000,1010100000,1010101000,1010101006', 'admin', '2021-06-07 15:05:31.451000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101007, 1010101000, '棉北街道', '440513', '116.626,23.288', '0754', 'street', 6, '0,1010000000,1010100000,1010101000,1010101007', 'admin', '2021-06-07 15:05:31.452000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101008, 1010101000, '海门镇', '440513', '116.663,23.2298', '0754', 'street', 7, '0,1010000000,1010100000,1010101000,1010101008', 'admin', '2021-06-07 15:05:31.453000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101009, 1010101000, '贵屿镇', '440513', '116.38,23.3781', '0754', 'street', 8, '0,1010000000,1010100000,1010101000,1010101009', 'admin', '2021-06-07 15:05:31.453000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101010, 1010101000, '文光街道', '440513', '116.6,23.2507', '0754', 'street', 9, '0,1010000000,1010100000,1010101000,1010101010', 'admin', '2021-06-07 15:05:31.454000', NULL, NULL, b'0'); INSERT INTO `com_city` VALUES (1010101011, 1010101000, '关埠镇', '440513', '116.44,23.3991', '0754', 'street', 10, '0,1010000000,1010100000,101010