From 298e948226a6773c5432f490f68c671af80dfc16 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 14 十月 2026 09:29:28 +0800
Subject: [PATCH] feat(crm-invoice): 新增开票Excel批量导入功能
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 10 ++++++----
1 files changed, 6 insertions(+), 4 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 fd73613..716210e 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -242,10 +242,7 @@
"source_doc_id" bigint DEFAULT NULL,
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
- "work_order_id" bigint DEFAULT NULL,
- "task_id" bigint DEFAULT NULL,
- "workstation_id" bigint DEFAULT NULL,
- "process_id" bigint DEFAULT NULL,
+ "batch_code" varchar(100) DEFAULT NULL,
"item_id" bigint DEFAULT NULL,
"check_quantity" decimal(14,2) DEFAULT NULL,
"qualified_quantity" decimal(14,2) DEFAULT NULL,
@@ -263,6 +260,11 @@
"inspect_date" timestamp DEFAULT NULL,
"inspector_user_id" bigint DEFAULT NULL,
"status" tinyint DEFAULT NULL,
+ "sampling_location" varchar(255) DEFAULT NULL,
+ "certificate_no" varchar(100) DEFAULT NULL,
+ "execute_standard" varchar(100) DEFAULT NULL,
+ "audit_user_id" bigint DEFAULT NULL,
+ "approve_user_id" bigint DEFAULT NULL,
"remark" varchar(500) DEFAULT NULL,
"creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
--
Gitblit v1.9.3