MySQL校友管理系统添加校友表的设计代码

CREATE TABLE alumni ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL, gender varchar(10) NOT NULL, birthday date NOT NULL, email varchar(50) DEFAULT NULL, phone varchar(20) DEFAULT NULL, address varchar(100) DEFAULT NULL, graduate_year int(11) NOT NULL, major varchar(50) NOT NULL, degree varchar(20) NOT NULL, company varchar(100) DEFAULT NULL, position varchar(50) DEFAULT NULL, work_address varchar(100) DEFAULT NULL, create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4