数据库建表

use spmms;
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '学号',
  `name` varchar(20) NOT NULL COMMENT '姓名',
  `password` varchar(20) NOT NULL COMMENT '登录密码',
   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

use spmms;
DROP TABLE IF EXISTS `kcb`;
CREATE TABLE `kcb` (
  `cno` int(20) NOT NULL AUTO_INCREMENT COMMENT '课程号',
  `cn` varchar(20) NOT NULL COMMENT '课程名',
  `xf` varchar(20) NOT NULL COMMENT '学分',
  `xs` varchar(2) NOT NULL COMMENT '学时',
   PRIMARY KEY (`cno`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

use spmms;
DROP TABLE IF EXISTS `scb`;
CREATE TABLE `scb` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '计数',
  `cno` int(20) DEFAULT NULL COMMENT '课程号',
  `scid` int(11) DEFAULT NULL COMMENT '学生学号',
   PRIMARY KEY (`id`),
   CONSTRAINT `scb_ibfk_1` FOREIGN KEY (`cno`) REFERENCES `kcb` (`cno`) ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT `scb_ibfk_2` FOREIGN KEY (`scid`) REFERENCES `xsb` (`snumber`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

use spmms;
DROP TABLE IF EXISTS `XSB`;
CREATE TABLE `XSB` (
  `snumber` int(11) NOT NULL AUTO_INCREMENT COMMENT  '学号',
  `sname` varchar(20) DEFAULT NULL COMMENT '姓名',
  `ssex` varchar(20) DEFAULT NULL COMMENT '性别',
  `sgrade` varchar(20) DEFAULT NULL COMMENT '班级',
  `smajor` varchar(20) DEFAULT NULL COMMENT '专业',
  `sdept` varchar(20) DEFAULT NULL COMMENT '学院',
  `sroom` varchar(20) DEFAULT NULL COMMENT '宿舍',
  PRIMARY KEY (`snumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;