代码拉取完成,页面将自动刷新
同步操作将从 1542249438/考研刷题小程序 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
Navicat MySQL Data Transfer
Source Server : 127.0.0.1
Source Server Version : 50527
Source Host : localhost:3306
Source Database : exam-master
Target Server Type : MYSQL
Target Server Version : 50527
File Encoding : 65001
Date: 2023-05-08 17:59:55
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `admin`
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adminName` varchar(50) DEFAULT NULL,
`adminPassword` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin');
-- ----------------------------
-- Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`topicId` int(11) DEFAULT NULL,
`img` varchar(255) DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
`submitImg` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('1', '1', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'fsdvdsgvs', '2023-04-12', null);
INSERT INTO `comment` VALUES ('2', '1', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'retyhjfg', '2023-04-12', null);
INSERT INTO `comment` VALUES ('3', '15', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '666', '2023-04-13', null);
INSERT INTO `comment` VALUES ('4', '15', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '66666666', '2023-04-13', null);
INSERT INTO `comment` VALUES ('5', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'ewfd', '2023-04-13', null);
INSERT INTO `comment` VALUES ('6', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'fsascf', '2023-04-13', null);
INSERT INTO `comment` VALUES ('7', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '666', '2023-04-13', null);
INSERT INTO `comment` VALUES ('8', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '666666', '2023-04-13', null);
INSERT INTO `comment` VALUES ('9', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'qwer', '2023-04-13', null);
INSERT INTO `comment` VALUES ('10', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '', '2023-04-13', null);
INSERT INTO `comment` VALUES ('11', '16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'dasscfs', '2023-04-13', null);
INSERT INTO `comment` VALUES ('12', '18', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'gxsfgdx', '2023-04-14', null);
INSERT INTO `comment` VALUES ('13', '18', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'rshfxf', '2023-04-14', null);
INSERT INTO `comment` VALUES ('14', '18', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'rdhv', '2023-04-14', null);
INSERT INTO `comment` VALUES ('15', '29', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '6666666\n', '2023-04-16', null);
INSERT INTO `comment` VALUES ('16', '29', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '777777777\n', '2023-04-16', null);
INSERT INTO `comment` VALUES ('17', '29', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '', '2023-04-16', null);
INSERT INTO `comment` VALUES ('18', '29', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '8888888888\n', '2023-04-16', null);
INSERT INTO `comment` VALUES ('19', '30', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '66666666\n', '2023-04-16', null);
INSERT INTO `comment` VALUES ('20', '31', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '66666加油\n', '2023-04-19', null);
INSERT INTO `comment` VALUES ('21', '32', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '6666666\n', '2023-04-19', null);
INSERT INTO `comment` VALUES ('22', '33', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '66666666666666\n', '2023-04-19', null);
-- ----------------------------
-- Table structure for `majorchapter`
-- ----------------------------
DROP TABLE IF EXISTS `majorchapter`;
CREATE TABLE `majorchapter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`chapter` varchar(255) DEFAULT NULL,
`count` int(11) unsigned zerofill DEFAULT NULL,
`wrongCount` int(11) unsigned zerofill DEFAULT NULL,
`rate` double unsigned zerofill DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorchapter
-- ----------------------------
INSERT INTO `majorchapter` VALUES ('1', '线性表', '00000000045', '00000000015', '0000066.66666666666667', '1');
INSERT INTO `majorchapter` VALUES ('2', '栈、队列和数组', '00000000039', '00000000015', '0000061.53846153846153', '1');
INSERT INTO `majorchapter` VALUES ('3', '树和二叉树', '00000000013', '00000000007', '0000046.15384615384615', '1');
INSERT INTO `majorchapter` VALUES ('4', '图', '00000000000', '00000000000', '0000000000000000000000', '1');
INSERT INTO `majorchapter` VALUES ('5', '查找', '00000000000', '00000000000', '0000000000000000000000', '1');
INSERT INTO `majorchapter` VALUES ('6', '排序', '00000000000', '00000000000', '0000000000000000000000', '1');
INSERT INTO `majorchapter` VALUES ('7', '计算机网络体系结构', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('8', '物理层', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('9', '数据链路层', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('10', '网络层', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('11', '传输层', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('12', '应用层', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `majorchapter` VALUES ('13', '操作系统概述', '00000000000', '00000000000', '0000000000000000000000', '3');
INSERT INTO `majorchapter` VALUES ('14', '进程管理', '00000000000', '00000000000', '0000000000000000000000', '3');
INSERT INTO `majorchapter` VALUES ('15', '内存管理', '00000000000', '00000000000', '0000000000000000000000', '3');
INSERT INTO `majorchapter` VALUES ('16', '文件管理', '00000000000', '00000000000', '0000000000000000000000', '3');
INSERT INTO `majorchapter` VALUES ('17', '输入输出管理', '00000000000', '00000000000', '0000000000000000000000', '3');
INSERT INTO `majorchapter` VALUES ('18', '计算机系统概述', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('19', '数据的表示和运算', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('20', '存储器层次结构', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('21', '指令系统', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('22', '中央处理器', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('23', '总线', '00000000000', '00000000000', '0000000000000000000000', '4');
INSERT INTO `majorchapter` VALUES ('24', '输入输出系统', '00000000000', '00000000000', '0000000000000000000000', '4');
-- ----------------------------
-- Table structure for `majorexam`
-- ----------------------------
DROP TABLE IF EXISTS `majorexam`;
CREATE TABLE `majorexam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`answerA` varchar(255) DEFAULT NULL,
`answerB` varchar(255) DEFAULT NULL,
`answerC` varchar(255) DEFAULT NULL,
`answerD` varchar(255) DEFAULT NULL,
`realAnswer` char(1) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`chapterId` int(11) DEFAULT NULL,
`examYear` char(4) DEFAULT NULL,
`isImage` varchar(10) DEFAULT 'false',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorexam
-- ----------------------------
INSERT INTO `majorexam` VALUES ('1', '下列对顺序存储的有序表(长度为n)实现给定操作的算法中平均时间复杂度为O(1)的是', '查找包含指定值元素的值', '插入包含指定值元素的算法', '删除第i个元素的算法', '获取第i个值的算法', 'D', '1', '1', '2023', 'false');
INSERT INTO `majorexam` VALUES ('2', '现有非空双向链表 L,其结点结构为prer、data、next。prer 是指向前直接前驱结点的指针,next 是指向直接后继结点的指针。若要在 L 中指针 p 所指向的结点( 非尾结点) 之后插入指针 s 指向的新结点, 则在执行了语句序列: “s->next=p->next;p->next=s”,后,还要执行', 's->next->prer=p; s->prer=p;', 'p->next->prer=s;s->prer=p;', 's->prer=s->next->prer; s->next->prer=s;', 'p->next->prer=s->prer; s->next->prer=p;', 'B', '1', '2', '2023', 'false');
INSERT INTO `majorexam` VALUES ('3', '若采用三元组表存储结构存储系数矩阵 M。则除三元组外,下列数据中还需要保存的是()I. M 的行数 II M 中包含非零元素的行数 III. M 的列数 IVM 中包含非零元素的列数', '仅 I 和 II', '仅 I 和 IV', '仅 II 和 IV ', 'I,II,III,IV', 'D', '1', '2', '2023', 'false');
INSERT INTO `majorexam` VALUES ('4', '在有 6 个字符组成的字符集 S 中,各个字符出现的频次分别为 3,4,5,6,8,10,为 S 构造的哈夫曼树的加权平均长度为()', '2.4', '2.5', '2.67', '2.75', 'B', '1', '3', '2023', 'false');
-- ----------------------------
-- Table structure for `majorquestionsolved`
-- ----------------------------
DROP TABLE IF EXISTS `majorquestionsolved`;
CREATE TABLE `majorquestionsolved` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`count` int(11) unsigned zerofill DEFAULT '00000000000',
`date` date DEFAULT NULL,
`wrongCount` int(11) unsigned zerofill DEFAULT '00000000000',
`userId` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorquestionsolved
-- ----------------------------
INSERT INTO `majorquestionsolved` VALUES ('1', '1', '00000000070', '2023-04-04', '00000000004', '1');
INSERT INTO `majorquestionsolved` VALUES ('2', '1', '00000000035', '2023-04-10', '00000000009', '1');
INSERT INTO `majorquestionsolved` VALUES ('3', '1', '00000000009', '2023-04-11', '00000000002', '1');
INSERT INTO `majorquestionsolved` VALUES ('4', '1', '00000000018', '2023-04-12', '00000000004', '1');
INSERT INTO `majorquestionsolved` VALUES ('5', '1', '00000000014', '2023-04-13', '00000000004', '1');
INSERT INTO `majorquestionsolved` VALUES ('6', '1', '00000000014', '2023-04-14', '00000000002', '1');
INSERT INTO `majorquestionsolved` VALUES ('7', '1', '00000000000', '2023-04-15', '00000000000', '1');
INSERT INTO `majorquestionsolved` VALUES ('8', '1', '00000000004', '2023-04-17', '00000000001', '1');
INSERT INTO `majorquestionsolved` VALUES ('9', '1', '00000000001', '2023-04-19', '00000000001', '1');
-- ----------------------------
-- Table structure for `majorselect`
-- ----------------------------
DROP TABLE IF EXISTS `majorselect`;
CREATE TABLE `majorselect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorselect
-- ----------------------------
INSERT INTO `majorselect` VALUES ('1', '数据结构');
INSERT INTO `majorselect` VALUES ('2', '计算机网络');
INSERT INTO `majorselect` VALUES ('3', '操作系统');
INSERT INTO `majorselect` VALUES ('4', '计算机组成原理');
-- ----------------------------
-- Table structure for `majorwrong`
-- ----------------------------
DROP TABLE IF EXISTS `majorwrong`;
CREATE TABLE `majorwrong` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date DEFAULT NULL,
`examId` int(11) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`userId` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorwrong
-- ----------------------------
INSERT INTO `majorwrong` VALUES ('1', '2023-04-04', '2', '1', '1');
INSERT INTO `majorwrong` VALUES ('2', '2023-04-04', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('3', '2023-04-04', '3', '1', '1');
INSERT INTO `majorwrong` VALUES ('4', '2023-04-04', '4', '1', '1');
INSERT INTO `majorwrong` VALUES ('5', '2023-04-10', '2', '1', '1');
INSERT INTO `majorwrong` VALUES ('6', '2023-04-10', '3', '1', '1');
INSERT INTO `majorwrong` VALUES ('7', '2023-04-10', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('8', '2023-04-10', '4', '1', '1');
INSERT INTO `majorwrong` VALUES ('9', '2023-04-11', '4', '1', '1');
INSERT INTO `majorwrong` VALUES ('10', '2023-04-11', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('11', '2023-04-12', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('12', '2023-04-12', '3', '1', '1');
INSERT INTO `majorwrong` VALUES ('13', '2023-04-13', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('14', '2023-04-13', '2', '1', '1');
INSERT INTO `majorwrong` VALUES ('15', '2023-04-13', '4', '1', '1');
INSERT INTO `majorwrong` VALUES ('16', '2023-04-14', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('17', '2023-04-14', '4', '1', '1');
INSERT INTO `majorwrong` VALUES ('18', '2023-04-17', '1', '1', '1');
INSERT INTO `majorwrong` VALUES ('19', '2023-04-19', '1', '1', '1');
-- ----------------------------
-- Table structure for `majorwrongrate`
-- ----------------------------
DROP TABLE IF EXISTS `majorwrongrate`;
CREATE TABLE `majorwrongrate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`wrongRate` varchar(10) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of majorwrongrate
-- ----------------------------
INSERT INTO `majorwrongrate` VALUES ('1', '1', '94.29%', '2023-04-04');
INSERT INTO `majorwrongrate` VALUES ('2', '1', '74.29%', '2023-04-10');
INSERT INTO `majorwrongrate` VALUES ('3', '1', '88.89%', '2023-04-11');
INSERT INTO `majorwrongrate` VALUES ('4', '1', '77.78%', '2023-04-12');
INSERT INTO `majorwrongrate` VALUES ('5', '1', '78.57%', '2023-04-13');
INSERT INTO `majorwrongrate` VALUES ('6', '1', '85.71%', '2023-04-14');
INSERT INTO `majorwrongrate` VALUES ('7', '1', '75.00%', '2023-04-17');
INSERT INTO `majorwrongrate` VALUES ('8', '1', '0.00%', '2023-04-19');
-- ----------------------------
-- Table structure for `mathchapter`
-- ----------------------------
DROP TABLE IF EXISTS `mathchapter`;
CREATE TABLE `mathchapter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`chapter` varchar(255) DEFAULT NULL,
`count` int(11) DEFAULT '0',
`wrongCount` int(11) unsigned zerofill DEFAULT '00000000000',
`rate` double unsigned zerofill DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathchapter
-- ----------------------------
INSERT INTO `mathchapter` VALUES ('1', '函数、极限与连续', '231', '00000000123', '000046.753246753246756', '1');
INSERT INTO `mathchapter` VALUES ('2', '一元函数微分学', '29', '00000000017', '000044.827586206896555', '1');
INSERT INTO `mathchapter` VALUES ('3', '一元函数积分学', '74', '00000000048', '0000036.48648648648649', '1');
INSERT INTO `mathchapter` VALUES ('4', '向量代数和空间解析几何', '0', '00000000000', '0000000000000000000036', '1');
INSERT INTO `mathchapter` VALUES ('5', '多元函数微分学', '0', '00000000000', '0000000000000000000072', '1');
INSERT INTO `mathchapter` VALUES ('6', '多元函数积分学', '0', '00000000000', '0000000000000000000066', '1');
INSERT INTO `mathchapter` VALUES ('7', '无穷级数', '0', '00000000000', '0000000000000000000040', '1');
INSERT INTO `mathchapter` VALUES ('8', '行列式', '0', '00000000000', '0000000000000000000000', '2');
INSERT INTO `mathchapter` VALUES ('9', '矩阵', '0', '00000000000', '0000000000000000000000', '2');
INSERT INTO `mathchapter` VALUES ('10', '向量', '0', '00000000000', '0000000000000000000000', '2');
INSERT INTO `mathchapter` VALUES ('11', '线性方程组', '0', '00000000000', '0000000000000000000000', '2');
INSERT INTO `mathchapter` VALUES ('12', '矩阵的特征值和特征向量', '0', '00000000000', '0000000000000000000000', '2');
INSERT INTO `mathchapter` VALUES ('13', '二次型', '0', '00000000000', '0000000000000000000000', '2');
-- ----------------------------
-- Table structure for `mathexam`
-- ----------------------------
DROP TABLE IF EXISTS `mathexam`;
CREATE TABLE `mathexam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`answerA` varchar(255) DEFAULT NULL,
`answerB` varchar(255) DEFAULT NULL,
`answerC` varchar(255) DEFAULT NULL,
`answerD` varchar(255) DEFAULT NULL,
`realAnswer` char(1) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`chapterId` int(11) DEFAULT NULL,
`examYear` char(4) DEFAULT NULL,
`isImage` varchar(10) DEFAULT 'false',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathexam
-- ----------------------------
INSERT INTO `mathexam` VALUES ('1', '../../image/数学题/1.png', '../../image/数学题/1_A.png', '../../image/数学题/1_B.png', '../../image/数学题/1_C.png', '../../image/数学题/1_D.png', 'B', '1', '1', '2023', 'true');
INSERT INTO `mathexam` VALUES ('2', '../../image/数学题/2.png', '../../image/数学题/2_A.png', '../../image/数学题/2_B.png', '../../image/数学题/2_C.png', '../../image/数学题/2_D.png', 'C', '1', '3', '2023', 'true');
INSERT INTO `mathexam` VALUES ('3', '../../image/数学题/3.png', '../../image/数学题/3_A.png', '../../image/数学题/3_B.png', '../../image/数学题/3_C.png', '../../image/数学题/3_D.png', 'C', '1', '2', '2022', 'true');
INSERT INTO `mathexam` VALUES ('4', '4+4等于几', '6', '7', '8', '9', 'C', '1', '1', '2021', 'false');
INSERT INTO `mathexam` VALUES ('7', '6+6=', '10', '12', '14', '16', 'B', '1', '1', '2019', 'false');
INSERT INTO `mathexam` VALUES ('8', '7+7=', '12', '13', '14', '15', 'C', '1', '1', '2018', 'false');
INSERT INTO `mathexam` VALUES ('9', '8+8=', '15', '16', '17', '18', 'B', '1', '4', '2017', 'false');
INSERT INTO `mathexam` VALUES ('10', '9+9=', '12', '15', '18', '19', 'C', '1', '5', '2016', 'false');
INSERT INTO `mathexam` VALUES ('11', '20+15=', '20', '15', '35', '40', 'C', '1', '6', '2015', 'false');
INSERT INTO `mathexam` VALUES ('12', '10+1=', '20', '11', '34', '55', 'B', '1', '7', '2014', 'false');
INSERT INTO `mathexam` VALUES ('13', '1+1=', '2', '3', '4', '5', 'A', '1', '1', '2023', 'false');
INSERT INTO `mathexam` VALUES ('14', '1+1=', '2', '3', '4', '5', 'A', '1', '1', '2023', 'false');
-- ----------------------------
-- Table structure for `mathquestionsolved`
-- ----------------------------
DROP TABLE IF EXISTS `mathquestionsolved`;
CREATE TABLE `mathquestionsolved` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`count` int(11) unsigned zerofill DEFAULT '00000000000',
`date` date DEFAULT NULL,
`wrongCount` int(11) unsigned zerofill DEFAULT '00000000000',
`userId` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathquestionsolved
-- ----------------------------
INSERT INTO `mathquestionsolved` VALUES ('1', '1', '00000000026', '2023-04-04', '00000000003', '1');
INSERT INTO `mathquestionsolved` VALUES ('2', '1', '00000000008', '2023-04-07', '00000000002', '1');
INSERT INTO `mathquestionsolved` VALUES ('3', '1', '00000000009', '2023-04-10', '00000000000', '1');
INSERT INTO `mathquestionsolved` VALUES ('4', '1', '00000000000', '2023-04-11', '00000000000', '1');
INSERT INTO `mathquestionsolved` VALUES ('5', '1', '00000000097', '2023-04-12', '00000000014', '1');
INSERT INTO `mathquestionsolved` VALUES ('6', '1', '00000000113', '2023-04-13', '00000000037', '1');
INSERT INTO `mathquestionsolved` VALUES ('7', '1', '00000000157', '2023-04-14', '00000000055', '1');
INSERT INTO `mathquestionsolved` VALUES ('8', '1', '00000000014', '2023-04-15', '00000000004', '1');
INSERT INTO `mathquestionsolved` VALUES ('9', '1', '00000000080', '2023-04-16', '00000000002', '1');
INSERT INTO `mathquestionsolved` VALUES ('10', '1', '00000000059', '2023-04-17', '00000000028', '1');
INSERT INTO `mathquestionsolved` VALUES ('11', '1', '00000000013', '2023-04-18', '00000000002', '1');
INSERT INTO `mathquestionsolved` VALUES ('26', '1', '00000000002', '2023-04-19', '00000000001', '1');
INSERT INTO `mathquestionsolved` VALUES ('27', '1', '00000000004', '2023-05-08', '00000000002', '1');
-- ----------------------------
-- Table structure for `mathselect`
-- ----------------------------
DROP TABLE IF EXISTS `mathselect`;
CREATE TABLE `mathselect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathselect
-- ----------------------------
INSERT INTO `mathselect` VALUES ('1', '高等数学');
INSERT INTO `mathselect` VALUES ('2', '线性代数');
-- ----------------------------
-- Table structure for `mathwrong`
-- ----------------------------
DROP TABLE IF EXISTS `mathwrong`;
CREATE TABLE `mathwrong` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date DEFAULT NULL,
`examId` int(11) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`userId` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathwrong
-- ----------------------------
INSERT INTO `mathwrong` VALUES ('1', '2023-04-04', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('2', '2023-04-07', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('3', '2023-04-07', '4', '1', '1');
INSERT INTO `mathwrong` VALUES ('4', '2023-04-12', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('5', '2023-04-13', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('6', '2023-04-13', '4', '1', '1');
INSERT INTO `mathwrong` VALUES ('7', '2023-04-13', '3', '1', '1');
INSERT INTO `mathwrong` VALUES ('8', '2023-04-13', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('9', '2023-04-14', '3', '1', '1');
INSERT INTO `mathwrong` VALUES ('10', '2023-04-14', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('11', '2023-04-14', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('12', '2023-04-15', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('13', '2023-04-15', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('14', '2023-04-15', '3', '1', '1');
INSERT INTO `mathwrong` VALUES ('15', '2023-04-16', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('16', '2023-04-16', '4', '1', '1');
INSERT INTO `mathwrong` VALUES ('17', '2023-04-17', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('18', '2023-04-17', '3', '1', '1');
INSERT INTO `mathwrong` VALUES ('19', '2023-04-17', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('20', '2023-04-17', '4', '1', '1');
INSERT INTO `mathwrong` VALUES ('21', '2023-04-18', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('22', '2023-04-18', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('49', '2023-04-19', '1', '1', '1');
INSERT INTO `mathwrong` VALUES ('50', '2023-05-08', '2', '1', '1');
INSERT INTO `mathwrong` VALUES ('51', '2023-05-08', '3', '1', '1');
-- ----------------------------
-- Table structure for `mathwrongrate`
-- ----------------------------
DROP TABLE IF EXISTS `mathwrongrate`;
CREATE TABLE `mathwrongrate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`wrongRate` varchar(10) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of mathwrongrate
-- ----------------------------
INSERT INTO `mathwrongrate` VALUES ('1', '1', '88.00%', '2023-04-04');
INSERT INTO `mathwrongrate` VALUES ('2', '1', '85.71%', '2023-04-07');
INSERT INTO `mathwrongrate` VALUES ('3', '1', '100.00%', '2023-04-10');
INSERT INTO `mathwrongrate` VALUES ('4', '1', '85.57%', '2023-04-12');
INSERT INTO `mathwrongrate` VALUES ('5', '1', '66.97%', '2023-04-13');
INSERT INTO `mathwrongrate` VALUES ('6', '1', '64.97%', '2023-04-14');
INSERT INTO `mathwrongrate` VALUES ('7', '1', '78.57%', '2023-04-15');
INSERT INTO `mathwrongrate` VALUES ('8', '1', '97.50%', '2023-04-16');
INSERT INTO `mathwrongrate` VALUES ('9', '1', '52.54%', '2023-04-17');
INSERT INTO `mathwrongrate` VALUES ('10', '1', '92.31%', '2023-04-18');
INSERT INTO `mathwrongrate` VALUES ('25', '1', '50.00%', '2023-04-19');
INSERT INTO `mathwrongrate` VALUES ('26', '1', '50.00%', '2023-05-08');
-- ----------------------------
-- Table structure for `politicalchapter`
-- ----------------------------
DROP TABLE IF EXISTS `politicalchapter`;
CREATE TABLE `politicalchapter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`chapter` varchar(255) DEFAULT NULL,
`count` int(11) unsigned zerofill DEFAULT NULL,
`wrongCount` int(11) unsigned zerofill DEFAULT NULL,
`rate` double unsigned zerofill DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalchapter
-- ----------------------------
INSERT INTO `politicalchapter` VALUES ('1', '马克思主义基本原理', '00000000000', '00000000000', '0000000000000000000000', '1');
INSERT INTO `politicalchapter` VALUES ('2', '毛泽东思想和中国特色社会主义理论体系概论', '00000000000', '00000000000', '0000000000000000000000', '2');
INSERT INTO `politicalchapter` VALUES ('3', '中国近代史纲要', '00000000004', '00000000004', '0000000000000000000025', '3');
INSERT INTO `politicalchapter` VALUES ('4', '思想道德修养与法律基础', '00000000000', '00000000000', '0000000000000000000000', '4');
-- ----------------------------
-- Table structure for `politicalexam`
-- ----------------------------
DROP TABLE IF EXISTS `politicalexam`;
CREATE TABLE `politicalexam` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`answerA` varchar(255) DEFAULT NULL,
`answerB` varchar(255) DEFAULT NULL,
`answerC` varchar(255) DEFAULT NULL,
`answerD` varchar(255) DEFAULT NULL,
`realAnswer` char(1) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`chapterId` int(11) DEFAULT NULL,
`examYear` char(4) DEFAULT NULL,
`isImage` varchar(10) DEFAULT 'false',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalexam
-- ----------------------------
INSERT INTO `politicalexam` VALUES ('1', '西安事变又称', '七七事变', '九一八事变', '秋收起义', '南昌起义', 'A', '3', '3', '2023', 'false');
INSERT INTO `politicalexam` VALUES ('2', '卢沟桥事变发生在', '广东', '东北', '华北', '西北', 'B', '3', '3', '2023', 'false');
-- ----------------------------
-- Table structure for `politicalquestionsolved`
-- ----------------------------
DROP TABLE IF EXISTS `politicalquestionsolved`;
CREATE TABLE `politicalquestionsolved` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`count` int(11) unsigned zerofill DEFAULT '00000000000',
`date` date DEFAULT NULL,
`wrongCount` int(11) unsigned zerofill DEFAULT '00000000000',
`userId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalquestionsolved
-- ----------------------------
INSERT INTO `politicalquestionsolved` VALUES ('1', '3', '00000000007', '2023-04-15', '00000000004', '1');
-- ----------------------------
-- Table structure for `politicalselect`
-- ----------------------------
DROP TABLE IF EXISTS `politicalselect`;
CREATE TABLE `politicalselect` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalselect
-- ----------------------------
INSERT INTO `politicalselect` VALUES ('1', '马克思主义基本原理');
INSERT INTO `politicalselect` VALUES ('2', '毛泽东思想和中国特色社会主义理论体系概论');
INSERT INTO `politicalselect` VALUES ('3', '中国近代史纲要');
INSERT INTO `politicalselect` VALUES ('4', '思想道德修养与法律基础');
-- ----------------------------
-- Table structure for `politicalwrong`
-- ----------------------------
DROP TABLE IF EXISTS `politicalwrong`;
CREATE TABLE `politicalwrong` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date DEFAULT NULL,
`examId` int(11) DEFAULT NULL,
`projectSelectId` int(11) DEFAULT NULL,
`userId` int(11) DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalwrong
-- ----------------------------
INSERT INTO `politicalwrong` VALUES ('1', '2023-04-15', '1', '3', '1');
-- ----------------------------
-- Table structure for `politicalwrongrate`
-- ----------------------------
DROP TABLE IF EXISTS `politicalwrongrate`;
CREATE TABLE `politicalwrongrate` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`projectSelectId` int(11) DEFAULT NULL,
`wrongRate` varchar(10) DEFAULT NULL,
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of politicalwrongrate
-- ----------------------------
INSERT INTO `politicalwrongrate` VALUES ('1', '3', '57.14%', '2023-04-15');
-- ----------------------------
-- Table structure for `topiclist`
-- ----------------------------
DROP TABLE IF EXISTS `topiclist`;
CREATE TABLE `topiclist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`img` varchar(255) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`date` date DEFAULT NULL,
`submitImg` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of topiclist
-- ----------------------------
INSERT INTO `topiclist` VALUES ('1', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'fwdgvsw', '2023-04-07', null);
INSERT INTO `topiclist` VALUES ('2', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'bfebhfrhbdgbd n', '2023-04-07', null);
INSERT INTO `topiclist` VALUES ('4', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'jhjghgjkjgh', '2023-04-11', null);
INSERT INTO `topiclist` VALUES ('10', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '<p>tyfewdvw</p>', '2023-04-12', null);
INSERT INTO `topiclist` VALUES ('11', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '<p>tyfewdvw</p>', '2023-04-12', null);
INSERT INTO `topiclist` VALUES ('12', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'tyfewdvw\n', '2023-04-12', null);
INSERT INTO `topiclist` VALUES ('13', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'tyfewdvw\n', '2023-04-12', null);
INSERT INTO `topiclist` VALUES ('14', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '滕佳洛6666666666dascaadsdascadaxaas2023/4/12xdas\n', '2023-04-12', null);
INSERT INTO `topiclist` VALUES ('15', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'jhgyuhjknnhjknmn\n', '2023-04-13', null);
INSERT INTO `topiclist` VALUES ('16', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', 'jhgyuhjknnhjknmn\n', '2023-04-13', null);
INSERT INTO `topiclist` VALUES ('33', 'https://thirdwx.qlogo.cn/mmopen/vi_32/KZd62NRVDNp76hwvkDR61ewDLnNFFfHQlP76h3MLJhBIBSNqAoliaEevaUed3cy93wicyicgv7nIFSLuywwM2wXgQ/132', '\n请问这题怎么做\n', '2023-04-19', '../../image/数学题/1.png');
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`UserName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '123456789');
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。