yvjia/db/sys_user.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_user`;

CREATE TABLE `sys_user` (
    PRIMARY KEY (`id`),
    `id` BIGINT(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `username` VARCHAR(20) COMMENT '用户名',
    `phone` VARCHAR(20) COMMENT '手机号码',
    `phone_area_code` INT COMMENT '手机区号/国家码',
    `password` VARCHAR(100) NOT NULL COMMENT '密码',
    UNIQUE KEY (`username`),
    INDEX `idx_username` (`username`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统用户表';

# 原始密码：123456
# 前端MD5加密：e10adc3949ba59abbe56e057f20f883e
# 后端使用BCrypt加密：(加盐)

INSERT INTO sys_user(username, phone, phone_area_code, password) VALUES
    ('admin', '13670511519', 86, '$2a$10$xITUWkoJydVbYzwh2nflmOWTTGFp0bByyFXnr2l5W1ZM080uPseEC'),
    ('admintest', '', null, '$2a$10$lVO.VhDbyCKMsfajNQc6xO4aZsWMHu0p5YuVATNuAgLV8Pbjkv17W'),
    ('admintest2', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('aaa', '', null, '123456'),
    ('bbb', '', null, '123456'),
    ('ccc', '', null, '123456'),
    ('ddd', '', null, '123456'),
    ('eee', '', null, '123456'),
    ('fff', '', null, '123456'),
    ('gkyaGYjs', '', null, '123456'),
    ('hhh', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('iii', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('lulu', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('limeiying', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('chenjiayang', '', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('hongzexin','', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy')
;