From e60607fbdc127d7c622f2a20fb15fd9b04b0faac Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 16 十月 2026 14:53:46 +0800
Subject: [PATCH] fix(system): 岗位导入补充必填校验，修复编码为空时的「系统异常」
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 5 +++++
1 files changed, 5 insertions(+), 0 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 203b99a..a766f59 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -543,10 +543,15 @@
"name" varchar(255) DEFAULT NULL,
"iqc_id" bigint DEFAULT NULL,
"notice_id" bigint DEFAULT NULL,
+ "notice_code" varchar(64) DEFAULT NULL,
"vendor_id" bigint DEFAULT NULL,
+ "vendor_name" varchar(128) DEFAULT NULL,
"purchase_order_code" varchar(64) DEFAULT NULL,
+ "purchase_order_id" bigint DEFAULT NULL,
"receipt_date" timestamp DEFAULT NULL,
"status" tinyint NOT NULL DEFAULT 0,
+ "process_instance_id" varchar(64) DEFAULT NULL,
+ "process_definition_key" varchar(64) DEFAULT NULL,
"remark" varchar(500) DEFAULT NULL,
"creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
--
Gitblit v1.9.3