-- MySQL dump 9.11
--
-- Host: localhost    Database: cage_analysis
-- ------------------------------------------------------
-- Server version	4.0.20-log

--
-- Table structure for table `rna_lib_summary`
--

CREATE TABLE rna_lib_summary (
  rna_lib_id varchar(10) NOT NULL default '',
  tissue_id int(11) NOT NULL default '0',
  dev_stage_id varchar(16) NOT NULL default '',
  category_id int(11) NOT NULL default '0',
  short_description varchar(64) NOT NULL default '',
  cage_tags int(11) NOT NULL default '0',
  CTSSs int(11) NOT NULL default '0',
  basic_TSSs int(11) NOT NULL default '0',
  library_TSSs int(11) NOT NULL default '0',
  riken_TSSs int(11) NOT NULL default '0',
  TEs int(11) NOT NULL default '0',
  PRIMARY KEY  (rna_lib_id),
  KEY tissue_id (tissue_id),
  KEY basic_TSSs (basic_TSSs),
  KEY dev_stage_id (dev_stage_id),
  KEY category_id (category_id),
  KEY short_description (short_description),
  KEY CTSSs (CTSSs),
  KEY TEs (TEs),
  KEY library_TSSs (library_TSSs),
  KEY cage_tags (cage_tags),
  KEY riken_TSSs (riken_TSSs)
) TYPE=MyISAM;
