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

#
# Table structure for table 'cpgIsland'
#
CREATE TABLE cpgIsland (
  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,
  length int(10) unsigned DEFAULT '0' NOT NULL,
  cpgNum int(10) unsigned DEFAULT '0' NOT NULL,
  gcNum int(10) unsigned DEFAULT '0' NOT NULL,
  perCpg float(10,2) DEFAULT '0.00' NOT NULL,
  perGc float(10,2) DEFAULT '0.00' NOT NULL,
  KEY chrom (chrom(12),chromStart),
  KEY chrom_2 (chrom(12),chromEnd)
);
