Viewing File: /home/ubuntu/code_review/phabricator/resources/sql/patches/20130423.conpherenceindices.sql

ALTER TABLE {$NAMESPACE}_conpherence.conpherence_participant
  DROP KEY participantPHID,
  ADD KEY unreadCount (participantPHID, participationStatus),
  ADD KEY participationIndex (participantPHID, dateTouched, id);