chore: 部署sql脚本整理,新增 admin-platform 的cas 认证注册脚本
diff --git a/deploy-manifests/k8s-rancher/6.admin-platform/10.0.init.sql b/deploy-manifests/k8s-rancher/6.admin-platform/10.0.init.sql
index 2442ec5..4e5fe68 100644
--- a/deploy-manifests/k8s-rancher/6.admin-platform/10.0.init.sql
+++ b/deploy-manifests/k8s-rancher/6.admin-platform/10.0.init.sql
@@ -19,6 +19,37 @@
commit;
+-- admin-platform 的认证对接信息
+
+INSERT INTO `TB_SERVICE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
+ `NAME`, `DESCRIPTION`, `INFORMATION_URL`, `LOGOUT_URL`,
+ `RESPONSE_TYPE`, `LOGOUT_TYPE`,
+ `EVALUATION_ORDER`, `FRIENDLY_NAME`, `REGISTERED_SERVICE_ID`, `SERVICE_ID`,
+ `ENABLED`, `SSO_ENABLED`, `REQUIRE_ALL_ATTRIBUTES`,
+ `APPLICATION_ID`, `EXTERNAL_ID`)
+VALUES ('21', '1', 0, 'admin', '2020-07-01 00:00:00',
+ '云平台', '云平台', 'https://admin-platform.paas.example.com', 'https://admin-platform.paas.example.com/?clearToken=clearToken',
+ 'REDIRECT', 'FRONT_CHANNEL',
+ 21, '云平台', 21, 'https://admin-platform.paas.example.com/(.*)',
+ 1, 1, 1,
+ '21', '21');
+
+commit;
+
+-- 修改根域名
+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/(.*)',
+ ID_TOKEN_ENABLED=1,
+ JWT_AS_SERVICE_TICKET=1,
+ APPLICATION_DOMAIN='admin-platform.paas.example.com'
+where ID='21'; -- todo, modify
+
+commit;
+
+
use user_authz;
-- 更新 admin-center 下的角色同步地址