From 0db27b2ea4752d71db98745b76a1805db8f57aaf Mon Sep 17 00:00:00 2001
From: payne <bzrlw2012@163.com>
Date: 周四, 25 4月 2024 16:10:49 +0800
Subject: [PATCH] 修改

---
 DBScript/01_DDL/04_DDL_INDEX.sql |   10 +++++++++-
 1 files changed, 9 insertions(+), 1 deletions(-)

diff --git a/DBScript/01_DDL/04_DDL_INDEX.sql b/DBScript/01_DDL/04_DDL_INDEX.sql
index 707a509..6438f2e 100644
--- a/DBScript/01_DDL/04_DDL_INDEX.sql
+++ b/DBScript/01_DDL/04_DDL_INDEX.sql
@@ -1 +1,9 @@
-/* 这里写整个系统的索引脚本 */
\ No newline at end of file
+/* 这里写整个系统的索引脚本 */
+
+-- 替代品编号创建一个新的唯一索引 update liuwq 2024-04-25
+CREATE UNIQUE INDEX idx_substitute_good_substituteCode
+ON wms_substitute_good (SubstituteCode);
+
+-- 客户编号创建一个新的唯一索引 update liuwq 2024-04-25
+CREATE UNIQUE INDEX idx_base_customer_custCode
+ON base_customer (CustCode);
\ No newline at end of file

--
Gitblit v1.9.3