db_init.sql

-- Create databases if they do not exist;
CREATE DATABASE IF NOT EXISTS `codo-admin` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-cmdb` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-flow` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-kerrigan` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-agent-server` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-cnmp` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-notice` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `codo-k2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- Create a user and grant privileges;
CREATE USER IF NOT EXISTS 'codo'@'%' IDENTIFIED WITH mysql_native_password BY 'ss1917';
GRANT ALL PRIVILEGES ON *.* TO 'codo'@'%' WITH GRANT OPTION;

-- Flush privileges;
FLUSH PRIVILEGES;


-- 初始化数据字典;
USE `codo-flow`;

-- 创建 sys_dict_type 表，如果它不存在;
CREATE TABLE IF NOT EXISTS `sys_dict_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `is_lock` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `dict_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `dict_code` (`dict_code`) USING BTREE,
  UNIQUE KEY `ix_sys_dict_type_dict_name` (`dict_name`) USING BTREE,
  KEY `ix_sys_dict_type_dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- 创建 sys_dict_data 表，如果它不存在;
CREATE TABLE IF NOT EXISTS `sys_dict_data` (
  `id` int NOT NULL AUTO_INCREMENT,
  `is_lock` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `update_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `dict_code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pid` int DEFAULT NULL,
  `dict_sort` smallint DEFAULT NULL,
  `dict_label` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dict_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `data_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ix_sys_dict_data_dict_label` (`dict_label`) USING BTREE,
  KEY `ix_sys_dict_data_dict_sort` (`dict_sort`) USING BTREE,
  KEY `ix_sys_dict_data_pid` (`pid`) USING BTREE,
  KEY `ix_sys_dict_data_dict_code` (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- 检查并插入 sys_dict_type;
INSERT IGNORE INTO`sys_dict_type` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `dict_name`, `dict_type`)
SELECT 1, 'n', '0', '流程类型', 'admin', '', '2023-03-15 16:48:10', '2023-03-15 16:48:10', 'FLOW_TYPE', '流程类型', 'list'
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_type` WHERE `dict_code` = 'FLOW_TYPE');

