-- MySQL dump 9.11
--
-- Host: localhost    Database: hg17
-- ------------------------------------------------------
-- Server version	4.0.24

--
-- Table structure for table `snp125`
--

CREATE TABLE snp125 (
  bin smallint(5) unsigned NOT NULL default '0',
  chrom varchar(15) NOT NULL default '',
  chromStart int(10) unsigned NOT NULL default '0',
  chromEnd int(10) unsigned NOT NULL default '0',
  name varchar(15) NOT NULL default '',
  score smallint(5) unsigned NOT NULL default '0',
  strand enum('?','+','-') NOT NULL default '?',
  refNCBI blob NOT NULL,
  refUCSC blob NOT NULL,
  observed varchar(255) NOT NULL default '',
  molType enum('unknown','genomic','cDNA') NOT NULL default 'unknown',
  class enum('unknown','single','in-del','het','microsatellite','named','no var','mixed','mnp','insertion','deletion') NOT NULL default 'unknown',
  valid set('unknown','by-cluster','by-frequency','by-submitter','by-2hit-2allele','by-hapmap') NOT NULL default 'unknown',
  avHet float NOT NULL default '0',
  avHetSE float NOT NULL default '0',
  func set('unknown','locus','coding','coding-synon','coding-nonsynon','untranslated','intron','splice-site','cds-reference') NOT NULL default 'unknown',
  locType enum('unknown','range','exact','between','rangeInsertion','rangeSubstitution','rangeDeletion') NOT NULL default 'unknown',
  weight int(10) unsigned NOT NULL default '0',
  KEY name (name),
  KEY chrom (chrom,bin)
) ENGINE=MyISAM;
