数据质量管理平台

# LA2 版本升级到 GA 版本

⚠️文档中以MySQL数据安装为示例进行安装。

⚠️GA 版本使用的AFCenter版本为8.2.5，对应的EOS Platform版本为8.2.5。

本文介绍从数据质量 7.1 LA2 版本升级到 7.1 GA 版本的升级过程。

# 介质准备

下载数据质量 7.1 GA 介质，解压到安装服务器上。

微应用版本

前提：AFCenter 已经升级到 8.2.5。

微应用版本介质目录如下：

## 先解压Primeton_QualityCube_7.1_GA_MicroApp.tar.gz
## 再解压Primeton_QualityCube_7.1_GA_Server.tar.gz 、Primeton_QualityCube_7.1_GA_Scheduler.tar.gz 、Primeton_QualityCube_7.1_GA_Executor.tar.gz和Primeton_QualityCube_7.1_GA_UI.tar.gz。
## Primeton_QualityCube_7.1_GA_Server.tar.gz
├── bin
│   ├── shutdown.cmd
│   ├── shutdown.sh
│   ├── startup.cmd
│   └── startup.sh
├── config
│   ├── QUALITY
│   ├── application-afc.properties
│   ├── application-dqms.properties
│   ├── application.properties
│   ├── application-nacos.properties
│   ├── application-eureka.properties
│   ├── bootstrap.properties
│   └── logback-spring.xml
├── db-scripts
│   ├── DaMeng
│   ├── Mysql
│   ├── GaussDB
│   ├── Oracle
│   └── upgrade ## 7.1LA2-7.1GA升级脚本目录
├── lib ## 数据库驱动目录，mysql、oracle驱动需要自行下载
│   ├── DmJdbcDriver18-8.1.1.193.jar
│   ├── hive-jdbc-2.1.1.jar
│   └── opengauss-jdbc-3.0.0.jar
└── dqms-boot-7.1.1-exec.jar
## Primeton_QualityCube_7.1_GA_Scheduler
├── config
│   ├── application.properties
│   ├── logback.xml
├── lib
│   ├── .gitkeep
├── README.md
├── startJob.bat
├── startJob.sh
├── stopJob.bat
├── stopJob.sh
└── xxl-job-admin-2.2.0-exec.jar
## Primeton_QualityCube_7.1_GA_Executor
├── bin
│   ├── shutdown.cmd
│   ├── shutdown.sh
│   ├── startup.cmd
│   └── startup.sh
├── config
│   ├── legal-validator-tpl
│   ├── mapper
│   ├── spark
│   ├── templates
│   ├── account.properties
│   ├── application.properties
│   ├── banner.txt
│   ├── core-site.xml
│   ├── hdfs-site.xml
│   └── logback.xml
├── spark
│   └── hiveseq_check
├── lib ## 数据库驱动目录，mysql驱动需要自行下载
│   └── mysql-connector-java-8.0.19.jar
├── README.md
└── quality-executor-7.1.1-exec.jar
## Primeton_QualityCube_7.1_GA_UI
├── dist
│   ├── assets
│   ├── static
│   ├── index.html
│   └── remoteEntry.js
└── quality.conf

独立部署版本

独立部署版本介质目录如下：

