-- MySQL dump 9.11
--
-- Host: localhost    Database: dm1
-- ------------------------------------------------------
-- Server version	4.0.21

--
-- Table structure for table `pscreen`
--

CREATE TABLE pscreen (
  bin smallint(5) 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 char(1) NOT NULL default '',
  stockNumber int(10) unsigned NOT NULL default '0',
  geneCount int(10) unsigned NOT NULL default '0',
  geneIds longblob NOT NULL,
  KEY chrom (chrom(8),bin),
  KEY chrom_2 (chrom(8),chromStart),
  KEY name (name(8))
) ENGINE=MyISAM;
