CREATE TABLE `front_user` ( `user_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'USER 唯一ID', `user_phone` varchar(20) NOT NULL DEFAULT '' COMMENT '用户手机号', `user_mail` varchar(50) NOT NULL DEFAULT '' COMMENT '用户邮箱', `enabled_state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态1-启用，0-禁用', `score` double(5,2) NOT NULL DEFAULT '0.00' COMMENT '当前积分', `wallet_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '钱包可用金额', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`user_id`), UNIQUE KEY `idx_user_phone` (`user_phone`), UNIQUE KEY `idx_user_mail` (`user_mail`), KEY `idx_create_time` (`create_time`) ) COMMENT='前端用户表';