grahamc/hydra2 - Change E2TOU3L66CH5DA4XPATQM5YM63SFXX63V7SDOIGS4ND3GR7HQALAC

* More indices.

Created by Eelco Dolstra on February 11, 2010

E2TOU3L66CH5DA4XPATQM5YM63SFXX63V7SDOIGS4ND3GR7HQALAC

Dependencies

In channels

main

Change contents

Insertion in src/sql/hydra.sql at line 432 [3.1]

[2.2524]

create index IndexBuildStepsOnDrvpathTypeBusyStatus on BuildSteps(drvpath, type, busy, status);
create index IndexBuildStepsOnOutpath on BuildSteps(outpath);

Replacement in src/sql/hydra.sql at line 442 [3.1]

B:BD[2.3040] → [2.3040:3114]

create index IndexJobsetAltsOnJobset on JobsetInputAlts(project, jobset);

[2.3040]

[4.8636]

create index IndexCachedGitInputsOnHash on CachedGitInputs(uri, branch, sha256hash);
create index IndexCachedGitInputsOnLastSeen on CachedGitInputs(uri, branch, lastSeen);
create index IndexCachedSubversionInputsOnUriRevision on CachedSubversionInputs(uri, revision);
create index IndexJobsetInputAltsOnInput on JobsetInputAlts(project, jobset, input);
create index IndexJobsetInputAltsOnJobset on JobsetInputAlts(project, jobset);
create index IndexProjectsOnEnabled on Projects(enabled);