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

--
-- Table structure for table `encodeRna`
--

CREATE TABLE encodeRna (
  bin int(10) unsigned NOT NULL default '0',
  chrom varchar(255) NOT NULL default '',
  chromStart int(10) unsigned NOT NULL default '0',
  chromEnd int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  score int(10) unsigned NOT NULL default '0',
  strand char(1) NOT NULL default '',
  source varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  fullScore float NOT NULL default '0',
  isPsuedo int(10) unsigned NOT NULL default '0',
  isRmasked int(10) unsigned NOT NULL default '0',
  isTranscribed int(10) unsigned NOT NULL default '0',
  isPrediction int(10) unsigned NOT NULL default '0',
  transcribedIn blob NOT NULL,
  KEY chrom (chrom(6),bin),
  KEY chrom_2 (chrom(6),chromStart),
  KEY chrom_3 (chrom(6),chromEnd),
  KEY name (name)
) ENGINE=MyISAM;
