   PRIMARY KEY (`meta_id`),
   UNIQUE KEY `species_key_value_idx` (`species_id`,`meta_key`,`meta_value`(255)),
   KEY `species_value_idx` (`species_id`,`meta_value`(255))
-) ENGINE=MyISAM DEFAULT CHARSET=latin1  ;
+) ENGINE=MyISAM  ;
 
 CREATE TABLE `method_link` (
   `method_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  `value` mediumtext NOT NULL,
  KEY `node_id_tag` (`node_id`,`tag`),
  KEY `node_id` (`node_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;

CREATE TABLE `gene_tree_root` (
  `root_id` int(10) unsigned NOT NULL,

  KEY `rank` (`rank`),
  KEY `left_index` (`left_index`),
  KEY `right_index` (`right_index`)
) ENGINE=MyISAM ;

CREATE TABLE `ortholog_goc_metric` (
  `method_link_species_set_id` int(11) NOT NULL,
  `homology_id` int(11) NOT NULL,
  `gene_member_id` int(11) NOT NULL,
  `dnafrag_id` int(11) NOT NULL,
  `goc_score` int(11) NOT NULL,
  `left1` int(11) DEFAULT NULL,
  `left2` int(11) DEFAULT NULL,
  `right1` int(11) DEFAULT NULL,
  `right2` int(11) DEFAULT NULL
) ENGINE=MyISAM ;

CREATE TABLE `other_member_sequence` (
  `seq_member_id` int(10) unsigned NOT NULL,
