MySql建表语句，教师，学生，班级

DROP DATABASE IF EXISTS Teach;
CREATE DATABASE Teach  DEFAULT CHARACTER SET utf8;
USE Teach;

CREATE TABLE class (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
INSERT INTO class VALUES(01,'class1');
INSERT INTO class VALUES(02,'class2');

CREATE TABLE teacher (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  cid int(11) DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO teacher VALUES(01,'teacher1',01);
INSERT INTO teacher VALUES(02,'teacher2',01);
INSERT INTO teacher VALUES(03,'teacher3',02);
INSERT INTO teacher VALUES(04,'teacher4',02);

CREATE TABLE student (
  id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(255) DEFAULT NULL,
  cid int(11) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY fk_student_class (cid)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO student VALUES(01,'student1',01);
INSERT INTO student VALUES(02,'student2',01);
INSERT INTO student VALUES(03,'student3',01);
INSERT INTO student VALUES(04,'student4',01);
INSERT INTO student VALUES(05,'student5',02);
INSERT INTO student VALUES(06,'student6',02);
INSERT INTO student VALUES(07,'student7',02);
INSERT INTO student VALUES(08,'student8',02);

CREATE TABLE stuteach (
  id int(11) NOT NULL AUTO_INCREMENT,
  sid int(11) DEFAULT NULL,
  tid int(11) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY fk_stuteach_student (sid),
  KEY fk_stuteach_teacher (tid)
)ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;
INSERT INTO stuteach VALUES(01,01,01);
INSERT INTO stuteach VALUES(02,02,01);
INSERT INTO stuteach VALUES(03,03,01);
INSERT INTO stuteach VALUES(04,04,01);
INSERT INTO stuteach VALUES(05,05,02);
INSERT INTO stuteach VALUES(06,06,02);
INSERT INTO stuteach VALUES(07,07,02);
INSERT INTO stuteach VALUES(08,08,02);
select * from stuteach;