From e76f0739e647fe8a7e0e2618914e2faff554b1b7 Mon Sep 17 00:00:00 2001
From: huang <1532065656@qq.com>
Date: 星期一, 17 十一月 2025 17:33:23 +0800
Subject: [PATCH] 解决冲突

---
 mes-processes/mes-plcSend/src/main/resources/db/migration/V1.0.1__Create_plc_test_task_table.sql |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 deletions(-)

diff --git a/mes-processes/mes-plcSend/src/main/resources/db/migration/V1.0.1__Create_plc_test_task_table.sql b/mes-processes/mes-plcSend/src/main/resources/db/migration/V1.0.1__Create_plc_test_task_table.sql
new file mode 100644
index 0000000..ec2e21a
--- /dev/null
+++ b/mes-processes/mes-plcSend/src/main/resources/db/migration/V1.0.1__Create_plc_test_task_table.sql
@@ -0,0 +1,22 @@
+-- 鍒涘缓PLC娴嬭瘯浠诲姟琛�
+CREATE TABLE IF NOT EXISTS `plc_test_task` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
+  `project_id` varchar(50) NOT NULL COMMENT '鍏宠仈鐨勯」鐩甀D锛堝閿級',
+  `module` varchar(50) NOT NULL COMMENT '妯″潡鍚嶇О',
+  `operation_mode` varchar(20) NOT NULL COMMENT '鎿嶄綔妯″紡锛歁ANUAL|AUTOMATIC',
+  `selected_fields` json COMMENT '閫変腑鐨勫瓧娈靛垪琛紙JSON鏍煎紡锛�',
+  `status` varchar(20) NOT NULL DEFAULT 'PENDING' COMMENT '浠诲姟鐘舵�侊細PENDING|RUNNING|SUCCESS|FAILED|STOPPED',
+  `start_time` datetime COMMENT '浠诲姟寮�濮嬫椂闂�',
+  `end_time` datetime COMMENT '浠诲姟缁撴潫鏃堕棿',
+  `duration` int(11) COMMENT '鑰楁椂锛堟绉掞級',
+  `result` json COMMENT '娴嬭瘯缁撴灉鏁版嵁锛圝SON鏍煎紡锛�',
+  `error_message` varchar(255) COMMENT '閿欒淇℃伅',
+  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  PRIMARY KEY (`id`),
+  KEY `idx_project_id` (`project_id`),
+  KEY `idx_status` (`status`),
+  KEY `idx_created_at` (`created_at`),
+  CONSTRAINT `fk_project_id` FOREIGN KEY (`project_id`) 
+    REFERENCES `plc_address_mapping` (`project_id`) ON DELETE RESTRICT
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='PLC娴嬭瘯浠诲姟琛�';

--
Gitblit v1.8.0