ALTER TABLE vehicles
ADD UNIQUE INDEX uq_vehicles_vin_active (vin, _uq_is_active),
ADD UNIQUE INDEX uq_vehicles_oem_vin_active (oem_id, oem_vin, _uq_is_active),
DROP INDEX IF EXISTS vin,
DROP INDEX IF EXISTS uq_vehicles_oem_id_oem_vin,
ALGORITHM=NOCOPY, LOCK=NONE