高级版的user表结构:
CREATE TABLE user (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) NOT NULL,
auth_key varchar(32) NOT NULL,
password_hash varchar(255) NOT NULL,
password_reset_token varchar(255) DEFAULT NULL,
email varchar(255) NOT NULL,
role smallint(6) NOT NULL DEFAULT '10',
status smallint(6) NOT NULL DEFAULT '10',
created_at int(11) NOT NULL,
updated_at int(11) NOT NULL,
PRIMARY KEY (id)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;