-- Make index unique -- ALTER TABLE `redcap_surveys_response` DROP INDEX `participant_record` , ADD UNIQUE `participant_record` ( `participant_id` , `record` );