From f0088fd96c74f68ba912593710dd9271bcee581d Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 23 12月 2024 10:12:32 +0800
Subject: [PATCH] NG处理，pda上增加一键 清理 板件队列（从 269 到bz01的队列数据）
---
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