Database - xhjxhj001/chatroom GitHub Wiki

User

CREATE TABLE `user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `user_id` bigint(20) unsigned DEFAULT NULL COMMENT '用户uid',
  `user_account` varchar(255) NULL COMMENT '用户账号',
  `email` varchar(255) NULL COMMENT '用户email',
  `name` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '用户名',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `avatar` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '头像',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态: 1:正常, 0:失效',
  `ctime` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间戳',
  `mtime` int(12) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间戳',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci