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 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`),
    UNIQUE KEY (`phone`),
    INDEX `idx_username` (`username`),
    INDEX `idx_phone` (`phone`)
) 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'),
    ('admin2', '13333330001', null, '$2a$10$lVO.VhDbyCKMsfajNQc6xO4aZsWMHu0p5YuVATNuAgLV8Pbjkv17W'),
    ('admin3', '13333330002', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('aaa', '13333330003', null, '123456'),
    ('bbb', '13333330004', null, '123456'),
    ('ccc', '13333330005', null, '123456'),
    ('ddd', '13333330006', null, '123456'),
    ('eee', '13333330007', null, '123456'),
    ('fff', '13333330008', null, '123456'),
    ('gkyaGYjs', '13333330009', null, '123456'),
    ('hhh', '13333330010', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('iii', '13333330011', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('lulu', '13333330012', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('limeiying', '13333330013', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('chenjiayang', '13333330014', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy'),
    ('hongzexin','13333330015', null, '$2a$10$Uo530feMzEZFIU9y40uiteN493JWtJQBVpLBRVWC4dg/Mv7eaUhMy')
;