Get rid of some obsolete indexes

Dependencies

• [2] P57OYJ4P Index builds on stop time
• [3] LGNML7VJ Don't use a prepared statement for the active build steps query
• [4] 2I2ZX6JB * Make the "latest succeeded" query (used by the "latest" channel)
• [5] 6QRHXIM3 * Speed up the jobset index page. Especially the query to get the
• [6] 34DPX2OR * Create some more indices on tables that have a foreign key reference
• [7] C5W3WZ3Y * Index the Builds table on drvPath to prevent a full table scan
• [8] TFVGX4JS Add an index to speed up the /project/<name> pages
• [9] 5L272QSC Speed up the /jobset overview pages a lot
• [10] P5VJCT6U fix wrong comment
• [11] PT5XCF2N Add another index to speed up the jobstatus page
• [12] RXVJFQ5A Evaluator cleanups
• [13] FANTYCR7 Materialize the number of finished builds
• [14] E2TOU3L6 * More indices.
• [15] O25D52TA initial support for mercurial
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/sql/hydra.sql at line 552
  [3.81]→[3.0:153](∅→∅),[3.83]→[3.0:153](∅→∅),[3.2638]→[3.0:153](∅→∅),[3.153]→[3.2787:2867](∅→∅),[3.703]→[3.2787:2867](∅→∅),[3.2787]→[3.2787:2867](∅→∅)
  − --create index IndexBuildsOnJob on Builds(project, jobset, job);

  − --create index IndexBuildsOnJobAndIsCurrent on Builds(project, jobset, job, isCurrent);

  − create index IndexBuildsOnJobAndSystem on Builds(project, jobset, job, system);
• edit in src/sql/hydra.sql at line 556
  [2.79]→[3.2248:2365](∅→∅),[3.3040]→[3.2248:2365](∅→∅)
  − create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp DESC); -- obsolete?
• edit in src/sql/hydra.sql at line 557
  [3.804]→[3.105:200](∅→∅)
  − create index IndexBuildsOnJobSystemCurrent on Builds(project, jobset, job, system, isCurrent);
• edit in src/sql/hydra.sql at line 571
  [3.3219]→[3.3219:3337](∅→∅)
  − create index IndexMostRecentSuccessfulBuilds on Builds(project, jobset, job, system, finished, buildStatus, id desc);
• file addition: upgrade-29.sql (----------)
  [18.3004]
  + drop index IndexBuildsOnJobAndSystem;

  + drop index IndexBuildsOnJobSystemCurrent;

  + drop index IndexBuildsOnJobsetFinishedTimestamp;

  + drop index IndexMostRecentSuccessfulBuilds;