From b29d86d9ed34fd890eb14cb7a75f6ae4f7148865 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 01 九月 2026 13:58:03 +0800
Subject: [PATCH] feat(mes): 新增防伪防窜货功能模块
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 98 +++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 98 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 fd73613..a6ef868 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -830,3 +830,101 @@
"tenant_id" bigint NOT NULL DEFAULT 0,
PRIMARY KEY ("id")
);
+
+-- ----------------------------
+-- MES 娑堣垂鑰呮壂鐮佽闂簨浠�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_trace_consumer_scan_event" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "trace_code" varchar(255) NOT NULL,
+ "normalized_code" varchar(128) DEFAULT NULL,
+ "source_type" varchar(32) DEFAULT NULL,
+ "channel" varchar(32) DEFAULT NULL,
+ "province" varchar(64) DEFAULT NULL,
+ "city" varchar(64) DEFAULT NULL,
+ "batch_id" bigint DEFAULT NULL,
+ "success" bit NOT NULL DEFAULT FALSE,
+ "error_code" varchar(64) DEFAULT NULL,
+ "ip_hash" varchar(64) DEFAULT NULL,
+ "user_agent_hash" varchar(64) DEFAULT NULL,
+ "event_time" timestamp NOT 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 闃茬獪璐ц鍒欓厤缃�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_trace_anti_config" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "config_key" varchar(64) DEFAULT NULL,
+ "config_value" varchar(255) DEFAULT NULL,
+ "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,
+ PRIMARY KEY ("id")
+);
+
+-- ----------------------------
+-- MES 绐滆揣棰勮璁板綍
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_trace_cross_region_warning" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "warning_no" varchar(64) DEFAULT NULL,
+ "bag_code_id" bigint DEFAULT NULL,
+ "bag_code" varchar(64) DEFAULT NULL,
+ "pallet_code_id" bigint DEFAULT NULL,
+ "pallet_code" varchar(64) DEFAULT NULL,
+ "batch_id" bigint DEFAULT NULL,
+ "batch_code" varchar(64) DEFAULT NULL,
+ "item_id" bigint DEFAULT NULL,
+ "item_code" varchar(64) DEFAULT NULL,
+ "item_name" varchar(128) DEFAULT NULL,
+ "sales_id" bigint DEFAULT NULL,
+ "sales_code" varchar(64) DEFAULT NULL,
+ "client_id" bigint DEFAULT NULL,
+ "client_name" varchar(128) DEFAULT NULL,
+ "dealer_province" varchar(64) DEFAULT NULL,
+ "dealer_city" varchar(64) DEFAULT NULL,
+ "scan_province" varchar(64) DEFAULT NULL,
+ "scan_city" varchar(64) DEFAULT NULL,
+ "warning_type" varchar(32) DEFAULT NULL,
+ "scan_event_id" bigint DEFAULT NULL,
+ "status" tinyint NOT NULL DEFAULT 10,
+ "handle_user_id" bigint DEFAULT NULL,
+ "handle_time" timestamp DEFAULT NULL,
+ "handle_remark" varchar(255) DEFAULT NULL,
+ "event_time" timestamp NOT 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,
+ PRIMARY KEY ("id")
+);
+
+-- ----------------------------
+-- MES 鏁版嵁瀹屾暣鎬ф牎楠岃褰�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_trace_integrity_record" (
+ "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
+ "biz_type" varchar(32) NOT NULL,
+ "biz_id" bigint NOT NULL,
+ "biz_code" varchar(64) DEFAULT NULL,
+ "content_hash" varchar(64) NOT NULL,
+ "event_time" timestamp NOT 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,
+ PRIMARY KEY ("id")
+);
--
Gitblit v1.9.3