deploy-manifests/k8s-rancher/open-platform/1.0.init.sql

use cas_server;

-- portal-ui 认证对接信息
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`, 
  `ID_TOKEN_ENABLED`, `JWT_AS_SERVICE_TICKET`, 
  `APPLICATION_ID`, `EXTERNAL_ID`,
  `APPLICATION_DOMAIN`
)
VALUES ('90', '1', 0, 'admin', '2021-10-20 00:00:00',
  '开发者中心', '开发者中心', 'https://dev-portal.paas.xxx.edu.cn/', 'https://dev-portal.paas.xxx.edu.cn/?clearCertification=clearCertification', 
  'REDIRECT', 'FRONT_CHANNEL', 
  90, '开发者中心', 90, 'https://dev-portal.paas.xxx.edu.cn/(.*)', 
  1, 1, 1, 
  1, 1, 
  '90', '90', 
  'dev-portal.paas.xxx.edu.cn'
);


-- 修改根域名
update TB_SERVICE 
set 
  INFORMATION_URL='https://dev-portal.paas.xxx.edu.cn/', 
  LOGOUT_URL='https://dev-portal.paas.xxx.edu.cn/?clearCertification=clearCertification', 
  SERVICE_ID='https://dev-portal.paas.xxx.edu.cn/(.*)', 
  ID_TOKEN_ENABLED=1,
  JWT_AS_SERVICE_TICKET=1,
  APPLICATION_DOMAIN='dev-portal.paas.xxx.edu.cn'
where ID='90';  -- todo, modify

commit;


use developer_center;

INSERT INTO `TB_DEV_ACCOUNT` (`ID`, `COMPANY_ID`, `DELETED`, `USERNAME`, `PASSWORD`, `IS_DEVELOPER`,
  `TYPE`, `NAME`, `STATUS`, `CERTIFICATE_TYPE`, `CERTIFICATE_NUMBER`, `EXTERNAL_ID`
)
VALUES ('150', '1', '0', 'defaultDeveloper', 'defaultDeveloper', '1',
'individual', '上海树维', '1', '1', '150', '150');

INSERT INTO `TB_DEV_ACCOUNT` (`ID`, `COMPANY_ID`, `DELETED`, `USERNAME`, `PASSWORD`, `IS_OPERATOR`,
  `TYPE`, `NAME`, `STATUS`, `CERTIFICATE_TYPE`, `CERTIFICATE_NUMBER`, `EXTERNAL_ID`
)
VALUES ('151', '1', '0', 'defaultOperator', 'defaultOperator', '1',
'individual', '上海树维管理员', '1', '1', '151','151');


INSERT INTO `TB_DEV_ACCOUNT` (`ID`, `COMPANY_ID`, `DELETED`, `ADD_ACCOUNT`, `ADD_TIME`,
  `USERNAME`, `PASSWORD`, `ENABLED`, `ACCOUNT_NON_EXPIRED`, `ACCOUNT_NON_LOCKED`, `CREDENTIALS_NON_EXPIRED`,
  `IS_DEVELOPER`, `IS_OPERATOR`, `IS_SCOPE_AUDIT`, `IS_ADMINISTRATOR`, `IS_SCHOOL_ACCOUNT`,
  `TYPE`, `NAME`, `STATUS`
)
VALUES ('90', '1', 0, 'admin', '2020-10-20 00:00:00',
  'openadmin', 'openadmin', 1, 1, 1, 1,
  0, 0, 0, 1, 0,
  'admin', '开放平台管理员', '1'
);

commit;


use user;

-- 身份
INSERT INTO `TB_B_IDENTITY_TYPE`(`ID`, `DELETED`, `PARENT_IDENTITY_TYPE_ID`,
  `CODE`, `NAME`, `ENABLE`, `SORT`)
VALUES ('D01', 0, null, 'D01', '个人开发者', 1, 0);

INSERT INTO `TB_B_IDENTITY_TYPE`(`ID`, `DELETED`, `PARENT_IDENTITY_TYPE_ID`,
  `CODE`, `NAME`, `ENABLE`, `SORT`)
VALUES ('D02', 0, null, 'D02', '企业开发者', 1, 0);
commit;


-- defaultDeveloper
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 ('150', 0,
  '150', 'defaultDeveloper', '上海树维', 'defaultDeveloper', 'defaultDeveloper',
  '20001', '150', null, 'defaultDeveloper@supwisdom.com',
  '30001', '40001', '50156', null);

INSERT INTO `TB_B_SAFETY`(`ID`, `DELETED`, `USER_ID`, `SCORE`, `PASSWORD_SCORE`, `SECURE_EMAIL`, `SECURE_PHONE`)
VALUES ('150', 0, '150', '0', '0', null, null);


INSERT INTO `TB_B_ACCOUNT` (`ID`, `DELETED`, `USER_ID`,
  `ACCOUNT_NAME`, `ACCOUNT_EXPIRY_DATE`, `ORGANIZATION_ID`, `IDENTITY_TYPE_ID`,
  `ACTIVATION`, `STATE`, `IS_DATA_CENTER`, 
  `USER_UID`, `USER_NAME`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`)
