From ed9b0c0b150e295e9a5db053882019a3a64ec299 Mon Sep 17 00:00:00 2001
From: payne <bzrlw2012@163.com>
Date: 周四, 25 4月 2024 19:02:49 +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