   FOREIGN KEY (member_id) REFERENCES member(member_id),
   FOREIGN KEY (peptide_member_id) REFERENCES member(member_id),
 
-  UNIQUE homology_member_id (homology_id,member_id),
+  PRIMARY KEY homology_member_id (homology_id,member_id),
   KEY (homology_id),
   KEY (member_id),
   KEY (peptide_member_id)


  FOREIGN KEY (method_link_species_set_id) REFERENCES method_link_species_set(method_link_species_set_id),

  UNIQUE KEY tag_mlss_id (method_link_species_set_id,tag)

) COLLATE=latin1_swedish_ci ENGINE=MyISAM;


  FOREIGN KEY (member_id) REFERENCES member(member_id),

  KEY (member_id),
  PRIMARY KEY subset_member_id (subset_id, member_id)

) COLLATE=latin1_swedish_ci ENGINE=MyISAM;

