dinky0.7.3版本

/* * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for dlink_alert_group -- ---------------------------- DROP TABLE IF EXISTS `dlink_alert_group`; CREATE TABLE `dlink_alert_group` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'alert group name', `tenant_id` int NOT NULL DEFAULT '1' COMMENT 'tenant id', `alert_instance_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Alert instance IDS', `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'note', `enabled` tinyint DEFAULT '1' COMMENT 'is enable', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `dlink_alert_instance_un` (`name`,`tenant_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='Alert group'; -- ---------------------------- -- Table structure for dlink_alert_history -- ---------------------------- DROP TABLE IF EXISTS `dlink_alert_history`; CREATE TABLE `dlink_alert_history` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `tenant_id` int NOT NULL DEFAULT '1' COMMENT 'tenant id', `alert_group_id` int DEFAULT NULL COMMENT 'Alert group ID', `job_instance_id` int DEFAULT NULL COMMENT 'job instance ID', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'alert title', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'content description', `status` int DEFAULT NULL COMMENT 'alert status', `log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'log', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='Alert history'; -- ---------------------------- -- Table structure for dlink_alert_instance -- ---------------------------- DROP TABLE IF EXISTS `dlink_alert_instance`; CREATE TABLE `dlink_alert_instance` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'alert instance name', `tenant_id` int NOT NULL DEFAULT '1' COMMENT 'tenant id', `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'alert instance type such as: DingTalk,Wechat(Webhook,app) Feishu ,email', `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'configuration', `enabled` tinyint DEFAULT '1' COMMENT 'is enable', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `dlink_alert_instance_un` (`name`,`tenant_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='Alert instance'; -- ---------------------------- -- Table structure for dlink_catalogue -- ---------------------------- DROP TABLE IF EXISTS `dlink_catalogue`; CREATE TABLE `dlink_catalogue` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID', `tenant_id` int NOT NULL DEFAULT '1' COMMENT 'tenant id', `task_id` int DEFAULT NULL COMMENT 'Job ID', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Job Name', `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Job Type', `parent_id` int NOT NULL DEFAULT '0' COMMENT 'parent ID', `enabled` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'is enable', `is_leaf` tinyint(1) NOT NULL COMMENT 'is leaf node', `create_time` datetime DEFAULT NULL COMMENT 'create time', `update_time` datetime DEFAULT NULL COMMENT 'update time', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `dlink_catalogue_un` (`name`,`parent_id`,`tenant_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='catalogue'; -- ---------------------------- -- Table structure for dlink_cluster -- ---------------------------- DROP TABLE IF EXISTS `dlink_cluster`; CREATE TABLE `dlink_cluster` ( `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID', `tenant_id` int NOT NULL DEFAULT '1' COMMENT 'tenant id', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'cluster instance name', `alias` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'cluster instance alias', `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'cluster types', `hosts` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'cluster hosts', `job_manager_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Job Manager Host', `version` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'version', `status` int DEFAULT NULL COMMENT 'cluster status', `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'note',