-- 添加唯一索引  [Editby liuwq,2024-07-20]
IF EXISTS(select 1 from sysindexes where id=object_id('mes_order_gather') and name='idx_mes_order_gather') 
DROP INDEX idx_mes_order_gather ON mes_order_gather
CREATE UNIQUE INDEX 
idx_mes_order_gather ON mes_order_gather(Info5) 
GO 


IF EXISTS(select 1 from sysindexes where id=object_id('mes_package_gather') and name='idx_mes_package_gather') 
DROP INDEX idx_mes_package_gather ON mes_package_gather
CREATE UNIQUE INDEX 
idx_mes_package_gather ON mes_package_gather(PackageCode) 
GO