VALUES ('150', 0, '150',
  'defaultDeveloper', null, '0', 'D01',
  1, 'NORMAL', 0, 
  '150', '上海树维', '20001', '150');

INSERT INTO `TB_B_ACCOUNT_ORGANIZATION` (`ID`, `DELETED`,
  `ROOT_ORGANIZATION_ID`, `ACCOUNT_ID`, `ORGANIZATION_ID`)
VALUES ('150_0', 0,
  '0', '150', '0');

/*
INSERT INTO `TB_B_ACCOUNT_LABEL`(`ID`, `DELETED`,
  `ACCOUNT_ID`, `LABEL_ID`)
VALUES ('150_1', 0, '150', '1');
*/

commit;

-- defaultOperator
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 ('151', 0,
  '151', 'defaultOperator', '上海树维业务管理员', 'defaultOperator', 'defaultOperator',
  '20001', '151', null, 'defaultOperator@supwisdom.com',
  '30001', '40001', '50156', null);

INSERT INTO `TB_B_SAFETY`(`ID`, `DELETED`, `USER_ID`, `SCORE`, `PASSWORD_SCORE`, `SECURE_EMAIL`, `SECURE_PHONE`)
VALUES ('151', 0, '151', '0', '0', null, null);


INSERT INTO `TB_B_ACCOUNT` (`ID`, `DELETED`, `USER_ID`,
  `ACCOUNT_NAME`, `ACCOUNT_EXPIRY_DATE`, `ORGANIZATION_ID`, `IDENTITY_TYPE_ID`,
  `ACTIVATION`, `STATE`, `IS_DATA_CENTER`, 
  `USER_UID`, `USER_NAME`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`)
VALUES ('151', 0, '151',
  'defaultOperator', null, '0', 'D02',
  1, 'NORMAL', 0, 
  '151', '上海树维业务管理员', '20001', '151');

INSERT INTO `TB_B_ACCOUNT_ORGANIZATION` (`ID`, `DELETED`,
  `ROOT_ORGANIZATION_ID`, `ACCOUNT_ID`, `ORGANIZATION_ID`)
VALUES ('151_0', 0,
  '0', '151', '0');

/*
INSERT INTO `TB_B_ACCOUNT_LABEL`(`ID`, `DELETED`,
  `ACCOUNT_ID`, `LABEL_ID`)
VALUES ('151_1', 0, '151', '1');
*/

commit;

-- 平台管理员
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 ('90', 0,
  '90', 'openadmin', '开放平台管理员', 'openadmin', 'openadmin',
  '20001', '90', null, 'openadmin@supwisdom.com',
  '30001', '40001', '50156', null);

INSERT INTO `TB_B_SAFETY`(`ID`, `DELETED`, `USER_ID`, `SCORE`, `PASSWORD_SCORE`, `SECURE_EMAIL`, `SECURE_PHONE`)
VALUES ('90', 0, '90', '0', '0', null, null);


INSERT INTO `TB_B_ACCOUNT` (`ID`, `DELETED`, `USER_ID`,
  `ACCOUNT_NAME`, `ACCOUNT_EXPIRY_DATE`, `ORGANIZATION_ID`, `IDENTITY_TYPE_ID`,
  `ACTIVATION`, `STATE`, `IS_DATA_CENTER`, 
  `USER_UID`, `USER_NAME`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`)
VALUES ('90', 0, '90',
  'openadmin', null, '0', '1',
  1, 'NORMAL', 0, 
  '90', '开放平台管理员', '20001', '90');

INSERT INTO `TB_B_ACCOUNT_ORGANIZATION` (`ID`, `DELETED`,
  `ROOT_ORGANIZATION_ID`, `ACCOUNT_ID`, `ORGANIZATION_ID`)
VALUES ('90_0', 0,
  '0', '90', '0');

/*
INSERT INTO `TB_B_ACCOUNT_LABEL`(`ID`, `DELETED`,
  `ACCOUNT_ID`, `LABEL_ID`)
VALUES ('90_1', 0, '90', '1');
*/

commit;