-- MySQL dump 9.11
--
-- Host: localhost    Database: hg15
-- ------------------------------------------------------
-- Server version	4.0.24

--
-- Table structure for table `gbCdnaInfo`
--

CREATE TABLE gbCdnaInfo (
  id int(10) unsigned NOT NULL default '0',
  acc char(12) NOT NULL default '',
  version char(12) NOT NULL default '',
  type enum('EST','mRNA') NOT NULL default 'EST',
  direction enum('5','3','0') NOT NULL default '5',
  source int(10) unsigned NOT NULL default '0',
  organism int(10) unsigned NOT NULL default '0',
  library int(10) unsigned NOT NULL default '0',
  mrnaClone int(10) unsigned NOT NULL default '0',
  sex int(10) unsigned NOT NULL default '0',
  tissue int(10) unsigned NOT NULL default '0',
  development int(10) unsigned NOT NULL default '0',
  cell int(10) unsigned NOT NULL default '0',
  cds int(10) unsigned NOT NULL default '0',
  keyword int(10) unsigned NOT NULL default '0',
  description int(10) unsigned NOT NULL default '0',
  geneName int(10) unsigned NOT NULL default '0',
  productName int(10) unsigned NOT NULL default '0',
  author int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  UNIQUE KEY acc (acc,version),
  UNIQUE KEY acc_2 (acc),
  KEY type (type),
  KEY library (library),
  KEY mrnaClone (mrnaClone),
  KEY tissue (tissue),
  KEY development (development),
  KEY cell (cell),
  KEY keyword (keyword),
  KEY description (description),
  KEY geneName (geneName),
  KEY productName (productName),
  KEY author (author)
) ENGINE=MyISAM;
