1
2
3
4
5
6
7
8
9
10
11
12
13
| -- 测试用户数据
| -- 插入测试用户到 t_user 表
| INSERT INTO t_user (name, wx_open_id, wx_union_id, state, mobile, create_time, update_time, version) VALUES
| ('测试员工', 'test_employee_openid', 'test_employee_unionid', 1, '13800000001', NOW(), NOW(), 0),
| ('测试评委', 'test_judge_openid', 'test_judge_unionid', 1, '13800000002', NOW(), NOW(), 0);
|
| -- 插入测试员工到 t_employee 表
| INSERT INTO t_employee (name, phone, password, role_id, user_id, state, create_time, update_time, version, description) VALUES
| ('测试员工', '13800000001', '$2a$10$N.zmdr9k7uOCQb96VdOYx.93UGOXOQAaJLVrpJeJEPPTJZaGqQ4oa', 'ADMIN', 1, 1, NOW(), NOW(), 0, '系统测试员工账号');
|
| -- 插入测试评委到 t_judge 表
| INSERT INTO t_judge (name, user_id, phone, gender, state, description, create_time, update_time, version, title, company, introduction) VALUES
| ('测试评委', 2, '13800000002', 1, 1, '系统测试评委账号', NOW(), NOW(), 0, '高级技术专家', '测试公司', '拥有丰富的技术评审经验');
|
|
