shiro-test-dml.sql
4.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `username`, `name`, `password`, `salt`, `email`, `mobile`, `status`, `province_code`,
`department`, `create_by`, `create_time`, `updated_by`, `updated_time`)
VALUES (1, 'test001', 'test001', 'test001', 'aaaa', 'test001@kuihai.net', '13012345678', 1, '010', '100', 'system',
'2023-12-22 10:19:57', 'system', '2023-12-22 10:19:57');
INSERT INTO `sys_user` (`user_id`, `username`, `name`, `password`, `salt`, `email`, `mobile`, `status`, `province_code`,
`department`, `create_by`, `create_time`, `updated_by`, `updated_time`)
VALUES (2, 'test002', 'test002', 'test002', 'bbb', 'test002@kuihai.net', '13987654321', 1, '020', '200', 'system',
'2023-12-22 10:19:57', 'system', '2023-12-22 10:19:57');
COMMIT;
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`)
VALUES (1, 1, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`)
VALUES (2, 2, 2);
COMMIT;
-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `role_name`, `remark`, `create_user_id`, `create_time`)
VALUES (1, '系统管理员', '系统管理员', NULL, '2023-12-29 18:03:52');
INSERT INTO `sys_role` (`role_id`, `role_name`, `remark`, `create_user_id`, `create_time`)
VALUES (2, '普通管理员', '普通管理员', NULL, '2023-12-29 18:03:52');
COMMIT;
-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (1, 1, 1);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (2, 1, 2);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (3, 2, 1);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (4, 2, 3);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`)
VALUES (5, 1, 4);
COMMIT;
-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
VALUES (1, NULL, '', NULL, 'sys:perm:read', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
VALUES (2, NULL, '', NULL, 'sys:perm:write', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
VALUES (3, NULL, '', NULL, 'employee:view:name,address', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `parent_id`, `name`, `url`, `perms`, `type`, `icon`, `order_num`)
VALUES (4, NULL, '', NULL, 'employee:view', NULL, NULL, NULL);
COMMIT;
-- ----------------------------
-- Records of sys_dg
-- ----------------------------
BEGIN;
INSERT INTO `sys_dg` (`id`, `dg_key`, `columns`)
VALUES (1, 'dg_emp_list_001', 'name,salary,address');
INSERT INTO `sys_dg` (`id`, `dg_key`, `columns`)
VALUES (2, 'dg_sys_user_list_001',
'user_id,username,name,password,salt,email,mobile,status,province_code,department,create_by,create_time,updated_by,updated_time');
COMMIT;
-- ----------------------------
-- Records of sys_role_dg
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dg` (`id`, `role_id`, `dg_id`, `columns`)
VALUES (1, 1, 1, 'name,salary,address');
INSERT INTO `sys_role_dg` (`id`, `role_id`, `dg_id`, `columns`)
VALUES (2, 2, 1, 'name,address');
INSERT INTO `sys_role_dg` (`id`, `role_id`, `dg_id`, `columns`)
VALUES (3, 1, 2,
'user_id,username,name,password,salt,email,mobile,status,province_code,department,create_by,create_time,updated_by,updated_time');
INSERT INTO `sys_role_dg` (`id`, `role_id`, `dg_id`, `columns`)
VALUES (4, 2, 2,
'user_id,username,name,email,status,province_code,department,create_by,create_time,updated_by,updated_time');
COMMIT;
-- ----------------------------
-- Records of employee
-- ----------------------------
BEGIN;
INSERT INTO `employee` (`id`, `name`, `salary`, `address`)
VALUES (1, 'Alice', '5000', '123 Main St');
INSERT INTO `employee` (`id`, `name`, `salary`, `address`)
VALUES (2, 'Bob', '6000', '456 Oak St');
COMMIT;