运行 show create table www_members 结构如下:
CREATE TABLE www_members (
id int(11) unsigned NOT NULL AUTO_INCREMENT,
username varchar(20) NOT NULL COMMENT ‘登录帐号’,
password varchar(32) NOT NULL COMMENT ‘登录密码’,
salt varchar(32) NOT NULL COMMENT ‘Salt’,
email varchar(30) NOT NULL COMMENT ‘电子邮箱’,
nickname varchar(30) NOT NULL COMMENT ‘别名’,
type tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘类型’,
avatar_saved_path varchar(30) DEFAULT NULL COMMENT ‘头像’,
registed_at int(11) unsigned NOT NULL COMMENT ‘注册时间’,
registed_ip varchar(15) NOT NULL COMMENT ‘注册 IP’,
is_active tinyint(1) unsigned NOT NULL DEFAULT ‘1’ COMMENT ‘激活’,
last_login_time int(11) unsigned DEFAULT NULL COMMENT ‘最后一次登陆时间’,
last_login_ip varchar(15) DEFAULT NULL COMMENT ‘最后一次登陆IP’,
login_count int(11) unsigned NOT NULL DEFAULT ‘0’ COMMENT ‘登陆次数’,
created_at int(11) unsigned NOT NULL COMMENT ‘添加时间’,
updated_at int(11) unsigned NOT NULL COMMENT ‘更新时间’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=‘Members’
这样是正确的,但是生成的 rule 就是有点问题。