-- MySQL dump 9.11
--
-- Host: localhost    Database: hg16
-- ------------------------------------------------------
-- Server version	4.0.21

--
-- Table structure for table `celeraOverlay`
--

CREATE TABLE celeraOverlay (
  bin smallint(6) 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 '',
  otherChrom varchar(25) NOT NULL default '',
  otherStart int(10) unsigned NOT NULL default '0',
  otherEnd int(10) unsigned NOT NULL default '0',
  orient char(1) NOT NULL default '',
  field1 char(1) NOT NULL default '',
  field2 char(1) NOT NULL default '',
  localId varchar(10) NOT NULL default '',
  parentInfo varchar(25) NOT NULL default '',
  refId varchar(25) NOT NULL default '',
  refStart int(10) unsigned NOT NULL default '0',
  refLength int(10) unsigned NOT NULL default '0',
  refOrient tinyint(4) NOT NULL default '0',
  queryId varchar(25) NOT NULL default '',
  queryStart int(10) unsigned NOT NULL default '0',
  queryLength int(10) unsigned NOT NULL default '0',
  queryOrient tinyint(4) NOT NULL default '0',
  KEY chrom (chrom(8),bin),
  KEY chrom_2 (chrom(8),chromStart),
  KEY chrom_3 (chrom(8),chromEnd),
  KEY name (name(18))
) ENGINE=MyISAM;
