开放平台 - 开发者中心数据初始化.md

文档说明

操作指南

请仔细阅读文档后，再进行操作

初始化数据

创建帐号

方式，SQL脚本

连接至 user 数据库，执行以下 SQL脚本

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;