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

#
# Table structure for table 'stsInfo'
#

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