ALTER TABLE `visitors`
  DROP INDEX `uq_visitors_id_fingerprint`,
  ADD UNIQUE KEY `uq_visitors_id_fingerprint_ip` (`visitor_id`, `fingerprint`, `last_ip`);