一、建表
用户表tb_user
create table if not exists tb_user( user_id int auto_increment, user_name varchar(32) not null, user_password varchar(64) not null, user_avatar varchar(128) default null, user_city varchar(32) not null, user_createdat datetime default current_timestamp, user_updatedat datetime default current_timestamp on update current_timestamp, primary key(user_id), unique(user_name) )default charset = utf8;
博客表tb_blog
create table if not exists tb_blog( blog_id int auto_increment, blog_user_id int not null, blog_title varchar(100) not null, blog_content varchar(1024) not null, blog_createdat datetime default current_timestamp, blog_updatedat datetime default current_timestamp on update current_timestamp, primary key(blog_id), foreign key(blog_user_id) references tb_user(user_id) on delete cascade on update cascade )default charset=utf8;
标签表tb_tag
create table if not exists tb_tag( tag_id int auto_increment, tag_content varchar(16) not null, primary key(tag_id) )default charset = utf8;
博客标签表tb_blog_tag
create table if not exists tb_blog_tag( blog_tag_id int auto_increment, rel_blog_id int not null, rel_tag_id int not null, primary key(blog_tag_id), foreign key(rel_blog_id) references tb_blog(blog_id) on delete cascade on update cascade, foreign key(rel_tag_id) references tb_tag(tag_id) on delete cascade on update cascade )default charset=utf8;
评论内容tb_comment
create table if not exists tb_comment( comment_id int auto_increment, comment_blog_id int not null, comment_user_id int not null, comment_content varchar(256) not null, comment_createdat datetime default current_timestamp, comment_updatedat datetime default current_timestamp on update current_timestamp, primary key(comment_id), foreign key(comment_blog_id) references tb_blog(blog_id) on delete cascade on update cascade, foreign key(comment_user_id) references tb_user(user_id) on delete cascade on update cascade )default charset = utf8;