docs: 整理数据迁移脚本
diff --git "a/docs/\345\274\200\346\224\276\345\271\263\345\217\260\345\210\235\345\247\213\346\225\260\346\215\256\350\277\201\347\247\273\346\223\215\344\275\234\350\257\264\346\230\216.md" "b/docs/\345\274\200\346\224\276\345\271\263\345\217\260\345\210\235\345\247\213\346\225\260\346\215\256\350\277\201\347\247\273\346\223\215\344\275\234\350\257\264\346\230\216.md"
index bd0c4a5..40d6493 100644
--- "a/docs/\345\274\200\346\224\276\345\271\263\345\217\260\345\210\235\345\247\213\346\225\260\346\215\256\350\277\201\347\247\273\346\223\215\344\275\234\350\257\264\346\230\216.md"
+++ "b/docs/\345\274\200\346\224\276\345\271\263\345\217\260\345\210\235\345\247\213\346\225\260\346\215\256\350\277\201\347\247\273\346\223\215\344\275\234\350\257\264\346\230\216.md"
@@ -154,7 +154,7 @@
```sql
select CONCAT(
'INSERT INTO \`TB_DEV_APPLICATION\` (ID, DELETED, NAME, DESCRIPTION, URL, SYSTEM_ID, APPLICATION_IDENTIFICATION) VALUES',
- '(\'', ID, '\',\'1\',\'',NAME, '\',\'',DESCRIPTION,'\',\'', INFORMATION_URL,'\',\'','1', '\',\'', APPLICATION_ID , '\');') as INSERT_SQL
+ '(\'cas_server-', ID, '\',\'1\',\'',NAME, '\',\'',DESCRIPTION,'\',\'', INFORMATION_URL,'\',\'','1', '\',\'', APPLICATION_ID , '\');') as INSERT_SQL
from cas_server.TB_SERVICE
where DELETED = 0
;
@@ -207,7 +207,7 @@
```sql
select CONCAT(
'INSERT INTO \`TB_DEV_APPLICATION\` (ID,DELETED, NAME, DESCRIPTION, SYSTEM_ID, `APPLICATION_IDENTIFICATION`, URL) VALUES ',
- '(\'',ID,'-message\',\'1\',\'',NAME,'\',\'', IFNULL(DESCRIPTION,''),'\',\'','1','\',\'',APP_ID,'\',\'',IFNULL(URL,''),'\');') as INSERT_SQL
+ '(\'message-',ID,'\',\'1\',\'',NAME,'\',\'', IFNULL(DESCRIPTION,''),'\',\'','1','\',\'',APP_ID,'\',\'',IFNULL(URL,''),'\');') as INSERT_SQL
from message.ACCESS_APP
where DELETED = 0 AND APP_ID IS NOT NULL
;
@@ -340,7 +340,7 @@
```sql
select CONCAT(
'INSERT INTO \`TB_DEV_APPLICATION_ABILITY_USAGE\` (ID, COMPANY_ID, DELETED, APPLICATION_ID, ABILITY_ID, APPLY_TIME,ABILITY_SETTINGS) VALUES (',
- '\'',ID,'cas','\',\'',' 1\', \'0','\',\'', ID,'\',\'', 'cas\', \'2020-12-22 15:32:43\',\'',
+ '\'cas_server-',ID,'-cas\',\'',' 1\', \'0','\',\'cas_server-', ID,'\',\'', 'cas\', \'2020-12-22 15:32:43\',\'',
'{"logoutType":"',IFNULL(LOGOUT_TYPE,''),'","applicationDomain":"',IFNULL(APPLICATION_DOMAIN,''),'","addTime":1608538919314,"description":"',IFNULL(DESCRIPTION,''),
'","externalId":"',IFNULL(EXTERNAL_ID,''),'","informationUrl":"',IFNULL(INFORMATION_URL,''),'","enabled":true,"registeredServiceId":',IFNULL(REGISTERED_SERVICE_ID,''),
',"companyId":"1","responseType":"',RESPONSE_TYPE,'","deleted":false,"ssoEnabled":',IF(SSO_ENABLED = 1,'true','false'),',"idTokenEnabled":',IF(ID_TOKEN_ENABLED = 1,'true','false'),
@@ -349,7 +349,7 @@
'}',
'\');'
) as INSERT_SQL
-from TB_SERVICE
+from cas_server.TB_SERVICE
where DELETED = '0'
;
```
@@ -367,6 +367,23 @@
;
```
+
+可以使用下面的查询语句生成 sql拼接语句来进行插入：
+
+```sql
+select CONCAT(
+ 'INSERT INTO \`TB_DEV_APPLICATION_ABILITY_USAGE\` (ID, COMPANY_ID, DELETED, APPLICATION_ID, ABILITY_ID, APPLY_TIME,ABILITY_SETTINGS) VALUES (',
+ '\'message-',ID,'-message\',\'',' 1\', \'0','\',\'message-', ID,'\',\'', 'message\', \'2020-12-22 15:32:43\',\'',
+ '{',
+
+ '}',
+ '\');'
+from message.ACCESS_APP
+where DELETED = 0 AND APP_ID IS NOT NULL
+;
+```
+
+
#### 3.3 添加应用的openapi基础能力。
* 开通