shiro-test-dml.sql

INSERT INTO `sys_user`
VALUES (1, 'test001', 'test001', 'test001', NULL, NULL, NULL, 1, NULL, NULL, 'system', '2024-08-24 10:19:57', 'system',
        '2023-12-22 10:19:57'),
       (2, 'test002', 'test002', 'test002', NULL, NULL, NULL, 1, NULL, NULL, 'system', '2024-08-24 10:19:57', 'system',
        '2023-12-22 10:19:57');

INSERT INTO `sys_user_role`
VALUES (1, 1, 1),
       (2, 2, 2);

INSERT INTO `sys_role`
VALUES (1, '系统管理员', '系统管理员', NULL, '2023-12-29 18:03:52'),
       (2, '普通管理员', '普通管理员', NULL, '2023-12-29 18:03:52');

INSERT INTO `sys_role_menu`
VALUES (1, 1, 1),
       (2, 1, 2),
       (3, 2, 1),
       (4, 2, 3),
       (5, 1, 4);

INSERT INTO `sys_menu`
VALUES (1, null, '', null, 'sys:perm:read', null, null, null),
       (2, null, '', null, 'sys:perm:write', null, null, null),
       (3, null, '', null, 'employee:view:name,address', null, null, null),
       (4, null, '', null, 'employee:view', null, null, null);

INSERT INTO `employee`
VALUES (1, 'Alice', '5000', '123 Main St'),
       (2, 'Bob', '6000', '456 Oak St');