-- MySQL dump 9.11
--
-- Host: localhost    Database: mm4
-- ------------------------------------------------------
-- Server version	4.0.21

--
-- Table structure for table `gbSeq`
--

CREATE TABLE gbSeq (
  id int(10) unsigned NOT NULL default '0',
  acc char(12) NOT NULL default '',
  version smallint(5) unsigned NOT NULL default '0',
  size int(10) unsigned NOT NULL default '0',
  gbExtFile int(10) unsigned NOT NULL default '0',
  file_offset bigint(20) NOT NULL default '0',
  file_size int(10) unsigned NOT NULL default '0',
  type enum('EST','mRNA','PEP') NOT NULL default 'EST',
  srcDb enum('GenBank','RefSeq','Other') NOT NULL default 'GenBank',
  PRIMARY KEY  (id),
  UNIQUE KEY acc (acc),
  KEY typeSrcDbAcc2 (type,srcDb,acc(2)),
  KEY gbExtFile (gbExtFile)
) ENGINE=MyISAM;
