big event sql

CREATE DATABASE big_event /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTIONN */;-- big_event.article definitionCREATE TABLE article (id int unsigned NOT NULL AUTO_INCREMENT COMMENT ID,title varchar(30) NOT NULL COMMENT 文章标题,content varchar(10000) NOT NULL COMMENT 文章内容,cover_img varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 文章封面,state varchar(3) DEFAULT 草稿 COMMENT 文章状态: 只能是[已发布] 或者 [草稿],category_id int unsigned DEFAULT NULL COMMENT 文章分类ID,create_user int unsigned NOT NULL COMMENT 创建人ID,create_time datetime NOT NULL COMMENT 创建时间,update_time datetime NOT NULL COMMENT 修改时间,PRIMARY KEY (id),KEY fk_article_category (category_id),KEY fk_article_user (create_user),CONSTRAINT fk_article_category FOREIGN KEY (category_id) REFERENCES category (id),CONSTRAINT fk_article_user FOREIGN KEY (create_user) REFERENCES user (id)) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8mb3;-- big_event.category definitionCREATE TABLE category (id int unsigned NOT NULL AUTO_INCREMENT COMMENT ID,category_name varchar(32) NOT NULL COMMENT 分类名称,category_alias varchar(32) NOT NULL COMMENT 分类别名,create_user int unsigned NOT NULL COMMENT 创建人ID,create_time datetime NOT NULL COMMENT 创建时间,update_time datetime NOT NULL COMMENT 修改时间,PRIMARY KEY (id),KEY fk_category_user (create_user),CONSTRAINT fk_category_user FOREIGN KEY (create_user) REFERENCES user (id)) ENGINEInnoDB AUTO_INCREMENT7 DEFAULT CHARSETutf8mb3;-- big_event.user definitionCREATE TABLE user (id int unsigned NOT NULL AUTO_INCREMENT COMMENT ID,username varchar(20) NOT NULL COMMENT 用户名,password varchar(32) DEFAULT NULL COMMENT 密码,nickname varchar(10) DEFAULT COMMENT 昵称,email varchar(128) DEFAULT COMMENT 邮箱,user_pic varchar(128) DEFAULT COMMENT 头像,create_time datetime NOT NULL COMMENT 创建时间,update_time datetime NOT NULL COMMENT 修改时间,PRIMARY KEY (id),UNIQUE KEY username (username)) ENGINEInnoDB AUTO_INCREMENT5 DEFAULT CHARSETutf8mb3 COMMENT用户表;