text: # stsMap.sql was originally generated by the autoSql program, which also 
  # generated stsMap.c and stsMap.h.  This creates the database representation of
  # an object which can be loaded and saved from RAM in a fairly 
  # automatic way.
  
  #STS marker and its position on golden path and various maps
  CREATE TABLE stsMap (
      chrom varchar(255) not null,	# Chromosome or 'unknown'
      chromStart int not null,	# Start position in chrom - negative 1 if unpositioned
      chromEnd int unsigned not null,	# End position in chrom
      name varchar(255) not null,	# Name of STS marker
      score int unsigned not null,	# Score of a marker = 1000 when placed uniquely, else 1500/(#placements) when placed in multiple locations
      identNo int unsigned not null,	# Identification number of STS
      ctgAcc varchar(255) not null,	# Contig accession number
      otherAcc varchar(255) not null,	# Accession number of other contigs that the marker hits
      genethonChrom varchar(255) not null,	# Chromosome (no chr) from Genethon map or 0 if none
      genethonPos float not null,	# Position on Genethon map
      marshfieldChrom varchar(255) not null,	# Chromosome (no chr) from Marshfield map or 0 if none
      marshfieldPos float not null,	# Position on Marshfield map
      gm99Gb4Chrom varchar(255) not null,	# Chromosome (no chr) from GeneMap99 map or 0 if none
      gm99Gb4Pos float not null,	# Position on gm99_bg4 map
      shgcTngChrom varchar(255) not null,	# Chromosome (no chr) from shgc_tng map or 0 if none
      shgcTngPos float not null,	# Position on shgc_tng map
      shgcG3Chrom varchar(255) not null,	# Chromosome (no chr) from Stanford G3 map or 0 if none
      shgcG3Pos float not null,	# Position on shgc_g3 map
      wiYacChrom varchar(255) not null,	# Chromosome (no chr) from Whitehead YAC map or 0 if none
      wiYacPos float not null,	# Position on wi_yac map
      wiRhChrom varchar(255) not null,	# Chromosome (no chr) from Whitehead RH map or 0 if none
      wiRhPos float not null,	# Position on wi_rh map
      fishChrom varchar(255) not null,	# Chromosome (no chr) from FISH map or 0 if none
      beginBand varchar(255) not null,	# Beginning of range of bands on FISH map
      endBand varchar(255) not null,	# End of range of bands on FISH map
      lab varchar(255) not null,	# Laboratory that placed the FISH clone
      decodeChrom varchar(255) not null,	# Chromosome (no chr) from deCODE map or 0 if none
      decodePos float not null,	# Position on deCODE map
                #Indices
      INDEX(name(16)),
      INDEX(chrom(8),chromStart)
  );
  