yvjia/db/b2c_member.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/11/26 08:05:21
*/

DROP TABLE IF EXISTS `b2c_member`;
CREATE TABLE `b2c_member` (
   PRIMARY KEY (`id`),
   `id` BIGINT AUTO_INCREMENT,
   `open_id` VARCHAR(32) COMMENT 'OpenID',
   `nickname` VARCHAR(20) COMMENT '昵称',
   `phone` VARCHAR(20) COMMENT '手机号码',
   `email` VARCHAR(50) COMMENT '邮箱地址',
   `password` VARCHAR(100) NOT NULL COMMENT '密码',
   `gender` TINYINT(1) DEFAULT NULL COMMENT '性别(1男, 2女, 3保密)',
   `avatar` VARCHAR(1000) DEFAULT NULL COMMENT '头像',
   `last_login_uuid` VARCHAR(36) COMMENT '最后登录UUID',
   `last_login_ip` VARCHAR(20) COMMENT '最后登录IP',
   `last_login_time` DATETIME COMMENT '最后登录时间',
   `status` TINYINT(1) DEFAULT '1' COMMENT '账号状态 (-1禁用, 1启用)',
   `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
   `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
   `del_flag` TINYINT(1) DEFAULT '-1' COMMENT '删除标志 (-1未删除, 1删除)',
   INDEX `idx_nickname` (`nickname`),
   INDEX `idx_phone` (`phone`),
   INDEX `idx_email` (`email`)
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='会员表';

INSERT INTO b2c_member(open_id, nickname, phone, email, password, gender) VALUES
    ('o_FiE5k6Bx9svZ12ZpzegVcOaMfc', 'Mure', '13670511519', '405348097@qq.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('r_VqY5uWtbGiW7vPAQ8VZT6poiRs', '张小红', '13123456781', 'zhangxh@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('x_LgT3mZfCvXoQ58AlrWE3r9BkeI', '李建国', '13123456782', 'lijg@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('c_PoE7nF95XvAmT4JuReD4wBhsmL', '王丽华', '13123456783', 'wanglh@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('s_YsC4qF8thD7BHg1oJEvKxeznU9V', '刘大伟', '13123456784', 'liudw@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('m_NdG0sH7jHhKMV1zD9UpWj7h98L', '陈小娟', '13123456785', 'chenxj@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('d_SeA8kN9eY6xByC0iQOW7wZ2tjq', '张伟', '13123456786', 'zhangw@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('z_KwZ0sG5eO9AuH7MjCeS4fI80vL', '刘小飞', '13123456787', 'liuxf@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('f_PlO7mJ9iNnYjM5csEpG4wFhX02', '杨丽', '13123456788', 'yangl@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('t_RbP9vC2lUMk5T0O8yZbF6kzG1D', '赵磊', '13123456789', 'zhaol@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('n_EfZ3bD6vJiMxHg4LyPbQ8FzK5C', '陈建华', '13123456790', 'chenjh@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('y_HlK2vG8eSkV9dT7OxQF6gW3U0Z', '张秀英', '13123456791', 'zhangxy@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1),
    ('l_BvX2zM3dKcJYiF7QeEf6gS4lsN', '王建军', '13123456792', 'wangjj@example.com', '$2a$10$0cFrGBWCP42iqolPYwH5c.ZfpuawXqMl3NiQI2WArzeNdwJyGwGAy', 1)
;