CREATETABLEuser(
id BIGINTPRIMARYKEYAUTO_INCREMENT,
username VARCHAR(255)UNIQUENOTNULL,
password VARCHAR(64)NOTNULL,
nickname VARCHAR(255)NOTNULL,
avatar VARCHAR(255)NOTNULL);CREATETABLE category (
id BIGINTPRIMARYKEYAUTO_INCREMENT,
statusId BIGINTNOTNULL,
name VARCHAR(20)UNIQUENOTNULL,
detail VARCHAR(255));CREATETABLE article (
id BIGINTPRIMARYKEYAUTO_INCREMENT,
user_id BIGINTNOTNULL,
cover_image VARCHAR(255)NOTNULL,
category_id INTNOTNULL,statusTINYINTNOTNULLDEFAULT0,
title VARCHAR(200)NOTNULL,
content TEXTNOTNULL,
view_count BIGINTNOTNULLDEFAULT0,
created_at DATETIMENOTNULL,
updated_at DATETIMENOTNULL);CREATETABLEcomment(
id BIGINTPRIMARYKEYAUTO_INCREMENT,
user_id BIGINTNOTNULL,
article_id BIGINTNOTNULL,
content VARCHAR(400)NOTNULL,
created_at DATETIMENOTNULL);
三、编写pojo类
publicclassArticle{private Long id;private Long userId;private String coverImage;privateint categoryId;privatebyte status;private String title;private String content;private Long viewCount;private Date createdAt;private Date updatedAt;private User author;// 文章作者private Integer commentCount;// 文章评论数private List<Comment> commentList;}publicclassCategory{private Long id;privateint statusId;private String name;private String detail;private Long articleCount;}publicclassComment{private Long id;private Long userId;private Long articleId;private String content;private Date createdAt;private User user;}publicclassUser{private Long id;private String username;private String password;private String nickname;private String avatar;}