docs: 修正 1.2 chart 的 数据初始化脚本
diff --git a/deploy-manifests/charts/10.0.init.sql b/deploy-manifests/charts/10.0.init.sql
index db122db..8b04d75 100644
--- a/deploy-manifests/charts/10.0.init.sql
+++ b/deploy-manifests/charts/10.0.init.sql
@@ -7,7 +7,7 @@
use admin_center;
-
+-- 若 insert 异常，确认下 TB_MGT_ROUTE 中 是否已经存在记录，若存在，可忽略，直接执行 update 即可
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)
@@ -22,12 +22,13 @@
commit;
+-- 若 insert 异常，确认下 TB_MGT_ROUTE 中 是否已经存在记录，若存在，可忽略，直接执行 update 即可
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);
+values ('10', 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';
+update TB_MGT_ROUTE set URL='http://admin-platform-admin-center-sa.admin-platform.svc.cluster.local:8080/v1/admin' where ID='10';
commit;
@@ -35,7 +36,7 @@
-- 更新 admin-center 下菜单的访问域
update TB_MGT_PERMISSION
set
- ORIGIN='http://admin-center.paas.example.com'
+ ORIGIN='https://admin-center.paas.example.com'
where APPLICATION_ID='00000'
;
@@ -45,7 +46,7 @@
-- 更新 admin-platform 下菜单的访问域
update TB_MGT_PERMISSION
set
- ORIGIN='http://admin-platform.paas.example.com'
+ ORIGIN='https://admin-platform.paas.example.com'
where APPLICATION_ID='1'
;
@@ -57,9 +58,10 @@
-- 更新 服务 admin-center 的信息（废弃）
update TB_SERVICE
set
- INFORMATION_URL='http://admin-center.paas.example.com',
+ DELETED=1,
+ INFORMATION_URL='https://admin-center.paas.example.com',
LOGOUT_URL='https://admin-center.paas.example.com/slo?redirect_uri=https://admin-platform.paas.example.com?clearCertification=Admin-Token',
- SERVICE_ID='http://admin-center.paas.example.com/cas/(.*)'
+ SERVICE_ID='https://admin-center.paas.example.com/cas/(.*)'
where ID='1'; -- todo, modify
commit;
@@ -84,9 +86,9 @@
-- 修改根域名
update TB_SERVICE
set
- INFORMATION_URL='http://admin-center.paas.example.com',
- LOGOUT_URL='http://admin-center.paas.example.com/?clearToken=clearToken',
- SERVICE_ID='http://admin-center.paas.example.com/(.*)',
+ INFORMATION_URL='https://admin-center.paas.example.com',
+ LOGOUT_URL='https://admin-center.paas.example.com/?clearToken=clearToken',
+ SERVICE_ID='https://admin-center.paas.example.com/(.*)',
ID_TOKEN_ENABLED=1,
JWT_AS_SERVICE_TICKET=1,
APPLICATION_DOMAIN='admin-center.paas.example.com'
@@ -114,9 +116,9 @@
-- 修改根域名
update TB_SERVICE
set
- INFORMATION_URL='http://admin-platform.paas.example.com',
- LOGOUT_URL='http://admin-platform.paas.example.com/?clearToken=clearToken',
- SERVICE_ID='http://admin-platform.paas.example.com/(.*)',
+ INFORMATION_URL='https://admin-platform.paas.example.com',
+ LOGOUT_URL='https://admin-platform.paas.example.com/?clearToken=clearToken',
+ SERVICE_ID='https://admin-platform.paas.example.com/(.*)',
ID_TOKEN_ENABLED=1,
JWT_AS_SERVICE_TICKET=1,
APPLICATION_DOMAIN='admin-platform.paas.example.com'
@@ -131,7 +133,7 @@
-- 更新 admin-center 下的角色同步地址
update TB_APPLICATION
set
- SYNC_URL='http://admin-center.paas.example.com/api/v1/open/sync/roles'
+ SYNC_URL='https://admin-center.paas.example.com/api/v1/open/sync/roles'
where ID='1'; -- todo, modify
commit;