Dependencies

• [2] MI4IMCD3
• [3] A6FXZPKE * Another essential index.
• [4] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
• [5] SLWFKMU5 extra indexes
• [6] Z4KRJX4Q * In the last succeeded / job status queries, use the Builds.isCurrent
• [7] KN3VYE5P * Cleaned up the foreign key constraints.
• [8] RAKTHYAI * In the job status and error pages, show when the status of a job
• [*] N22GPKYT * Put info about logs / build products in the DB.

Change contents

• edit in src/sql/hydra.sql at line 430
  [4.1262]

  [4.2984]
  + create index IndexBuildsByFinished on Builds(finished);
• replacement in src/sql/hydra.sql at line 433
  [2.81]→[4.5906:6014](∅→∅),[4.3104]→[4.5906:6014](∅→∅)
  − create index IndexBuild on BuildProducts(build);

  − create index IndexBuildType on BuildProducts(build, type);
  [2.81]

  [3.0]
  + create index IndexBuildProductsByBuild on BuildProducts(build);

  + create index IndexBuildProducstByBuildAndType on BuildProducts(build, type);