From 3ff6604c75c887f4056ee03545d204bc9323286c Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 15 十月 2026 17:47:19 +0800
Subject: [PATCH] feat(mes): 新增报工设备快照功能并优化状态校验
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/yudao-module-mes/src/test/resources/sql/create_tables.sql b/yudao-module-mes/src/test/resources/sql/create_tables.sql
index 780ff99..50fe66d 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -202,6 +202,7 @@
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
"vendor_id" bigint DEFAULT NULL,
+ "vendor_name" varchar(255) DEFAULT NULL,
"vendor_batch" varchar(64) DEFAULT NULL,
"item_id" bigint DEFAULT NULL,
"received_quantity" decimal(24,6) DEFAULT NULL,
@@ -277,6 +278,9 @@
-- MES 鐢熶骇鎶ュ伐
-- ----------------------------
CREATE TABLE IF NOT EXISTS "mes_pro_feedback" (
+ "machinery_ids" varchar(2048) DEFAULT NULL,
+ "process_instance_id" varchar(64) DEFAULT NULL,
+ "process_definition_key" varchar(255) DEFAULT NULL,
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
"code" varchar(64) DEFAULT NULL,
"type" tinyint DEFAULT NULL,
@@ -393,7 +397,7 @@
"source_doc_id" bigint DEFAULT NULL,
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
- "client_id" bigint NOT NULL,
+ "client_id" bigint DEFAULT NULL,
"batch_code" varchar(64) DEFAULT NULL,
"item_id" bigint NOT NULL,
"min_check_quantity" int DEFAULT 1,
--
Gitblit v1.9.3