# MySQL dump 7.1
#
# Host: localhost    Database: hg6
#--------------------------------------------------------
# Server version	3.22.32

#
# Table structure for table 'mrna'
#
CREATE TABLE mrna (
  id int(10) unsigned DEFAULT '0' NOT NULL,
  acc char(12) DEFAULT '' NOT NULL,
  type enum('EST','mRNA') DEFAULT 'EST' NOT NULL,
  direction enum('5','3','0') DEFAULT '5' NOT NULL,
  source int(10) unsigned DEFAULT '0' NOT NULL,
  organism int(10) unsigned DEFAULT '0' NOT NULL,
  library int(10) unsigned DEFAULT '0' NOT NULL,
  mrnaClone int(10) unsigned DEFAULT '0' NOT NULL,
  sex int(10) unsigned DEFAULT '0' NOT NULL,
  tissue int(10) unsigned DEFAULT '0' NOT NULL,
  development int(10) unsigned DEFAULT '0' NOT NULL,
  cell int(10) unsigned DEFAULT '0' NOT NULL,
  cds int(10) unsigned DEFAULT '0' NOT NULL,
  keyword int(10) unsigned DEFAULT '0' NOT NULL,
  description int(10) unsigned DEFAULT '0' NOT NULL,
  geneName int(10) unsigned DEFAULT '0' NOT NULL,
  productName int(10) unsigned DEFAULT '0' NOT NULL,
  author int(10) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  UNIQUE acc (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)
);
