From b4627e0b24a7075c70fffa93a11bf5b3e577c4ce Mon Sep 17 00:00:00 2001
From: =?utf8?q?=E5=88=98=E6=B4=AA=E9=9D=92?= <hongqing.liu@supwisdom.com>
Date: Tue, 24 Nov 2020 17:30:25 +0800
Subject: [PATCH] =?utf8?q?feat:=20=E9=80=9A=E8=AE=AF=E5=BD=95=E5=88=9D?=
 =?utf8?q?=E5=A7=8B=E6=95=B0=E6=8D=AE=E8=84=9A=E6=9C=AC?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 .../10.1.init-address-book.sql                | 59 +++++++++++++++++++
 1 file changed, 59 insertions(+)
 create mode 100644 deploy-manifests/k8s-rancher/1.authx-service/10.1.init-address-book.sql

diff --git a/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-address-book.sql b/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-address-book.sql
new file mode 100644
index 0000000..43f48ec
--- /dev/null
+++ b/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-address-book.sql
@@ -0,0 +1,59 @@
+-- 10.1.init-address-book.sql
+
+
+/*
+将 paas.example.com 替换为 paas.学校域名.edu.cn
+*/
+
+
+-- 以下脚本为可选操作
+
+/*
+ * 若部署了通讯录服务产品
+ * 可默认创建几个管理员帐号，以及初始授权
+ */
+
+
+use user;
+
+
+-- 通讯录
+
+insert into `TB_APPLICATION` (ID, DELETED, 
+  BUSINESS_DOMAIN_ID, BUSINESS_DOMAIN_NAME, SYSTEM_ID, SYSTEM_NAME, 
+  APPLICATION_ID, NAME, DESCRIPTION, 
+  ENABLED)
+values ('90', 0,
+  '1', '智慧校园', '1', '业务中台',
+  '90', '通讯录', '', 
+  1
+);
+
+commit;
+
+
+
+use user_authz;
+
+-- 通讯录
+
+INSERT INTO `TB_R_SYSTEM` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, 
+  `BUSINESS_DOMAIN_ID`, 
+  `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`)
+VALUES ('90', '1', 0, 'admin', '2019-07-01 00:00:00', 
+  '1', 
+  'address-book', '通讯录', '通讯录', 1);
+
+INSERT INTO `TB_APPLICATION` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, 
+  `BUSINESS_DOMAIN_ID`, `SYSTEM_ID`, 
+  `NAME`, `APPLICATION_ID`, `SYNC_URL`, `ENABLED`)
+VALUES ('90', '1', 0, 'admin', '2019-07-01 00:00:00', 
+  '1', '90', 
+  '通讯录', '90', '', 1);
+
+-- 更新应用的定时同步接口的地址
+-- UPDATE `TB_APPLICATION` set `SYNC_URL`='http://message-platform.paas.xxx.edu.cn/roles' WHERE ID='90';
+
+commit;
+
+
-- 
2.17.1