53 lines
4.2 KiB
SQL
53 lines
4.2 KiB
SQL
INSERT INTO sys_user (id, nickname, avatar, gender, email, phone, tenant_id, creator_id, modifier_id, create_time, modify_time, deleted)
|
|
VALUES (1, '管理员', '', 'Unknown', '', '', 1, 1, 1, '2025-04-09 15:09:04', '2025-08-26 09:41:06', 0);
|
|
|
|
INSERT INTO sys_user_account (id, user_id, username, email, phone, secret, wechat_openid, wechat_unionid, regdate, client_code, disabled, creator_id, modifier_id, create_time, modify_time, deleted)
|
|
VALUES (1, 1, 'admin', '', '', '$2a$10$C3G.VZBRnqeL9yDaGkxfGujo5VCxLqp5.raje8lY16oo3yQzP5hBa', '', '', '2025-04-09 15:09:51', 1, 0, 1, 1, '2025-04-09 15:09:49', '2025-08-26 09:41:07', 0);
|
|
INSERT INTO sys_tenant (id, sn, tenant_name, tenant_status, creator_id, modifier_id, create_time, modify_time, deleted)
|
|
VALUES (1, 'zsy', '再昇云', 'QiYong', 1, 1, '2025-04-27 10:10:56', '2025-04-27 10:10:56', 0);
|
|
|
|
INSERT INTO sys_role (id, role_code, role_name, memo, creator_id, modifier_id, create_time, modify_time, deleted)
|
|
VALUES (1, 'ROLE_ADMIN', '管理员', '', 1, 1, '2025-04-11 13:37:13', '2025-08-11 09:30:26', 0);
|
|
|
|
INSERT INTO sys_user_role (id, user_id, role_id)
|
|
VALUES (1, 1, 1);
|
|
|
|
INSERT INTO njzscloud.sys_menu (id, sn, pid, title, icon, tier, breadcrumb, menu_category, freeze, sort, route_name, creator_id, modifier_id, create_time, modify_time, deleted)
|
|
VALUES (1, 'sys', 0, '系统管理', '', 1, '["系统管理"]', 'Catalog', 0, 100, '', 1, 1, '2025-07-30 18:07:10', '2025-07-30 18:07:10', 0),
|
|
(2, 'menus', 1, '菜单管理', 'menu', 1, '["菜单管理"]', 'Page', 0, 100, 'menus', 1, 1, '2025-07-29 16:05:08', '2025-08-01 16:04:18', 0),
|
|
(3, 'menu-create', 2, '新增菜单', '', 2, '["菜单管理"]', 'SubPage', 0, 100, 'menu-create', 1, 1, '2025-07-29 16:05:08', '2025-07-29 16:05:10', 0),
|
|
(4, 'menu-detail', 2, '菜单详情', '', 2, '["菜单管理", "菜单详情"]', 'SubPage', 0, 0, 'menu-detail', 1, 1, '2025-07-31 09:08:13', '2025-07-31 09:08:13', 0),
|
|
(5, 'user', 1, '用户管理', 'user', 1, '["用户管理"]', 'Page', 0, 99, 'user', 1, 1, '2025-07-29 17:25:54', '2025-07-29 17:25:54', 0),
|
|
(6, 'user-create', 5, '新增用户', '', 2, '["用户管理","新增用户"]', 'Page', 0, 0, 'user-create', 1, 1, '2025-07-31 09:09:55', '2025-07-31 09:09:55', 0),
|
|
(7, 'user-detail', 5, '用户详情', '', 2, '["用户管理","用户详情"]', 'Page', 0, 0, 'user-detail', 1, 1, '2025-07-31 09:09:41', '2025-07-31 09:09:41', 0),
|
|
(8, 'role', 1, '角色管理', 'igw-f-role', 1, '["角色管理"]', 'Page', 0, 98, 'role', 1, 1, '2025-07-29 17:26:17', '2025-07-29 17:26:17', 0),
|
|
(9, 'role-create', 8, '新增角色', '', 2, '["角色管理","新增角色"]', 'Page', 0, 0, 'role-create', 1, 1, '2025-07-31 09:09:14', '2025-07-31 09:09:14', 0),
|
|
(10, 'role-detail', 8, '角色详情', '', 2, '["角色管理","角色详情"]', 'SubPage', 0, 0, 'role-detail', 1, 1, '2025-07-31 09:08:53', '2025-07-31 09:08:53', 0);
|
|
|
|
|
|
INSERT sys_resource (id, sn, table_name, data_id, memo)
|
|
VALUES (1, 'sys', 'sys_menu', 1, '菜单资源-目录-系统管理'),
|
|
(2, 'menus', 'sys_menu', 2, '菜单资源-页面-菜单管理'),
|
|
(3, 'menu-create', 'sys_menu', 3, '菜单资源-子页面-新增菜单'),
|
|
(4, 'menu-detail', 'sys_menu', 4, '菜单资源-子页面-菜单详情'),
|
|
(5, 'user', 'sys_menu', 5, '菜单资源-页面-用户管理'),
|
|
(6, 'user-create', 'sys_menu', 6, '菜单资源-子页面-新增用户'),
|
|
(7, 'user-detail', 'sys_menu', 7, '菜单资源-子页面-用户详情'),
|
|
(8, 'role', 'sys_menu', 8, '菜单资源-页面-角色管理'),
|
|
(9, 'role-create', 'sys_menu', 9, '菜单资源-子页面-新增角色'),
|
|
(10, 'role-detail', 'sys_menu', 10, '菜单资源-子页面-角色详情')
|
|
;
|
|
|
|
INSERT INTO sys_role_resource (id, role_id, res_id, res_sn, table_name, data_id)
|
|
VALUES (1, 1, 1, 'sys', 'sys_menu', 1),
|
|
(2, 1, 2, 'menus', 'sys_menu', 2),
|
|
(3, 1, 3, 'menu-create', 'sys_menu', 3),
|
|
(4, 1, 4, 'menu-detail', 'sys_menu', 4),
|
|
(5, 1, 5, 'user', 'sys_menu', 5),
|
|
(6, 1, 6, 'user-create', 'sys_menu', 6),
|
|
(7, 1, 7, 'user-detail', 'sys_menu', 7),
|
|
(8, 1, 8, 'role', 'sys_menu', 8),
|
|
(9, 1, 9, 'role-create', 'sys_menu', 9),
|
|
(10, 1, 10, 'role-detail', 'sys_menu', 10)
|
|
;
|