From d34ea2a9fc2334d2bf7383cb64562f301ffbda84 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 17 4月 2025 13:09:07 +0800
Subject: [PATCH] 包中只有一块板时，认定为 不齐包 【Editby shaocx,2025-04-01】
---
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