path: root/sql/mysql-2024-1-23.sql

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