From c9c91ad3e3ac218d81c86809c93a35622b51a686 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周三, 17 9月 2025 16:05:05 +0800
Subject: [PATCH] 初步 增加 推送线程
---
DBScript/01_DDL/01_DDL_TABLE_WGQ.sql | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/DBScript/01_DDL/01_DDL_TABLE_WGQ.sql b/DBScript/01_DDL/01_DDL_TABLE_WGQ.sql
new file mode 100644
index 0000000..cd418ff
--- /dev/null
+++ b/DBScript/01_DDL/01_DDL_TABLE_WGQ.sql
@@ -0,0 +1,43 @@
+use WGQ_WB19011_CORE
+go
+
+/*==============================================================*/
+/* Table: Wms_outInStockRecord_V2_Mes */
+/* Description: 鍑哄叆搴撹褰�(涓烘帹閫丮ES) */
+/* Author:shaocx */
+/* CreateTime:2025-09-17 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Wms_outInStockRecord_V2_Mes') AND TYPE = 'U')
+create table Wms_outInStockRecord_V2_Mes(
+ ID int IDENTITY(1,1) NOT NULL, -- 涓婚敭
+
+ OutInFlagName VARCHAR(10) ,--- 鍑哄叆搴撶被鍨� 1 鍏ュ簱 2 鍑哄簱
+
+ ListNo NVARCHAR(128) NULL , -- 鍑哄叆鍗曞彿
+ Code NVARCHAR(128) NULL , -- 鍨嬫潗鍞竴缂栫爜
+ Name NVARCHAR(128) NULL , -- 鐗╂枡鍚嶇О
+
+ SerialNo NVARCHAR(128) NULL , -- 鍒嗘鍙�
+ IssueProjectNo NVARCHAR(128) NULL , -- 鍙戞斁宸ョ▼鍙�
+
+ PlaceCode VARCHAR(100) NULL , -- 搴撲綅缂栫爜
+ OccurrenceTime datetime NULL , -- 鍙戠敓鏃堕棿
+
+
+ IsSendToMes int NULL , -- 鎺ㄩ�佺姸鎬�
+ IsSendToMesStr VARCHAR(100) NULL , -- 鎺ㄩ�佺姸鎬�
+ SendToMesCount int NULL , -- 鎺ㄧ粰MES娆℃暟
+ SendToMesTime datetime null, -- 鎺ㄧ粰MES鏃堕棿
+ MesRet NVARCHAR(128) NULL , -- MES杩斿洖缁撴灉
+
+
+ Remark NVARCHAR(128) NULL , -- 澶囨敞
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null, -- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Wms_outInStockRecord_V2_Mes primary key (ID)
+)
+GO
+
--
Gitblit v1.9.3