From fc908c0965ae7579a53eaa76ceb4b5439d325c69 Mon Sep 17 00:00:00 2001 From: 潘志宝 <979469083@qq.com> Date: 星期日, 13 四月 2025 14:10:44 +0800 Subject: [PATCH] 高炉休风 --- ansteel-biz/db/mysql.sql | 9 ++++++--- 1 files changed, 6 insertions(+), 3 deletions(-) diff --git a/ansteel-biz/db/mysql.sql b/ansteel-biz/db/mysql.sql index 01a58b3..a5e08f4 100644 --- a/ansteel-biz/db/mysql.sql +++ b/ansteel-biz/db/mysql.sql @@ -279,7 +279,7 @@ `remark` varchar(50) NULL DEFAULT NULL COMMENT '备注', `sort` int NULL DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE, - UNIQUE INDEX `uk_name` varchar(50) NULL DEFAULT NULL COMMENT '名称' + UNIQUE INDEX `uk_name` (`name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '电力功率因数管控功率因数主表'; -- ---------------------------- @@ -386,7 +386,9 @@ `analy_title` varchar(20) NULL DEFAULT NULL COMMENT '分析标题', `analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期', `analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次', - `analy_content` varchar(20) NULL DEFAULT NULL COMMENT '内容', + `analy_value` varchar(20) NULL DEFAULT NULL COMMENT '分析值', + `analy_content` varchar(100) NULL DEFAULT NULL COMMENT '内容', + `sort` int NULL DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序趋势分析'; @@ -399,6 +401,7 @@ `analy_type` varchar(20) NULL DEFAULT NULL COMMENT '分析类型', `analy_date` varchar(20) NULL DEFAULT NULL COMMENT '分析日期', `analy_class` varchar(20) NULL DEFAULT NULL COMMENT '分析班次', - `analy_content` varchar(20) NULL DEFAULT NULL COMMENT '内容', + `analy_content` varchar(100) NULL DEFAULT NULL COMMENT '内容', + `sort` int NULL DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT '焦化工序指标分析'; -- Gitblit v1.9.3