运行 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 就是有点问题。