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

#
# Table structure for table 'clonePos'
#
CREATE TABLE clonePos (
  name varchar(255) DEFAULT '' NOT NULL,
  seqSize int(10) unsigned DEFAULT '0' NOT NULL,
  phase tinyint(3) unsigned DEFAULT '0' NOT NULL,
  chrom varchar(255) DEFAULT '' NOT NULL,
  chromStart int(10) unsigned DEFAULT '0' NOT NULL,
  chromEnd int(10) unsigned DEFAULT '0' NOT NULL,
  stage char(1) DEFAULT '' NOT NULL,
  faFile varchar(255) DEFAULT '' NOT NULL,
  PRIMARY KEY (name(12)),
  KEY chrom (chrom(12),chromStart),
  KEY chrom_2 (chrom(12),chromEnd)
);
