
CREATE TABLE hapmapAllelesSummary (
  bin int(10) unsigned NOT NULL default '0',
  chrom varchar(255) NOT NULL default '',
  chromStart int(10) unsigned 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',
  strand varchar(255) NOT NULL default '',
  observed varchar(255) NOT NULL default '',
  allele1 varchar(255) NOT NULL default '',
  allele2 varchar(255) NOT NULL default '',
  popCount int(10) unsigned NOT NULL default '0',
  isMixed varchar(255) NOT NULL default '',
  majorAlleleCEU varchar(255) NOT NULL default '',
  majorAlleleCountCEU int(10) unsigned NOT NULL default '0',
  totalAlleleCountCEU int(10) unsigned NOT NULL default '0',
  majorAlleleCHB varchar(255) NOT NULL default '',
  majorAlleleCountCHB int(10) unsigned NOT NULL default '0',
  totalAlleleCountCHB int(10) unsigned NOT NULL default '0',
  majorAlleleJPT varchar(255) NOT NULL default '',
  majorAlleleCountJPT int(10) unsigned NOT NULL default '0',
  totalAlleleCountJPT int(10) unsigned NOT NULL default '0',
  majorAlleleYRI varchar(255) NOT NULL default '',
  majorAlleleCountYRI int(10) unsigned NOT NULL default '0',
  totalAlleleCountYRI int(10) unsigned NOT NULL default '0',
  chimpAllele varchar(255) NOT NULL default '',
  chimpAlleleQuality int(10) unsigned NOT NULL default '0',
  macaqueAllele varchar(255) NOT NULL default '',
  macaqueAlleleQuality int(10) unsigned NOT NULL default '0',
  KEY name (name),
  KEY chrom (chrom,bin)
) TYPE=MyISAM;

