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

#
# Table structure for table 'simpleRepeat'
#
CREATE TABLE simpleRepeat (
  chrom varchar(255) DEFAULT '' NOT NULL,
  chromStart int(10) unsigned DEFAULT '0' NOT NULL,
  chromEnd int(10) unsigned DEFAULT '0' NOT NULL,
  name varchar(255) DEFAULT '' NOT NULL,
  period int(10) unsigned DEFAULT '0' NOT NULL,
  copyNum float(10,2) DEFAULT '0.00' NOT NULL,
  consensusSize int(10) unsigned DEFAULT '0' NOT NULL,
  perMatch int(10) unsigned DEFAULT '0' NOT NULL,
  perIndel int(10) unsigned DEFAULT '0' NOT NULL,
  score int(10) unsigned DEFAULT '0' NOT NULL,
  A int(10) unsigned DEFAULT '0' NOT NULL,
  C int(10) unsigned DEFAULT '0' NOT NULL,
  T int(10) unsigned DEFAULT '0' NOT NULL,
  G int(10) unsigned DEFAULT '0' NOT NULL,
  entropy float(10,2) DEFAULT '0.00' NOT NULL,
  sequence longblob NOT NULL,
  KEY chrom (chrom(12),chromStart),
  KEY chrom_2 (chrom(12),chromEnd)
);
