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

#
# Table structure for table 'genomicDups'
#
CREATE TABLE genomicDups (
  bin smallint(5) unsigned DEFAULT '0' NOT NULL,
  chrom varchar(255) DEFAULT '' NOT NULL,
  chromStart int(10) unsigned DEFAULT '0' NOT NULL,
  chromEnd int(10) unsigned DEFAULT '0' NOT NULL,
  name varchar(255) DEFAULT '' NOT NULL,
  score int(10) unsigned DEFAULT '0' NOT NULL,
  strand char(1) DEFAULT '' NOT NULL,
  otherChrom varchar(255) DEFAULT '' NOT NULL,
  otherStart int(10) unsigned DEFAULT '0' NOT NULL,
  otherEnd int(10) unsigned DEFAULT '0' NOT NULL,
  alignB int(10) unsigned DEFAULT '0' NOT NULL,
  matchB int(10) unsigned DEFAULT '0' NOT NULL,
  mismatchB int(10) unsigned DEFAULT '0' NOT NULL,
  fracMatch float(10,2) DEFAULT '0.00' NOT NULL,
  jcK float(10,2) DEFAULT '0.00' NOT NULL,
  KEY chrom (chrom(8),bin),
  KEY chrom_2 (chrom(8),chromStart),
  KEY chrom_3 (chrom(8),chromEnd)
);
