DROP TABLE IF EXISTS `student`;

CREATE TABLE `student` (
  `id` int NOT NULL,
  `password` varchar(50) DEFAULT '123',
  `name` varchar(50) DEFAULT '',
  `sex` varchar(20) DEFAULT '男',
  `school_date` varchar(50) ,
  `major` varchar(50) ,
  `email` varchar(50) ,
  PRIMARY KEY (`id`)
);




LOCK TABLES `student` WRITE;

INSERT INTO `student` VALUES ('2022212001','123','李明','男','2022-9','计算机科学与技术',NULL),('2022212015','123','张三','男','2022-9','计算机科学与技术',NULL),('2022212033','123','小红','女','2022-9','计算机科学与技术',NULL),('2022212045','123','小宇','男','2022-9','计算机科学与技术',NULL),('2022212077','123','王五','男','2022-9','计算机科学与技术',NULL),('2022212099','123','赵四','男','2022-9','计算机科学与技术',NULL),('2022213011','123','小帅','男','2022-9','软件工程',NULL),('2022213015','123','吴用','男','2022-9','软件工程',NULL),('2022211088','123','王配','男','2022-9','人工智能',NULL),('2022211100','123','小丽','女','2022-9','人工智能',NULL),('2022211095','123','刘明','男','2022-9','人工智能',NULL),('2022211003','123','小黄','男','2022-9','人工智能',NULL),('2022213046','123','王林','男','2022-9','软件工程',NULL);

UNLOCK TABLES;



DROP TABLE IF EXISTS `teacher`;

CREATE TABLE `teacher` (
  `id` int NOT NULL,
  `password` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT '',
  `sex` varchar(20) DEFAULT '男',
  `email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
);



LOCK TABLES `teacher` WRITE;

INSERT INTO `teacher` VALUES ('199911','lzf','lzf','男','226978874@qq.com');

UNLOCK TABLES;



DROP TABLE IF EXISTS `score`;

CREATE TABLE `score` (
  `id` int NOT NULL,
  `dat` varchar(50) DEFAULT '',
  `android` varchar(50) DEFAULT '',
  `jsp` varchar(50) DEFAULT '',
  PRIMARY KEY (`id`),
	FOREIGN KEY(id) REFERENCES student(id)
);



LOCK TABLES `score` WRITE;

INSERT INTO `score` VALUES ('2022212001','90','59','90'),('2022212015','59','84','90'),('2022212033','93','97','90'),('2022212045','70','90','90'),('2022212077','90','50','50'),('2022212099','90','90','92'),('2022213011','90','90','90'),('2022213015','40','90','90'),('2022211088','90','90','90'),('2022211100','90','90','90'),('2022211095','85','94','90'),('2022211003','75','67','76'),('2022213046','89','78','87');

UNLOCK TABLES;


-- AUTO_INCREMENT