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