/* ÕâÀïÐ´Õû¸öÏµÍ³µÄË÷Òý½Å±¾ */





--Ìæ´úÆ· ÎïÁÏ±àºÅ Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_substitute_good') and name='idx_substitute_good_substituteCode') 
DROP INDEX idx_substitute_good_substituteCode ON wms_base_substitute_good
CREATE UNIQUE INDEX 
idx_substitute_good_substituteCode ON wms_base_substitute_good(SubstituteCode) 
GO 


-- ¿âÇø±àºÅ Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_area') and name='idx_wms_area_areaCode') 
DROP INDEX idx_wms_area_areaCode ON wms_base_area
CREATE UNIQUE INDEX 
idx_wms_area_areaCode ON wms_base_area(AreaCode) 
GO 


-- ¿âÎ»±àºÅ Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_place') and name='idx_wms_place_placeCode') 
DROP INDEX idx_wms_place_placeCode ON wms_base_place
CREATE UNIQUE INDEX 
idx_wms_place_placeCode ON wms_base_place(PlaceCode) 
GO 




-- ¿Í»§±àºÅ Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_customer') and name='idx_base_customer_custCode') 
DROP INDEX idx_base_customer_custCode ON wms_base_customer
CREATE UNIQUE INDEX 
idx_base_customer_custCode ON wms_base_customer(CustCode) 
GO 


-- ¿â´æ¸ú×ÙÂë Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_stock_quan') and name='idx_wms_stock_quan_snCode') 
DROP INDEX idx_wms_stock_quan_snCode ON wms_stock_quan
CREATE UNIQUE INDEX 
idx_wms_stock_quan_snCode ON wms_stock_quan(SNCode) 
GO 


-- ¿â´æ¸ú×ÙÂë Ìí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_container') and name='idx_wms_container_containerCode') 
DROP INDEX idx_wms_container_containerCode ON wms_base_container
CREATE UNIQUE INDEX 
idx_wms_container_containerCode ON wms_base_container(ContainerCode) 
GO 


-- ¿âÎ»ºÍÈÝÆ÷¹ØÏµ±í£¬ ÈÝÆ÷±àºÅÌí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_container_place') and name='idx_wms_container_place') 
DROP INDEX idx_wms_container_place ON wms_container_place
CREATE UNIQUE INDEX 
idx_wms_container_place ON wms_container_place(ContainerCode) 
GO 


-- ÎïÁÏÈÝÆ÷ÀàÐÍ¹ØÏµ£¬ ÎïÁÏ±àºÅÌí¼ÓÎ¨Ò»Ë÷Òý  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('wms_base_container_packaging ') and name='idx_wms_base_container_packaging') 
DROP INDEX idx_wms_base_container_packaging ON wms_base_container_packaging 
CREATE UNIQUE INDEX 
idx_wms_base_container_packaging ON wms_base_container_packaging (MaterialCode) 
GO 