CREATE TABLE `protein_info` (
  `protein` int(11) unsigned NOT NULL,
  `seqid` varchar(100) NOT NULL DEFAULT '',
  `gene_name` text,
  `gene_desc` text,
  PRIMARY KEY (`protein`,`seqid`),
  FULLTEXT KEY `gene_name_fulltext` (`gene_name`),
  FULLTEXT KEY `gene_desc_fulltext` (`gene_desc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
