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

#
# Table structure for table 'stsInfo'
#
CREATE TABLE stsInfo (
  identNo int(10) unsigned DEFAULT '0' NOT NULL,
  name varchar(255) DEFAULT '' NOT NULL,
  gbCount int(10) unsigned DEFAULT '0' NOT NULL,
  genbank longblob,
  gdbCount int(10) unsigned DEFAULT '0' NOT NULL,
  gdb longblob,
  nameCount int(10) unsigned DEFAULT '0' NOT NULL,
  otherNames longblob,
  dbSTSid int(10) unsigned DEFAULT '0' NOT NULL,
  otherDbstsCount int(10) unsigned DEFAULT '0' NOT NULL,
  otherDbSTS longblob,
  leftPrimer varchar(255),
  rightPrimer varchar(255),
  distance varchar(255),
  organism varchar(255) DEFAULT '' NOT NULL,
  sequence int(10) unsigned DEFAULT '0' NOT NULL,
  otherUCSCcount int(10) unsigned DEFAULT '0' NOT NULL,
  otherUCSC longblob,
  mergeUCSCcount int(10) unsigned DEFAULT '0' NOT NULL,
  mergeUCSC longblob,
  genethonName varchar(255),
  genethonChr varchar(255),
  genethonPos float(10,2) DEFAULT '0.00' NOT NULL,
  genethonLOD float(10,2) DEFAULT '0.00' NOT NULL,
  marshfieldName varchar(255),
  marshfieldChr varchar(255),
  marshfieldPos float(10,2) DEFAULT '0.00' NOT NULL,
  marshfieldLOD float(10,2) DEFAULT '0.00' NOT NULL,
  wiyacName varchar(255),
  wiyacChr varchar(255),
  wiyacPos float(10,2) DEFAULT '0.00' NOT NULL,
  wiyacLOD float(10,2) DEFAULT '0.00' NOT NULL,
  wirhName varchar(255),
  wirhChr varchar(255),
  wirhPos float(10,2) DEFAULT '0.00' NOT NULL,
  wirhLOD float(10,2) DEFAULT '0.00' NOT NULL,
  gm99gb4Name varchar(255),
  gm99gb4Chr varchar(255),
  gm99gb4Pos float(10,2) DEFAULT '0.00' NOT NULL,
  gm99gb4LOD float(10,2) DEFAULT '0.00' NOT NULL,
  gm99g3Name varchar(255),
  gm99g3Chr varchar(255),
  gm99g3Pos float(10,2) DEFAULT '0.00' NOT NULL,
  gm99g3LOD float(10,2) DEFAULT '0.00' NOT NULL,
  tngName varchar(255),
  tngChr varchar(255),
  tngPos float(10,2) DEFAULT '0.00' NOT NULL,
  tngLOD float(10,2) DEFAULT '0.00' NOT NULL,
  PRIMARY KEY (identNo)
);
