代码拉取完成，页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50720
Source Host : localhost:3306
Source Database : study
Target Server Type : MYSQL
Target Server Version : 50720
File Encoding : 65001
Date: 2018-04-12 21:49:16
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`interrupt1` int(11) DEFAULT NULL,
`interrupt2` int(11) DEFAULT NULL,
`interrupt3` int(11) DEFAULT NULL,
`question1` int(11) DEFAULT NULL,
`question2` int(11) DEFAULT NULL,
`question3` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES ('4', '124114', '../../file/video?fileName=1523014506118-news.mp4', '2018-04-06 22:56:53', '2', '5', '7', '4', '4', '4');
INSERT INTO `course` VALUES ('5', '等会测试用', '../../file/video?fileName=1523103589089-news.mp4', '2018-04-07 20:20:36', '3', '5', '10', '4', '5', '4');
-- ----------------------------
-- Table structure for grade
-- ----------------------------
DROP TABLE IF EXISTS `grade`;
CREATE TABLE `grade` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`num` int(11) NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`mark` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of grade
-- ----------------------------
INSERT INTO `grade` VALUES ('1', '美食班', '1', '2018-04-06 15:09:40', '');
INSERT INTO `grade` VALUES ('2', '舞蹈班', '2', '2018-04-06 14:28:14', null);
INSERT INTO `grade` VALUES ('3', '跆拳道', '0', '2018-04-06 14:29:56', null);
INSERT INTO `grade` VALUES ('4', '啊2', '-1', '2018-04-07 20:11:18', null);
INSERT INTO `grade` VALUES ('5', 'po9', '0', '2018-04-07 20:15:21', null);
-- ----------------------------
-- Table structure for gradekn
-- ----------------------------
DROP TABLE IF EXISTS `gradekn`;
CREATE TABLE `gradekn` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(255) DEFAULT NULL,
`gname` varchar(255) DEFAULT '0',
`kname` varchar(255) DEFAULT NULL,
`num` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of gradekn
-- ----------------------------
INSERT INTO `gradekn` VALUES ('4', '1', '美食班', '3.25gegx', '7');
-- ----------------------------
-- Table structure for knowledge
-- ----------------------------
DROP TABLE IF EXISTS `knowledge`;
CREATE TABLE `knowledge` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`mark` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`num` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of knowledge
-- ----------------------------
INSERT INTO `knowledge` VALUES ('2', '3.25gegx', '33324', '2018-04-06 22:31:16', '29');
INSERT INTO `knowledge` VALUES ('5', '菜', '1412412', '2018-04-07 20:18:32', '1');
-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`gname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of message
-- ----------------------------
INSERT INTO `message` VALUES ('4', '张三', '\n 2412412 ', '2018-04-06 23:08:52', '美食班');
INSERT INTO `message` VALUES ('5', '张三', '\n 211414124', '2018-04-07 20:22:32', '美食班');
-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES ('2', '3.25gegx', '\n 124124124124124', '2018-04-06 15:46:43');
INSERT INTO `notice` VALUES ('4', '1', '12124124124\n 44', '2018-04-07 20:18:09');
-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`a` varchar(255) NOT NULL,
`b` varchar(255) DEFAULT NULL,
`c` varchar(255) DEFAULT NULL,
`d` varchar(255) DEFAULT NULL,
`correct` varchar(255) DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`knowledge` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of question
-- ----------------------------
INSERT INTO `question` VALUES ('4', '爱因斯的', '选择1', '选择2', '选择3', '选择4', 'C', '2018-04-06 22:00:07', '2');
INSERT INTO `question` VALUES ('5', '等一下测试用', '111111111', '222222222', '333333333333', '4444444444', 'B', '2018-04-07 20:19:11', '5');
-- ----------------------------
-- Table structure for question_student
-- ----------------------------
DROP TABLE IF EXISTS `question_student`;
CREATE TABLE `question_student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT NULL,
`qid` int(11) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of question_student
-- ----------------------------
INSERT INTO `question_student` VALUES ('1', '1', '4', '2018-04-12 21:33:14');
INSERT INTO `question_student` VALUES ('2', '1', '4', '2018-04-12 21:33:19');
-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`loginName` varchar(50) NOT NULL,
`sex` varchar(1) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`grade` int(11) DEFAULT NULL,
`pwd` varchar(50) NOT NULL,
`gradeName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '张三', 'zs', '男', '18', '1', '123456', '美食班');
INSERT INTO `student` VALUES ('3', '王六', 'wl', '男', '18', '2', '123456', '舞蹈班');
-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(11) DEFAULT NULL,
`gname` varchar(255) DEFAULT NULL,
`qid` int(11) DEFAULT NULL,
`qname` varchar(255) DEFAULT NULL,
`errnum` int(11) NOT NULL DEFAULT '0',
`num` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of task
-- ----------------------------
INSERT INTO `task` VALUES ('1', '2', '舞蹈班', '4', '爱因斯的', '0', '0');
INSERT INTO `task` VALUES ('3', '1', '美食班', '5', '等一下测试用', '0', '0');
INSERT INTO `task` VALUES ('4', '1', '美食班', '4', '爱因斯的', '0', '0');
INSERT INTO `task` VALUES ('5', '1', '美食班', '4', '爱因斯的', '0', '0');
-- ----------------------------
-- Table structure for taskstudent
-- ----------------------------
DROP TABLE IF EXISTS `taskstudent`;
CREATE TABLE `taskstudent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`tid` int(11) DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
`ans` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of taskstudent
-- ----------------------------
INSERT INTO `taskstudent` VALUES ('2', '2', '1', '0');
INSERT INTO `taskstudent` VALUES ('3', '3', '1', '0');
INSERT INTO `taskstudent` VALUES ('4', '4', '1', '0');
INSERT INTO `taskstudent` VALUES ('5', '5', '1', '0');
-- ----------------------------
-- Table structure for task_file
-- ----------------------------
DROP TABLE IF EXISTS `task_file`;
CREATE TABLE `task_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`filepath` varchar(255) DEFAULT NULL,
`gid` int(11) DEFAULT NULL,
`gname` varchar(255) DEFAULT NULL,
`tid` int(11) DEFAULT NULL,
`tname` varchar(255) DEFAULT NULL,
`date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of task_file
-- ----------------------------
INSERT INTO `task_file` VALUES ('2', '老师测试', '../../file/down?fileName=1523457789176-TIM图片20180405201532.jpg', '2', '舞蹈班', '2', '刘星', null);
INSERT INTO `task_file` VALUES ('5', '1234124', '../../file/down?fileName=1523461798564-index.html', '1', '美食班', null, null, null);
-- ----------------------------
-- Table structure for task_file_student
-- ----------------------------
DROP TABLE IF EXISTS `task_file_student`;
CREATE TABLE `task_file_student` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`taskid` int(11) DEFAULT NULL,
`taskname` varchar(255) DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
`sname` varchar(255) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`filepath` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of task_file_student
-- ----------------------------
INSERT INTO `task_file_student` VALUES ('8', '5', '1234124', '1', '张三', '2018-04-11 23:54:55', '../../file/down?fileName=1523462095621-index.html');
-- ----------------------------
-- Table structure for teachers
-- ----------------------------
DROP TABLE IF EXISTS `teachers`;
CREATE TABLE `teachers` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`sex` varchar(255) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`pwd` varchar(255) NOT NULL,
`loginName` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of teachers
-- ----------------------------
INSERT INTO `teachers` VALUES ('2', '刘星', '男', '79', '123456', 'lx');
INSERT INTO `teachers` VALUES ('3', '王琦', '男', '90', '123456', 'wq');
-- ----------------------------
-- Table structure for translation
-- ----------------------------
DROP TABLE IF EXISTS `translation`;
CREATE TABLE `translation` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`content` varchar(255) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of translation
-- ----------------------------
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`pwd` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'admin');
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。