composer install

php ./yii install

drop table if exists `tbl_user`; 
CREATE TABLE tbl_user 
( 
 `user_id` INTEGER NOT NULL AUTO_INCREMENT comment '主键', 
 `username` VARCHAR(128) NOT NULL comment '用户名', 
 `nickname` VARCHAR(128) NOT NULL comment '昵称', 
 `password` VARCHAR(128) NOT NULL comment '密码', 
 `email` VARCHAR(128) NOT NULL comment '邮箱', 
 `is_delete` tinyint not null default 0 comment '删除标志', 
 unique key(`username`), 
 primary key (`user_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 comment='用户表'; 
 
drop table if exists `tbl_post`; 
CREATE TABLE tbl_post 
( 
 `post_id` INTEGER NOT NULL AUTO_INCREMENT comment '主键', 
 `title` VARCHAR(128) NOT NULL comment '标题', 
 `content` TEXT NOT NULL comment '文章内容', 
 `tags` TEXT comment '标签', 
 `status` INTEGER NOT NULL comment '状态，0 = 草稿，1 = 审核通过，-1 = 审核不通过，2 = 发布', 
 `create_time` INTEGER comment '创建时间', 
 `update_time` INTEGER comment '更新时间', 
 `author_id` INTEGER NOT NULL comment '作者', 
 `is_delete` tinyint not null default 0 comment '删除标志', 
 CONSTRAINT `post_ibfk_1` FOREIGN KEY (author_id) 
  REFERENCES tbl_user (`user_id`) ON DELETE CASCADE ON UPDATE RESTRICT, 
 primary key (`post_id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 comment='日志表';