From b06c210f54fae630bbd25849cae7ed39cd550ff9 Mon Sep 17 00:00:00 2001
From: 潘志宝 <979469083@qq.com>
Date: 星期三, 20 十一月 2024 18:10:16 +0800
Subject: [PATCH] 预警配置
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/iailab-module-model/iailab-module-model-biz/db/mysql.sql b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
index 59662c5..649f596 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -236,6 +236,7 @@
create table t_mm_predict_alarm_message
(
id varchar(36) not null,
+ config_id varchar(36) COMMENT '配置ID',
title varchar(36) COMMENT '消息标题',
content varchar(128) COMMENT '消息内容',
alarm_obj varchar(36) COMMENT '监控对象',
@@ -250,6 +251,7 @@
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
primary key (id),
INDEX idx_item_id (item_id),
+ INDEX idx_config_id (config_id),
INDEX idx_alarm_obj (alarm_obj),
INDEX idx_alarm_time (alarm_time)
) engine = innodb
--
Gitblit v1.9.3