From 52b61fce22f188e37a88c20740e005ff109637a7 Mon Sep 17 00:00:00 2001
From: hsy <1029150275@qq.com>
Date: 星期一, 17 八月 2026 15:02:27 +0800
Subject: [PATCH] dos: 新增表：mes_pro_task_pause_record

---
 docs/sql/task_pause_record.sql |   20 ++++++++++++++++++++
 1 files changed, 20 insertions(+), 0 deletions(-)

diff --git a/docs/sql/task_pause_record.sql b/docs/sql/task_pause_record.sql
new file mode 100644
index 0000000..927afbb
--- /dev/null
+++ b/docs/sql/task_pause_record.sql
@@ -0,0 +1,20 @@
+CREATE TABLE `mes_pro_task_pause_record` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
+  `task_id` bigint(20) NOT NULL COMMENT '浠诲姟缂栧彿',
+  `work_order_id` bigint(20) DEFAULT NULL COMMENT '宸ュ崟缂栧彿',
+  `workstation_id` bigint(20) DEFAULT NULL COMMENT '宸ヤ綔绔欑紪鍙�',
+  `reason` varchar(255) NOT NULL COMMENT '鍋滃伐鍘熷洜',
+  `pause_time` datetime NOT NULL COMMENT '鍋滃伐鏃堕棿',
+  `pause_user_id` bigint(20) NOT NULL COMMENT '鍋滃伐鎿嶄綔浜篒D',
+  `resume_time` datetime DEFAULT NULL COMMENT '澶嶅伐鏃堕棿',
+  `resume_user_id` bigint(20) DEFAULT NULL COMMENT '澶嶅伐鎿嶄綔浜篒D',
+  `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞',
+  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�',
+  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�',
+  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
+  `tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿',
+  PRIMARY KEY (`id`) USING BTREE,
+  KEY `idx_task_id` (`task_id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鐢熶骇浠诲姟鍋滃伐璁板綍琛�';

--
Gitblit v1.9.3