docs: 调整route的sql脚本
diff --git a/sql/base.sql b/sql/base.sql
index 0404695..2701905 100644
--- a/sql/base.sql
+++ b/sql/base.sql
@@ -49,9 +49,9 @@
`MEMO` VARCHAR(500) COMMENT '备注',
`STATUS` VARCHAR(10) NOT NULL COMMENT '状态（1 启用，0 停用）',
- `URI` VARCHAR(500) NOT NULL COMMENT '路由地址',
-
`PATH_PREFIX` VARCHAR(100) NOT NULL COMMENT '路径前缀',
+ `URL` VARCHAR(500) NOT NULL COMMENT '路由地址',
+ `STRIP_PREFIX` INT(1) COMMENT '是否排除前缀',
PRIMARY KEY (`ID`),
UNIQUE KEY `UQ_CODE` (`COMPANY_ID`,`CODE`)
@@ -60,15 +60,15 @@
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX)
-values ('10', 0, 'aggr-api', '管理服务 - 聚合接口', '1', 'http://localhost:8081', '/api/aggr');
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('1', 0, 'bff-api', '管理服务 - 聚合接口', '1', '/api/bff', 'http://localhost:8081', 1);
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX)
-values ('11', 0, 'base-api', '管理服务 - 基础接口', '1', 'http://localhost:8082', '/api/base');
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX)
-values ('12', 0, 'system-api', '管理服务 - 系统接口', '1', 'http://localhost:8082', '/api/system');
-insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, URI, PATH_PREFIX)
-values ('13', 0, 'biz-api', '管理服务 - 业务接口', '1', 'http://localhost:8082', '/api/biz');
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('10', 0, 'admin-base-api', '管理服务 - 基础接口', '1', '/api/base', 'http://localhost:8082', 1);
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('20', 0, 'adminsystem-api', '管理服务 - 系统接口', '1', '/api/system', 'http://localhost:8082', 1);
+insert into TB_BASE_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('30', 0, 'biz-api', '管理服务 - 业务接口', '1', '/api/biz', 'http://localhost:8083', 1);
commit;
@@ -355,31 +355,36 @@
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 20);
+values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 18);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 2, 17);
+values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 2, 15);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
values ('10100', 0, 'admin.base.account', '帐号管理', '1', '2', '', '1', '10000', 10100, 2, 3, 4);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
values ('10200', 0, 'admin.base.role', '角色管理', '1', '2', '', '1', '10000', 10200, 2, 5, 6);
-insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10300', 0, 'admin.base.menu', '菜单管理', '1', '2', '', '1', '10000', 10300, 2, 7, 8);
-insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10400', 0, 'admin.base.operation', '操作管理', '1', '2', '', '1', '10000', 10400, 2, 9, 10);
-insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10500', 0, 'admin.base.resource', '资源管理', '1', '2', '', '1', '10000', 10500, 2, 11, 12);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10600', 0, 'admin.base.application', '应用管理', '1', '2', '', '1', '10000', 10600, 2, 13, 14);
+values ('10400', 0, 'admin.base.menu', '菜单管理', '1', '2', '', '1', '10000', 10400, 2, 7, 8);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('10700', 0, 'admin.base.route', '路由管理', '1', '2', '', '1', '10000', 10700, 2, 15, 16);
+values ('10500', 0, 'admin.base.operation', '操作管理', '1', '2', '', '1', '10000', 10500, 2, 9, 10);
+insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10600', 0, 'admin.base.resource', '资源管理', '1', '2', '', '1', '10000', 10600, 2, 11, 12);
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
-values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 18, 19);
+values ('10700', 0, 'admin.base.route', '路由管理', '1', '2', '', '1', '10000', 10700, 2, 13, 14);
+
+
+insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 16, 17);
+
+/*
+insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10300', 0, 'admin.base.application', '应用管理', '1', '2', '', '1', '10000', 10300, 2, 13, 14);
+*/
/*
insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
@@ -446,7 +451,7 @@
insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
values ('10209', 0, 'BaseAdminRole.relatePermissions', '关联角色的权限', '1', 'POST', '/api/base/v1/admin/roles/{id}/permissions', 'authorize');
-
+/*
insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
values ('10301', 0, 'BaseAdminApplication.query', '查询应用', '1', 'GET', '/api/base/v1/admin/applications', 'authorize');
insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
@@ -457,7 +462,7 @@
values ('10304', 0, 'BaseAdminApplication.update', '修改应用', '1', 'PUT', '/api/base/v1/admin/applications/{id}', 'authorize');
insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
values ('10305', 0, 'BaseAdminApplication.delete', '删除应用', '1', 'DELETE', '/api/base/v1/admin/applications/{id}', 'authorize');
-
+*/
insert into TB_BASE_RESOURCE (ID, DELETED, CODE, NAME, STATUS, METHOD, PATH, ACCESS)
values ('10401', 0, 'BaseAdminMenu.query', '查询菜单', '1', 'GET', '/api/base/v1/admin/menus', 'authorize');
@@ -582,6 +587,7 @@
insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
values ('10200_10209', 0, '10200', '10209');
+/*
insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
values ('10300_10301', 0, '10300', '10301');
insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
@@ -592,6 +598,7 @@
values ('10300_10304', 0, '10300', '10304');
insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
values ('10300_10305', 0, '10300', '10305');
+*/
insert into TB_BASE_PERMISSION_RESOURCE (ID, DELETED, PERMISSION_ID, RESOURCE_ID)
values ('10400_10401', 0, '10400', '10401');