-- MySQL dump 9.10
--
-- Host: localhost    Database: mm3
-- ------------------------------------------------------
-- Server version	4.0.18

--
-- Table structure for table `mgcFullStatus`
--

CREATE TABLE mgcFullStatus (
  imageId int(10) unsigned NOT NULL default '0',
  status enum('unpicked','candidate','picked','notBack','noDecision','fullLength','fullLengthShort','incomplete','chimeric','frameShift','contaminated','retainedIntron','mixedWells','noGrowth','noInsert','no5est','microDel','artifact','noPolyATail','cantSequence','inconsistentWithGene') NOT NULL default 'unpicked',
  state enum('unpicked','pending','fullLength','problem') NOT NULL default 'unpicked',
  acc char(12) NOT NULL default '',
  organism char(2) NOT NULL default '',
  KEY imageId (imageId),
  KEY status (status),
  KEY state (state),
  KEY acc (acc),
  KEY organism (organism)
) TYPE=MyISAM;
