# 创建数据库
drop database if exists blog_db;
create database blog_db character set utf8mb4 collate utf8mb4_general_ci;

# 选择数据库
use blog_db;

# 创建表
drop table if exists user;
create table user (
                      id bigint primary key auto_increment comment '用户Id，自增',
                      username varchar(50) unique not null comment '用户名',
                      password varchar(50) not null comment '密码'
);

drop table if exists blog;
create table blog (
                      id bigint primary key auto_increment comment 'Id，自增',
                      title varchar(1024) not null comment '标题',
                      content text not null comment '内容',
                      createTime datetime not null comment '发布时间',
                      userId bigint not null
);

insert into user values (null, '张三', '123456');
insert into user values (null, '李四', '123456');