```[sql-table]
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL COMMENT '用户昵称',
`username` varchar(255) DEFAULT NULL COMMENT '用户名',
`email` varchar(255) DEFAULT NULL COMMENT '邮箱',
`email_active` tinyint(1) NOT NULL DEFAULT '0' COMMENT '邮箱是否验证',
`password` varchar(255) DEFAULT NULL COMMENT '密码',
`description` varchar(255) DEFAULT NULL COMMENT '个人简介',
`origin` varchar(255) DEFAULT NULL COMMENT '用户来源',
`login_count` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
`login_time` timestamp NULL DEFAULT NULL COMMENT '登录时间',
`login_ip` varchar(45) DEFAULT NULL COMMENT '登录ip',
`reg_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
`reg_ip` varchar(45) NOT NULL COMMENT '注册ip',
`salt` varchar(50) DEFAULT NULL COMMENT '密码加盐',
`coin` int(11) unsigned NOT NULL DEFAULT '0',
`token` varchar(255) DEFAULT NULL COMMENT '令牌',
`remember_token` varchar(255) DEFAULT NULL COMMENT '记住我令牌',
`commission_ratio` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '手续费率',
`sale_book_number` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '收费文档数量',
`delete_time` timestamp NULL DEFAULT NULL,
`dashboard` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `token` (`token`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
```