CREATE TABLE IF NOT EXISTS SmartCdd (
        orfId     INT(10) unsigned NOT NULL,
        version int(2) unsigned DEFAULT 1,	
        subject     LONGTEXT DEFAULT NULL,
        identity FLOAT unsigned NOT NULL,
        alignLength int(10) unsigned NOT NULL,
	mismatch int(10) unsigned NOT NULL,
	gap int(10) unsigned NOT NULL,
  	qBegin int(10) unsigned NOT NULL,
	qEnd int(10) unsigned NOT NULL, 	 
      	sBegin int(10) unsigned NOT NULL,
	sEnd int(10) unsigned NOT NULL,
	evalue FLOAT NOT NULL,
	score FLOAT NOT NULL,
	sLength int(10) unsigned NOT NULL,
       FOREIGN KEY (orfId, version) REFERENCES ORF (orfId, version) 	
  
 );
