php中yii框架实例用法

poser install

php ./yii install

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