From afc3ef31921d5ca812f7db92dfb107e2c25eff4c Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周二, 01 4月 2025 16:41:45 +0800
Subject: [PATCH] 上一次码垛包装号和站点 LastPalletizingData 加上 第几块板和 upi
---
DBScript/01_DDL/04_DDL_INDEX.sql | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/DBScript/01_DDL/04_DDL_INDEX.sql b/DBScript/01_DDL/04_DDL_INDEX.sql
index e69de29..ceab704 100644
--- a/DBScript/01_DDL/04_DDL_INDEX.sql
+++ b/DBScript/01_DDL/04_DDL_INDEX.sql
@@ -0,0 +1,13 @@
+-- 娣诲姞鍞竴绱㈠紩 [Editby liuwq,2024-07-20]
+IF EXISTS(select 1 from sysindexes where id=object_id('mes_order_gather') and name='idx_mes_order_gather')
+DROP INDEX idx_mes_order_gather ON mes_order_gather
+CREATE UNIQUE INDEX
+idx_mes_order_gather ON mes_order_gather(Info5)
+GO
+
+
+IF EXISTS(select 1 from sysindexes where id=object_id('mes_package_gather') and name='idx_mes_package_gather')
+DROP INDEX idx_mes_package_gather ON mes_package_gather
+CREATE UNIQUE INDEX
+idx_mes_package_gather ON mes_package_gather(PackageCode)
+GO
--
Gitblit v1.9.3