gfwleak/enderbyendera-realtime-protection
Archived
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
This repository has been archived on 2025-09-14. You can view files and clone it, but cannot push or open issues or pull requests.
Files
haskafka
enderbyendera-realtime-prot…/sql/mysql-2024-1-23.sql
EnderByEndera 73ed4b75aa 添加SQL创建信息
2024-01-23 22:53:16 +08:00

351 lines
21 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- MySQL dump 10.13 Distrib 8.0.35, for Linux (x86_64)
--
-- Host: 192.168.107.89 Database: realtime_protection
-- ------------------------------------------------------
-- Server version 8.0.35-0ubuntu0.22.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `realtime_protection`
--
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `realtime_protection` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `realtime_protection`;
--
-- Table structure for table `chanct_log_usual`
--
DROP TABLE IF EXISTS `chanct_log_usual`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `chanct_log_usual` (
`id` bigint NOT NULL COMMENT '编号',
`service_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '服务ID',
`server_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '服务器名',
`server_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '服务器IP地址',
`env` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '系统环境',
`log_level` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志级别',
`log_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志业务id',
`log_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '日志数据',
`method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作方式',
`request_uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求URI',
`remote_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作IP地址',
`method_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法类',
`method_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '方法名',
`user_agent` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '用户代理',
`params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '操作提交的数据',
`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建者',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tenant_id` bigint DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='通用审计表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_command_statistics`
--
DROP TABLE IF EXISTS `t_command_statistics`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_command_statistics` (
`command_id` bigint unsigned NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`command_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='处置指令统计表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_dynamic_rule`
--
DROP TABLE IF EXISTS `t_dynamic_rule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_dynamic_rule` (
`dynamic_rule_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`dynamic_rule_used_task_id` bigint unsigned DEFAULT NULL COMMENT '动态规则使用的任务ID',
`dynamic_rule_name` varchar(32) NOT NULL COMMENT 'VARCHAR(32)',
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modify_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
`dynamic_rule_create_username` varchar(32) DEFAULT NULL COMMENT '规则创建人名称',
`dynamic_rule_create_depart` varchar(32) DEFAULT NULL COMMENT '创建人处室',
`dynamic_rule_protect_level` tinyint DEFAULT NULL COMMENT '防护等级',
`dynamic_rule_priority` tinyint NOT NULL COMMENT '优先级',
`dynamic_rule_range` varchar(32) NOT NULL COMMENT '局点选择',
`dynamic_rule_frequency` tinyint NOT NULL COMMENT '下发频率',
`dynamic_rule_create_user_id` int DEFAULT NULL,
`template_id` bigint unsigned NOT NULL COMMENT '策略模板ID',
PRIMARY KEY (`dynamic_rule_id`),
KEY `t_dynamic_rule_t_task_task_id_fk` (`dynamic_rule_used_task_id`),
CONSTRAINT `t_dynamic_rule_t_task_task_id_fk` FOREIGN KEY (`dynamic_rule_used_task_id`) REFERENCES `t_task` (`task_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='动态规则信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_protect_level`
--
DROP TABLE IF EXISTS `t_protect_level`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_protect_level` (
`protect_level_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '防护等级ID',
`has_protect_object_ip` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含防护对象IP',
`has_protect_object_port` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含防护对象端口',
`has_protocol` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含协议',
`has_url` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含URL',
`has_peer_ip` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含对端IP',
`has_peer_port` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含对端端口',
`has_dns` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否包含DNS字段',
PRIMARY KEY (`protect_level_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9746 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='防护等级表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_protect_object`
--
DROP TABLE IF EXISTS `t_protect_object`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_protect_object` (
`protect_object_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`protect_object_name` varchar(32) NOT NULL COMMENT '防护对象名称',
`protect_object_system_name` varchar(32) DEFAULT NULL COMMENT '防护对象系统名称',
`protect_object_ip` int unsigned DEFAULT NULL COMMENT '防护对象IP',
`protect_object_port` smallint unsigned NOT NULL COMMENT '防护对象业务端口',
`protect_object_url` varchar(255) DEFAULT NULL COMMENT '防护对象URL',
`protect_object_protocol` varchar(32) NOT NULL COMMENT '防护对象使用协议',
`protect_object_audit_status` tinyint NOT NULL DEFAULT '0' COMMENT '防护对象审核状态',
`protect_object_create_username` varchar(32) DEFAULT NULL COMMENT '防护对象创建人',
`protect_object_create_depart` varchar(32) DEFAULT NULL COMMENT '防护对象创建人处室',
`protect_object_create_user_id` int DEFAULT NULL COMMENT '防护对象创建人ID',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modify_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`protect_object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23557 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='防护对象信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_protect_object_dynamic_rule_conn`
--
DROP TABLE IF EXISTS `t_protect_object_dynamic_rule_conn`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_protect_object_dynamic_rule_conn` (
`conn_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '关联ID',
`protect_object_id` bigint unsigned NOT NULL COMMENT '防护对象ID',
`dynamic_rule_id` bigint unsigned NOT NULL COMMENT '动态规则ID',
PRIMARY KEY (`conn_id`),
KEY `t_protect_object_dynamic_rule_id_fk` (`dynamic_rule_id`),
KEY `t_protect_object_id_fk` (`protect_object_id`),
CONSTRAINT `t_protect_object_dynamic_rule_id_fk` FOREIGN KEY (`dynamic_rule_id`) REFERENCES `t_dynamic_rule` (`dynamic_rule_id`) ON DELETE CASCADE,
CONSTRAINT `t_protect_object_id_fk` FOREIGN KEY (`protect_object_id`) REFERENCES `t_protect_object` (`protect_object_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='防护对象-动态规则关联表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_static_rule`
--
DROP TABLE IF EXISTS `t_static_rule`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_static_rule` (
`static_rule_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`static_rule_name` varchar(32) NOT NULL COMMENT '静态规则名称',
`static_rule_create_time` datetime NOT NULL COMMENT '静态规则创建时间',
`static_rule_create_username` varchar(32) DEFAULT NULL COMMENT '创建人名称',
`static_rule_audit_status` tinyint DEFAULT NULL COMMENT '静态规则审核状态，分为未审核（0）、退回（1）、已审核（2）',
`static_rule_create_depart` varchar(32) DEFAULT NULL COMMENT '规则创建人处室',
`static_rule_create_user_id` bigint unsigned DEFAULT NULL COMMENT '规则创建人ID',
`static_rule_used_task_id` bigint unsigned DEFAULT NULL COMMENT '使用该静态规则的任务主键id',
`static_rule_sip` int unsigned DEFAULT NULL COMMENT '源ip',
`static_rule_msip` int unsigned DEFAULT NULL COMMENT '源ip掩码',
`static_rule_sport` smallint unsigned DEFAULT NULL COMMENT '源端口',
`static_rule_msport` smallint unsigned DEFAULT NULL COMMENT '源端口掩码',
`static_rule_dip` int unsigned DEFAULT NULL COMMENT '目的ip',
`static_rule_mdip` int unsigned DEFAULT NULL COMMENT '目的ip掩码',
`static_rule_dport` smallint unsigned DEFAULT NULL COMMENT '目的端口',
`static_rule_mdport` smallint unsigned DEFAULT NULL COMMENT '目的端口掩码',
`static_rule_protocol` varchar(32) DEFAULT NULL COMMENT '协议v',
`static_rule_mprotocol` varchar(32) DEFAULT NULL COMMENT '协议掩码',
`static_rule_dns` varchar(255) DEFAULT NULL COMMENT 'dns地址',
`static_rule_url` varchar(255) DEFAULT NULL COMMENT 'url',
`static_rule_priority` tinyint NOT NULL COMMENT '优先级，1代表高、2代表中、3代表低',
`static_rule_range` varchar(255) NOT NULL COMMENT '局点选择',
`static_rule_frequency` tinyint NOT NULL COMMENT '下发频率',
`static_rule_modify_time` datetime DEFAULT NULL COMMENT '静态规则修改时间',
PRIMARY KEY (`static_rule_id`),
KEY `t_static_rule_t_task_task_id_fk` (`static_rule_used_task_id`),
CONSTRAINT `t_static_rule_t_task_task_id_fk` FOREIGN KEY (`static_rule_used_task_id`) REFERENCES `t_task` (`task_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=1132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='静态关键信息库表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_strategy_template`
--
DROP TABLE IF EXISTS `t_strategy_template`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_strategy_template` (
`strategy_template_id` bigint unsigned NOT NULL AUTO_INCREMENT,
`strategy_template_name` varchar(64) NOT NULL COMMENT '策略模板名称',
`strategy_template_create_username` varchar(32) DEFAULT NULL COMMENT '策略模板创建人名称',
`strategy_template_create_depart` varchar(32) DEFAULT NULL COMMENT '策略模板创建人处室',
`strategy_template_create_user_id` int DEFAULT NULL COMMENT '策略模板创建人ID',
`strategy_template_low_level_id` int unsigned DEFAULT NULL COMMENT '策略模板日常态等级ID',
`strategy_template_medium_level_id` int unsigned DEFAULT NULL COMMENT '策略模板应急态等级ID',
`strategy_template_high_level_id` int unsigned DEFAULT NULL COMMENT '策略模板紧急态等级ID',
`strategy_template_source_system` varchar(32) NOT NULL COMMENT '默认数据来源系统',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`modify_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`strategy_template_id`),
UNIQUE KEY `t_strategy_template_pk` (`strategy_template_name`,`strategy_template_source_system`),
KEY `t_strategy_template_t_protect_level_protect_level_id_fk` (`strategy_template_low_level_id`),
KEY `t_strategy_template_t_protect_level_protect_level_id_fk_2` (`strategy_template_medium_level_id`),
KEY `t_strategy_template_t_protect_level_protect_level_id_fk_3` (`strategy_template_high_level_id`),
CONSTRAINT `t_strategy_template_t_protect_level_protect_level_id_fk` FOREIGN KEY (`strategy_template_low_level_id`) REFERENCES `t_protect_level` (`protect_level_id`) ON DELETE SET NULL,
CONSTRAINT `t_strategy_template_t_protect_level_protect_level_id_fk_2` FOREIGN KEY (`strategy_template_medium_level_id`) REFERENCES `t_protect_level` (`protect_level_id`) ON DELETE SET NULL,
CONSTRAINT `t_strategy_template_t_protect_level_protect_level_id_fk_3` FOREIGN KEY (`strategy_template_high_level_id`) REFERENCES `t_protect_level` (`protect_level_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3252 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='策略模板信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_task`
--
DROP TABLE IF EXISTS `t_task`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_task` (
`task_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '任务ID',
`task_name` varchar(32) NOT NULL COMMENT '任务名称',
`task_start_time` datetime NOT NULL COMMENT '任务开始时间',
`task_end_time` datetime NOT NULL COMMENT '任务结束时间',
`task_create_time` datetime NOT NULL COMMENT '任务创建时间',
`task_modify_time` datetime NOT NULL COMMENT '任务信息修改时间',
`task_type` tinyint unsigned NOT NULL COMMENT '任务类型',
`task_act` varchar(32) NOT NULL COMMENT '任务行为',
`task_create_username` varchar(32) DEFAULT NULL COMMENT '任务创建人名称',
`task_create_depart` varchar(32) DEFAULT NULL COMMENT '任务创建人处室',
`task_create_userid` bigint unsigned DEFAULT NULL COMMENT '任务创建人ID',
`task_status` tinyint NOT NULL DEFAULT '0' COMMENT '任务状态',
`task_audit_status` tinyint NOT NULL DEFAULT '0' COMMENT '任务审核状态',
PRIMARY KEY (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10933 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='任务信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `t_white_list`
--
DROP TABLE IF EXISTS `t_white_list`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `t_white_list` (
`white_list_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '白名单对象ID',
`white_list_name` varchar(32) NOT NULL COMMENT '白名单对象名称',
`white_list_system_name` varchar(32) DEFAULT NULL COMMENT '白名单对象系统名称',
`white_list_ip` int unsigned DEFAULT NULL COMMENT '白名单对象IP',
`white_list_url` varchar(255) DEFAULT NULL COMMENT '白名单对象域名',
`white_list_port` smallint unsigned DEFAULT NULL COMMENT '白名单对象端口',
`white_list_audit_status` tinyint NOT NULL COMMENT '白名单对象审核状态',
`white_list_protocol` varchar(32) DEFAULT NULL COMMENT '白名单对象使用协议',
`create_time` datetime DEFAULT NULL,
`modify_time` datetime DEFAULT NULL,
PRIMARY KEY (`white_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7056 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='白名单信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Temporary view structure for view `template_view`
--
DROP TABLE IF EXISTS `template_view`;
/*!50001 DROP VIEW IF EXISTS `template_view`*/;
SET @saved_cs_client = @@character_set_client;
/*!50503 SET character_set_client = utf8mb4 */;
/*!50001 CREATE VIEW `template_view` AS SELECT
1 AS `strategy_template_id`,
1 AS `strategy_template_name`,
1 AS `strategy_template_low_level_id`,
1 AS `strategy_template_medium_level_id`,
1 AS `strategy_template_high_level_id`,
1 AS `strategy_template_used_times`,
1 AS `strategy_template_running_tasks`,
1 AS `low_protect_level_id`,
1 AS `low_has_protect_object_ip`,
1 AS `low_has_protect_object_port`,
1 AS `low_has_peer_ip`,
1 AS `low_has_peer_port`,
1 AS `low_has_protocol`,
1 AS `low_has_url`,
1 AS `low_has_dns`,
1 AS `medium_protect_level_id`,
1 AS `medium_has_protect_object_ip`,
1 AS `medium_has_protect_object_port`,
1 AS `medium_has_peer_ip`,
1 AS `medium_has_peer_port`,
1 AS `medium_has_protocol`,
1 AS `medium_has_url`,
1 AS `medium_has_dns`,
1 AS `high_protect_level_id`,
1 AS `high_has_protect_object_ip`,
1 AS `high_has_protect_object_port`,
1 AS `high_has_peer_ip`,
1 AS `high_has_peer_port`,
1 AS `high_has_protocol`,
1 AS `high_has_url`,
1 AS `high_has_dns`*/;
SET character_set_client = @saved_cs_client;
--
-- Current Database: `realtime_protection`
--
USE `realtime_protection`;
--
-- Final view structure for view `template_view`
--
/*!50001 DROP VIEW IF EXISTS `template_view`*/;
/*!50001 SET @saved_cs_client = @@character_set_client */;
/*!50001 SET @saved_cs_results = @@character_set_results */;
/*!50001 SET @saved_col_connection = @@collation_connection */;
/*!50001 SET character_set_client = utf8mb4 */;
/*!50001 SET character_set_results = utf8mb4 */;
/*!50001 SET collation_connection = utf8mb4_0900_ai_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `template_view` AS select `tst`.`strategy_template_id` AS `strategy_template_id`,`tst`.`strategy_template_name` AS `strategy_template_name`,`tst`.`strategy_template_low_level_id` AS `strategy_template_low_level_id`,`tst`.`strategy_template_medium_level_id` AS `strategy_template_medium_level_id`,`tst`.`strategy_template_high_level_id` AS `strategy_template_high_level_id`,count(distinct `tdr`.`dynamic_rule_id`) AS `strategy_template_used_times`,count(distinct `tt`.`task_id`) AS `strategy_template_running_tasks`,`low_tpl`.`protect_level_id` AS `low_protect_level_id`,`low_tpl`.`has_protect_object_ip` AS `low_has_protect_object_ip`,`low_tpl`.`has_protect_object_port` AS `low_has_protect_object_port`,`low_tpl`.`has_peer_ip` AS `low_has_peer_ip`,`low_tpl`.`has_peer_port` AS `low_has_peer_port`,`low_tpl`.`has_protocol` AS `low_has_protocol`,`low_tpl`.`has_url` AS `low_has_url`,`low_tpl`.`has_dns` AS `low_has_dns`,`medium_tpl`.`protect_level_id` AS `medium_protect_level_id`,`medium_tpl`.`has_protect_object_ip` AS `medium_has_protect_object_ip`,`medium_tpl`.`has_protect_object_port` AS `medium_has_protect_object_port`,`medium_tpl`.`has_peer_ip` AS `medium_has_peer_ip`,`medium_tpl`.`has_peer_port` AS `medium_has_peer_port`,`medium_tpl`.`has_protocol` AS `medium_has_protocol`,`medium_tpl`.`has_url` AS `medium_has_url`,`medium_tpl`.`has_dns` AS `medium_has_dns`,`high_tpl`.`protect_level_id` AS `high_protect_level_id`,`high_tpl`.`has_protect_object_ip` AS `high_has_protect_object_ip`,`high_tpl`.`has_protect_object_port` AS `high_has_protect_object_port`,`high_tpl`.`has_peer_ip` AS `high_has_peer_ip`,`high_tpl`.`has_peer_port` AS `high_has_peer_port`,`high_tpl`.`has_protocol` AS `high_has_protocol`,`high_tpl`.`has_url` AS `high_has_url`,`high_tpl`.`has_dns` AS `high_has_dns` from (((((`t_strategy_template` `tst` left join `t_protect_level` `low_tpl` on((`low_tpl`.`protect_level_id` = `tst`.`strategy_template_low_level_id`))) left join `t_protect_level` `medium_tpl` on((`medium_tpl`.`protect_level_id` = `tst`.`strategy_template_medium_level_id`))) left join `t_protect_level` `high_tpl` on((`high_tpl`.`protect_level_id` = `tst`.`strategy_template_high_level_id`))) left join `t_dynamic_rule` `tdr` on((`tdr`.`template_id` = `tst`.`strategy_template_id`))) left join `t_task` `tt` on((`tt`.`task_id` = `tdr`.`dynamic_rule_used_task_id`))) group by `tst`.`strategy_template_id` */;
/*!50001 SET character_set_client = @saved_cs_client */;
/*!50001 SET character_set_results = @saved_cs_results */;
/*!50001 SET collation_connection = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2024-01-23 22:51:22
Reference in New Issue View Git Blame Copy Permalink