grahamc/hydra - Change 3E6IP3R3JGH76PNGG7RCADV65KOV24HQXPXNLVVYIQ46AVYJRG3AC

* Add the name of the jobset to ReleaseSetJobs, otherwise we can't

distinguish between jobs with the same name in different jobsets (e.g. "trunk" vs "stdenv-branch" for Nixpkgs).

Renamed the "attrName" field of Builds to "job".
Renamed the "id" field of BuildSteps to "build".

Created by Eelco Dolstra on March 12, 2009

3E6IP3R3JGH76PNGG7RCADV65KOV24HQXPXNLVVYIQ46AVYJRG3AC

Dependencies

In channels

upstream

main

Change contents

Replacement in src/lib/Hydra/Controller/Job.pm at line 29 [2.46]

B:BD[2.714] → [2.714:799]

        $c->stash->{curProject}->builds->search({attrName => $c->stash->{jobName}});

[2.714]

[2.799]

        $c->stash->{curProject}->builds->search({job => $c->stash->{jobName}});

Replacement in src/lib/Hydra/Helper/CatalystUtils.pm at line 52 [6.3469]

B:BD[5.10585] → [5.10585:10684]

    foreach my $job ($builds->search({},
        {group_by => ['project', 'attrname', 'system']}))

[5.10585]

[5.10684]

    foreach my $build ($builds->search({},
        {group_by => ['project', 'job', 'system']}))

Replacement in src/lib/Hydra/Helper/CatalystUtils.pm at line 56 [6.3469]

