forked from gz-yami/mall4cloud
-
Notifications
You must be signed in to change notification settings - Fork 0
/
mall4cloud_rbac.sql
231 lines (204 loc) · 16.1 KB
/
mall4cloud_rbac.sql
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
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 8.0.25 : Database - mall4cloud_rbac
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`mall4cloud_rbac` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `mall4cloud_rbac`;
/*Table structure for table `menu` */
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`menu_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`parent_id` bigint unsigned NOT NULL COMMENT '父菜单ID，一级菜单为0',
`biz_type` tinyint DEFAULT NULL COMMENT '业务类型 1 店铺菜单 2平台菜单',
`permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限，需要有哪个权限才能访问该菜单',
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '路径 就像uri',
`component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '1.''Layout'' 为布局，不会跳页面 2.''components-demo/tinymce'' 跳转到该页面',
`redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '当设置 noRedirect 的时候该路由在面包屑导航中不可被点击',
`always_show` tinyint DEFAULT NULL COMMENT '一直显示根路由',
`hidden` tinyint DEFAULT NULL COMMENT '当设置 true 的时候该路由不会在侧边栏出现 如401，login等页面，或者如一些编辑页面/edit/1',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设定路由的名字，一定要填写不然使用<keep-alive>时会出现各种问题',
`title` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设置该路由在侧边栏和面包屑中展示的名字',
`icon` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设置该路由的图标，支持 svg-class，也支持 el-icon-x element-ui 的 icon',
`no_cache` tinyint DEFAULT NULL COMMENT '如果设置为true，则不会被 <keep-alive> 缓存(默认 false)',
`breadcrumb` tinyint DEFAULT NULL COMMENT '如果设置为false，则不会在breadcrumb面包屑中显示(默认 true)',
`affix` tinyint DEFAULT NULL COMMENT '若果设置为true，它则会固定在tags-view中(默认 false)',
`active_menu` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '当路由设置了该属性，则会高亮相对应的侧边栏。',
`seq` int DEFAULT NULL COMMENT '排序，越小越靠前',
PRIMARY KEY (`menu_id`) USING BTREE,
KEY `idx_pid` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=328 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单管理';
-- ----------------------------
-- Records of menu
-- ----------------------------
insert into `menu` (`menu_id`, `parent_id`, `biz_type`, `permission`, `path`, `component`, `redirect`, `always_show`, `hidden`, `name`, `title`, `icon`, `no_cache`, `breadcrumb`, `affix`, `active_menu`, `seq`) values
('111','0','1',NULL,'/rbac','Layout',NULL,NULL,'0','权限管理','权限管理','office-buildingplus',NULL,NULL,NULL,NULL,'99'),
('112','111','1',NULL,'shop_user','rbac/shop-user',NULL,NULL,'0','用户管理','用户管理','',NULL,NULL,NULL,NULL,'0'),
('134','111','1',NULL,'role','rbac/role',NULL,NULL,'0','角色管理','角色管理',NULL,NULL,NULL,NULL,NULL,'1'),
('137','141','1',NULL,'attr','product/attr',NULL,NULL,'0','属性管理','属性管理',NULL,NULL,NULL,NULL,NULL,'0'),
('139','141','1',NULL,'category','product/category',NULL,NULL,'0','category','分类管理',NULL,NULL,NULL,NULL,NULL,'2'),
('141','0','1',NULL,'/product','Layout',NULL,NULL,'0','商品管理','商品管理','ShoppingBagplus',NULL,NULL,NULL,NULL,'0'),
('142','141','1',NULL,'prod_info','product/prod-info',NULL,NULL,'0','发布商品','发布商品',NULL,NULL,NULL,NULL,NULL,'4'),
('145','0','1',NULL,'/multishop','Layout',NULL,NULL,'0','店铺管理','店铺管理','Shopplus',NULL,NULL,NULL,NULL,'0'),
('146','145','1',NULL,'index_img','multishop/index-img',NULL,NULL,'0','轮播图管理','轮播图管理','',NULL,NULL,NULL,NULL,'0'),
('147','0','1',NULL,'/order','Layout',NULL,NULL,'0','订单管理','订单管理','documentplus',NULL,NULL,NULL,NULL,'90'),
('148','147','1',NULL,'order','order/order',NULL,NULL,'0','order','订单管理',NULL,NULL,NULL,NULL,NULL,'1'),
('152','141','1',NULL,'list','product/list',NULL,NULL,'0','商品列表','商品列表','',NULL,NULL,NULL,NULL,'5'),
('155','0','2',NULL,'/rbac','Layout',NULL,NULL,'0','权限管理','权限管理','office-buildingplus',NULL,NULL,NULL,NULL,'99'),
('156','155','2',NULL,'sys-user','rbac/sys-user',NULL,NULL,'0','用户管理','用户管理','',NULL,NULL,NULL,NULL,'0'),
('157','155','2',NULL,'role','rbac/role',NULL,NULL,'0','角色管理','角色管理',NULL,NULL,NULL,NULL,NULL,'1'),
('158','155','2',NULL,'menu','rbac/menu',NULL,NULL,'0','平台菜单管理','平台菜单管理',NULL,NULL,NULL,NULL,NULL,'2'),
('159','155','2',NULL,'menu-permission','rbac/menu-permission',NULL,NULL,'0','菜单资源','菜单资源',NULL,NULL,NULL,NULL,NULL,'3'),
('160','164','2',NULL,'attr','product/attr',NULL,NULL,'0','属性管理','属性管理',NULL,NULL,NULL,NULL,NULL,'0'),
('161','164','2',NULL,'brand','product/brand',NULL,NULL,'0','品牌管理','品牌管理',NULL,NULL,NULL,NULL,NULL,'1'),
('162','164','2',NULL,'category','product/category',NULL,NULL,'0','category','分类管理',NULL,NULL,NULL,NULL,NULL,'2'),
('164','0','2',NULL,'/product','Layout',NULL,NULL,'0','product','商品管理','ShoppingBagplus',NULL,NULL,NULL,NULL,'0'),
('175','164','2',NULL,'list','product/list',NULL,NULL,'0','商品管理','商品管理','',NULL,NULL,NULL,NULL,'5'),
('178','155','2',NULL,'shop-menu','rbac/shop-menu',NULL,NULL,'0','店铺菜单管理','店铺菜单管理','',NULL,NULL,NULL,NULL,'2'),
('255','0','2',NULL,'/platform','Layout',NULL,NULL,'0','platform','平台管理','tree',NULL,NULL,NULL,NULL,'0'),
('256','255','2',NULL,'hot-search','platform/hot-search',NULL,NULL,'0','hot-search','热搜管理','el-icon-search',NULL,NULL,NULL,NULL,'0'),
('257','255','2',NULL,'index-img','platform/index-img',NULL,NULL,'0','轮播图管理','轮播图管理','el-icon-picture-outline',NULL,NULL,NULL,NULL,'0'),
('258','145','1',NULL,'hot-search','multishop/hot-search',NULL,NULL,'0','hot-search','热搜管理','',NULL,NULL,NULL,NULL,'0'),
('302','255','2',NULL,'shop-detail','platform/shop-detail',NULL,NULL,'1','店铺详情','店铺详情','',NULL,NULL,NULL,NULL,'0'),
('306','255','2',NULL,'shop-edit','platform/shop-edit',NULL,NULL,'1','店铺编辑','店铺编辑','',NULL,NULL,NULL,NULL,'0'),
('327','255','2',NULL,'shop-manage','platform/shop-manage',NULL,NULL,'0','店铺管理','店铺管理','el-icon-s-order',NULL,NULL,NULL,NULL,'3');
/*Table structure for table `menu_permission` */
DROP TABLE IF EXISTS `menu_permission`;
CREATE TABLE `menu_permission` (
`menu_permission_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '菜单资源用户id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`menu_id` bigint NOT NULL COMMENT '资源关联菜单',
`biz_type` tinyint NOT NULL COMMENT '业务类型 1 店铺菜单 2平台菜单',
`permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限对应的编码',
`name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源名称',
`uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资源对应服务器路径',
`method` tinyint NOT NULL COMMENT '请求方法 1.GET 2.POST 3.PUT 4.DELETE',
PRIMARY KEY (`menu_permission_id`) USING BTREE,
UNIQUE KEY `uk_permission` (`permission`,`biz_type`) USING BTREE,
KEY `idx_menuid` (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=230 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='菜单资源';
insert into `menu_permission` (`menu_permission_id`, `menu_id`, `biz_type`, `permission`, `name`, `uri`, `method`) values
('1','256','2','platform:hotSearch:save','新增','/admin/hot_search','2'),
('2','256','2','platform:hotSearch:update','更新','/admin/hot_search','3'),
('3','256','2','platform:hotSearch:delete','删除','/admin/hot_search','4'),
('4','257','2','platform:indexImg:save','新增','/admin/index_img','2'),
('5','256','2','platform:indexImg:update','更新','/admin/index_img','3'),
('6','256','2','platform:indexImg:delete','删除','/admin/index_img','4'),
('7','160','2','product:attr:save','新增','/admin/attr','2'),
('8','160','2','product:attr:update','更新','/admin/attr','3'),
('9','160','2','product:attr:delete','删除','/admin/attr','1'),
('10','161','2','product:brand:save','新增','/platform/brand','2'),
('11','161','2','product:brand:update','更新','/platform/brand','3'),
('12','161','2','product:brand:delete','删除','/platform/brand','1'),
('13','162','2','product:category:save','新增','/admin/category','2'),
('14','162','2','product:category:update','更新','/admin/category','3'),
('15','162','2','product:category:delete','删除','/admin/category','4'),
('16','162','2','product:category:enableOrDisable','上架或下架','/admin/category/category_enable_or_disable','3'),
('17','175','2','product:product:info','查看详情','/admin/spu','1'),
('18','175','2','product:product:delete','删除','/admin/spu','4'),
('19','156','2','system:user:save','新增','/sys_user','2'),
('20','156','2','system:user:update','更新','/sys_user','3'),
('21','156','2','system:user:delete','删除','/sys_user','4'),
('22','156','2','system:userAccount:save','设置账号','/sys_user/account','2'),
('23','156','2','system:userAccount:update','修改账号','/sys_user/account','3'),
('24','157','2','system:role:save','新增','/role','2'),
('25','157','2','system:role:update','更新','/role','3'),
('26','157','2','system:role:delete','删除','/role','1'),
('27','178','2','system:menuRoute:save','新增','/menu','2'),
('28','178','2','system:menuRoute:update','更新','/menu','3'),
('29','178','2','system:menuRoute:delete','删除','/menu','4'),
('30','158','2','system:platformMenuRoute:save','新增','/menu','2'),
('31','158','2','system:platformMenuRoute:update','更新','/menu','3'),
('32','158','2','system:platformMenuRoute:delete','删除','/menu','4'),
('33','159','2','system:menuPermission:save','新增','/menu_permission','2'),
('34','159','2','system:menuPermission:update','更新','/menu_permission','3'),
('35','159','2','system:menuPermission:delete','删除','/menu_permission','4'),
('36','258','1','admin:hotSearch:save','保存','/admin/hot_search','2'),
('37','258','1','admin:hotSearch:update','更新','/admin/hot_search','3'),
('38','258','1','admin:hotSearch:delete','删除','/admin/hot_search','4'),
('39','146','1','admin:indexImg:save','保存','/admin/index_img','2'),
('40','146','1','admin:indexImg:update','更新','/admin/index_img','3'),
('41','146','1','admin:indexImg:delete','删除','/admin/index_img','4'),
('42','137','1','product:attr:save','保存','/admin/attr','2'),
('43','137','1','product:attr:update','更新','/admin/attr','3'),
('44','137','1','product:attr:delete','删除','/admin/attr','4'),
('45','139','1','product:category:save','保存','/admin/category','2'),
('46','139','1','product:category:update','更新','/admin/category','3'),
('47','139','1','product:category:delete','删除','/admin/category','4'),
('48','139','1','product:category:enableOrDisable','上架或下架','/admin/category/category_enable_or_disable','3'),
('49','152','1','product:product:save','保存','/admin/spu','2'),
('50','152','1','product:product:update','更新','/admin/spu','3'),
('51','152','1','product:product:delete','删除','/admin/spu','4'),
('52','152','1','product:product:status','上架或下架','/admin/spu/prod_status','3'),
('53','148','1','admin:order:info','订单详情','/m/order/order_info','1'),
('54','148','1','admin:order:delivery','发货','/m/order/delivery','2'),
('55','112','1','admin:shopUser:save','保存','/m/shop_user','2'),
('56','112','1','admin:shopUser:update','更新','/m/shop_user','3'),
('57','112','1','admin:shopUser:delete','删除','/m/shop_user','4'),
('58','134','1','admin:role:save','保存','/role','2'),
('59','134','1','admin:role:update','更新','/role','3'),
('60','134','1','admin:role:delete','删除','/role','4');
/*Table structure for table `role` */
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`role_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '角色id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`role_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
`remark` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '备注',
`create_user_id` bigint unsigned NOT NULL COMMENT '创建者ID',
`biz_type` tinyint DEFAULT NULL COMMENT '业务类型 1 店铺菜单 2平台菜单',
`tenant_id` bigint DEFAULT NULL COMMENT '所属租户',
PRIMARY KEY (`role_id`) USING BTREE,
KEY `idx_tenant_id` (`tenant_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色';
/*Table structure for table `role_menu` */
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '关联id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`role_id` bigint unsigned NOT NULL COMMENT '角色ID',
`menu_id` bigint unsigned DEFAULT NULL COMMENT '菜单ID',
`menu_permission_id` bigint unsigned DEFAULT NULL COMMENT '菜单资源用户id',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_roleid_menu_permission_id` (`role_id`,`menu_id`,`menu_permission_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1924 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='角色与菜单对应关系';
/*Table structure for table `undo_log` */
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
`id` bigint NOT NULL AUTO_INCREMENT,
`branch_id` bigint NOT NULL,
`xid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`context` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`rollback_info` longblob NOT NULL,
`log_status` int NOT NULL,
`log_created` datetime NOT NULL,
`log_modified` datetime NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*Table structure for table `user_role` */
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '关联id',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`user_id` bigint unsigned NOT NULL COMMENT '用户ID',
`role_id` bigint unsigned NOT NULL COMMENT '角色ID',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `uk_userid_roleid` (`user_id`,`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=254 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户与角色对应关系';
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;