[Summary view] [Print] [Text view]

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