开放平台 - 用户服务数据初始化.md

文档说明

操作指南

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

初始化数据

创建身份

方式，SQL脚本

连接至 user 数据库，执行以下 SQL脚本（如果已经存在相关数据，则无须执行；建议比对下数据是否正确）

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;

创建用户、帐号

方式，SQL脚本

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

use user;

-- 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;