the structure of table sys_user is not the same with the code
Opened this issue · 2 comments
szjinqh commented
the structure of table sys_user is not the same with the code
and the code is not completed
julianhu1979 commented
我也发现这个问题。代码中的用户表还有电话字段,但是表结构中没有
achinRen commented
可以执行这个脚本
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(80) NOT NULL COMMENT '用户名',
`email` VARCHAR(120) DEFAULT NULL COMMENT 'email',
`phone` VARCHAR(20) DEFAULT NULL COMMENT 'phone',
`avatar` VARCHAR(200) DEFAULT NULL COMMENT 'avatar',
`STATUS` INT(1) DEFAULT NULL COMMENT 'STATUS',
`password_hash` VARCHAR(128) DEFAULT NULL COMMENT '加密密码',
`createTime` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updateTime` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`lastLoginTime` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT 'lastLoginTime',
`createBy` VARCHAR(50) DEFAULT NULL COMMENT 'createBy',
`updateBy` VARCHAR(50) DEFAULT NULL COMMENT 'updateBy',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8