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