/*
SQLyog Ultimate v11.24 (32 bit)
MySQL - 5.7.20-log : Database - test
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!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 /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `test`;

/*Table structure for table `clazz` */

DROP TABLE IF EXISTS `clazz`;

CREATE TABLE `clazz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

/*Data for the table `clazz` */

insert  into `clazz`(`id`,`name`) values (1,'高一(1)班'),(2,'高一(2)班'),(3,'高二(1)班'),(4,'高二(2)班'),(5,'高三(1)班'),(6,'高三(2)班');

/*Table structure for table `clazz_student` */

DROP TABLE IF EXISTS `clazz_student`;

CREATE TABLE `clazz_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clazz_id` int(11) DEFAULT NULL,
  `stu_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;

/*Data for the table `clazz_student` */

insert  into `clazz_student`(`id`,`clazz_id`,`stu_id`) values (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,2,11),(12,2,12),(13,2,13),(14,2,14),(15,2,15),(16,2,16),(17,2,17),(18,2,18),(19,2,19),(20,2,20),(21,3,21),(22,3,22),(23,3,23),(24,3,24),(25,3,25),(26,3,26),(27,3,27),(28,3,28),(29,3,29),(30,3,30),(31,4,31),(32,4,32),(33,4,33),(34,4,34),(35,4,35),(36,4,36),(37,4,37),(38,4,38),(39,4,39),(40,4,40),(41,5,41),(42,5,42),(43,5,43),(44,5,44),(45,5,45),(46,5,46),(47,5,47),(48,5,48),(49,5,49),(50,5,50),(51,6,51),(52,6,52),(53,6,53),(54,6,54),(55,6,55),(56,6,56),(57,6,57),(58,6,58),(59,6,59),(60,6,60);

/*Table structure for table `grade` */

DROP TABLE IF EXISTS `grade`;

CREATE TABLE `grade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

/*Data for the table `grade` */

insert  into `grade`(`id`,`name`) values (1,'高一'),(2,'高二'),(3,'高三');

/*Table structure for table `grade_clazz` */

DROP TABLE IF EXISTS `grade_clazz`;

CREATE TABLE `grade_clazz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `grade_id` int(11) DEFAULT NULL,
  `clazz_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `grade_clazz` */

insert  into `grade_clazz`(`id`,`grade_id`,`clazz_id`) values (1,1,1),(2,1,2),(3,2,3),(4,2,4),(5,3,5),(6,3,6);

/*Table structure for table `student` */

DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `sex` varchar(60) DEFAULT NULL,
  `chinese` int(11) DEFAULT NULL,
  `math` int(11) DEFAULT NULL,
  `english` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8;

/*Data for the table `student` */

insert  into `student`(`id`,`name`,`sex`,`chinese`,`math`,`english`) values (1,'王一','男',67,100,54),(2,'王二','女',76,45,78),(3,'王三','女',95,58,98),(4,'王四','女',85,65,66),(5,'王五','男',55,85,54),(6,'张一','男',100,95,97),(7,'张二','男',75,18,78),(8,'张三','女',89,75,46),(9,'张四','女',84,98,85),(10,'张武','男',71,75,74),(11,'李一','男',68,62,100),(12,'李二','男',99,91,99),(13,'李三','女',41,100,95),(14,'李四','女',96,87,83),(15,'刘一','女',54,71,89),(16,'刘二','男',63,72,85),(17,'刘三','男',63,69,74),(18,'刘四','男',41,85,78),(19,'刘五','男',96,87,98),(20,'刘六','女',54,55,57),(21,'赵一','男',67,76,54),(22,'赵二','女',77,97,54),(23,'赵三','男',54,79,54),(24,'赵四','女',98,79,54),(25,'赵五','男',98,67,54),(26,'赵刘','女',87,65,54),(27,'赵七','男',76,54,54),(28,'赵八','男',65,45,54),(29,'赵九','女',87,45,54),(30,'赵十','女',98,45,54),(31,'钱一','女',77,76,54),(32,'钱二','女',67,76,54),(33,'钱三','男',67,76,54),(34,'钱四','女',77,76,54),(35,'钱五','女',67,76,54),(36,'钱刘','女',67,76,54),(37,'钱七','男',67,76,54),(38,'钱八','女',67,95,54),(39,'钱九','男',67,95,54),(40,'钱十','女',67,95,54),(41,'孙一','男',67,95,54),(42,'孙二','男',67,76,54),(43,'孙三','女',67,76,54),(44,'孙四','女',67,76,54),(45,'孙五','男',67,76,54),(46,'孙刘','女',31,76,54),(47,'孙七','男',32,76,54),(48,'孙八','女',67,78,54),(49,'孙九','男',67,78,54),(50,'孙十','男',45,78,54),(51,'李一','男',78,78,54),(52,'李二','女',67,78,54),(53,'李三','男',98,78,54),(54,'李四','女',89,78,54),(55,'李五','男',67,78,54),(56,'李刘','女',76,78,54),(57,'李七','男',56,78,54),(58,'李八','女',98,54,54),(59,'李九','男',67,78,54),(60,'李十','男',87,78,54),(61,'',NULL,NULL,NULL,NULL);

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

/*Data for the table `user` */

insert  into `user`(`id`,`name`,`age`) values (1,'张三',22),(2,'李四',20),(3,'王五',18),(4,'枫叶',25);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;