CREATE TABLE `genome` (
  `genome` char(3) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `name` varchar(150) NOT NULL,
  `include` enum('y','s','1','n','m','p') NOT NULL DEFAULT 'n',
  `excuse` varchar(15) NOT NULL DEFAULT '',
  `domain` enum('E','B','A','P','C','V','-') NOT NULL DEFAULT '-',
  `comment` varchar(255) NOT NULL DEFAULT '',
  `taxonomy` varchar(512) NOT NULL DEFAULT '',
  `taxon_id` mediumint(8) unsigned DEFAULT NULL,
  `download_link` varchar(512) NOT NULL DEFAULT '',
  `download_date` date NOT NULL DEFAULT '1970-01-01',
  `gene_link` varchar(512) NOT NULL DEFAULT '',
  `homepage` varchar(255) NOT NULL DEFAULT '',
  `password` varchar(9) NOT NULL DEFAULT '',
  `parse` varchar(64) NOT NULL DEFAULT '',
  `order1` smallint(5) unsigned DEFAULT NULL,
  `supfam` char(4) DEFAULT '1.73',
  `order2` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`genome`),
  FULLTEXT KEY `genome_text` (`name`,`comment`,`taxonomy`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
