-- MySQL dump 10.13 Distrib 5.7.18, for Win64 (x86_64)
--
-- Host: localhost Database: studyjava
-- ------------------------------------------------------
-- Server version	5.7.18-log

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE studyjava;
USE studyjava;

--
-- Table structure for table `attachment`
--

DROP TABLE IF EXISTS `attachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attachment` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(90) NOT NULL,
 `file_path` varchar(120) NOT NULL,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attachment`
--

LOCK TABLES `attachment` WRITE;
/*!40000 ALTER TABLE `attachment` DISABLE KEYS */;
INSERT INTO `attachment` VALUES (1,'ceshi1','sdaf/asdf','2017-11-22 20:17:38','2017-11-16 20:17:42'),(2,'ceshi2','/sdf/ss','2017-11-08 20:17:57','2017-11-03 20:18:00'),(3,'234sdafsad3','/file/4a7b8d004eef446a5cf72bc86914ab64.jpg','2017-11-23 09:53:57','2017-11-23 09:53:57');
/*!40000 ALTER TABLE `attachment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `chapter`
--

DROP TABLE IF EXISTS `chapter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chapter` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(60) NOT NULL,
 `course_id` bigint(20) NOT NULL,
 `description` text,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 `file_path` varchar(120) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `chapter`
--

