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

--
-- Table structure for table `specimen`
--

CREATE TABLE specimen (
  id int(11) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  taxon int(11) NOT NULL default '0',
  genotype int(11) NOT NULL default '0',
  bodyPart int(11) NOT NULL default '0',
  sex int(11) NOT NULL default '0',
  age float NOT NULL default '0',
  minAge float NOT NULL default '0',
  maxAge float NOT NULL default '0',
  notes longblob NOT NULL,
  PRIMARY KEY  (id),
  KEY name (name(8)),
  KEY taxon (taxon),
  KEY genotype (genotype),
  KEY bodyPart (bodyPart),
  KEY age (age)
) ENGINE=MyISAM;
