17 lines
720 B
MySQL
17 lines
720 B
MySQL
|
DROP TABLE IF EXISTS `user`;
|
||
|
|
SET character_set_client = utf8mb4 ;
|
||
|
|
CREATE TABLE `user` (
|
||
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
||
|
|
`username` varchar(50) DEFAULT NULL,
|
||
|
|
`password` varchar(50) DEFAULT NULL,
|
||
|
|
`salt` varchar(50) DEFAULT NULL,
|
||
|
|
`email` varchar(100) DEFAULT NULL,
|
||
|
|
`type` int(11) DEFAULT NULL COMMENT '0-普通用户; 1-超级管理员; 2-版主;',
|
||
|
|
`status` int(11) DEFAULT NULL COMMENT '0-未激活; 1-已激活;',
|
||
|
|
`activation_code` varchar(100) DEFAULT NULL,
|
||
|
|
`header_url` varchar(200) DEFAULT NULL,
|
||
|
|
`create_time` timestamp NULL DEFAULT NULL,
|
||
|
|
PRIMARY KEY (`id`),
|
||
|
|
KEY `index_username` (`username`(20)),
|
||
|
|
KEY `index_email` (`email`(20))
|
||
|
|
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
|