## 解压Primeton_QualityCube_7.1_GA_Standalone.tar.gz
├── standalone
│   ├── clearLog.cmd
│   ├── clearLog.sh
│   ├── readme.txt
│   ├── shutdown.cmd
│   ├── shutdown.sh
│   ├── startup.cmd
│   └── startup.sh
├── server
│   ├── primetonlicense.xml
│   ├── executor
│   │   ├── bin
│   │   │   ├── shutdown.cmd
│   │   │   ├── shutdown.sh
│   │   │   ├── startup.cmd
│   │   │   └── startup.sh
│   │   ├── config
│   │   │   ├── legal-validator-tpl
│   │   │   ├── mapper
│   │   │   ├── spark
│   │   │   ├── templates
│   │   │   ├── account.properties
│   │   │   ├── application.properties
│   │   │   ├── banner.txt
│   │   │   ├── core-site.xml
│   │   │   ├── hdfs-site.xml
│   │   │   └── logback.xml
│   │   ├── spark
│   │   │   └── hiveseq_check
│   │   ├── lib ## 数据库驱动目录，mysql驱动需要自行下载
│   │   │   └── mysql-connector-java-8.0.19.jar
│   │   ├── README.md
│   │   └── quality-executor-7.1.1-exec.jar
│   ├── scheduler
│   │   ├── config
│   │   │   ├── application.properties
│   │   │   ├── logback.xml
│   │   ├── lib
│   │   │   ├── .gitkeep
│   │   ├── README.md
│   │   ├── startJob.bat
│   │   ├── startJob.sh
│   │   ├── stopJob.bat
│   │   ├── stopJob.sh
│   │   └── xxl-job-admin-2.2.0-exec.jar
│   └── quality
│      ├── afc-embed-boot-7.1.1-exec.jar
│      ├── config
│      │   ├── QUALITY
│      │   ├── application-afc.properties
│      │   ├── application-dqms.properties
│      │   ├── application.properties
│      │   ├── application-eureka.properties
│      │   ├── application-nacos.properties
│      │   ├── bootstrap.properties
│      │   └── logback-spring.xml
│      ├── lib ## 数据库驱动目录，mysql、oracle驱动需要自行下载
│      │   ├── DmJdbcDriver18-8.1.1.193
│      │   ├── hive-jdbc-2.1.1.jar
│      │   └── opengauss-jdbc-3.0.0.jar
│      ├── bin
│      │   ├── shutdown.cmd
│      │   ├── shutdown.sh
│      │   ├── startup.cmd
│      │   └── startup.sh
│      └── db-scripts
│         ├── afcenter
│         ├── eos
│         ├── bfp
│         ├── full
│         ├── locode
│         └── dqms
│            ├── DaMeng
│            ├── Mysql
│            ├── GaussDB
│            ├── Oracle
│            └── upgrade ## 7.1LA2-7.1GA升级脚本目录
└── web
   ├── afcenter
   │   ├── assets
   │   ├── bfp
   │   ├── components
   │   ├── components-ext
   │   ├── config
   │   ├── formDesigner
   │   ├── ide
   │   ├── quality ## 数据质量前端资源文件
   │   ├── static
   │   ├── remoteEntry.js
   │   ├── remoteEntry.js.gz
   │   ├── version.properties
   │   └── index.html
   └── conf
      └── quality.conf

# 执行升级脚本

⚠️升级前请先备份数据。

