From c215f6c20445b973ff730dcdf4206426992da81d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 19 十月 2026 11:30:57 +0800
Subject: [PATCH] feat(mes): 完善质检流程功能
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 13 +++++++++++++
1 files changed, 13 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..1e8d1c7 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -413,6 +413,7 @@
"inspect_date" timestamp DEFAULT NULL,
"inspector_user_id" bigint DEFAULT NULL,
"status" tinyint NOT NULL DEFAULT 0,
+ "workflow_status" tinyint NOT NULL DEFAULT 0,
"remark" varchar(500) DEFAULT '',
"creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -423,6 +424,18 @@
PRIMARY KEY ("id")
);
+CREATE TABLE IF NOT EXISTS "mes_qc_oqc_action" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "oqc_id" bigint NOT NULL,
+ "action" varchar(32) NOT NULL,
+ "result" tinyint DEFAULT NULL,
+ "opinion" varchar(500) DEFAULT NULL,
+ "quantities_json" varchar(4000) DEFAULT NULL,
+ "operator_id" bigint DEFAULT NULL,
+ "create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY ("id")
+);
+
-- ----------------------------
-- MES 閫�璐ф楠屽崟锛圧QC锛�
-- ----------------------------
--
Gitblit v1.9.3