From 7d4ee817ca92f1d28a8a292bee5172bd3cbd2c7e Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期三, 28 十月 2026 14:26:10 +0800
Subject: [PATCH] feat(mes): 实现批次绑定托盘和吨袋的分页查询功能
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 19 +++++++++++++++++++
1 files changed, 19 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 a6ef868..53cdbba 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -424,6 +424,25 @@
);
-- ----------------------------
+-- MES 璐ㄦ瀹℃牳浜洪厤缃�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_qc_approver_config" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "qc_type" tinyint NOT NULL,
+ "approve_node" tinyint NOT NULL,
+ "user_id" bigint NOT NULL,
+ "status" tinyint NOT NULL DEFAULT 0,
+ "remark" varchar(255) DEFAULT NULL,
+ "creator" varchar(64) DEFAULT '',
+ "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "updater" varchar(64) DEFAULT '',
+ "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "deleted" bit NOT NULL DEFAULT FALSE,
+ "tenant_id" bigint NOT NULL DEFAULT 0,
+ PRIMARY KEY ("id")
+);
+
+-- ----------------------------
-- MES 閫�璐ф楠屽崟锛圧QC锛�
-- ----------------------------
CREATE TABLE IF NOT EXISTS "mes_qc_rqc" (
--
Gitblit v1.9.3