CREATE TABLE `protein` (
  `genome` char(3) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `seqid` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `protein` int(11) unsigned NOT NULL,
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (`genome`,`seqid`),
  KEY `protein_index` (`protein`),
  FULLTEXT KEY `protein_text` (`seqid`,`comment`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
