chore: 郑州大学部署脚本
diff --git a/project/zzu/k8s-rancher/6.admin-platform/10.0.init.sql b/project/zzu/k8s-rancher/6.admin-platform/10.0.init.sql
new file mode 100644
index 0000000..579d3db
--- /dev/null
+++ b/project/zzu/k8s-rancher/6.admin-platform/10.0.init.sql
@@ -0,0 +1,73 @@
+-- 10.1.init.sql
+
+/*
+将 paas.example.com 替换为 paas.学校域名.edu.cn
+*/
+
+
+use cas_server;
+
+-- 更新 服务 admin-center 的信息
+
+update TB_SERVICE
+set
+ INFORMATION_URL='http://admin-center.paas.example.com',
+ LOGOUT_URL='http://admin-center.paas.example.com/cas/slo',
+ SERVICE_ID='http://admin-center.paas.example.com/cas/(.*)'
+where ID='1'; -- todo, modify
+
+-- 更新 服务 personal-security-center 的信息
+
+update TB_SERVICE
+set
+ INFORMATION_URL='http://personal-security-center.paas.example.com',
+ LOGOUT_URL='http://personal-security-center.paas.example.com/cas/slo',
+ SERVICE_ID='http://personal-security-center.paas.example.com/cas/(.*)'
+where ID='2'; -- todo, modify
+
+commit;
+
+
+use user_authz;
+
+-- 更新 admin-center 下的角色同步地址
+
+update TB_APPLICATION
+set
+ SYNC_URL='http://admin-center.paas.example.com/api/v1/open/sync/roles'
+where ID='1'; -- todo, modify
+
+commit;
+
+
+use admin_center;
+
+-- 更新 admin-management 下菜单的访问域
+
+update TB_MGT_PERMISSION
+set
+ ORIGIN='http://admin-management.paas.example.com'
+where APPLICATION_ID='00000'
+;
+
+commit;
+
+
+-- 更新 admin-platform 下菜单的访问域
+
+update TB_MGT_PERMISSION
+set
+ ORIGIN='http://admin-platform.paas.example.com'
+where APPLICATION_ID='1'
+;
+
+commit;
+
+/*
+insert into TB_MGT_ROUTE (ID, DELETED, CODE, NAME, STATUS, PATH_PREFIX, URL, STRIP_PREFIX)
+values ('23', 0, 'user-biz', '用户服务 - 业务接口', '1', '/api/v1/user/biz', 'http://localhost:8023/api/v1/biz', 1);
+
+update TB_MGT_ROUTE set URL='http://user-data-service-biz-svc.user-data-service.svc.cluster.local:8080/api/v1/biz' where ID='23';
+
+commit;
+*/