升级脚本从db-scripts/*/upgrade目录中获取，文件列表如下：

├── DaMeng
├── Mysql
├── GaussDB
└── Oracle

微应用版本

使用微应用版本部署时，AFCenter、数据质量后端服务是独立进程，因此都是独立的数据库，需要分别执行升级脚本。

升级AFCenter数据库

mysql> source 00-quaity-afc-data.sql

升级数据质量后端服务数据库（默认quaity_pub）

mysql> source 10-quaity-ddl.sql
mysql> source 11-quaity-data.sql
mysql> source 12-quality-function.sql

独立部署版本

独立部署版本部署时，AFCenter、数据质量后端服务为同一数据库，直接执行升级脚本即可。

mysql> source 00-quaity-afc-data.sql
mysql> source 01-afc-template-data.sql
mysql> source 10-quaity-ddl.sql
mysql> source 11-quaity-data.sql
mysql> source 12-quality-function.sql

# 替换新版本介质

⚠️升级前请先替换文件。

更新数据质量后端服务

使用解压后的后端介质文件，替换原有文件。

对于微应用版本，使用Primeton_QualityCube_7.1_GA_Server.tar.gz解压后进行替换。对于独立部署版本，可以使用server/quality目录替换原有文件。

更新调度器服务

对于微应用版本，使用Primeton_QualityCube_7.1_GA_Scheduler.tar.gz解压后进行替换。对于独立部署版本，可以使用server/scheduler目录替换原有文件。

更新执行器服务

对于微应用版本，使用Primeton_QualityCube_7.1_GA_Executor.tar.gz解压后进行替换。对于独立部署版本，可以使用server/executor目录替换原有文件。

更新数据质量前端资源

对于微应用版本，使用Primeton_QualityCube_7.1_GA_UI.tar.gz解压后的dist目录进行替换。对于独立部署版本，使用web/afcenter/quality目录进行替换原有文件。更新后，无需修改nginx配置。

# 验证

验证后端服务

访问数据质量平台在线文档地址http://<ip>:<port>/swagger-ui.html，确认后端服务是否正常。

验证调度器服务

访问调度器xxl-job地址http://<ip>:<port>/job-admin，确认调度器服务是否正常。

验证执行器服务

查看调度器下的执行器是否存在，确认执行器服务是否正常。

验证前端服务

访问AFCenter，登录后切换到数据质量，检查菜单、数据是否正常展示。

# 附录

# 新增配置说明

后端配置说明

升级脚本 升级脚本从db-scripts/upgrade目录中获取

00-quaity-afc-data.sql升级脚本说明（mysql、oracle、dm、opengauss相同）

##添加afc资源
-- afc_resource
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-241', '告警配置 - 新增', 'dqms-f-alarm-config-add', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:42:32', '2023-04-17 22:08:44', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-242', '告警配置 - 删除', 'dqms-f-alarm-config-delete-by-id', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:43:38', '2023-04-17 22:08:51', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-243', '告警配置 - 批量删除', 'dqms-f-alarm-config-delete-by-ids', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:43:56', '2023-04-17 22:08:38', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-244', '告警配置 - 修改', 'dqms-f-alarm-config-update', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:44:23', '2023-04-17 22:08:31', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-245', '告警配置 - 状态修改', 'dqms-f-alarm-config-update-state', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:45:02', '2023-04-17 22:08:24', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-246', '告警记录 - 关闭', 'dqms-f-alarm-record-close-remind', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:58:00', '2023-04-17 22:08:10', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-247', '告警记录 - 批量关闭', 'dqms-f-alarm-record-batch-modify-state', 'function', 'dqms-66', 'dqms-453', null, null, null, null, 'sys_tenant', '2023-04-10 23:58:52', '2023-04-17 22:08:17', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-248', '数据源配置新增', 'dqms-f-ds-data-config-save', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:00:53', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-250', '数据源配置修改', 'dqms-f-ds-data-config-update', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:02:32', '2023-04-11 00:02:47', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-251', '数据源配置删除', 'dqms-f-ds-data-config-delete', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:03:21', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-252', '数据源新增', 'dqms-f-ds-data-source-add', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:12:04', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-253', '数据源删除', 'dqms-f-ds-data-source-delete', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:12:20', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-254', '数据源修改', 'dqms-f-ds-data-source-update', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:12:37', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-255', '数据源 - 测试连接', 'dqms-f-ds-data-source-test-connect', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:13:02', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-256', 'hbase表映射配置删除', 'dqms-f-hbase-table-mapping-del', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:14:15', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-257', 'hbase表映射配置新增', 'dqms-f-hbase-table-mapping-save', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:14:34', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-258', 'hbase映射表创建', 'dqms-f-hbase-table-mapping-create-table', 'function', 'dqms-66', 'dqms-456', null, null, null, null, 'sys_tenant', '2023-04-11 00:15:01', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-259', '日历 - 新增', 'dqms-f-calendar-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-11 00:15:41', '2023-04-14 00:13:43', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-260', '日历 - 修改', 'dqms-f-calendar-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-11 00:15:57', '2023-04-14 00:13:54', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-261', '日历 - 删除', 'dqms-f-calendar-delete-by-name', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-11 00:19:54', '2023-04-14 00:14:01', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-263', '检核结果转问题', 'dqms-f-res-check-save-problem', 'function', 'dqms-66', 'dqms-452', null, null, null, null, 'sys_tenant', '2023-04-11 00:52:37', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-264', '检核结果 - 问题关闭', 'dqms-f-res-check-save-close-problem', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-11 00:53:12', '2023-04-14 23:13:14', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-350', '检核结果列表导出', 'dqms-f-res-check-excel-export', 'function', 'dqms-66', 'dqms-452', null, null, null, '将检核结果列表导出为xlsx', 'sys_tenant', '2023-06-07 00:42:44', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-265', '检核规则管理 - 删除', 'dqms-f-res-check-del-by-config-sid', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 17:41:36', '2023-04-11 22:52:47', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-266', '检核规则立即执行', 'dqms-f-res-check-immediate-exe', 'function', 'dqms-66', 'dqms-451', null, null, null, null, 'sys_tenant', '2023-04-11 17:42:58', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-267', '检核结果下载', 'dqms-f-res-check-download-ftp', 'function', 'dqms-66', 'dqms-452', null, null, null, null, 'sys_tenant', '2023-04-11 17:44:52', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-268', '检核规则监控状态重置', 'dqms-f-res-check-re-set-method-monitor', 'function', 'dqms-66', 'dqms-451', null, null, null, null, 'sys_tenant', '2023-04-11 17:45:49', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-281', '检核工作台 - 关系型数据库检核规则新增', 'dqms-f-method-config-add-config-for-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 22:51:26', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-282', '检核规则管理 - 新增', 'dqms-f-method-config-add-tradition-method', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 22:52:32', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-283', '检核工作台 - sql预览', 'dqms-f-method-config-show-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 23:06:31', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-284', '检核工作台 - 预览数据', 'dqms-f-method-config-show-sql-data', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 23:13:30', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-286', '检核工作台 - 检核规则模板批量导出', 'dqms-f-method-config-download-for-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 23:20:49', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-287', '检核工作台 - 检核规则模板批量导入', 'dqms-f-method-config-import-data-for-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-11 23:22:50', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-288', '检核工作台 - 检核规则模板批量保存', 'dqms-f-method-config-add-batch-config-for-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-12 01:34:52', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-289', '检核工作台 - 非关系型数据库检核规则新增', 'dqms-f-method-config-add-config-for-item', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-12 01:45:11', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-290', '检核规则管理 - 状态 -> 停用', 'dqms-f-method-config-stop-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-12 23:40:00', '2023-04-12 23:41:00', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-291', '检核规则管理 - 状态 -> 启用', 'dqms-f-method-config-start-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-12 23:40:33', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-292', '检核工作台 - sql/hive类型的检核规则修改', 'dqms-f-method-config-edit-for-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-12 23:56:01', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-293', '检核工作台 - hbase/bcp类型检核规则修改', 'dqms-f-method-config-edit-for-no-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 00:00:07', '2023-04-13 00:10:44', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-294', '检核工作台 - 下载hbase/bcp检核规则导入模板', 'dqms-f-method-config-download-for-no-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 00:03:12', '2023-04-13 00:04:44', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-295', '检核工作台 - hbase/bcp类型的检核规则导入', 'dqms-f-method-config-import-data-for-no-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 00:10:36', '2023-04-13 00:15:09', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-296', '检核工作台 - 批量新增hbase/bcp检核规则', 'dqms-f-method-config-add-batch-config-for-no-sql', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 00:14:55', '2023-04-13 00:15:17', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-297', '检核规则管理 - hbase导入模板下载', 'dqms-f-method-config-down-for-ct', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 01:00:19', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-298', '检核规则管理 - hbase导入', 'dqms-f-method-config-import-data-for-ct', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 01:03:25', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-299', '检核规则管理 - jdbc导入模板下载', 'dqms-f-x-check-config-sql-template', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 02:26:00', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-300', 'jdbc导入', 'dqms-f-x-check-config-import-data', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-13 02:26:18', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-301', '频度 - 新增', 'dqms-f-frequency-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-14 00:14:20', '2023-04-14 00:14:32', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-302', '频度 - 修改', 'dqms-f-frequency-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-14 00:14:50', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-303', '频度 - 删除', 'dqms-f-frequency-delete-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-14 00:15:11', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-304', '通用检核 - 新增', 'dqms-f-general-config-add-general-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:14:31', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-305', '通用检核 - 数据对照新增', 'dqms-f-general-config-add-general-config-for-data-compare', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:15:02', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-306', '通用检核 - 删除', 'dqms-f-general-config-delete-by-ids', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:15:26', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-307', '通用检核 - 修改', 'dqms-f-general-config-update-general-config', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:15:44', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-308', '通用检核 - 状态修改', 'dqms-f-general-config-update-general-config-state', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:16:05', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-309', '通用检核 - 新增（页面）', 'dqms-f-general-config-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:16:26', '2023-04-14 02:21:34', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-310', '检核规则管理 - 导入（页面）', 'dqms-f-method-config-import', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 01:44:49', '2023-04-14 02:21:44', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-311', '分组 - 新增', 'dqms-f-group-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:22:06', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-312', '分组 - 批量删除分组信息', 'dqms-f-group-delete-batch', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:22:24', '2023-04-14 02:23:32', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-313', '分组 - 删除分组下规则信息', 'dqms-f-group-delete-relation', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:23:07', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-314', '分组 - 修改', 'dqms-f-group-update-relation', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:24:04', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-315', '分组 - 规则/指标指定分组', 'dqms-f-group-add-relation-batch', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:26:06', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-317', '指标 - 新增', 'dqms-f-index-info-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:27:04', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-318', '指标 - 删除', 'dqms-f-index-info-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:27:21', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-319', '指标 - 更新', 'dqms-f-index-info-update', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 02:27:37', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-320', '知识库 - 保存（页面）', 'dqms-f-knowledge-info-save', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 22:03:25', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-321', '知识库 - 新增', 'dqms-f-knowledge-info-add', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 22:03:48', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-322', '知识库 - 修改', 'dqms-f-knowledge-info-update', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 22:04:06', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-324', '问题处理 - 添加反馈', 'dqms-f-option-save-feedback', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 23:04:04', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-325', '问题处理 - 新增', 'dqms-f-option-save-option', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 23:04:30', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-326', '问题处理 - 关闭', 'dqms-f-option-update-state', 'function', 'dqms-66', 'dqms-454', null, null, null, null, 'sys_tenant', '2023-04-14 23:04:57', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-327', 'hbase规则维护 - 新增', 'dqms-f-rule-info-add', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 23:28:44', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-328', 'hbase规则维护 - 删除', 'dqms-f-rule-info-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 23:29:05', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-329', 'hbase规则维护 - 删除', 'dqms-f-rule-info-update', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-14 23:29:31', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-330', '检核任务管理 - 新增', 'dqms-f-schedule-config-add', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:04:17', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-331', '检核任务管理 - 删除', 'dqms-f-schedule-config-delete', 'function', 'dqms-66', 'dqms-450', null, '检核工作台使用', null, null, 'sys_tenant', '2023-04-15 00:05:19', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-332', '检核任务管理 - 修改', 'dqms-f-schedule-config-update', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:06:04', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-333', '检核任务管理 - 启用', 'dqms-f-schedule-config-start-schedule', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:06:25', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-334', '检核任务管理 - 停用', 'dqms-f-schedule-config-stop-schedule', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:06:55', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-335', '检核工作台 - 批量删除', 'dqms-f-schedule-config-delete-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:07:23', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-336', '检核任务管理 - 批量启用', 'dqms-f-schedule-config-start-schedule-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:08:08', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-337', '检核任务管理 - 批量停用', 'dqms-f-schedule-config-stop-schedule-batch', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:08:27', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-338', '检核任务管理 - 立即执行', 'dqms-f-schedule-config-start-schedule-now', 'function', 'dqms-66', 'dqms-450', null, null, null, null, 'sys_tenant', '2023-04-15 00:09:17', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-341', '检核任务管理 - 状态切换（页面）', 'dqms-f-schedule-config-update-state', 'function', 'dqms-66', 'dqms-450', null, '启用\\停用', null, null, 'sys_tenant', '2023-04-15 00:14:46', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-342', '分组 - 删除（页面）', 'dqms-f-group-delete', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-17 23:46:19', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-343', '检核规则管理 - 修改', 'dqms-f-method-config-edit-tradition-method', 'function', 'dqms-66', 'dqms-449', null, null, null, null, 'sys_tenant', '2023-04-18 01:20:28', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-361', '检核工作台 - 新增检核规则（页面）', 'dqms-f-method-config-add', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:47:22', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-362', '检核工作台 - 批量新增检核规则（页面）', 'dqms-f-method-config-add-batch', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:48:10', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-363', '检核工作台 - 新增数据源（页面）', 'dqms-f-method-config-add-datasource', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:48:48', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-364', '检核工作台 - 批量新增数据源（页面）', 'dqms-f-method-config-add-batch-datasource', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:49:22', '2023-04-19 17:49:30', 'admin', 'admin', null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-365', '检核工作台 - 检核任务新增（页面）', 'dqms-f-method-config-add-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:50:03', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-366', '检核工作台 - 检核任务修改（页面）', 'dqms-f-method-config-edit-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:50:33', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-367', '检核工作台 - 检核任务删除（页面）', 'dqms-f-method-config-del-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:50:56', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-368', '检核工作台 - 检核任务启用（页面）', 'dqms-f-method-config-start-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:51:38', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-369', '检核工作台 - 检核任务停用（页面）', 'dqms-f-method-config-stop-task', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:52:09', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-370', '检核工作台 - 指标新增（页面）', 'dqms-f-method-config-add-index', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:53:02', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-371', '检核工作台 - 指标修改（页面）', 'dqms-f-method-config-edit-index', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:53:45', null, 'admin', null, null);
INSERT INTO afc_resource (ID, NAME, CODE, TYPES, APP_ID, RES_GROUP_ID, SUB_TYPE, DESCRIPTION, BUSINESS_OBJ_ID, CONTENT, TENANT_ID, CREATE_TIME, UPDATE_TIME, CREATE_USER, UPDATE_USER, IS_FIXED) VALUES ('dqms-372', '检核工作台 - 指标删除（页面）', 'dqms-f-method-config-del-index', 'function', 'dqms-66', 'dqms-449', null, '页面tree', null, null, 'sys_tenant', '2023-04-19 17:54:21', null, 'admin', null, null);

##添加afc资源角色
-- afc_r_res_role
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-822', 'dqms-350', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1116', 'dqms-265', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1117', 'dqms-281', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1118', 'dqms-282', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1119', 'dqms-283', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1120', 'dqms-284', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1121', 'dqms-286', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1122', 'dqms-287', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1123', 'dqms-288', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1124', 'dqms-289', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1125', 'dqms-290', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1126', 'dqms-291', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1127', 'dqms-292', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1128', 'dqms-293', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1129', 'dqms-294', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1130', 'dqms-295', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1131', 'dqms-296', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1132', 'dqms-297', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1133', 'dqms-298', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1134', 'dqms-299', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1135', 'dqms-304', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1136', 'dqms-305', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1137', 'dqms-306', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1138', 'dqms-307', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1139', 'dqms-308', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1140', 'dqms-309', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1141', 'dqms-310', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1142', 'dqms-311', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1143', 'dqms-312', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1144', 'dqms-313', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1145', 'dqms-314', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1146', 'dqms-315', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1147', 'dqms-317', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1148', 'dqms-318', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1149', 'dqms-319', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1150', 'dqms-327', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1151', 'dqms-328', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1152', 'dqms-329', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1153', 'dqms-342', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1154', 'dqms-343', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1155', 'dqms-259', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1156', 'dqms-260', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1157', 'dqms-261', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1158', 'dqms-301', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1159', 'dqms-302', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1160', 'dqms-303', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1161', 'dqms-330', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1162', 'dqms-331', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1163', 'dqms-332', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1164', 'dqms-333', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1165', 'dqms-334', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1166', 'dqms-335', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1167', 'dqms-336', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1168', 'dqms-337', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1169', 'dqms-338', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1170', 'dqms-341', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1171', 'dqms-266', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1172', 'dqms-268', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1173', 'dqms-263', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1174', 'dqms-267', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1175', 'dqms-241', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1176', 'dqms-242', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1177', 'dqms-243', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1178', 'dqms-244', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1179', 'dqms-245', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1180', 'dqms-246', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1181', 'dqms-247', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1182', 'dqms-264', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1183', 'dqms-320', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1184', 'dqms-321', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1185', 'dqms-322', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1186', 'dqms-324', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1187', 'dqms-325', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1188', 'dqms-326', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1189', 'dqms-248', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1190', 'dqms-250', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1191', 'dqms-251', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1192', 'dqms-252', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1193', 'dqms-253', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1194', 'dqms-254', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1195', 'dqms-255', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1196', 'dqms-256', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1197', 'dqms-257', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-1198', 'dqms-258', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);
INSERT INTO afc_r_res_role (ID, RES_ID, RES_TYPE, ROLE_ID, ROLE_TYPE, BUSINESS_OBJ_ID, BUSINESS_OBJ_INST_ID, TENANT_ID, IS_FIXED) VALUES ('dqms-449', 'dqms-316', 'function', 'dqms-92', 'platform', null, null, 'sys_tenant', null);

10-quality-ddl.sql升级脚本说明（mysql、oracle、dm、opengauss相同）

ALTER TABLE DQMS_RATING_RESULT RENAME COLUMN ORG_ID TO ORG_ID_TEMP;

ALTER TABLE DQMS_RATING_RESULT ADD COLUMN ORG_ID VARCHAR(64);

UPDATE DQMS_RATING_RESULT SET ORG_ID = TRIM(ORG_ID_TEMP);

ALTER TABLE DQMS_RATING_RESULT DROP COLUMN ORG_ID_TEMP;

ALTER TABLE DQMS_RATING_RESULT RENAME COLUMN PARENT_ORG_ID TO PARENT_ORG_ID_TEMP;

ALTER TABLE DQMS_RATING_RESULT ADD COLUMN PARENT_ORG_ID VARCHAR(64);

UPDATE DQMS_RATING_RESULT SET PARENT_ORG_ID = TRIM(PARENT_ORG_ID_TEMP);

ALTER TABLE DQMS_RATING_RESULT DROP COLUMN PARENT_ORG_ID_TEMP;

##为CK_GENERAL_CONFIG(通用检核规则)添加告警id字段，为通用检核增加告警功能

ALTER TABLE CK_GENERAL_CONFIG ADD COLUMN ALARM_ID BIGINT;

##为CK_GENERAL_CONFIG(通用检核规则)添加告警配置信息，为通用检核增加告警具体信息

ALTER TABLE CK_GENERAL_CONFIG ADD COLUMN CHECK_CONFIG VARCHAR(255);

ALTER TABLE CK_GENERAL_RESULT ADD COLUMN COUNT_OUT_OF_RANGE BIGINT(65);

← 账号权限管理 →