ALTER TABLE `patient_infos` ADD Unique index patient_i_t(institution_id,temp_patient_id); alter table studies engine=innodb; ALTER TABLE `studies` ADD Unique index studies_ss(studyuid,patient_id,modality); alter table series engine=innodb; ALTER TABLE `series` ADD Unique index studies_ss(study_id,seriesuid); alter table images engine=innodb; ALTER TABLE `images` ADD Unique index images_s_i(series_id,image_id);