65 lines
2.1 KiB
MySQL
65 lines
2.1 KiB
MySQL
|
-- 初始化用户数据（与 sys schema 对应）
|
||
|
|
-- 创建系统管理员账户和示例用户
|
||
|
|
|
||
|
|
-- =============================
|
||
|
|
-- 1. 创建超级管理员用户
|
||
|
|
-- =============================
|
||
|
|
-- 注意：密码需要使用 bcrypt 加密，这里使用的是 'admin123' 的 bcrypt hash
|
||
|
|
-- 实际部署时应该修改为安全的密码
|
||
|
|
INSERT INTO sys.tb_sys_user (
|
||
|
|
optsn, user_id, usercode, password, email, phone,
|
||
|
|
create_time, status, deleted
|
||
|
|
) VALUES
|
||
|
|
('USER-0001', 'user_admin', 'admin',
|
||
|
|
'$2a$10$N.zmdr9k7uOCQb376NoUnuTJ8iAt6Z5EHsM8lE9lBOsl7q0TP/Hza', -- admin123
|
||
|
|
'admin@urbanlifeline.com', '13800138000',
|
||
|
|
now(), 1, false);
|
||
|
|
|
||
|
|
-- 超级管理员用户信息
|
||
|
|
INSERT INTO sys.tb_sys_user_info (
|
||
|
|
optsn, user_id, username, avatar, gender, level, remark,
|
||
|
|
create_time, deleted
|
||
|
|
) VALUES
|
||
|
|
('UINFO-0001', 'user_admin', '系统管理员',
|
||
|
|
'/static/avatar/admin.png', 1, 10, '系统超级管理员账户',
|
||
|
|
now(), false);
|
||
|
|
|
||
|
|
-- =============================
|
||
|
|
-- 2. 关联超级管理员角色
|
||
|
|
-- =============================
|
||
|
|
INSERT INTO sys.tb_sys_user_role (
|
||
|
|
optsn, user_id, role_id, dept_id, dept_path,
|
||
|
|
creator, create_time, deleted
|
||
|
|
) VALUES
|
||
|
|
('UR-0001', 'user_admin', 'role_super_admin', 'dept_root', '/dept_root/',
|
||
|
|
'system', now(), false);
|
||
|
|
|
||
|
|
-- =============================
|
||
|
|
-- 3. 创建示例普通用户（可选）
|
||
|
|
-- =============================
|
||
|
|
INSERT INTO sys.tb_sys_user (
|
||
|
|
optsn, user_id, usercode, password, email, phone,
|
||
|
|
create_time, status, deleted
|
||
|
|
) VALUES
|
||
|
|
('USER-0002', 'user_demo', 'demo',
|
||
|
|
'$2a$10$N.zmdr9k7uOCQb376NoUnuTJ8iAt6Z5EHsM8lE9lBOsl7q0TP/Hza', -- admin123
|
||
|
|
'demo@urbanlifeline.com', '13800138001',
|
||
|
|
now(), 1, false);
|
||
|
|
|
||
|
|
-- 示例用户信息
|
||
|
|
INSERT INTO sys.tb_sys_user_info (
|
||
|
|
optsn, user_id, username, avatar, gender, level, remark,
|
||
|
|
create_time, deleted
|
||
|
|
) VALUES
|
||
|
|
('UINFO-0002', 'user_demo', '演示用户',
|
||
|
|
'/static/avatar/demo.png', 0, 1, '系统演示账户',
|
||
|
|
now(), false);
|
||
|
|
|
||
|
|
-- 关联普通用户角色
|
||
|
|
INSERT INTO sys.tb_sys_user_role (
|
||
|
|
optsn, user_id, role_id, dept_id, dept_path,
|
||
|
|
creator, create_time, deleted
|
||
|
|
) VALUES
|
||
|
|
('UR-0002', 'user_demo', 'role_user', 'dept_root', '/dept_root/',
|
||
|
|
'system', now(), false);
|