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

#
# Table structure for table 'stsMap'
#
CREATE TABLE stsMap (
  chrom varchar(255) DEFAULT '' NOT NULL,
  chromStart int(11) 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,
  identNo int(10) unsigned DEFAULT '0' NOT NULL,
  ctgAcc varchar(255) DEFAULT '' NOT NULL,
  otherAcc varchar(255) DEFAULT '' NOT NULL,
  genethonChrom varchar(255) DEFAULT '' NOT NULL,
  genethonPos float(10,2) DEFAULT '0.00' NOT NULL,
  marshfieldChrom varchar(255) DEFAULT '' NOT NULL,
  marshfieldPos float(10,2) DEFAULT '0.00' NOT NULL,
  gm99Gb4Chrom varchar(255) DEFAULT '' NOT NULL,
  gm99Gb4Pos float(10,2) DEFAULT '0.00' NOT NULL,
  shgcTngChrom varchar(255) DEFAULT '' NOT NULL,
  shgcTngPos float(10,2) DEFAULT '0.00' NOT NULL,
  shgcG3Chrom varchar(255) DEFAULT '' NOT NULL,
  shgcG3Pos float(10,2) DEFAULT '0.00' NOT NULL,
  wiYacChrom varchar(255) DEFAULT '' NOT NULL,
  wiYacPos float(10,2) DEFAULT '0.00' NOT NULL,
  wiRhChrom varchar(255) DEFAULT '' NOT NULL,
  wiRhPos float(10,2) DEFAULT '0.00' NOT NULL,
  fishChrom varchar(255) DEFAULT '' NOT NULL,
  beginBand varchar(255) DEFAULT '' NOT NULL,
  endBand varchar(255) DEFAULT '' NOT NULL,
  lab varchar(255) DEFAULT '' NOT NULL,
  KEY name (name),
  KEY chrom (chrom(8),chromStart),
  KEY chrom_2 (chrom(8),chromEnd)
);
