xy-authorize/sql/init.sql

-- 新增业务用户
delete from sys_work_user where id = 1;
insert into sys_work_user(id, account, password, create_time, update_time)
values(1, 'xyadmin', 'e10adc3949ba59abbe56e057f20f883e', now(), now());

-- 新增权限系统
delete from sys_system where id = 1;
insert into sys_system(id, code, name, create_time, update_time, create_user, update_user)
values(1, 'xy_system', '兴元权限系统', now(), now(), 1, 1);

-- 新增角色
delete from sys_role where id = 1;
insert into sys_role(id, sys_id, code, name, description, create_time, update_time)
values(1, 1, 'xy_admin', '超级管理员', '超级管理员', now(), now());

-- 新增业务用户角色关联
delete from sys_user_role where id = 1;
insert into sys_user_role(id, work_user_id, role_id, sys_id)
values(1, 1, 1, 1);

-- 新增菜单
delete from sys_menu where id in(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23);
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(1, null, 1, 'authorize', '权限管理', 1, null, null, now(), now());

insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(2, 1, 1, 'menu', '菜单管理', 1, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(3, 2, 1, 'menu_data', '菜单列表', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(4, 3, 1, 'menu_add', '添加菜单', 3, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(5, 3, 1, 'menu_del', '删除菜单', 3, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(6, 3, 1, 'menu_edit', '编辑菜单', 3, null, null, now(), now());

insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(7, 1, 1, 'role', '角色管理', 1, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(8, 7, 1, 'role_data', '角色列表', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(9, 8, 1, 'role_add', '添加角色', 3, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(10, 8, 1, 'role_add', '删除角色', 3, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(11, 8, 1, 'role_menu', '分配菜单', 3, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(12, 8, 1, 'role_edit', '编辑角色', 3, null, null, now(), now());

insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(13, 1, 1, 'system', '系统管理', 1, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(14, 13, 1, 'system_data', '系统列表', 2, "/sys-system/page", null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(15, 14, 1, 'system_add', '添加系统', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(16, 14, 1, 'system_del', '删除系统', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(17, 14, 1, 'system_edit', '编辑系统', 2, null, null, now(), now());

insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(18, 1, 1, 'dept', '部门管理', 1, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(19, 18, 1, 'dept_data', '部门列表', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(20, 19, 1, 'dept_add', '添加部门', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(21, 19, 1, 'dept_del', '删除部门', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(22, 19, 1, 'dept_edit', '编辑部门', 2, null, null, now(), now());
insert into sys_menu(id, pater_id, sys_id, code, name, type, interface_uri, web_json, create_time, update_time)
values(23, 19, 1, 'dept_role', '分配角色', 2, null, null, now(), now());

-- 新增角色菜单关联
delete from sys_role_menu where id in(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(1, 1, 1, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(2, 1, 2, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(3, 1, 3, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(4, 1, 4, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(5, 1, 5, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(6, 1, 6, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(7, 1, 7, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(8, 1, 8, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(9, 1, 9, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(10, 1, 10, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(11, 1, 11, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(12, 1, 12, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(13, 1, 13, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(14, 1, 14, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(15, 1, 15, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(16, 1, 16, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(17, 1, 17, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(18, 1, 18, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(19, 1, 19, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(20, 1, 20, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(21, 1, 21, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(22, 1, 22, true, 1);
insert into sys_role_menu(id, role_id, menu_id, select_is_admin, sys_id)
values(23, 1, 23, true, 1);