-- MySQL dump 9.11
--
-- Host: localhost    Database: ce4
-- ------------------------------------------------------
-- Server version	4.0.27-standard-log

--
-- Table structure for table `netCaeRem2`
--

CREATE TABLE netCaeRem2 (
  bin smallint(5) unsigned NOT NULL default '0',
  level int(10) unsigned NOT NULL default '0',
  tName varchar(255) NOT NULL default '',
  tStart int(10) unsigned NOT NULL default '0',
  tEnd int(10) unsigned NOT NULL default '0',
  strand char(1) NOT NULL default '',
  qName varchar(255) NOT NULL default '',
  qStart int(10) unsigned NOT NULL default '0',
  qEnd int(10) unsigned NOT NULL default '0',
  chainId int(10) unsigned NOT NULL default '0',
  ali int(10) unsigned NOT NULL default '0',
  score double NOT NULL default '0',
  qOver int(11) NOT NULL default '0',
  qFar int(11) NOT NULL default '0',
  qDup int(11) NOT NULL default '0',
  type varchar(255) NOT NULL default '',
  tN int(11) NOT NULL default '0',
  qN int(11) NOT NULL default '0',
  tR int(11) NOT NULL default '0',
  qR int(11) NOT NULL default '0',
  tNewR int(11) NOT NULL default '0',
  qNewR int(11) NOT NULL default '0',
  tOldR int(11) NOT NULL default '0',
  qOldR int(11) NOT NULL default '0',
  tTrf int(11) NOT NULL default '0',
  qTrf int(11) NOT NULL default '0',
  KEY tName (tName(16),bin),
  KEY tName_2 (tName(16),tStart)
) TYPE=MyISAM;
