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

--
-- Table structure for table `cnpSharp`
--

CREATE TABLE cnpSharp (
  bin smallint(6) 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 '',
  variationType enum('Gain','Loss','Gain and Loss') NOT NULL default 'Gain',
  cytoName varchar(255) NOT NULL default '',
  cytoStrain varchar(255) NOT NULL default '',
  dupPercent float NOT NULL default '0',
  repeatsPercent float NOT NULL default '0',
  LINEpercent float NOT NULL default '0',
  SINEpercent float NOT NULL default '0',
  LTRpercent float NOT NULL default '0',
  DNApercent float NOT NULL default '0',
  diseaseSpotsPercent float NOT NULL default '0',
  KEY chrom (chrom(5),bin),
  KEY name (name(12))
) ENGINE=MyISAM;
