From 4b9662108cbe730dbf72475d78fc61083631c65c Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期五, 06 六月 2025 18:09:21 +0800
Subject: [PATCH] 建议快照 上下限sql

---
 iailab-module-model/iailab-module-model-biz/db/增量SQL/2025.sql |    7 ++++++-
 1 files changed, 6 insertions(+), 1 deletions(-)

diff --git "a/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql" "b/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
index 74b85fe..0d1d6e0 100644
--- "a/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
+++ "b/iailab-module-model/iailab-module-model-biz/db/\345\242\236\351\207\217SQL/2025.sql"
@@ -76,4 +76,9 @@
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='调度建议快照记录表';
 
 ALTER TABLE `t_st_suggest_operation_record`
-    ADD COLUMN `reason` varchar(255) NULL COMMENT '原因' AFTER `operate`;
\ No newline at end of file
+    ADD COLUMN `reason` varchar(255) NULL COMMENT '原因' AFTER `operate`;
+
+alter table t_st_suggest_snapshot_conf_det add column `limit_h` decimal(10,4) DEFAULT NULL COMMENT '上限';
+alter table t_st_suggest_snapshot_conf_det add column `limit_l` decimal(10,4) DEFAULT NULL COMMENT '下限';
+alter table t_st_suggest_snapshot_record add column `limit_h` decimal(10,4) DEFAULT NULL COMMENT '上限';
+alter table t_st_suggest_snapshot_record add column `limit_l` decimal(10,4) DEFAULT NULL COMMENT '下限';
\ No newline at end of file

--
Gitblit v1.9.3