style: 消息服务、消息平台的sql脚本整理
diff --git a/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-message.sql b/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-message.sql
index f69dbfe..e34383c 100644
--- a/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-message.sql
+++ b/deploy-manifests/k8s-rancher/1.authx-service/10.1.init-message.sql
@@ -17,13 +17,14 @@
use user;
--- messageadmin
+-- 消息平台管理
+
INSERT INTO `TB_B_USER` (`ID`, `DELETED`,
`UID`, `PASSWORD`, `NAME`, `NAME_SPELLING`, `FULL_NAME_SPELLING`,
`CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`, `PHONE_NUMBER`, `EMAIL`,
`GENDER_ID`, `NATION_ID`, `COUNTRY_ID`, `ADDRESS_ID`)
VALUES ('80', 0,
- '80', 'messageadmin', '流程表单管理员', 'messageadmin', 'messageadmin',
+ '80', 'messageadmin', '消息平台管理员', 'messageadmin', 'messageadmin',
'20001', '80', null, 'messageadmin@supwisdom.com',
'30001', '40001', '50156', '310000');
@@ -49,15 +50,22 @@
commit;
+
-- 创建管理帐号的授权
use user_authz;
--- message
-INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
-VALUES ('80', '1', 0, 'admin', '2020-07-01 00:00:00', '1', 'message-admin', '消息平台管理员', '消息平台管理员', 1, '80');
-INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
-VALUES ('81', '1', 0, 'admin', '2020-07-01 00:00:00', '1', 'message-opt', '消息平台操作员', '消息平台操作员', 1, '81');
+
+-- 消息平台管理
+
+INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
+ `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
+VALUES ('80', '1', 0, 'admin', '2020-07-01 00:00:00',
+ '1', 'message-admin', '消息平台管理员', '消息平台管理员', 1, '80');
+INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
+ `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
+VALUES ('81', '1', 0, 'admin', '2020-07-01 00:00:00',
+ '1', 'message-opt', '消息平台操作员', '消息平台操作员', 1, '81');
INSERT INTO `TB_GRANTED_ACCOUNT_ROLE` (`ID`, `COMPANY_ID`, `DELETED`,
`ACCOUNT_ID`, `ROLE_ID`,
@@ -76,3 +84,5 @@
NULL);
commit;
+
+