chore: 调整目录结构
diff --git a/deploy-manifests/k8s-rancher/open-platform/1.0.init.sql b/deploy-manifests/k8s-rancher/open-platform/1.0.init.sql
index 0e5fe44..e6096c8 100644
--- a/deploy-manifests/k8s-rancher/open-platform/1.0.init.sql
+++ b/deploy-manifests/k8s-rancher/open-platform/1.0.init.sql
@@ -11,13 +11,13 @@
`APPLICATION_DOMAIN`
)
VALUES ('13', '1', 0, 'admin', '2020-07-01 00:00:00',
- '开放平台管理端', '开放平台管理端', 'https://dev-admin.dev.supwisdom.com', 'https://dev-admin.dev.supwisdom.com/slo',
+ '开放平台管理端', '开放平台管理端', 'https://dev-admin.paas.xxx.edu.cn', 'https://dev-admin.paas.xxx.edu.cn/slo',
'REDIRECT', 'FRONT_CHANNEL',
- 13, '开放平台管理端', 13, 'https://dev-admin.dev.supwisdom.com/(.*)',
+ 13, '开放平台管理端', 13, 'https://dev-admin.paas.xxx.edu.cn/(.*)',
1, 1, 1,
'1', '1',
13, 13,
- 'dev-admin.dev.supwisdom.com'
+ 'dev-admin.paas.xxx.edu.cn'
);
@@ -35,6 +35,7 @@
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`,
@@ -68,26 +69,31 @@
VALUES ('150', 0,
'150', 'defaultDeveloper', '上海树维', 'defaultDeveloper', 'defaultDeveloper',
'20001', '150', null, 'defaultDeveloper@supwisdom.com',
- '30001', '40001', '50156', '310000');
-
-INSERT INTO `TB_B_ACCOUNT` (`ID`, `DELETED`, `USER_ID`,
- `ACCOUNT_NAME`, `ACCOUNT_EXPIRY_DATE`, `ORGANIZATION_ID`, `IDENTITY_TYPE_ID`,
- `ACTIVATION`, `STATE`, `IS_DATA_CENTER`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`, `USER_NAME`)
-VALUES ('150', 0, '150',
- 'defaultDeveloper', null, '1', 'D01',
- 1, 'NORMAL', 0, '20001', '150', '上海树维');
+ '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_1', 0,
- '0', '150', '1');
+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;
@@ -99,57 +105,66 @@
VALUES ('151', 0,
'151', 'defaultOperator', '上海树维业务管理员', 'defaultOperator', 'defaultOperator',
'20001', '151', null, 'defaultOperator@supwisdom.com',
- '30001', '40001', '50156', '310000');
-
-INSERT INTO `TB_B_ACCOUNT` (`ID`, `DELETED`, `USER_ID`,
- `ACCOUNT_NAME`, `ACCOUNT_EXPIRY_DATE`, `ORGANIZATION_ID`, `IDENTITY_TYPE_ID`,
- `ACTIVATION`, `STATE`, `IS_DATA_CENTER`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`, `USER_NAME`)
-VALUES ('151', 0, '151',
- 'defaultOperator', null, '1', 'D02',
- 1, 'NORMAL', 0, '20001', '151', '上海树维业务管理员');
+ '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_1', 0,
- '0', '151', '1');
+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 ('152', 0,
- '152', 'openadmin', '开放平台管理员', 'openadmin', 'openadmin',
- '20001', '152', null, 'openadmin@supwisdom.com',
- '30001', '40001', '50156', '310000');
+VALUES ('13', 0,
+ '13', 'openadmin', '开放平台管理员', 'openadmin', 'openadmin',
+ '20001', '13', 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 ('13', 0, '13', '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`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`, `USER_NAME`)
-VALUES ('152', 0, '152',
- 'openadmin', null, '1', 'D02',
- 1, 'NORMAL', 0, '20001', '152', '开放平台管理员');
-
-
-INSERT INTO `TB_B_SAFETY`(`ID`, `DELETED`, `USER_ID`, `SCORE`, `PASSWORD_SCORE`, `SECURE_EMAIL`, `SECURE_PHONE`)
-VALUES ('152', 0, '152', '0', '0', null, null);
+ `ACTIVATION`, `STATE`, `IS_DATA_CENTER`,
+ `USER_UID`, `USER_NAME`, `CERTIFICATE_TYPE_ID`, `CERTIFICATE_NUMBER`)
+VALUES ('13', 0, '13',
+ 'openadmin', null, '0', 'D02',
+ 1, 'NORMAL', 0,
+ '13', '开放平台管理员', '20001', '13');
INSERT INTO `TB_B_ACCOUNT_ORGANIZATION` (`ID`, `DELETED`,
`ROOT_ORGANIZATION_ID`, `ACCOUNT_ID`, `ORGANIZATION_ID`)
-VALUES ('152_1', 0,
- '0', '152', '1');
+VALUES ('13_0', 0,
+ '0', '13', '0');
+/*
INSERT INTO `TB_B_ACCOUNT_LABEL`(`ID`, `DELETED`,
`ACCOUNT_ID`, `LABEL_ID`)
-VALUES ('152_1', 0, '152', '1');
+VALUES ('13_1', 0, '13', '1');
+*/
-commit;
\ No newline at end of file
+commit;