/* ÕâÀïдÕû¸öϵͳµÄË÷Òý½Å±¾ */





--Ìæ´úÆ· ÎïÁϱàºÅ Ìí¼ÓΨһË÷Òý  [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