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

--
-- Table structure for table `gbStatus`
--

CREATE TABLE gbStatus (
  acc char(12) NOT NULL default '',
  version smallint(5) unsigned NOT NULL default '0',
  modDate date NOT NULL default '0000-00-00',
  type enum('EST','mRNA') NOT NULL default 'EST',
  srcDb enum('GenBank','RefSeq') NOT NULL default 'GenBank',
  orgCat enum('native','xeno') NOT NULL default 'native',
  gbSeq int(10) unsigned NOT NULL default '0',
  numAligns int(10) unsigned NOT NULL default '0',
  seqRelease char(8) NOT NULL default '',
  seqUpdate char(10) NOT NULL default '',
  metaRelease char(8) NOT NULL default '',
  metaUpdate char(10) NOT NULL default '',
  extRelease char(8) NOT NULL default '',
  extUpdate char(10) NOT NULL default '',
  time timestamp(14) NOT NULL,
  PRIMARY KEY  (acc),
  UNIQUE KEY gbSeq (gbSeq),
  UNIQUE KEY acc (acc),
  KEY typeSrcDbAcc2 (type,srcDb,acc(2))
) TYPE=MyISAM;
