   external_db_id              SMALLINT UNSIGNED,
   hcoverage                   DOUBLE,
   external_data               TEXT, 
+  pair_dna_align_feature_id   INT(10) UNSIGNED,
 
   PRIMARY KEY (dna_align_feature_id),
   KEY seq_region_idx (seq_region_id, analysis_id, seq_region_start, score),
   KEY seq_region_idx_2 (seq_region_id, seq_region_start),
   KEY hit_idx (hit_name),
   KEY analysis_idx (analysis_id),
-  KEY external_db_idx (external_db_id)
+  KEY external_db_idx (external_db_id),
+  KEY pair_idx (pair_dna_align_feature_id)
 
 ) COLLATE=latin1_swedish_ci TYPE=MyISAM MAX_ROWS=100000000 AVG_ROW_LENGTH=80;
 

CREATE TABLE dna (

  seq_region_id       INT(10) UNSIGNED NOT NULL,
  sequence            MEDIUMTEXT NOT NULL,

  PRIMARY KEY (seq_region_id)


   dbprimary_acc              VARCHAR(40) NOT NULL,
   display_label              VARCHAR(128) NOT NULL,
   version                    VARCHAR(10) DEFAULT '0' NOT NULL,
   description                TEXT,
   info_type                  ENUM( 'PROJECTION', 'MISC', 'DEPENDENT',
                                    'DIRECT', 'SEQUENCE_MATCH',
                                    'INFERRED_PAIR', 'PROBE',
