4 lines
268 B
MySQL
4 lines
268 B
MySQL
|
ALTER TABLE edi.deliveryInformation DROP KEY deliveryInformation_UN;
|
||
|
|
ALTER TABLE edi.deliveryInformation ADD CONSTRAINT deliveryInformation_UN
|
||
|
|
UNIQUE KEY (Location, LatestDeliveryDateTime, FirstOrderDateTime, LatestOrderDateTime, supplyResponseID, DeliveryType);
|