   FOREIGN KEY (member_id) REFERENCES member(member_id),
 
   KEY (member_id),
-  UNIQUE subset_member_id (subset_id, member_id)
+  PRIMARY KEY subset_member_id (subset_id, member_id)
 
 ) COLLATE=latin1_swedish_ci ENGINE=MyISAM;
 

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

  UNIQUE (node_id),
  KEY (member_id)

) COLLATE=latin1_swedish_ci ENGINE=MyISAM;

  FOREIGN KEY (member_id) REFERENCES member(member_id),
  FOREIGN KEY (peptide_member_id) REFERENCES member(member_id),

  PRIMARY KEY homology_member_id (homology_id,member_id),
  KEY (homology_id),
  KEY (member_id),
  KEY (peptide_member_id)
