   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.

  modified_at   DATETIME,

  PRIMARY KEY (web_data_id)
);

-- VIEWS

-- Table schema for the production database


-- The 'species' table.
-- Lists the species for which there is a Core database.
