project/nwpu/k8s-rancher/2.account-management/10.0.init.sql

-- 10.0.init.sql


/*
将 paas.example.com 替换为 paas.学校域名.edu.cn
*/


use cas_server;

-- account-management 认证对接信息

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 ('300', '1', 0, 'admin', '2020-07-01 00:00:00',
  '帐号分级管理', '帐号分级管理', 'https://account-management.paas.example.com', 'https://account-management.paas.example.com/?clearCertification=clearCertification', 
  'REDIRECT', 'FRONT_CHANNEL', 
  300, '帐号分级管理', 300, 'https://account-management.paas.example.com/(.*)', 
  1, 1, 1, 
  '300', '300');

commit;

-- 修改根域名
update TB_SERVICE 
set 
  INFORMATION_URL='https://account-management.paas.example.com', 
  LOGOUT_URL='https://account-management.paas.example.com/?clearCertification=clearCertification', 
  SERVICE_ID='https://account-management.paas.example.com/(.*)', 
  ID_TOKEN_ENABLED=1,
  JWT_AS_SERVICE_TICKET=1,
  APPLICATION_DOMAIN='account-management.paas.example.com'
where ID='300';  -- todo, modify

commit;

-- user_authz

use user_authz;

INSERT INTO `TB_R_SYSTEM` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, 
  `BUSINESS_DOMAIN_ID`, 
  `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`)
VALUES ('300', '1', 0, 'admin', '2019-07-01 00:00:00', 
  '1', 
  'user-management-service', '用户管理服务', '用户管理服务', 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 ('300', '1', 0, 'admin', '2019-07-01 00:00:00', 
  '1', '300', 
  '用户管理服务', '300', '', 1);


INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, 
  `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
VALUES ('300_31', '1', 0, 'admin', '2019-07-01 00:00:00', 
  '300', 'user-management-grant-admin', '用户业务管理员', '用户业务管理员', 1, '31');

INSERT INTO `TB_ROLE` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`, 
  `APPLICATION_ID`, `CODE`, `NAME`, `DESCRIPTION`, `ENABLED`, `EXTERNAL_ID`)
VALUES ('300_32', '1', 0, 'admin', '2019-07-01 00:00:00', 
  '300', 'user-management-man-grant-admin', '用户分级管理员', '用户分级管理员', 1, '32');

commit;