From b698a2085fd090e90abedb1e91266ec496574b29 Mon Sep 17 00:00:00 2001
From: wanshenmean <cathay_xy@163.com>
Date: 星期四, 16 四月 2026 23:31:35 +0800
Subject: [PATCH] 1

---
 Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260416_Dt_SplitTemp.sql |   15 +++++++++++++++
 1 files changed, 15 insertions(+), 0 deletions(-)

diff --git a/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260416_Dt_SplitTemp.sql b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260416_Dt_SplitTemp.sql
new file mode 100644
index 0000000..3a42a53
--- /dev/null
+++ b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260416_Dt_SplitTemp.sql
@@ -0,0 +1,15 @@
+-- 鎷嗙洏涓存椂琛細鐢ㄤ簬鏆傚瓨鎷嗙洏浠诲姟鐢佃姱鍒楄〃锛屼緵鎵归噺纭鏃朵娇鐢�
+IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_SplitTemp]') AND type in (N'U'))
+BEGIN
+    CREATE TABLE [dbo].[Dt_SplitTemp](
+        [Id] [int] IDENTITY(1,1) NOT NULL,
+        [PalletCode] [nvarchar](50) NOT NULL,
+        [SfcList] [nvarchar](max) NOT NULL,
+        [CreateTime] [datetime] NOT NULL DEFAULT GETDATE(),
+        CONSTRAINT [PK_Dt_SplitTemp] PRIMARY KEY CLUSTERED ([Id] ASC)
+    );
+
+    -- 鍞竴绱㈠紩闃叉鍚屼竴鎵樼洏閲嶅鍐欏叆
+    CREATE UNIQUE NONCLUSTERED INDEX [IX_Dt_SplitTemp_PalletCode] ON [dbo].[Dt_SplitTemp]([PalletCode] ASC);
+END
+GO

--
Gitblit v1.9.3