-- MySQL dump 9.11
--
-- Host: localhost    Database: visiGene
-- ------------------------------------------------------
-- Server version	4.0.27-standard-log

--
-- Table structure for table `gene`
--

CREATE TABLE gene (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  locusLink varchar(255) NOT NULL default '',
  refSeq varchar(255) NOT NULL default '',
  genbank varchar(255) NOT NULL default '',
  uniProt varchar(255) NOT NULL default '',
  taxon int(11) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY name (name(8)),
  KEY locusLink (locusLink(8)),
  KEY refSeq (refSeq(10)),
  KEY genbank (genbank(10)),
  KEY uniProt (uniProt(10)),
  KEY taxon (taxon)
) ENGINE=MyISAM;
