changed hive.process_id to varchar[40] to handle extended syntax for lsf job arrays (e.g. 72344[3]). Also changed analysis_job index (analysis_id, status) so that the analysis_id is indexed first which provides better indexing when only the analysis_id is specified.
changed hive.process_id to varchar[40] to handle extended syntax for
lsf job arrays (e.g. 72344[3]).
Also changed analysis_job index (analysis_id, status) so that the
analysis_id is indexed first which provides better indexing when only
the analysis_id is specified.

Ensembl/ensembl-hive,Ensembl/ensembl-hive,Ensembl/ensembl-hive,Ensembl/ensembl-hive