# MySQL dump 8.14
#
# Host: localhost    Database: hg11
#--------------------------------------------------------
# Server version	3.23.41

#
# Table structure for table 'stsMap'
#

CREATE TABLE stsMap (
  chrom varchar(255) NOT NULL default '',
  chromStart int(11) NOT NULL default '0',
  chromEnd int(10) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  score int(10) unsigned NOT NULL default '0',
  identNo int(10) unsigned NOT NULL default '0',
  ctgAcc varchar(255) NOT NULL default '',
  otherAcc varchar(255) NOT NULL default '',
  genethonChrom varchar(255) NOT NULL default '',
  genethonPos float NOT NULL default '0',
  marshfieldChrom varchar(255) NOT NULL default '',
  marshfieldPos float NOT NULL default '0',
  gm99Gb4Chrom varchar(255) NOT NULL default '',
  gm99Gb4Pos float NOT NULL default '0',
  shgcTngChrom varchar(255) NOT NULL default '',
  shgcTngPos float NOT NULL default '0',
  shgcG3Chrom varchar(255) NOT NULL default '',
  shgcG3Pos float NOT NULL default '0',
  wiYacChrom varchar(255) NOT NULL default '',
  wiYacPos float NOT NULL default '0',
  wiRhChrom varchar(255) NOT NULL default '',
  wiRhPos float NOT NULL default '0',
  fishChrom varchar(255) NOT NULL default '',
  beginBand varchar(255) NOT NULL default '',
  endBand varchar(255) NOT NULL default '',
  lab varchar(255) NOT NULL default '',
  KEY name (name),
  KEY chrom (chrom(8),chromStart),
  KEY chrom_2 (chrom(8),chromEnd)
) TYPE=MyISAM;
