-- 添加唯一索引 [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
|
