From 59c915d7e87dabbf1dc8367f49bd6bc75d0aa357 Mon Sep 17 00:00:00 2001
From: liuying <1427574514@qq.com>
Date: 周四, 09 5月 2024 09:47:22 +0800
Subject: [PATCH] 流程图

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

diff --git a/DBScript/01_DDL/04_DDL_INDEX.sql b/DBScript/01_DDL/04_DDL_INDEX.sql
index 707a509..1d462cd 100644
--- a/DBScript/01_DDL/04_DDL_INDEX.sql
+++ b/DBScript/01_DDL/04_DDL_INDEX.sql
@@ -1 +1,13 @@
-/* 这里写整个系统的索引脚本 */
\ 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);
+
+-- 库位编号创建一个新的唯一索引 update liuwq 2024-04-25
+CREATE UNIQUE INDEX idx_wms_place_placeCode
+ON wms_place (PlaceCode);
\ No newline at end of file

--
Gitblit v1.9.3