B:BD[5.10710] → [5.10710:10841]

            { project => $job->get_column('project')
            , attrname => $job->attrname
            , system => $job->system

[5.10710]

[5.10841]

            { project => $build->get_column('project')
            , job => $build->job
            , system => $build->system

Replacement in src/lib/Hydra/Helper/Nix.pm at line 127 [8.436]

B:BD[7.1530] → [7.1530:1587]

        { attrname => $primaryJob->job, finished => 1 },

[7.1530]

[7.1587]

        { job => $primaryJob->job, finished => 1 },

Replacement in src/lib/Hydra/Helper/Nix.pm at line 157 [8.436]

B:BD[7.2478] → [7.2478:2536]

                { attrname => $job->job, finished => 1 },

[7.2478]

[7.2536]

                { job => $job->job, finished => 1 },

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 39 [9.1]

B:BD[9.782] → [4.0:142]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:11XN47b5bRrRKiWtzLO+Pw

[9.782]

[9.924]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CLL7aeJ0fe0NX3LCnNs4/A

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 38 [10.4268]

B:BD[10.4922] → [4.143:285]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gUnxXuaqq40KFRIUSBmVuA

[10.4922]

[10.5064]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9Eer/gLCKlOKfnwC+kfFaw

Replacement in src/lib/Hydra/Schema/BuildResultInfo.pm at line 38 [11.1594]

B:BD[11.2382] → [4.286:428]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xvSDu+FkyKp5wTAEGmiKOw

[11.2382]

[11.2524]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ieF3JOI4N3XZUyMboZhrjg

Replacement in src/lib/Hydra/Schema/BuildResultInfo.pm at line 44 [11.1594]

B:BD[12.668] → [12.668:727]

  { id => "faileddepbuild", stepnr => "faileddepstepnr" },

[12.668]

[12.727]

  { build => "faileddepbuild", stepnr => "faileddepstepnr" },

Replacement in src/lib/Hydra/Schema/BuildSchedulingInfo.pm at line 30 [11.3773]

B:BD[11.4473] → [4.429:571]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xv5P0Erv5oEy4r3c9RuV0w

[11.4473]

[11.4615]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oomDjaTJHIQjraUqhzFPsg

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 11 [13.1675]
B:BD[13.1870] → [13.1870:1878]
```
  "id",
```
[13.1870]
[13.1878]
```
  "build",
```

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 34 [13.1675]

B:BD[13.2688] → [13.2688:2734]

B:BD[13.2734] → [14.2426:2498]

__PACKAGE__->set_primary_key("id", "stepnr");
__PACKAGE__->belongs_to("id", "Hydra::Schema::Builds", { id => "id" });

[13.2688]

[13.2815]

__PACKAGE__->set_primary_key("build", "stepnr");
__PACKAGE__->belongs_to("build", "Hydra::Schema::Builds", { id => "build" });

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 38 [13.1675]

B:BD[13.2959] → [4.572:714]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ne+uSrfxnk+wK60IrVoTww

[13.2959]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+nb1zsYcv9WziZ6IHcc/yw

Replacement in src/lib/Hydra/Schema/Builds.pm at line 21 [10.5202]
B:BD[15.431] → [15.431:445]
```
  "attrname",
```
[15.431]
[16.661]
```
  "job",
```
Replacement in src/lib/Hydra/Schema/Builds.pm at line 60 [10.5202]
∅:D[16.849] → [11.2973:3006]
∅:D[17.1316] → [11.2973:3006]
∅:D[14.1651] → [11.2973:3006]
B:BD[11.2973] → [11.2973:3006]
```
  { "foreign.id" => "self.id" },
```
[17.1316]
[11.3006]
```
  { "foreign.build" => "self.id" },
```

Replacement in src/lib/Hydra/Schema/Builds.pm at line 79 [10.5202]

B:BD[10.6194] → [4.715:857]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iwt05CKHqfd33lW+wAC2mw

[10.6194]

[11.3377]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UahvxjBmn7b70IK+QcnKHA

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 25 [18.859]

B:BD[18.1497] → [4.858:1000]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hjklk18AGqKd7dDPUlqS9A

[18.1497]

[18.1639]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+AZEuCFAfkl7SKwlxDBnaw

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 23 [18.1780]

B:BD[18.2342] → [4.1001:1143]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OMt7YCEd4Vc3edHp2fxcrw

[18.2342]

[18.2484]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2JtWOkH5OVGl7Cb7STLM5Q

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 34 [19.825]

B:BD[19.1831] → [4.1144:1286]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gQOuvSuoR2kczD57yaVSwQ

[19.1831]

[19.1973]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ka/dxG48LaZOQeShZFs0Hw

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 46 [15.590]

B:BD[15.1681] → [4.1287:1429]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GpIp3ENzylBZ9HQUNhO17Q

[15.1681]

[15.1823]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:earsp0XPWppy5/VOJkQ/PA

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 53 [15.1960]

B:BD[15.2992] → [4.1430:1572]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BcAloJiRDPMvL/+GqsPiTw

[15.2992]

[15.3134]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ADLNgkS2YPv4DuszwHau7g

Replacement in src/lib/Hydra/Schema/Projects.pm at line 48 [15.3266]

B:BD[15.3685] → [4.1573:1715]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TTHljyVTOMxXzNATXkltNg

[15.3685]

[15.3827]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R/GeZxDujiuKze++Mc2ZTw

Insertion in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 24 [20.5076]
[20.5728]
[20.5728]
```
  { data_type => "text", is_nullable => 0, size => undef },
  "jobset",
```

Replacement in src/lib/Hydra/Schema/ReleaseSetJobs.pm at line 37 [20.5076]

B:BD[20.6070] → [4.1850:1992]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YC+cgQcuvO4TxC5UpU7u4A

[20.6070]

[20.6212]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OM2joIa3Bj6t9BhVrOjN8Q

Replacement in src/lib/Hydra/Schema/ReleaseSets.pm at line 32 [20.6351]

B:BD[20.7142] → [4.2075:2217]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Sv+5cdtqHDjWM0Zmmu0PSg

[20.7142]

[20.7284]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSzri22yKGHLKCjNLv9/VQ

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 19 [21.1717]

B:BD[21.2105] → [4.2218:2360]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RLOKTpEzFYJMyzgMCg7zSg

[21.2105]

[21.2247]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:viZlvDAHk9k8ScuA/qfUGw

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 20 [22.3263]

B:BD[22.3736] → [4.2361:2503]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QTXCy6SeSRYYXW3odCVLiQ

[22.3736]

[22.3878]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gRuZJKELtc15+vQFjxjkKQ

Replacement in src/lib/Hydra/Schema/Users.pm at line 33 [23.3258]

B:BD[23.3782] → [4.2504:2646]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eQFOcWRNwb7IE1ifGrw4rQ

[23.3782]

[23.3924]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lomf54EURbBIbrWGojiFIw

Replacement in src/lib/Hydra/Schema.pm at line 11 [10.6376]

B:BD[10.6498] → [4.2647:2789]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:17:32
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bK7m5SJjCnJKOckiufcb9w

[10.6498]

[10.6640]

# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-03-12 14:55:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oeLeU2T8C2dVBS+ugF0p8g

Replacement in src/root/build.tt at line 7 [10.7350]

B:BD[11.5620] → [11.5620:5696]

  Job <tt>[% build.project.name %]:[% build.attrname %]</tt> build [% id %]

[11.5620]

[11.5696]

  Job <tt>[% build.project.name %]:[% build.job %]</tt> build [% id %]

Replacement in src/root/build.tt at line 50 [10.7350]

B:BD[12.3224] → [12.3224:3359]

          (namely, <a href="[% c.uri_for('/build' failedDep.id.id 'nixlog' failedDep.stepnr) %]"><tt>[% failedDep.outpath %]</tt></a>)

[12.3224]

[24.665]

          (namely, <a href="[% c.uri_for('/build' failedDep.build.id 'nixlog' failedDep.stepnr) %]"><tt>[% failedDep.outpath %]</tt></a>)

Replacement in src/root/build.tt at line 84 [10.7350]

B:BD[10.7565] → [2.1117:1242]

    <td><a href="[% c.uri_for('/project' build.project.name 'job' build.attrname) %]"><tt>[% build.attrname %]</tt></a></td>

[10.7565]

[16.2225]

    <td><a href="[% c.uri_for('/project' build.project.name 'job' build.job) %]"><tt>[% build.job %]</tt></a></td>

Replacement in src/root/build.tt at line 190 [10.7350]

B:BD[25.1583] → [26.2977:3162]

            <a href="[% c.uri_for('/build' input.dependency.id) %]">Job <tt>[% input.dependency.project.name %]:[% input.dependency.attrname %]</tt> build [% input.dependency.id %]</a>

[25.1583]

[27.2786]

            <a href="[% c.uri_for('/build' input.dependency.id) %]">Job <tt>[% input.dependency.project.name %]:[% input.dependency.job %]</tt> build [% input.dependency.id %]</a>

Replacement in src/root/build.tt at line 301 [10.7350]

B:BD[28.417] → [26.3163:3333]

        <td><a href="[% c.uri_for('/build' input.build.id) %]">Job <tt>[% input.build.project.name %]:[% input.build.attrname %]</tt> build [% input.build.id %]</a></td>

[28.417]

[28.590]

        <td><a href="[% c.uri_for('/build' input.build.id) %]">Job <tt>[% input.build.project.name %]:[% input.build.job %]</tt> build [% input.build.id %]</a></td>

Replacement in src/root/common.tt at line 64 [30.2803]

B:BD[29.1029] → [2.1243:1383]

          <td><a href="[% c.uri_for('/project' build.get_column("project") 'job' build.attrname) %]"><tt>[% build.attrname %]</tt></a></td>

[29.1029]

[31.307]

          <td><a href="[% c.uri_for('/project' build.get_column("project") 'job' build.job) %]"><tt>[% build.job %]</tt></a></td>

Replacement in src/root/log.tt at line 3 [10.11783]

B:BD[10.11832] → [32.34:206]

<h1>Logfile for <tt>[% build.project.name %]:[% build.attrname %]</tt> build [% build.id %][%IF step %], step [% step.stepnr %] (<tt>[% step.outpath %]</tt>)[% END %]</h1>

[10.11832]

[10.11895]

<h1>Logfile for <tt>[% build.project.name %]:[% build.job %]</tt> build [% build.id %][%IF step %], step [% step.stepnr %] (<tt>[% step.outpath %]</tt>)[% END %]</h1>

Replacement in src/script/hydra_build.pl at line 61 [33.2912]

B:BD[12.4782] → [12.4782:4835]

                    $failedDepBuild = $step->id->id;

[12.4782]

[12.4835]

                    $failedDepBuild = $step->build->id;

Replacement in src/script/hydra_build.pl at line 94 [33.2912]

B:BD[13.5496] → [17.4462:4520]

∅:D[17.4520] → [13.5554:5648]

B:BD[13.5554] → [13.5554:5648]

                    $db->resultset('BuildSteps')->create(
                        { id => $build->id
                        , stepnr => $buildStepNr++

[13.5496]

[13.5648]

                    $build->buildsteps->create(
                        { stepnr => $buildStepNr++

Replacement in src/script/hydra_build.pl at line 109 [33.2912]

B:BD[13.6018] → [17.4521:4592]

∅:D[17.4592] → [13.6127:6208]

B:BD[13.6127] → [13.6127:6208]

                    (my $step) = $db->resultset('BuildSteps')->search(
                        {id => $build->id, type => 0, drvpath => $drvPath}, {});

[13.6018]

[13.6208]

                    (my $step) = $build->buildsteps->search(
                        {type => 0, drvpath => $drvPath}, {});

Replacement in src/script/hydra_build.pl at line 121 [33.2912]

B:BD[13.6495] → [17.4593:4664]

∅:D[17.4664] → [34.3885:3970]

B:BD[13.6604] → [34.3885:3970]

                    (my $step) = $db->resultset('BuildSteps')->search(
                        {id => $build->id, type => 0, drvpath => $drvPathStep}, {});

[13.6495]

[35.2610]

                    (my $step) = $build->buildsteps->search(
                        {type => 0, drvpath => $drvPathStep}, {});

Replacement in src/script/hydra_build.pl at line 126 [33.2912]

B:BD[35.2927] → [17.4665:4727]

∅:D[17.4727] → [35.2989:3091]

B:BD[35.2989] → [35.2989:3091]

                        $db->resultset('BuildSteps')->create(
                            { id => $build->id
                            , stepnr => $buildStepNr++

[35.2927]

[35.3091]

                        $build->buildsteps->create(
                            { stepnr => $buildStepNr++

Replacement in src/script/hydra_build.pl at line 145 [33.2912]

B:BD[36.798] → [17.4728:4786]

∅:D[17.4786] → [36.856:950]

B:BD[36.856] → [36.856:950]

                    $db->resultset('BuildSteps')->create(
                        { id => $build->id
                        , stepnr => $buildStepNr++

[36.798]

[36.950]

                    $build->buildsteps->create(
                        { stepnr => $buildStepNr++

Replacement in src/script/hydra_build.pl at line 158 [33.2912]

B:BD[36.1314] → [17.4787:4858]

∅:D[17.4858] → [36.1385:1466]

B:BD[36.1385] → [36.1385:1466]

                    (my $step) = $db->resultset('BuildSteps')->search(
                        {id => $build->id, type => 1, outpath => $outPath}, {});

[36.1314]

[36.1466]

                    (my $step) = $build->buildsteps->search(
                        {type => 1, outpath => $outPath}, {});

Replacement in src/script/hydra_build.pl at line 168 [33.2912]

B:BD[36.1799] → [17.4859:4930]

∅:D[17.4930] → [36.1870:1951]

B:BD[36.1870] → [36.1870:1951]

                    (my $step) = $db->resultset('BuildSteps')->search(
                        {id => $build->id, type => 1, outpath => $outPath}, {});

[36.1799]

[36.1951]

                    (my $step) = $build->buildsteps->search(
                        {type => 1, outpath => $outPath}, {});

Replacement in src/script/hydra_queue_runner.pl at line 109 [33.7823]

B:BD[37.1220] → [37.1220:1335]

        print "starting build $id (", $build->project->name, ":", $build->attrname, ") on ", $build->system, "\n";

[37.1220]

[33.9004]

        print "starting build $id (", $build->project->name, ":", $build->job, ") on ", $build->system, "\n";

Insertion in src/script/hydra_queue_runner.pl at line 134 [33.7823]

[33.9301]

[38.840]

}
if (scalar(@ARGV) == 1 && $ARGV[0] eq "--unlock") {
    unlockDeadBuilds;
    exit 0;

Replacement in src/script/hydra_scheduler.pl at line 158 [39.1319]

B:BD[3.386] → [3.386:507]

            {finished => 1, project => $project->name, jobset => $jobset->name, attrname => $jobName, buildStatus => 0},

[3.386]

[3.507]

            {finished => 1, project => $project->name, jobset => $jobset->name, job => $jobName, buildStatus => 0},

Replacement in src/script/hydra_scheduler.pl at line 221 [39.1319]

B:BD[33.9525] → [33.9525:9594]

                , attrname => $jobName, outPath => $outPath })) > 0)

[33.9525]

[33.9594]

                , job => $jobName, outPath => $outPath })) > 0)

Replacement in src/script/hydra_scheduler.pl at line 234 [39.1319]
B:BD[33.10241] → [33.10241:10276]
```
            , attrname => $jobName
```
[33.10241]
[40.978]
```
            , job => $jobName
```

Replacement in src/script/hydra_update_gc_roots.pl at line 41 [42.472]

B:BD[41.627] → [41.627:696]

        {select => [{distinct => 'attrname'}], as => ['attrname']}))

[41.627]

[41.696]

        {select => [{distinct => 'job'}], as => ['job']}))

Replacement in src/script/hydra_update_gc_roots.pl at line 43 [42.472]

B:BD[41.702] → [7.3742:3841]

        print "*** looking for builds to keep in job ", $project->name, ":", $job->attrname, "\n";

[41.702]

[41.797]

        print "*** looking for builds to keep in job ", $project->name, ":", $job->job, "\n";

Replacement in src/script/hydra_update_gc_roots.pl at line 48 [42.472]
B:BD[41.939] → [41.939:980]
```
            { attrname => $job->attrname
```
[41.939]
[41.980]
```
            { job => $job->job
```

Replacement in src/sql/hydra.sql at line 14 [39.1]

B:BD[15.4250] → [15.4250:4302]

B:BD[15.4302] → [26.4134:4186]

∅:D[26.4186] → [15.4354:4387]

B:BD[15.4354] → [15.4354:4387]

    project       text not null, -- !!! foreign key
    jobset        text not null, -- !!! foreign key
    attrName      text not null,

[15.4250]

[15.4431]

    project       text not null,
    jobset        text not null,
    job           text not null,

Replacement in src/sql/hydra.sql at line 88 [39.1]

B:BD[13.7150] → [12.5340:5401]

    id            integer not null, -- !!! rename to "build"

[13.7150]

[13.7186]

    build         integer not null,

Replacement in src/sql/hydra.sql at line 107 [39.1]

B:BD[13.7557] → [13.7557:7673]

    primary key   (id, stepnr),
    foreign key   (id) references Builds(id) on delete cascade -- ignored by sqlite

[13.7557]

[13.7673]

    primary key   (build, stepnr),
    foreign key   (build) references Builds(id) on delete cascade -- ignored by sqlite

Insertion in src/sql/hydra.sql at line 373 [39.1]
[20.13252]
[4.3219]
```
    jobset        text not null,
    
```

Insertion in src/sql/hydra.sql at line 378 [39.1]

[4.3386]

[20.13510]

    foreign key   (project, jobset) references Jobsets(project, name) on delete restrict -- ignored by sqlite