docs: 整理 chart 部署时,初始化sql
diff --git a/deploy-manifests/charts/10.0.init.sql b/deploy-manifests/charts/10.0.init.sql
index 5e32052..db122db 100644
--- a/deploy-manifests/charts/10.0.init.sql
+++ b/deploy-manifests/charts/10.0.init.sql
@@ -9,17 +9,30 @@
insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('9', 0, 'management-api', '管理门户 - 管理接口', '1', '/api/v1/mgt', 'http://admin-center-sa-svc.admin-center.svc.cluster.local:8080/v1/admin', 1);
+values ('1', 0, 'bff-admin-api', '管理门户 - 聚合接口', '1', '/api/v1/admin', 'http://localhost:8081', 0);
+insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('2', 0, 'bff-me-api', '管理门户 - 聚合接口(当前用户)', '1', '/api/v1/me', 'http://localhost:8081', 0);
+insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('3', 0, 'bff-open-api', '管理门户 - 聚合接口(公开)', '1', '/api/v1/open', 'http://localhost:8081', 0);
+
+update TB_MGT_ROUTE set URL='http://admin-platform-admin-center-bff.admin-platform.svc.cluster.local:8080' where ID='1';
+update TB_MGT_ROUTE set URL='http://admin-platform-admin-center-bff.admin-platform.svc.cluster.local:8080' where ID='2';
+update TB_MGT_ROUTE set URL='http://admin-platform-admin-center-bff.admin-platform.svc.cluster.local:8080' where ID='3';
commit;
-update TB_MGT_ROUTE set URL='http://admin-center-sa-svc.admin-center.svc.cluster.local:8080/v1/admin' where ID='9';
+
+insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('9', 0, 'management-api', '管理门户 - 管理接口', '1', '/api/v1/mgt', 'http://localhost:8080/v1/admin', 1);
+
+commit;
+
+update TB_MGT_ROUTE set URL='http://admin-platform-admin-center-sa.admin-platform.svc.cluster.local:8080/v1/admin' where ID='9';
commit;
-- 更新 admin-center 下菜单的访问域
-
update TB_MGT_PERMISSION
set
ORIGIN='http://admin-center.paas.example.com'
@@ -30,7 +43,6 @@
-- 更新 admin-platform 下菜单的访问域
-
update TB_MGT_PERMISSION
set
ORIGIN='http://admin-platform.paas.example.com'
@@ -42,8 +54,7 @@
use cas_server;
--- 更新 服务 admin-center 的信息
-
+-- 更新 服务 admin-center 的信息(废弃)
update TB_SERVICE
set
INFORMATION_URL='http://admin-center.paas.example.com',
@@ -55,7 +66,6 @@
-- admin-management 的认证对接信息
-
INSERT INTO `TB_SERVICE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
`NAME`, `DESCRIPTION`, `INFORMATION_URL`, `LOGOUT_URL`,
`RESPONSE_TYPE`, `LOGOUT_TYPE`,
@@ -86,7 +96,6 @@
-- admin-platform 的认证对接信息
-
INSERT INTO `TB_SERVICE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
`NAME`, `DESCRIPTION`, `INFORMATION_URL`, `LOGOUT_URL`,
`RESPONSE_TYPE`, `LOGOUT_TYPE`,
@@ -120,7 +129,6 @@
use user_authz;
-- 更新 admin-center 下的角色同步地址
-
update TB_APPLICATION
set
SYNC_URL='http://admin-center.paas.example.com/api/v1/open/sync/roles'
diff --git a/deploy-manifests/charts/10.1.init-authx.sql b/deploy-manifests/charts/10.1.init-authx.sql
deleted file mode 100644
index 6c0088f..0000000
--- a/deploy-manifests/charts/10.1.init-authx.sql
+++ /dev/null
@@ -1,55 +0,0 @@
--- 10.1.init-authx.sql
-
-
-/* 升级认证授权接口时,执行 */
-/*
-update TB_MGT_ROUTE set MEMO='废弃', STATUS='0' where ID='1';
-
-commit;
-
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('30', 0, 'authx-admin-api', '认证授权 - 认证授权接口', '1', '/api/v1/admin', 'http://localhost:8009', 0);
-
-update TB_MGT_ROUTE set URL='http://authx-service-bff-svc.authx-service.svc.cluster.local:8080' where ID='30';
-
-*/
-
-
-/* 部署云平台2.0时,执行以下脚本 */
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('1', 0, 'bff-admin-api', '管理门户 - 聚合接口', '1', '/api/v1/admin', 'http://localhost:8081', 0);
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('2', 0, 'bff-me-api', '管理门户 - 聚合接口(当前用户)', '1', '/api/v1/me', 'http://localhost:8081', 0);
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('3', 0, 'bff-open-api', '管理门户 - 聚合接口(公开)', '1', '/api/v1/open', 'http://localhost:8081', 0);
-
-update TB_MGT_ROUTE set URL='http://admin-center-bff-svc.admin-center.svc.cluster.local:8080' where ID='1';
-update TB_MGT_ROUTE set URL='http://admin-center-bff-svc.admin-center.svc.cluster.local:8080' where ID='2';
-update TB_MGT_ROUTE set URL='http://admin-center-bff-svc.admin-center.svc.cluster.local:8080' where ID='3';
-
-commit;
-
-
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('10', 0, 'authx-admin-api', '认证授权 - 认证授权接口', '1', '/api/v2/admin', 'http://localhost:8009', 0);
-
-update TB_MGT_ROUTE set URL='http://authx-service-bff-svc.authx-service.svc.cluster.local:8080' where ID='10';
-
-commit;
-
-
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('20', 0, 'user-api', '认证授权 - 用户接口', '1', '/api/v1/base', 'https://localhost:8022', 0);
-
-insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
-values ('40', 0, 'personal-api', '认证授权 - 个人信息接口', '1', '/api/v1/personal', 'http://localhost:8041/api/v1', 1);
-
-update TB_MGT_ROUTE set URL='http://user-data-service-goa-svc.user-data-service.svc.cluster.local:8080' where ID='20';
-update TB_MGT_ROUTE set URL='http://personal-security-center-bff-svc.personal-security-center.svc.cluster.local:8080/api/v1' where ID='40';
-
-commit;
-
-
-/* 菜单、角色的初始化,请参考《认证授权菜单初始化》 */
-
-