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
| -- ----------------------------
| -- 用户和角色关联表 用户N-1角色
| -- ----------------------------
| drop table if exists sys_role_menu;
|
| -- 创建表
| create table sys_role_menu
| (
| role_id bigint not null, -- 角色ID
| menu_id bigint not null, -- 菜单ID
| primary key (role_id, menu_id) -- 复合主键
| );
|
| comment on table sys_role_menu is '角色和菜单关联表';
| comment on column sys_role_menu.role_id is '角色ID';
| comment on column sys_role_menu.menu_id is '菜单ID';
|
| -- 初始化-角色和菜单关联表数据
| insert into sys_role_menu (role_id, menu_id)
| values ('2', '1'),
| ('2', '2'),
| ('2', '3'),
| ('2', '4'),
| ('2', '100'),
| ('2', '101'),
| ('2', '102'),
| ('2', '103'),
| ('2', '104'),
| ('2', '105'),
| ('2', '106'),
| ('2', '107'),
| ('2', '108'),
| ('2', '109'),
| ('2', '110'),
| ('2', '111'),
| ('2', '112'),
| ('2', '113'),
| ('2', '114'),
| ('2', '115'),
| ('2', '116'),
| ('2', '117'),
| ('2', '500'),
| ('2', '501'),
| ('2', '1000'),
| ('2', '1001'),
| ('2', '1002'),
| ('2', '1003'),
| ('2', '1004'),
| ('2', '1005'),
| ('2', '1006'),
| ('2', '1007'),
| ('2', '1008'),
| ('2', '1009'),
| ('2', '1010'),
| ('2', '1011'),
| ('2', '1012'),
| ('2', '1013'),
| ('2', '1014'),
| ('2', '1015'),
| ('2', '1016'),
| ('2', '1017'),
| ('2', '1018'),
| ('2', '1019'),
| ('2', '1020'),
| ('2', '1021'),
| ('2', '1022'),
| ('2', '1023'),
| ('2', '1024'),
| ('2', '1025'),
| ('2', '1026'),
| ('2', '1027'),
| ('2', '1028'),
| ('2', '1029'),
| ('2', '1030'),
| ('2', '1031'),
| ('2', '1032'),
| ('2', '1033'),
| ('2', '1034'),
| ('2', '1035'),
| ('2', '1036'),
| ('2', '1037'),
| ('2', '1038'),
| ('2', '1039'),
| ('2', '1040'),
| ('2', '1041'),
| ('2', '1042'),
| ('2', '1043'),
| ('2', '1044'),
| ('2', '1045'),
| ('2', '1046'),
| ('2', '1047'),
| ('2', '1048'),
| ('2', '1049'),
| ('2', '1050'),
| ('2', '1051'),
| ('2', '1052'),
| ('2', '1053'),
| ('2', '1054'),
| ('2', '1055'),
| ('2', '1056'),
| ('2', '1057'),
| ('2', '1058'),
| ('2', '1059'),
| ('2', '1060');
|
|
