   modified_at   DATETIME,
 
   PRIMARY KEY (analysis_web_data_id),
-  UNIQUE INDEX uniq_idx (species_id, db_type, analysis_description_id)
+  UNIQUE INDEX uniq_idx (species_id, db_type, analysis_description_id),
+  INDEX ad_idx (analysis_description_id),
+  INDEX wd_idx (web_data_id)
 );
 
 -- The 'web_data' table.

  web_data_id               INTEGER UNSIGNED DEFAULT NULL,
  species_id                INTEGER UNSIGNED NOT NULL,

  db_type                   SET('cdna', 'core', 'funcgen',
                                'otherfeatures', 'rnaseq', 'vega')
                            NOT NULL DEFAULT 'core',

  displayable               BOOLEAN NOT NULL DEFAULT true,

  taxon           VARCHAR(20),
  species_prefix  VARCHAR(20),
  is_current      BOOLEAN NOT NULL DEFAULT true,
  attrib_type_id  SMALLINT(5) UNSIGNED DEFAULT NULL,

  -- Columns for the web interface:
  created_by    INTEGER,
