   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 (family_id) REFERENCES family(family_id),
  FOREIGN KEY (member_id) REFERENCES member(member_id),

  UNIQUE family_member_id (family_id,member_id),
  KEY (family_id),
  KEY (member_id)


  FOREIGN KEY (node_id) REFERENCES gene_tree_node(node_id),
  FOREIGN KEY (member_id) REFERENCES member(member_id),

  PRIMARY KEY (node_id),
  KEY (member_id)

) COLLATE=latin1_swedish_ci ENGINE=MyISAM;