INSERT IGNORE INTO`sys_dict_type` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `dict_name`, `dict_type`)
SELECT 2, 'n', '0', '常用任务使用', 'admin', '', '2023-03-16 09:56:28', '2023-03-16 09:56:28', 'TASK_TYPE', '任务类型', 'list'
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_type` WHERE `dict_code` = 'TASK_TYPE');

-- 检查并插入 sys_dict_data;
INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 1, 'n', '0', '事件', 'admin', '', '2023-03-15 16:48:38', '2023-03-15 16:48:38', 'FLOW_TYPE', 1, 0, '事件', 'event', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'FLOW_TYPE' AND `dict_value` = 'event');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 2, 'n', '0', '请求', 'admin', '', '2023-03-16 09:53:36', '2023-03-16 09:53:36', 'FLOW_TYPE', 1, 0, '请求', 'request', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'FLOW_TYPE' AND `dict_value` = 'request');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 3, 'n', '0', '发布', 'admin', '', '2023-03-16 09:54:57', '2023-03-16 09:54:57', 'FLOW_TYPE', 1, 0, '发布', 'publish', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'FLOW_TYPE' AND `dict_value` = 'publish');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 4, 'n', '0', '监控', 'admin', '', '2023-03-16 09:55:24', '2023-03-16 09:55:24', 'FLOW_TYPE', 1, 0, '监控', 'monitor', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'FLOW_TYPE' AND `dict_value` = 'monitor');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 5, 'n', '0', '服务端', 'admin', '', '2023-03-16 09:56:56', '2023-03-16 09:56:56', 'TASK_TYPE', 2, 0, '服务端', 'server', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'TASK_TYPE' AND `dict_value` = 'server');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 6, 'n', '0', '客户端', 'admin', '', '2023-03-16 09:57:17', '2023-03-16 09:57:17', 'TASK_TYPE', 2, 0, '客户端', 'client', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'TASK_TYPE' AND `dict_value` = 'client');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 7, 'n', '0', '运维任务', 'admin', '', '2023-03-16 09:57:55', '2023-03-16 09:57:55', 'TASK_TYPE', 2, 0, '运维任务', 'ops', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'TASK_TYPE' AND `dict_value` = 'ops');

INSERT IGNORE INTO`sys_dict_data` (`id`, `is_lock`, `status`, `remark`, `created_by`, `update_by`, `create_time`, `update_time`, `dict_code`, `pid`, `dict_sort`, `dict_label`, `dict_value`, `data_type`, `css_class`, `list_class`)
SELECT 8, 'n', '0', '打包构建', 'admin', '', '2023-06-07 17:44:21', '2023-06-07 17:44:21', 'FLOW_TYPE', 1, 0, '构建', 'build', 'string', '', ''
WHERE NOT EXISTS (SELECT 1 FROM `sys_dict_data` WHERE `dict_code` = 'FLOW_TYPE' AND `dict_value` = 'build');


-- cnmp

use codo-cnmp;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for audit_log
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `audit_log`
(
    `id`             bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `username`       varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '操作用户名',
    `client_ip`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '客户端IP',
    `module`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '模块',
    `cluster`        varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '集群名称',
    `namespace`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL DEFAULT '' COMMENT '命名空间',
    `resource_type`  varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '对象类型',
    `resource_name`  varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '对象名称',
    `action`         varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL COMMENT '操作类型',
    `request_path`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求路径',
    `request_body`   text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '请求内容',
    `response_body`  text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '响应内容',
    `status`         tinyint(4) NOT NULL DEFAULT 0 COMMENT '操作状态 0:成功 1:失败',
    `duration`       varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci   NOT NULL DEFAULT '0' COMMENT '操作耗时(ms)',
    `operation_time` timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
    `created_at`     timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at`     timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted_at`     timestamp NULL DEFAULT NULL COMMENT '删除时间',
    `trace_id`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'traceID',
    PRIMARY KEY (`id`) USING BTREE,
    INDEX            `idx_username`(`username`) USING BTREE,
    INDEX            `idx_cluster`(`cluster`) USING BTREE,
    INDEX            `idx_operation_time`(`operation_time`) USING BTREE,
    INDEX            `idx_resource`(`resource_type`, `resource_name`) USING BTREE,
    INDEX            `idx_request_path`(`request_path`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '操作审计日志表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for cluster
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `cluster`
(
    `id`             bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at`     datetime(3) NULL DEFAULT NULL,
    `updated_at`     datetime(3) NULL DEFAULT NULL,
    `deleted_at`     datetime(3) NULL DEFAULT NULL,
    `name`           varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `description`    text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `import_type`    tinyint(4) NULL DEFAULT NULL,
    `import_detail`  longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `status`         tinyint(4) NULL DEFAULT NULL,
    `server_version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `platform`       varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `build_date`     varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `ext_info`       longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `node_state`     tinyint(4) NULL DEFAULT NULL,
    `health_state`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `cpu_usage`      decimal(10, 2) NULL DEFAULT NULL,
    `memory_usage`   decimal(10, 2) NULL DEFAULT NULL,
    `cpu_total`      decimal(10, 2) NULL DEFAULT NULL,
    `memory_total`   decimal(10, 2) NULL DEFAULT NULL,
    `node_count`     tinyint(3) UNSIGNED NULL DEFAULT NULL,
    `cluster_state`  tinyint(4) NULL DEFAULT NULL,
    `uid`            varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci  NOT NULL,
    `idip`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `app_id`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `app_secret`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `ops`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `dst_agent_id`   bigint(20) NULL DEFAULT NULL,
    `connet_type`    tinyint(4) NULL DEFAULT 1,
    `mesh_addr`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `links`          longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX            `idx_codo_cluster_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for game_server
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `game_server`
(
    `id`                  int(11) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
    `entity_num`          int(11) NOT NULL COMMENT '实例对象数',
    `server_name`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '进程ID',
    `online_num`          int(11) NOT NULL COMMENT '在线用户数',
    `lock_entity_status`  tinyint(1) NULL DEFAULT 0 COMMENT 'entity锁定状态',
    `lock_lb_status`      tinyint(1) NULL DEFAULT 0 COMMENT 'lb锁定状态',
    `server_type`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '进程类型',
    `server`              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '进程名称',
    `cluster_name`        varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '集群名',
    `namespace`           varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '命名空间',
    `pod`                 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'pod名称',
    `server_version`      varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '服务版本',
    `code_version_game`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '游戏代码版本',
    `code_version_config` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置代码版本',
    `created_at`          datetime(3) NULL DEFAULT NULL COMMENT '创建时间',
    `updated_at`          datetime(3) NULL DEFAULT NULL COMMENT '更新时间',
    `deleted_at`          datetime(3) NULL DEFAULT NULL COMMENT '删除时间',
    `code_version_script` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `workload`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作负载',
    `workload_type`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作负载类型',
    `server_type_desc`    varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进程类型中文名',
    `big_area`            varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '大区编号 ',
    `game_app_id`         varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '游戏应用编号',
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `idx_unique`(`cluster_name`, `namespace`, `pod`) USING BTREE,
    INDEX                 `idx_server_name`(`server_name`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '游戏服务器实体表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for node
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `node`
(
    `id`                 int(11) NOT NULL AUTO_INCREMENT,
    `name`               varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `conditions`         longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `capacity`           longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `allocatable`        longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `addresses`          longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `creation_timestamp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at`         datetime(3) NULL DEFAULT NULL,
    `updated_at`         datetime(3) NULL DEFAULT NULL,
    `deleted_at`         datetime(3) NULL DEFAULT NULL,
    `cluster_id`         bigint(20) UNSIGNED NULL DEFAULT NULL,
    `cpu_usage`          decimal(10, 2) NULL DEFAULT NULL,
    `memory_usage`       decimal(10, 2) NULL DEFAULT NULL,
    `status`             tinyint(4) NULL DEFAULT NULL,
    `labels`             longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `annotations`        longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `node_info`          longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `roles`              varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `uid`                varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `resource_version`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `health_state`       varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `spec`               longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX                `cluster_id`(`cluster_id`) USING BTREE,
    CONSTRAINT `node_ibfk_1` FOREIGN KEY (`cluster_id`) REFERENCES `cluster` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for proxy_agent
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `proxy_agent`
(
    `id`         bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at` datetime(3) NULL DEFAULT NULL,
    `updated_at` datetime(3) NULL DEFAULT NULL,
    `deleted_at` datetime(3) NULL DEFAULT NULL,
    `name`       varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `agent_id`   varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX        `idx_role_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for role
-- ----------------------------
CREATE TABLE  IF NOT EXiSTS `role`
(
    `id`          bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at`  datetime(3) NULL DEFAULT NULL,
    `updated_at`  datetime(3) NULL DEFAULT NULL,
    `deleted_at`  datetime(3) NULL DEFAULT NULL,
    `name`        varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `role_type`   tinyint(4) NOT NULL,
    `is_default`  tinyint(1) NOT NULL DEFAULT 0,
    `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `yaml`        text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `update_by`   varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX         `idx_role_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for role_binding
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `role_binding`
(
    `id`            bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at`    datetime(3) NULL DEFAULT NULL,
    `updated_at`    datetime(3) NULL DEFAULT NULL,
    `deleted_at`    datetime(3) NULL DEFAULT NULL,
    `user_group_id` bigint(20) UNSIGNED NOT NULL,
    `cluster_id`    bigint(20) UNSIGNED NOT NULL,
    `role_id`       bigint(20) UNSIGNED NOT NULL,
    `namespace`     varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `idx_user_group_cluster_role_namespace`(`user_group_id`, `cluster_id`, `role_id`, `namespace`, `deleted_at`) USING BTREE,
    INDEX           `idx_role_binding_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user
-- ----------------------------
CREATE TABLE  IF NOT EXiSTS `user`
(
    `id`         bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at` datetime(3) NULL DEFAULT NULL,
    `updated_at` datetime(3) NULL DEFAULT NULL,
    `deleted_at` datetime(3) NULL DEFAULT NULL,
    `username`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `nickname`   varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `user_id`    bigint(20) UNSIGNED NOT NULL,
    `email`      varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `source`     varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `uid_user_id`(`user_id`) USING BTREE,
    INDEX        `idx_user_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_follow
-- ----------------------------
CREATE TABLE  IF NOT EXiSTS `user_follow`
(
    `id`           bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `user_id`      bigint(20) UNSIGNED NOT NULL COMMENT '用户ID',
    `follow_type`  tinyint(4) NOT NULL COMMENT '关注类型',
    `follow_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '关注对象',
    `created_at`   timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `updated_at`   timestamp                                                     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `deleted_at`   timestamp NULL DEFAULT NULL COMMENT '删除时间',
    `cluster_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `uk_user_type`(`user_id`, `follow_type`, `follow_value`, `deleted_at`, `cluster_name`) USING BTREE,
    INDEX          `idx_user_id`(`user_id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户关注表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for user_group
-- ----------------------------
CREATE TABLE  IF NOT EXiSTS `user_group`
(
    `id`            bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at`    datetime(3) NULL DEFAULT NULL,
    `updated_at`    datetime(3) NULL DEFAULT NULL,
    `deleted_at`    datetime(3) NULL DEFAULT NULL,
    `name`          varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_group_id` bigint(20) UNSIGNED NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `uid_user_group_id`(`user_group_id`) USING BTREE,
    INDEX           `idx_user_group_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for user_user_group_rel
-- ----------------------------
CREATE TABLE IF NOT EXiSTS `user_user_group_rel`
(
    `id`            bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `created_at`    datetime(3) NULL DEFAULT NULL,
    `updated_at`    datetime(3) NULL DEFAULT NULL,
    `deleted_at`    datetime(3) NULL DEFAULT NULL,
    `user_id`       bigint(20) UNSIGNED NOT NULL,
    `user_group_id` bigint(20) UNSIGNED NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `uid_user_user_group`(`user_id`, `user_group_id`) USING BTREE,
    INDEX           `idx_user_user_group_rel_deleted_at`(`deleted_at`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

SET
FOREIGN_KEY_CHECKS = 1;


-- cnmp


-- notice

use `codo-notice`;
CREATE TABLE IF NOT EXISTS `codo_audit` (
                              `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                              `created_at` datetime(3) DEFAULT NULL,
                              `updated_at` datetime(3) DEFAULT NULL,
                              `deleted_at` datetime(3) DEFAULT NULL,
                              `created_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `updated_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `resource_type` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `resource_name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `resource_target` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                              `action` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
                              `status` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 'success',
                              `detail` mediumtext COLLATE utf8mb4_unicode_ci,
                              PRIMARY KEY (`id`),
                              KEY `idx_type` (`resource_type`),
                              KEY `idx_action` (`action`),
                              KEY `idx_codo_audit_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `codo_channel` (
                                `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                `created_at` datetime(3) DEFAULT NULL,
                                `updated_at` datetime(3) DEFAULT NULL,
                                `deleted_at` datetime(3) DEFAULT NULL,
                                `created_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                `updated_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                `name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                `use` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
                                `user` longtext COLLATE utf8mb4_unicode_ci,
                                `group` longtext COLLATE utf8mb4_unicode_ci,
                                `contact_points` mediumtext COLLATE utf8mb4_unicode_ci,
                                `custom_items` mediumtext COLLATE utf8mb4_unicode_ci,
                                `default_rule` longtext COLLATE utf8mb4_unicode_ci,
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `uni_codo_channel_name` (`name`),
                                KEY `idx_codo_channel_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `codo_router` (
                               `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                               `created_at` datetime(3) DEFAULT NULL,
                               `updated_at` datetime(3) DEFAULT NULL,
                               `deleted_at` datetime(3) DEFAULT NULL,
                               `created_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                               `updated_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                               `name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                               `description` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                               `status` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 'yes',
                               `channel_id` int DEFAULT '0',
                               `condition` mediumtext COLLATE utf8mb4_unicode_ci,
                               PRIMARY KEY (`id`),
                               UNIQUE KEY `uni_codo_router_name` (`name`),
                               KEY `idx_codo_router_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `codo_template` (
                                 `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                                 `created_at` datetime(3) DEFAULT NULL,
                                 `updated_at` datetime(3) DEFAULT NULL,
                                 `deleted_at` datetime(3) DEFAULT NULL,
                                 `created_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `updated_by` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                                 `name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
                                 `content` text COLLATE utf8mb4_unicode_ci,
                                 `type` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
                                 `use` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
                                 `default` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT 'no',
                                 PRIMARY KEY (`id`),
                                 UNIQUE KEY `uni_codo_template_name` (`name`),
                                 KEY `idx_codo_template_deleted_at` (`deleted_at`),
                                 KEY `idx_name` (`name`),
                                 KEY `idx_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `codo_user` (
                             `id` bigint unsigned NOT NULL AUTO_INCREMENT,
                             `created_at` datetime(3) DEFAULT NULL,
                             `updated_at` datetime(3) DEFAULT NULL,
                             `deleted_at` datetime(3) DEFAULT NULL,
                             `username` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `nickname` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `user_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `dep_id` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `dep` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `manager` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `avatar` varchar(1024) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `active` tinyint(1) DEFAULT '1',
                             `tel` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `email` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `data_source` mediumtext COLLATE utf8mb4_unicode_ci,
                             `disable` tinyint(1) DEFAULT '0',
                             `dd_id` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             `fs_id` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `uni_codo_user_user_id` (`user_id`),
                             KEY `idx_codo_user_deleted_at` (`deleted_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`) VALUES (1,'2022-07-29 18:00:00.000','2022-07-29 19:59:59.000',NULL,'admin(管理员)','admin(管理员)','阿里云短信默认模版','alydx','default','yes','{{.title}}, {{.description}}');
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`) VALUES (2,'2022-07-29 18:00:00.000','2022-07-29 19:59:58.000',NULL,'admin(管理员)','admin(管理员)','阿里云电话默认模版','alydh','default','yes','{{.title}}, {{.description}}');
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`) VALUES (3,'2022-07-29 18:00:00.000','2022-07-29 19:59:57.000',NULL,'admin(管理员)','admin(管理员)','腾讯云短信默认模版','txdx','default','yes','{\"msg\":\"{{.message}}\"}');
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`) VALUES (4,'2022-07-29 18:00:00.000','2022-07-29 19:59:56.000',NULL,'admin(管理员)','admin(管理员)','腾讯云电话默认模版','txdh','default','yes','{\"msg\":\"{{.message}}\"}');
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (5,'2022-07-29 18:00:00.000','2022-07-29 19:59:55.000',NULL,'admin(管理员)','admin(管理员)','邮件默认模版','email','default','yes',
        '{{if .message}}
        <h3>{{.message}}</h3>
        {{else}}
        <h3>未成功获取message信息</h3>
        {{end}}
        <img src=codo-notice.png />'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (6,'2022-07-29 18:00:00.000','2022-07-29 19:59:54.000',NULL,'admin(管理员)','admin(管理员)','飞书机器人默认模版','fs','default','yes',
        '{{if .message}}
        {{.message}}
        {{else}}
        未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (7,'2022-07-29 18:00:00.000','2022-07-29 19:59:53.000',NULL,'admin(管理员)','admin(管理员)','飞书应用默认模版','fsapp','default','yes',
        '{{if .message}}
        {{.message}}
        {{else}}
        未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (8,'2022-07-29 18:00:00.000','2022-07-29 19:59:52.000',NULL,'admin(管理员)','admin(管理员)','钉钉机器人默认模版','dd','default','yes',
        '{{if .message}}
        ### {{.message}}
        {{else}}
        ### 未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (9,'2022-07-29 18:00:00.000','2022-07-29 19:59:51.000',NULL,'admin(管理员)','admin(管理员)','钉钉应用默认模版','ddapp','default','yes',
        '{{if .message}}
        ### {{.message}}
        {{else}}
        ### 未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (10,'2022-07-29 18:00:00.000','2022-07-29 19:59:50.000',NULL,'admin(管理员)','admin(管理员)','企业微信默认模版','wx','grafana','yes',
        '{{if .message}}
        ### {{.message}}
        {{else}}
        ### 未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (11,'2022-07-29 18:00:00.000','2022-07-29 19:59:49.000',NULL,'admin(管理员)','admin(管理员)','企业微信应用默认模版','wxapp','default','yes',
        '{{if .message}}
        ### {{.message}}
        {{else}}
        ### 未成功获取message信息
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`) VALUES (12,'2022-07-29 18:00:00.000','2022-07-29 19:59:48.000',NULL,'admin(管理员)','admin(管理员)','Webhook默认模版','webhook','default','yes','{\"message\":\"{{.message}}\"}');
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (13,'2022-07-29 18:00:00.000','2022-07-29 19:59:47.000',NULL,'admin(管理员)','admin(管理员)','飞书机器人Prometheus','fs','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        **[Prometheus恢复信息]({{$v.generatorURL}})**
        *[{{$v.labels.alertname}}]({{$var}})*
        告警级别：{{$v.labels.level}}
        开始时间：{{timeFormat $v.startsAt}}
        结束时间：{{timeFormat $v.endsAt}}
        故障主机IP：{{$v.labels.instance}}
        **{{$v.annotations.description}}**
        {{else}}
        **[Prometheus告警信息]({{$v.generatorURL}})**
        *[{{$v.labels.alertname}}]({{$var}})*
        告警级别：{{$v.labels.level}}
        开始时间：{{timeFormat $v.startsAt}}
        结束时间：{{timeFormat $v.endsAt}}
        故障主机IP：{{$v.labels.instance}}
        **{{$v.annotations.description}}**
        {{end}}
        {{end}}
        {{ $urimsg := "xxx" }}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg = print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (14,'2022-07-29 18:00:00.000','2022-07-29 19:59:46.000',NULL,'admin(管理员)','admin(管理员)','飞书机器人Grafana','fs','grafana','yes',
        '{{if eq .state "ok"}}
        **[Grafana恢复信息]({{.ruleUrl}})**
        *{{.ruleName}}*
        告警级别：严重
        开始时间：{{nowLocal}}
        **{{.message}}**
        {{else}}
        **[Grafana告警信息]({{.ruleUrl}})**
        *{{.ruleName}}*
        告警级别：严重
        开始时间：{{nowLocal}}
        **{{.message}}**
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (15,'2022-07-29 18:00:00.000','2022-07-29 19:59:45.000',NULL,'admin(管理员)','admin(管理员)','飞书应用Prometheus','fsapp','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        **[Prometheus恢复信息]({{$v.generatorURL}})**
        *[{{$v.labels.alertname}}]({{$var}})*
        告警级别：{{$v.labels.level}}
        开始时间：{{timeFormat $v.startsAt}}
        结束时间：{{timeFormat $v.endsAt}}
        故障主机IP：{{$v.labels.instance}}
        **{{$v.annotations.description}}**
        {{else}}
        **[Prometheus告警信息]({{$v.generatorURL}})**
        *[{{$v.labels.alertname}}]({{$var}})*
        告警级别：{{$v.labels.level}}
        开始时间：{{timeFormat $v.startsAt}}
        结束时间：{{timeFormat $v.endsAt}}
        故障主机IP：{{$v.labels.instance}}
        **{{$v.annotations.description}}**
        {{end}}
        {{end}}
        {{ $urimsg := "xxx" }}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg = print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (16,'2022-07-29 18:00:00.000','2022-07-29 19:59:44.000',NULL,'admin(管理员)','admin(管理员)','飞书应用Grafana','fsapp','grafana','yes',
        '{{if eq .state "ok"}}
        **[Grafana恢复信息]({{.ruleUrl}})**
        *{{.ruleName}}*
        告警级别：严重
        开始时间：{{nowLocal}}
        **{{.message}}**
        {{else}}
        **[Grafana告警信息]({{.ruleUrl}})**
        *{{.ruleName}}*
        告警级别：严重
        开始时间：{{nowLocal}}
        **{{.message}}**
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (17,'2022-07-29 18:00:00.000','2022-07-29 19:59:43.000',NULL,'admin(管理员)','admin(管理员)','钉钉机器人Prometheus','dd','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        ## [Prometheus恢复信息]({{$v.generatorURL}})
        #### [{{$v.labels.alertname}}]({{$var}})
        ###### 告警级别：{{$v.labels.level}}
        ###### 开始时间：{{timeFormat $v.startsAt}}
        ###### 结束时间：{{timeFormat $v.endsAt}}
        ###### 故障主机IP：{{$v.labels.instance}}
        ##### {{$v.annotations.description}}
        ![Prometheus](codo-notice.png)
        {{else}}
        ## [Prometheus告警信息]({{$v.generatorURL}})
        #### [{{$v.labels.alertname}}]({{$var}})
        ###### 告警级别：{{$v.labels.level}}
        ###### 开始时间：{{timeFormat $v.startsAt}}
        ###### 结束时间：{{timeFormat $v.endsAt}}
        ###### 故障主机IP：{{$v.labels.instance}}
        ##### {{$v.annotations.description}}
        ![Prometheus](codo-notice.png)
        {{end}}
        {{end}}
        {{ $urimsg := "xxx"}}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg =  print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (18,'2022-07-29 18:00:00.000','2022-07-29 19:59:42.000',NULL,'admin(管理员)','admin(管理员)','钉钉机器人Grafana','dd','grafana','yes',
        '{{if eq .state "ok"}}
        ## [Grafana恢复信息]({{.ruleUrl}})
        #### {{.ruleName}}
        ###### 告警级别：严重
        ###### 开始时间：{{nowLocal}}
        ##### {{.message}}
        {{else}}
        ## [Grafana告警信息]({{.ruleUrl}})
        #### {{.ruleName}}
        ###### 告警级别：严重
        ###### 开始时间：{{nowLocal}}
        ##### {{.message}}
        {{end}}
        ![Prometheus](codo-notice.png)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (19,'2022-07-29 18:00:00.000','2022-07-29 19:59:41.000',NULL,'admin(管理员)','admin(管理员)','钉钉应用Prometheus','ddapp','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        ## [Prometheus恢复信息]({{$v.generatorURL}})
        #### [{{$v.labels.alertname}}]({{$var}})
        ###### 告警级别：{{$v.labels.level}}
        ###### 开始时间：{{timeFormat $v.startsAt}}
        ###### 结束时间：{{timeFormat $v.endsAt}}
        ###### 故障主机IP：{{$v.labels.instance}}
        ##### {{$v.annotations.description}}
        ![Prometheus](codo-notice.png)
        {{else}}
        ## [Prometheus告警信息]({{$v.generatorURL}})
        #### [{{$v.labels.alertname}}]({{$var}})
        ###### 告警级别：{{$v.labels.level}}
        ###### 开始时间：{{timeFormat $v.startsAt}}
        ###### 结束时间：{{timeFormat $v.endsAt}}
        ###### 故障主机IP：{{$v.labels.instance}}
        ##### {{$v.annotations.description}}
        ![Prometheus](codo-notice.png)
        {{end}}
        {{end}}
        {{ $urimsg := "xxx"}}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg =  print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (20,'2022-07-29 18:00:00.000','2022-07-29 19:59:40.000',NULL,'admin(管理员)','admin(管理员)','钉钉应用Grafana','ddapp','grafana','yes',
        '{{if eq .state "ok"}}
        ## [Grafana恢复信息]({{.ruleUrl}})
        #### {{.ruleName}}
        ###### 告警级别：严重
        ###### 开始时间：{{nowLocal}}
        ##### {{.message}}
        {{else}}
        ## [Grafana告警信息]({{.ruleUrl}})
        #### {{.ruleName}}
        ###### 告警级别：严重
        ###### 开始时间：{{nowLocal}}
        ##### {{.message}}
        {{end}}
        ![Prometheus](codo-notice.png)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (21,'2022-07-29 18:00:00.000','2022-07-29 19:59:39.000',NULL,'admin(管理员)','admin(管理员)','邮件Prometheus','email','prometheus','yes',
        '{{ $var := .externalURL}}{{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        <h1><a href ={{$v.generatorURL}}>Prometheus恢复信息</a></h1>
        <h2><a href ={{$var}}>{{$v.labels.alertname}}</a></h2>
        <h5>告警级别：{{$v.labels.level}}</h5>
        <h5>开始时间：{{$v.startsAt}}</h5>
        <h5>结束时间：{{$v.endsAt}}</h5>
        <h5>故障主机IP：{{$v.labels.instance}}</h5>
        <h3>{{$v.annotations.description}}</h3>
        <img src=codo-notice.png />
        {{else}}
        <h1><a href ={{$v.generatorURL}}>Prometheus告警信息</a></h1>
        <h2><a href ={{$var}}>{{$v.labels.alertname}}</a></h2>
        <h5>告警级别：{{$v.labels.level}}</h5>
        <h5>开始时间：{{$v.startsAt}}</h5>
        <h5>结束时间：{{$v.endsAt}}</h5>
        <h5>故障主机IP：{{$v.labels.instance}}</h5>
        <h3>{{$v.annotations.description}}</h3>
        <img src=codo-notice.png />
        {{end}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (22,'2022-07-29 18:00:00.000','2022-07-29 19:59:38.000',NULL,'admin(管理员)','admin(管理员)','邮件Grafana','email','grafana','yes',
        '{{if eq .state "ok"}}
        <h1><a href ={{.ruleUrl}}>Grafana恢复信息</a></h1>
        <h2>{{.ruleName}}</h2>
        <h5>告警级别：严重</h5>
        <h5>开始时间：{{nowLocal}}</h5>
        <h3>{{.message}}</h3>
        {{else}}
        <h1><a href ={{.ruleUrl}}>Grafana恢复信息</a></h1>
        <h2>{{.ruleName}}</h2>
        <h5>告警级别：严重</h5>
        <h5>开始时间：{{nowLocal}}</h5>
        <h3>{{.message}}</h3>
        {{end}}
        <img src=codo-notice.png />'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (23,'2022-07-29 18:00:00.000','2022-07-29 19:59:37.000',NULL,'admin(管理员)','admin(管理员)','企业微信Prometheus','wx','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        [PROMETHEUS-恢复信息]({{$v.generatorURL}})
        > **[{{$v.labels.alertname}}]({{$var}})**
        > <font color="info">告警级别:</font> {{$v.labels.level}}
        > <font color="info">开始时间:</font> {{$v.startsAt}}
        > <font color="info">结束时间:</font> {{$v.endsAt}}
        > <font color="info">故障主机IP:</font> {{$v.labels.instance}}
        > <font color="info">**{{$v.annotations.description}}**</font>
        {{else}}
        [PROMETHEUS-告警信息]({{$v.generatorURL}})
        > **[{{$v.labels.alertname}}]({{$var}})**
        > <font color="warning">告警级别:</font> {{$v.labels.level}}
        > <font color="warning">开始时间:</font> {{$v.startsAt}}
        > <font color="warning">结束时间:</font> {{$v.endsAt}}
        > <font color="warning">故障主机IP:</font> {{$v.labels.instance}}
        > <font color="warning">**{{$v.annotations.description}}**</font>
        {{end}}
        {{end}}
        {{ $urimsg:="xxx"}}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg =  print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (24,'2022-07-29 18:00:00.000','2022-07-29 19:59:37.000',NULL,'admin(管理员)','admin(管理员)','企业微信Grafana','wx','grafana','yes',
        '{{if eq .state "ok"}}
        [Grafana恢复信息]({{.ruleUrl}})
        >**{{.ruleName}}**
        >告警级别:严重
        开始时间:{{nowLocal}}
        {{.message}}
        {{else}}
        [Grafana告警信息]({{.ruleUrl}})
        >**{{.ruleName}}**
        >告警级别:严重
        开始时间:{{nowLocal}}
        {{.message}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (25,'2022-07-29 18:00:00.000','2022-07-29 19:59:36.000',NULL,'admin(管理员)','admin(管理员)','企业微信应用Prometheus','wxapp','prometheus','yes',
        '{{ $var := .externalURL}}
        {{ range $k,$v:=.alerts }}
        {{if eq $v.status "resolved"}}
        [PROMETHEUS-恢复信息]({{$v.generatorURL}})
        > **[{{$v.labels.alertname}}]({{$var}})**
        > <font color="info">告警级别:</font> {{$v.labels.level}}
        > <font color="info">开始时间:</font> {{$v.startsAt}}
        > <font color="info">结束时间:</font> {{$v.endsAt}}
        > <font color="info">故障主机IP:</font> {{$v.labels.instance}}
        > <font color="info">**{{$v.annotations.description}}**</font>
        {{else}}
        [PROMETHEUS-告警信息]({{$v.generatorURL}})
        > **[{{$v.labels.alertname}}]({{$var}})**
        > <font color="warning">告警级别:</font> {{$v.labels.level}}
        > <font color="warning">开始时间:</font> {{$v.startsAt}}
        > <font color="warning">结束时间:</font> {{$v.endsAt}}
        > <font color="warning">故障主机IP:</font> {{$v.labels.instance}}
        > <font color="warning">**{{$v.annotations.description}}**</font>
        {{end}}
        {{end}}
        {{ $urimsg:="xxx"}}
        {{ range $key,$value:=.commonLabels }}
        {{$urimsg =  print $urimsg $key "%3D%22" $value "%22%2C" }}
        {{end}}
        [*** 点我屏蔽该告警]({{$var}}/#/silences/new?filter=%7B{{substr 0 3 $urimsg}}%7D)'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (26,'2022-07-29 18:00:00.000','2022-07-29 19:59:35.000',NULL,'admin(管理员)','admin(管理员)','企业微信应用Grafana','wxapp','grafana','yes',
        '{{if eq .state "ok"}}
        [Grafana恢复信息]({{.ruleUrl}})
        >**{{.ruleName}}**
        >告警级别:严重
        开始时间:{{nowLocal}}
        {{.message}}
        {{else}}
        [Grafana告警信息]({{.ruleUrl}})
        >**{{.ruleName}}**
        >告警级别:严重
        开始时间:{{nowLocal}}
        {{.message}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (27,'2022-07-29 18:00:00.000','2022-07-29 19:59:34.000',NULL,'admin(管理员)','admin(管理员)','飞书机器人天枢监控','fs','tianshu','yes',
        '{{if eq .status "resolved"}}
        **【恢复信息】**
        主机IP：{{.address}}{{if .process_name}}
        进程名：{{.process_name}}{{end}}{{if .ps_name}}
        进程名ps：{{.ps_name}}{{end}}{{if .description}}
        告警描述：{{.description}}{{end}}
        告警等级：{{.severity}}
        业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        主机名称：{{.cmdb_host}}
        当前值：{{.value}}
        表达式：{{.expr}}
        类型：{{.classify}}
        来源：{{.source}}{{if .cpu}}
        cpu：{{.cpu}}{{end}}{{if .container}}
        k8s容器：{{.container}}{{end}}{{if .pod}}
        k8s-pod：{{.pod}}{{end}}{{if .namespace}}
        k8s命名空间：{{.namespace}}{{end}}{{if .server_name}}
        服务名：{{.server_name}}{{end}}{{if .instance}}
        实例：{{.instance}}{{end}}
        开始时间：{{timeFormat .starts_at}}
        结束时间：{{timeFormat .ends_at}}
        {{else}}
        **【告警信息】**
        主机IP：{{.address}}{{if .process_name}}
        进程名：{{.process_name}}{{end}}{{if .ps_name}}
        进程名ps：{{.ps_name}}{{end}}{{if .description}}
        告警描述：{{.description}}{{end}}
        告警等级：{{.severity}}
        业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        主机名称：{{.cmdb_host}}
        当前值：{{.value}}
        表达式：{{.expr}}
        类型：{{.classify}}
        来源：{{.source}}{{if .cpu}}
        cpu：{{.cpu}}{{end}}{{if .container}}
        k8s容器：{{.container}}{{end}}{{if .pod}}
        k8s-pod：{{.pod}}{{end}}{{if .namespace}}
        k8s命名空间：{{.namespace}}{{end}}{{if .server_name}}
        服务名：{{.server_name}}{{end}}{{if .instance}}
        实例：{{.instance}}{{end}}
        开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (28,'2022-07-29 18:00:00.000','2022-07-29 19:59:33.000',NULL,'admin(管理员)','admin(管理员)','飞书应用天枢监控','fsapp','tianshu','yes',
        '{{if eq .status "resolved"}}
        **【恢复信息】**
        主机IP：{{.address}}{{if .process_name}}
        进程名：{{.process_name}}{{end}}{{if .ps_name}}
        进程名ps：{{.ps_name}}{{end}}{{if .description}}
        告警描述：{{.description}}{{end}}
        告警等级：{{.severity}}
        业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        主机名称：{{.cmdb_host}}
        当前值：{{.value}}
        表达式：{{.expr}}
        类型：{{.classify}}
        来源：{{.source}}{{if .cpu}}
        cpu：{{.cpu}}{{end}}{{if .container}}
        k8s容器：{{.container}}{{end}}{{if .pod}}
        k8s-pod：{{.pod}}{{end}}{{if .namespace}}
        k8s命名空间：{{.namespace}}{{end}}{{if .server_name}}
        服务名：{{.server_name}}{{end}}{{if .instance}}
        实例：{{.instance}}{{end}}
        开始时间：{{timeFormat .starts_at}}
        结束时间：{{timeFormat .ends_at}}
        {{else}}
        **【告警信息】**
        主机IP：{{.address}}{{if .process_name}}
        进程名：{{.process_name}}{{end}}{{if .ps_name}}
        进程名ps：{{.ps_name}}{{end}}{{if .description}}
        告警描述：{{.description}}{{end}}
        告警等级：{{.severity}}
        业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        主机名称：{{.cmdb_host}}
        当前值：{{.value}}
        表达式：{{.expr}}
        类型：{{.classify}}
        来源：{{.source}}{{if .cpu}}
        cpu：{{.cpu}}{{end}}{{if .container}}
        k8s容器：{{.container}}{{end}}{{if .pod}}
        k8s-pod：{{.pod}}{{end}}{{if .namespace}}
        k8s命名空间：{{.namespace}}{{end}}{{if .server_name}}
        服务名：{{.server_name}}{{end}}{{if .instance}}
        实例：{{.instance}}{{end}}
        开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (29,'2022-07-29 18:00:00.000','2022-07-29 19:59:32.000',NULL,'admin(管理员)','admin(管理员)','钉钉机器人天枢监控','dd','tianshu','yes',
        '{{if eq .status "resolved"}}
        ## 【恢复信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        #### 结束时间：{{timeFormat .ends_at}}
        {{else}}
        ## 【告警信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (30,'2022-07-29 18:00:00.000','2022-07-29 19:59:31.000',NULL,'admin(管理员)','admin(管理员)','钉钉应用天枢监控','ddapp','tianshu','yes',
        '{{if eq .status "resolved"}}
        ## 【恢复信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        #### 结束时间：{{timeFormat .ends_at}}
        {{else}}
        ## 【告警信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (31,'2022-07-29 18:00:00.000','2022-07-29 19:59:30.000',NULL,'admin(管理员)','admin(管理员)','企业微信天枢监控','wx','tianshu','yes',
        '{{if eq .status "resolved"}}
        ## 【恢复信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        #### 结束时间：{{timeFormat .ends_at}}
        {{else}}
        ## 【告警信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (32,'2022-07-29 18:00:00.000','2022-07-29 19:59:29.000',NULL,'admin(管理员)','admin(管理员)','企业微信应用天枢监控','wxapp','tianshu','yes',
        '{{if eq .status "resolved"}}
        ## 【恢复信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        #### 结束时间：{{timeFormat .ends_at}}
        {{else}}
        ## 【告警信息】
        #### 主机IP：{{.address}}
        {{if .description}}#### 告警描述：{{.description}}{{end}}
        #### 告警等级：{{.severity}}
        #### 业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}
        #### 主机名称：{{.cmdb_host}}
        #### 当前值：{{.value}}
        #### 表达式：{{.expr}}
        #### 类型：{{.classify}}
        #### 来源：{{.source}}
        {{if .cpu}}#### cpu：{{.cpu}}{{end}}
        #### 开始时间：{{timeFormat .starts_at}}
        {{end}}'
       );
INSERT IGNORE INTO`codo_template` (`id`,`created_at`,`updated_at`,`deleted_at`,`created_by`,`updated_by`,`name`,`type`,`use`,`default`,`content`)
VALUES (33,'2022-07-29 18:00:00.000','2022-07-29 19:59:28.000',NULL,'admin(管理员)','admin(管理员)','邮件天枢监控','email','tianshu','yes',
        '{{if eq .status "resolved"}}
        <h2>【告警恢复】</h2>
        <h3>主机IP：{{.address}}</h3>
        <ul>
            {{if .description}}<li>告警描述：{{.description}}</li>{{end}}
            <li>告警等级：{{.severity}}</li>
            <li>业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}</li>
            <li>主机名称：{{.cmdb_host}}</li>
            <li>当前值：{{.value}}</li>
            <li>表达式：{{.expr}}</li>
            <li>类型：{{.classify}}</li>
            <li>来源：{{.source}}</li>
            {{if .cpu}}<li>cpu：{{.cpu}}</li>{{end}}
            <li>开始时间：{{timeFormat .starts_at}}</li>
            <li>结束时间：{{timeFormat .ends_at}}</li>
        </ul>
        {{else}}
        <h2>【告警信息】</h2>
        <h3>主机IP：{{.address}}</h3>
        <ul>
            {{if .description}}<li>告警描述：{{.description}}</li>{{end}}
            <li>告警等级：{{.severity}}</li>
            <li>业务拓扑：{{.cmdb_biz}}->{{.cmdb_env}}->{{.cmdb_set}}->{{.cmdb_module}}</li>
            <li>主机名称：{{.cmdb_host}}</li>
            <li>当前值：{{.value}}</li>
            <li>表达式：{{.expr}}</li>
            <li>类型：{{.classify}}</li>
            <li>来源：{{.source}}</li>
            {{if .cpu}}<li>cpu：{{.cpu}}</li>{{end}}
            <li>开始时间：{{timeFormat .starts_at}}</li>
        </ul>
        {{end}}'
       );