changed queries for compatibility with postgresql

Dependencies

• [2] EJFVQ33S * In the job status page and the channels, pick the build with the
• [3] L2E6EVE2 * Merged the Build and Job tables.
• [4] SJN2QPWH * Big speed-up of the job status page and the channel generation (such
• [*] J5UVLXOK * Start of a basic Catalyst web interface.

Change contents

• replacement in src/lib/Hydra/Schema/Builds.pm at line 117
  [3.2536]→[2.0:465](∅→∅)
  − makeSource('JobStatus' . $name, "select * from (select project, jobset, job, system, max(id) id from Builds where finished = 1 $constraint group by project, jobset, job, system) natural join Builds");

  − makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) natural join Builds");
  [3.2536]

  [3.3029]
  + makeSource('JobStatus' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as a natural join Builds");

  + makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as a natural join Builds");