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

--
-- Table structure for table `gene_summary`
--

CREATE TABLE gene_summary (
  gene_id varchar(49) NOT NULL default '',
  public_id varchar(32) NOT NULL default '',
  public_db_name varchar(16) NOT NULL default '',
  clone_id varchar(10) default '',
  chr_no varchar(6) NOT NULL default '',
  chr_id tinyint(4) NOT NULL default '0',
  strand char(1) NOT NULL default '',
  start_pos int(11) NOT NULL default '0',
  end_pos int(11) NOT NULL default '0',
  locus_link_id int(11) default NULL,
  te_id int(11) NOT NULL default '0',
  PRIMARY KEY  (gene_id),
  KEY public_id (public_id),
  KEY public_db_name (public_db_name),
  KEY clone_id (clone_id),
  KEY chr_no (chr_no),
  KEY chr_id (chr_id),
  KEY strand (strand),
  KEY start_pos (start_pos),
  KEY end_pos (end_pos),
  KEY locus_link_id (locus_link_id),
  KEY te_id (te_id)
) TYPE=MyISAM;
