Files
be.ems/database/upgrade/monitor_warn.sql
2023-08-17 18:30:50 +08:00

35 lines
1.3 KiB
SQL

/*
Navicat Premium Data Transfer
Source Server : 192.168.0.229
Source Server Type : MySQL
Source Server Version : 100335
Source Host : 192.168.0.229:33066
Source Schema : omc_db
Target Server Type : MySQL
Target Server Version : 100335
File Encoding : 65001
Date: 17/08/2023 18:25:09
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for monitor_warn
-- ----------------------------
DROP TABLE IF EXISTS `monitor_warn`;
CREATE TABLE `monitor_warn` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型标题',
`warn_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '告警类型',
`value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阈值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '监控_指标阈值告警' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;