From 9baffa8a8a5c9fbdda690544132b95db9196cc88 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 16 12月 2024 15:22:08 +0800
Subject: [PATCH] 22
---
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