-- 新建一个库 mysql
CREATE DATABASE
    IF
    NOT EXISTS mybatis;
USE mybatis;

create table blog
(
    bid         int auto_increment
        primary key,
    name        varchar(255)                       null,
    author_id   int                                null,
    create_time datetime default CURRENT_TIMESTAMP null,
    update_time datetime default CURRENT_TIMESTAMP null
)
    charset = utf8;

INSERT INTO `blog` (`bid`, `name`, `author_id`)
VALUES (1, 'RabbitMQ延时消息', 1001);
INSERT INTO `blog` (`bid`, `name`, `author_id`)
VALUES (2, 'MyBatis源码分析', 1008);