stephensuxun commented on issue #12426:
URL:
https://github.com/apache/shardingsphere/issues/12426#issuecomment-919015883
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for ainews_user_914
-- ----------------------------
DROP TABLE IF EXISTS `ainews_user_914`;
CREATE TABLE `ainews_user_914` (
`user_id` bigint NOT NULL COMMENT '用户ID',
`user_account` varchar(100) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户账号',
`user_name` varchar(100) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户名',
`nick_name` varchar(100) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户昵称',
`user_password` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户密码',
`user_header_portrait` varchar(255) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户的头像',
`user_email` varchar(100) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户的邮箱地址',
`user_used_amount` int DEFAULT '0' COMMENT '用户使用的数量',
`user_total_usage` int DEFAULT '0' COMMENT '用户使用的总量',
`user_salt` varchar(20) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT NULL COMMENT '用户的盐值',
`user_secret` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci
COMMENT '用户的密文',
`user_status` int DEFAULT '1' COMMENT '用户的状态 0代表冻结 1代表正常',
`user_type` varchar(10) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT '0' COMMENT '用户的类型 -1测试 0普通用户 1付费用户 2普通企业 3付费企业',
`is_authentication` varchar(10) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT '-1' COMMENT '是否通过认证 -1未认证 1个人认证 2企业认证 3代表审核中',
`user_grade` int DEFAULT '1' COMMENT '用户的等级',
`user_point` varchar(32) CHARACTER SET utf8mb4 COLLATE
utf8mb4_unicode_520_ci DEFAULT '0' COMMENT '用户的积分',
`user_create_amount` int DEFAULT '0' COMMENT '用户创作的数量',
`user_collect_amount` int DEFAULT '0' COMMENT '用户收藏的数量',
`expiration_date` datetime DEFAULT NULL COMMENT '到期时间',
`create_time` datetime DEFAULT NULL COMMENT '用户注册时间',
`update_time` datetime DEFAULT NULL COMMENT '用户更新时间',
`version` int DEFAULT '0' COMMENT '乐观锁',
`deleted` int DEFAULT '0' COMMENT '逻辑删除',
`token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci COMMENT
'用户的token',
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
COMMENT='';
SET FOREIGN_KEY_CHECKS = 1;
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
