数据表

CREATE TABLE blog (
  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  title VARCHAR(128) NOT NULL,
  text TEXT,
  preview VARCHAR(128),
  author VARCHAR(32),
  category VARCHAR(32),
  date TIMESTAMP DEFAULT '2016-05-20 00:00:00'
);

CREATE TABLE message (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    author VARCHAR(32),
    content TEXT,
    date TIMESTAMP DEFAULT '2016-05-20 00:00:00'
)