From 09542900534645e28c23f16caa94aa8a2c20cc5b Mon Sep 17 00:00:00 2001
From: payne <bzrlw2012@163.com>
Date: 周五, 03 5月 2024 16:10:02 +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