mysql8.0,存储引擎为innodb，
表结构

CREATE TABLE f5_student (
id int(10) UNSIGNED NOT NULL,
sno varchar(20) NOT NULL COMMENT ‘学号’,
name varchar(30) NOT NULL COMMENT ‘姓名’,
openid varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘微信公众号openid’,
unionid varchar(50) NOT NULL DEFAULT ‘’ COMMENT ‘微信unionid’,
dept_id smallint(5) UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘院系ID’,
class_id mediumint(8) UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘班级ID’,
major_id mediumint(8) UNSIGNED NOT NULL DEFAULT ‘0’ COMMENT ‘专业ID’,
come_year smallint(5) UNSIGNED NOT NULL COMMENT ‘入学年份’,
gender tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘性别 1男 2女’,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘学生信息表’;