From 68fc1180536b594e085972205116d3c8319edf0f Mon Sep 17 00:00:00 2001
From: dengzedong <dengzedong@email>
Date: 星期五, 11 四月 2025 09:14:20 +0800
Subject: [PATCH] config_code 唯一索引 selectOne("config_code",code,"is_enable",1);
---
iailab-module-model/iailab-module-model-biz/db/mysql.sql | 3 ++-
1 files changed, 2 insertions(+), 1 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 a0a416a..c580a56 100644
--- a/iailab-module-model/iailab-module-model-biz/db/mysql.sql
+++ b/iailab-module-model/iailab-module-model-biz/db/mysql.sql
@@ -1026,5 +1026,6 @@
`adjust_value_rule` varchar(36) DEFAULT NULL COMMENT '调整值计算规则',
`is_enable` tinyint DEFAULT NULL COMMENT '是否启用（0禁用 1启用）',
`create_time` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `config_code` (`config_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='预测结果自动调整配置表';
--
Gitblit v1.9.3