LOCK TABLES `chapter` WRITE;
/*!40000 ALTER TABLE `chapter` DISABLE KEYS */;
INSERT INTO `chapter` VALUES (1,'认识 Java',1,'知识点: 1.Java简介 2.Java开发环境搭建 3.文本文件编辑Java程序 4.Eclipse开发Java程序','2017-11-06 11:01:58','2017-11-06 11:02:02','/doc/认识Java.md'),(2,'Java 语言基础',1,'知识点: 1.关键字 2.标识符 3.变量和常量','2017-11-06 15:11:50','2017-11-06 15:11:53','/doc/Java语言基础.md'),(3,'测试',1,'阿斯顿法师打发','2017-11-18 14:38:24','2017-11-18 14:38:26','/doc/Java语言基础.md'),(7,'asdfasdf',1,'asdfasd234','2017-11-22 21:47:13','2017-11-22 21:47:13','/doc/5b403f526dd195181492cf57fbd84c26.md'),(8,'asdf123123',1,'123123zzxcv','2017-11-22 22:03:39','2017-11-22 22:03:39','/doc/7eebda80deb260b225952567adc06309.md');
/*!40000 ALTER TABLE `chapter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `choice`
--

DROP TABLE IF EXISTS `choice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `choice` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `content` varchar(300) NOT NULL,
 `question_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `choice`
--

LOCK TABLES `choice` WRITE;
/*!40000 ALTER TABLE `choice` DISABLE KEYS */;
INSERT INTO `choice` VALUES (33,'测试1.1',27),(34,'测试1.2',27),(35,'测试1.3',27),(36,'测试1.4',27),(37,'测试2.1',28),(38,'测试2.2',28),(39,'测试2.3',28),(40,'测试2.4',28),(41,'测试3.1',29),(42,'测试3.2',29),(43,'测试3.3',29),(44,'测试3.4',29),(45,'测试4.1',30),(46,'测试4.2',30),(47,'测试5.1',31),(48,'测试5.2',31),(49,'测试5.3',31),(50,'测试6.1',32),(51,'测试6.2',32),(52,'测试6.3',32),(53,'测试7.1',33),(54,'测试7.2',33),(55,'测试7.3阿斯顿法师打发撒点发是大法师的法师的法师敌方阿斯顿法师打发撒点发是大法师的法师的法师敌方阿斯顿法师打发撒点发是大法师的法师的法师敌方',33),(56,'测试7.4',33);
/*!40000 ALTER TABLE `choice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `course`
--

DROP TABLE IF EXISTS `course`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `course` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(60) NOT NULL,
 `course_category_id` bigint(20) NOT NULL,
 `description` text,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `course`
--

LOCK TABLES `course` WRITE;
/*!40000 ALTER TABLE `course` DISABLE KEYS */;
INSERT INTO `course` VALUES (1,'Java入门基础',1,'本课程将介绍 Java 语言基本语法、Java 平台应用、 Java 的核心概念:JVM、JDK、JRE以及 java 面向对象思想。同时我们会学到如何在系统中搭建 Java 开发环境,以及如何利用第三方工具进行 Java 程序的开发。','2017-11-06 10:56:47','2017-11-06 10:56:51'),(2,'ceshi1',1,'asdfasdf','2017-11-14 11:05:48','2017-11-14 11:05:52'),(3,'测试进阶',1,'阿斯顿发撒地方撒地方','2017-11-20 14:47:32','2017-11-20 14:47:32');
/*!40000 ALTER TABLE `course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `course_category`
--

DROP TABLE IF EXISTS `course_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `course_category` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `name` varchar(30) NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `course_category`
--

LOCK TABLES `course_category` WRITE;
/*!40000 ALTER TABLE `course_category` DISABLE KEYS */;
INSERT INTO `course_category` VALUES (1,'基础知识'),(2,'进阶知识'),(3,'拓展知识'),(4,'高级知识');
/*!40000 ALTER TABLE `course_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `example`
--

DROP TABLE IF EXISTS `example`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `example` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(90) NOT NULL,
 `description` text,
 `doc_file_path` varchar(120) DEFAULT NULL,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `example`
--

LOCK TABLES `example` WRITE;
/*!40000 ALTER TABLE `example` DISABLE KEYS */;
INSERT INTO `example` VALUES (1,'测试','测试临时','/static/doc/123.md','2017-11-22 20:17:10','2017-11-22 20:17:15'),(2,'123sadfxzcv','asdfsadfczxcv','/doc/3d93ca6018161c9c425b8b614eac06a4.md','2017-11-23 09:53:57','2017-11-23 09:53:57');
/*!40000 ALTER TABLE `example` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `example_attachment`
--

DROP TABLE IF EXISTS `example_attachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `example_attachment` (
 `example_id` bigint(20) unsigned NOT NULL,
 `attachment_id` bigint(20) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `example_attachment`
--

LOCK TABLES `example_attachment` WRITE;
/*!40000 ALTER TABLE `example_attachment` DISABLE KEYS */;
INSERT INTO `example_attachment` VALUES (1,1),(1,2),(2,3);
/*!40000 ALTER TABLE `example_attachment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `question`
--

DROP TABLE IF EXISTS `question`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `question` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `content` varchar(300) NOT NULL,
 `question_type` smallint(5) unsigned DEFAULT NULL,
 `test_id` bigint(20) unsigned DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `question`
--

LOCK TABLES `question` WRITE;
/*!40000 ALTER TABLE `question` DISABLE KEYS */;
INSERT INTO `question` VALUES (27,'测试1',1,1),(28,'测试2',1,1),(29,'测试3',2,1),(30,'测试4',1,1),(31,'测试5撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬撒点发是打发斯蒂芬',1,1),(32,'测试6',2,1),(33,'测试7',1,1);
/*!40000 ALTER TABLE `question` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `question_answer`
--

DROP TABLE IF EXISTS `question_answer`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `question_answer` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `question_id` bigint(20) unsigned NOT NULL,
 `choice_id` bigint(20) unsigned NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `question_answer`
--

LOCK TABLES `question_answer` WRITE;
/*!40000 ALTER TABLE `question_answer` DISABLE KEYS */;
INSERT INTO `question_answer` VALUES (1,27,34),(2,28,40),(3,29,41),(4,29,44),(5,30,46),(6,31,48),(7,32,51),(8,32,52),(9,33,56);
/*!40000 ALTER TABLE `question_answer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `test`
--

DROP TABLE IF EXISTS `test`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `title` varchar(30) NOT NULL,
 `description` text,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `test`
--

LOCK TABLES `test` WRITE;
/*!40000 ALTER TABLE `test` DISABLE KEYS */;
INSERT INTO `test` VALUES (1,'基础知识在线测试','就暗示的蓝卡分解埃里克森达菲鸡可拉伸的','2017-11-19 11:17:08','2017-11-19 11:17:12'),(2,'进阶知识测试','啊伺机待发离开家阿斯利康达菲鸡埃里克撒地方','2017-11-19 11:17:30','2017-11-19 11:17:34'),(3,'拓展知识测试','阿斯加德福利库静安寺离开的放假了卡使得','2017-11-19 11:17:47','2017-11-10 11:17:49'),(4,'高级知识测试','阿斯利康定积分行政村v装修成V字形橙V','2017-11-05 11:18:16','2017-11-19 11:18:20'),(5,'测试','撒地方','2017-11-20 14:29:29','2017-11-20 14:29:33');
/*!40000 ALTER TABLE `test` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
 `account` varchar(20) NOT NULL,
 `password` varchar(20) NOT NULL,
 `gender` char(3) NOT NULL,
 `name` varchar(24) NOT NULL,
 `gmt_create` datetime NOT NULL,
 `gmt_modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'B20140304532','123123','男','谭国炜','2017-11-03 14:16:10','2017-11-03 14:16:12'),(2,'qweqwe','123123','女','asdfasdfasdf','2017-11-17 17:20:04','2017-11-17 17:20:04'),(3,'asdfasdf','123123','女','asdfasdf','2017-11-20 14:46:07','2017-11-20 14:46:07');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2017年11月23日 10:01:27