grahamc/hydra2 - Change IGR322YPZG7IX33I6CSF4ZIHFKXCT4ERC2LC73MW6PN7W53D73BAC

sql: Generate models from postgresql

Lowercasing is due to postgresql not having case-sensitive table names. It always technically workde before, but those table names never existed literally.

The switch to generating from postgresql is to handle an upcoming addition of an auto-incrementign ID to the Jobset table. Sqlite doesn't seem to be able to handle the table having an auto incrementing ID field which isn't the primary key, but we can't change the primary key trivially.

Since hydra doesn't support sqlite and hasn't for many year anyway, it is easier to just generate from pgsql directly.

Created by Graham Christensen on February 6, 2020

IGR322YPZG7IX33I6CSF4ZIHFKXCT4ERC2LC73MW6PN7W53D73BAC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 30 [8.1669]
B:BD[8.2063] → [9.463:502]
```
=head1 TABLE: C<AggregateConstituents>
```
[8.2063]
[8.2097]
```
=head1 TABLE: C<aggregateconstituents>
```
Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 34 [8.1669]
B:BD[8.2104] → [9.503:548]
```
__PACKAGE__->table("AggregateConstituents");
```
[8.2104]
[8.2144]
```
__PACKAGE__->table("aggregateconstituents");
```

Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 106 [8.1669]

B:BD[8.3180] → [9.737:879]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-08-15 00:20:01
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TLNenyPLIWw2gWsOVhplZw

[8.3180]

[8.3322]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bQfQoSstlaFy7zw8i1R+ow

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 30 [12.1]
B:BD[10.32] → [11.59:88]
```
=head1 TABLE: C<BuildInputs>
```
[10.32]
[10.32]
```
=head1 TABLE: C<buildinputs>
```
Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 34 [12.1]
B:BD[12.137] → [13.859:894]
```
__PACKAGE__->table("BuildInputs");
```
[12.99]
[10.80]
```
__PACKAGE__->table("buildinputs");
```
Insertion in src/lib/Hydra/Schema/BuildInputs.pm at line 43 [12.1]
[10.194]
[10.208]
```
  sequence: 'buildinputs_id_seq'
```

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 102 [12.1]

B:BD[14.1143] → [11.329:401]

  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },

[14.1143]

[14.1206]

  {
    data_type         => "integer",
    is_auto_increment => 1,
    is_nullable       => 0,
    sequence          => "buildinputs_id_seq",
  },

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 185 [12.1]

B:BD[15.25] → [16.815:957]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-08 13:08:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OaJPzRM+8XGsu3eIkqeYEw

[15.25]

[17.151]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/Fwb8emBsvwrZlEab2X+gQ

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 30 [18.3245]
B:BD[18.3631] → [18.3631:3661]
```
=head1 TABLE: C<BuildMetrics>
```
[18.3631]
[18.3661]
```
=head1 TABLE: C<buildmetrics>
```
Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 34 [18.3245]
B:BD[18.3668] → [18.3668:3704]
```
__PACKAGE__->table("BuildMetrics");
```
[18.3668]
[18.3704]
```
__PACKAGE__->table("buildmetrics");
```

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 180 [18.3245]

B:BD[18.6026] → [18.6026:6168]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:52:20
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qoPm5/le+sVHigW4Dmum2Q

[18.6026]

[18.6168]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Roy7h/K9u7DQOzet4B1sbA

Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 30 [19.1]
B:BD[19.242] → [19.242:272]
```
=head1 TABLE: C<BuildOutputs>
```
[19.242]
[19.272]
```
=head1 TABLE: C<buildoutputs>
```
Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 34 [19.1]
B:BD[19.279] → [19.279:315]
```
__PACKAGE__->table("BuildOutputs");
```
[19.279]
[19.315]
```
__PACKAGE__->table("buildoutputs");
```

Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 97 [19.1]

B:BD[19.1127] → [20.26971:27113]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V8MbzKvZNEaeHBJV67+ZMQ

[19.1127]

[21.0]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:71R9clwAP6vzDh10EukTaw

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 30 [22.4268]
B:BD[10.1500] → [11.2687:2718]
```
=head1 TABLE: C<BuildProducts>
```
[10.1500]
[22.4342]
```
=head1 TABLE: C<buildproducts>
```
Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 34 [22.4268]
∅:D[10.1550] → [13.1412:1449]
B:BD[22.4406] → [13.1412:1449]
```
__PACKAGE__->table("BuildProducts");
```
[10.1550]
[10.1551]
```
__PACKAGE__->table("buildproducts");
```

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 146 [22.4268]

B:BD[22.5065] → [2.0:142]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-04-13 14:49:33
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kONECZn56f7sqfrLviiUOQ

[22.5065]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iI0gmKqQxiPBTy5QsM6tpQ

Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 30 [19.1415]
B:BD[19.1664] → [19.1664:1698]
```
=head1 TABLE: C<BuildStepOutputs>
```
[19.1664]
[19.1698]
```
=head1 TABLE: C<buildstepoutputs>
```
Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 34 [19.1415]
B:BD[19.1705] → [19.1705:1745]
```
__PACKAGE__->table("BuildStepOutputs");
```
[19.1705]
[19.1745]
```
__PACKAGE__->table("buildstepoutputs");
```

Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 122 [19.1415]

B:BD[19.3027] → [20.27549:27691]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A/4v3ugXYbuYoKPlOvC6mg

[19.3027]

[19.3169]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Y6DpbTM6z4cOGoYIhD3i1A

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 30 [23.1675]
B:BD[10.5579] → [11.6272:6300]
```
=head1 TABLE: C<BuildSteps>
```
[10.5579]
[10.5619]
```
=head1 TABLE: C<buildsteps>
```
Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 34 [23.1675]
∅:D[10.5626] → [23.1810:1844]
B:BD[23.1810] → [23.1810:1844]
```
__PACKAGE__->table("BuildSteps");
```
[10.5626]
[10.5627]
```
__PACKAGE__->table("buildsteps");
```

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 218 [23.1675]

B:BD[24.499] → [5.3113:3255]

# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-12-07 13:48:19
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3FYkqSUfgWmiqZzmX8J4TA

[24.499]

[25.10118]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AMjHq4g/fSUv/lZuZOljYg

Replacement in src/lib/Hydra/Schema/Builds.pm at line 30 [22.5202]
B:BD[10.7038] → [11.7568:7592]
```
=head1 TABLE: C<Builds>
```
[10.7038]
[22.5294]
```
=head1 TABLE: C<builds>
```
Replacement in src/lib/Hydra/Schema/Builds.pm at line 34 [22.5202]
∅:D[10.7067] → [13.2663:2693]
B:BD[22.5333] → [13.2663:2693]
```
__PACKAGE__->table("Builds");
```
[10.7067]
[10.7068]
```
__PACKAGE__->table("builds");
```
Insertion in src/lib/Hydra/Schema/Builds.pm at line 43 [22.5202]
[10.7182]
[10.7196]
```
  sequence: 'builds_id_seq'
```

Replacement in src/lib/Hydra/Schema/Builds.pm at line 204 [22.5202]

B:BD[22.5397] → [11.8031:8103]

  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },

[22.5397]

[13.2757]

  {
    data_type         => "integer",
    is_auto_increment => 1,
    is_nullable       => 0,
    sequence          => "builds_id_seq",
  },

Replacement in src/lib/Hydra/Schema/Builds.pm at line 553 [22.5202]

B:BD[13.3378] → [7.154:296]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2019-08-19 16:12:37
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VjYbAQwv4THW2VfWQ5ajYQ

[13.3378]

[8.4481]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H3hs+zEywsUmwTWKfSE8wQ

Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 30 [26.456]
B:BD[26.645] → [11.11179:11215]
```
=head1 TABLE: C<CachedBazaarInputs>
```
[26.645]
[26.645]
```
=head1 TABLE: C<cachedbazaarinputs>
```
Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 34 [26.456]
B:BD[26.700] → [26.700:742]
```
__PACKAGE__->table("CachedBazaarInputs");
```
[26.700]
[26.742]
```
__PACKAGE__->table("cachedbazaarinputs");
```

Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 86 [26.456]

B:BD[26.1677] → [20.28416:28558]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zvun8uhxwrr7B8EsqBoCjA

[26.1677]

[26.1819]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X8L4C57lMOctdqOKSmfA/g

Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 30 [27.1]
B:BD[27.181] → [11.11780:11813]
```
=head1 TABLE: C<CachedCVSInputs>
```
[27.181]
[10.10600]
```
=head1 TABLE: C<cachedcvsinputs>
```
Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 34 [27.1]
∅:D[10.10607] → [27.219:258]
B:BD[27.219] → [27.219:258]
```
__PACKAGE__->table("CachedCVSInputs");
```
[10.10607]
[10.10608]
```
__PACKAGE__->table("cachedcvsinputs");
```

Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 102 [27.1]

B:BD[27.1055] → [20.28705:28847]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vi1qzjW52Lnsl0JSmGzy0w

[27.1055]

[27.1200]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6eQ+i/th+oVZNRiDPd2luA

Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 30 [29.3643]
∅:D[28.1477] → [29.3894:3929]
B:BD[29.3894] → [29.3894:3929]
```
=head1 TABLE: C<CachedDarcsInputs>
```
[28.1477]
[29.3929]
```
=head1 TABLE: C<cacheddarcsinputs>
```
Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 34 [29.3643]
B:BD[29.3936] → [29.3936:3977]
```
__PACKAGE__->table("CachedDarcsInputs");
```
[29.3936]
[29.3977]
```
__PACKAGE__->table("cacheddarcsinputs");
```

Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 93 [29.3643]

B:BD[29.4751] → [28.1601:1743]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-09-20 11:08:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Yl1slt3SAizijgu0KUTn0A

[29.4751]

[28.1743]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Buwq42sBXQVfYUy01WMyYw

Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 30 [27.1340]
B:BD[27.1495] → [11.12540:12573]
```
=head1 TABLE: C<CachedGitInputs>
```
[27.1495]
[27.1519]
```
=head1 TABLE: C<cachedgitinputs>
```
Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 34 [27.1340]
∅:D[10.11404] → [27.1558:1597]
B:BD[27.1558] → [27.1558:1597]
```
__PACKAGE__->table("CachedGitInputs");
```
[10.11404]
[10.11405]
```
__PACKAGE__->table("cachedgitinputs");
```

Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 95 [27.1340]

B:BD[27.2415] → [20.28994:29136]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I4hI02FKRMkw76WV/KBocA

[27.2415]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0sdK9uQZpx869oqS5thRLw

Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 30 [30.1]
B:BD[30.186] → [11.13218:13250]
```
=head1 TABLE: C<CachedHgInputs>
```
[30.186]
[30.230]
```
=head1 TABLE: C<cachedhginputs>
```
Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 34 [30.1]
B:BD[30.237] → [30.237:275]
```
__PACKAGE__->table("CachedHgInputs");
```
[30.237]
[30.275]
```
__PACKAGE__->table("cachedhginputs");
```

Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 95 [30.1]

B:BD[30.1417] → [20.29283:29425]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qS/eiiZXmpc7KpTHdtaT7g

[30.1417]

[30.1559]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dYfjQ0SJG/mBrsZemAW3zw

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 30 [31.859]
B:BD[10.12239] → [11.13897:13931]
```
=head1 TABLE: C<CachedPathInputs>
```
[10.12239]
[31.928]
```
=head1 TABLE: C<cachedpathinputs>
```
Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 34 [31.859]
∅:D[10.12292] → [31.992:1032]
B:BD[31.992] → [31.992:1032]
```
__PACKAGE__->table("CachedPathInputs");
```
[10.12292]
[10.12293]
```
__PACKAGE__->table("cachedpathinputs");
```

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 93 [31.859]

B:BD[31.1497] → [20.29572:29714]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:28rja0vR1glJJ15hzVfjsQ

[31.1497]

[31.1639]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oV7tbWLNEMC8byKf9UnAlw

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 30 [31.1780]
B:BD[10.12953] → [11.14581:14621]
```
=head1 TABLE: C<CachedSubversionInputs>
```
[10.12953]
[31.1855]
```
=head1 TABLE: C<cachedsubversioninputs>
```
Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 34 [31.1780]
B:BD[31.1919] → [31.1919:1965]
```
__PACKAGE__->table("CachedSubversionInputs");
```
[31.1881]
[10.13012]
```
__PACKAGE__->table("cachedsubversioninputs");
```

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 86 [31.1780]

B:BD[31.2485] → [20.29861:30003]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3qXfnvkOVj25W94bfhQ65w

[31.2485]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VGt/0HG84eNZr9OIA8jzow

Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 30 [32.3074]
B:BD[32.3458] → [32.3458:3487]
```
=head1 TABLE: C<FailedPaths>
```
[32.3458]
[32.3487]
```
=head1 TABLE: C<failedpaths>
```
Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 34 [32.3074]
B:BD[32.3494] → [32.3494:3529]
```
__PACKAGE__->table("FailedPaths");
```
[32.3494]
[32.3529]
```
__PACKAGE__->table("failedpaths");
```

Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 60 [32.3074]

B:BD[32.3783] → [32.3783:3925]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2015-06-10 14:48:16
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WFgjfjH+szE6Ntcicmaflw

[32.3783]

[32.3925]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jr3XiGO4lWAzqfATbsMwFw

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 30 [33.1454]
B:BD[33.1537] → [11.15174:15196]
```
=head1 TABLE: C<Jobs>
```
[33.1537]
[10.13608]
```
=head1 TABLE: C<jobs>
```
Replacement in src/lib/Hydra/Schema/Jobs.pm at line 34 [33.1454]
∅:D[10.13615] → [33.1575:1603]
B:BD[33.1575] → [33.1575:1603]
```
__PACKAGE__->table("Jobs");
```
[10.13615]
[10.13616]
```
__PACKAGE__->table("jobs");
```

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 172 [33.1454]

B:BD[34.1556] → [18.6976:7118]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:52:20
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vDAo9bzLca+QWfhOb9OLMg

[34.1556]

[33.2756]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sYa6dZNK+stMAnTH0Tmn8A

Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 30 [35.378]
B:BD[35.627] → [35.627:661]
```
=head1 TABLE: C<JobsetEvalInputs>
```
[35.627]
[35.661]
```
=head1 TABLE: C<jobsetevalinputs>
```
Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 34 [35.378]
B:BD[35.668] → [35.668:708]
```
__PACKAGE__->table("JobsetEvalInputs");
```
[35.668]
[35.708]
```
__PACKAGE__->table("jobsetevalinputs");
```

Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 169 [35.378]

B:BD[35.2509] → [20.30439:30581]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1Dp8B58leBLh4GK0GPw2zg

[35.2509]

[36.38]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/cFQGBLhvpmBO1UJztgIAg

Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 30 [37.1327]
B:BD[37.1515] → [11.16592:16627]
```
=head1 TABLE: C<JobsetEvalMembers>
```
[37.1515]
[37.1515]
```
=head1 TABLE: C<jobsetevalmembers>
```
Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 34 [37.1327]
B:BD[37.1569] → [37.1569:1610]
```
__PACKAGE__->table("JobsetEvalMembers");
```
[37.1569]
[37.1610]
```
__PACKAGE__->table("jobsetevalmembers");
```

Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 113 [37.1327]

B:BD[11.17200] → [20.30728:30870]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ccPNQe/QnSjTAC3uGWe8Ng

[11.17200]

[37.2915]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T+dJFh/sDO8WsasqYVLRSQ

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 30 [38.65]
B:BD[38.222] → [11.17402:17431]
```
=head1 TABLE: C<JobsetEvals>
```
[38.222]
[38.246]
```
=head1 TABLE: C<jobsetevals>
```
Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 34 [38.65]
B:BD[10.16047] → [37.3159:3194]
```
__PACKAGE__->table("JobsetEvals");
```
[10.16047]
[10.16048]
```
__PACKAGE__->table("jobsetevals");
```
Insertion in src/lib/Hydra/Schema/JobsetEvals.pm at line 43 [38.65]
[37.3291]
[37.3305]
```
  sequence: 'jobsetevals_id_seq'
```

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 96 [38.65]

B:BD[37.3653] → [11.17615:17687]

  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },

[37.3653]

[38.352]

  {
    data_type         => "integer",
    is_auto_increment => 1,
    is_nullable       => 0,
    sequence          => "jobsetevals_id_seq",
  },

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 197 [38.65]

B:BD[11.18354] → [20.31017:31159]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SlEiF8oN6FBK262uSiMKiw

[11.18354]

[39.1674]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4ZaT8Z1tmCCt6k4ein0MNg

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 30 [40.825]
B:BD[10.14946] → [11.18560:18593]
```
=head1 TABLE: C<JobsetInputAlts>
```
[10.14946]
[10.14946]
```
=head1 TABLE: C<jobsetinputalts>
```
Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 34 [40.825]
B:BD[40.965] → [13.4758:4797]
```
__PACKAGE__->table("JobsetInputAlts");
```
[40.927]
[10.14998]
```
__PACKAGE__->table("jobsetinputalts");
```

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 124 [40.825]

B:BD[40.1974] → [20.31306:31448]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UUO37lIuEYm0GiR92m/fyA

[40.1974]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nh8dQDL9FtgzXcwjDufDMQ

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 30 [41.590]
B:BD[10.16931] → [11.19458:19488]
```
=head1 TABLE: C<JobsetInputs>
```
[10.16931]
[41.663]
```
=head1 TABLE: C<jobsetinputs>
```
Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 34 [41.590]
B:BD[41.727] → [13.4941:4977]
```
__PACKAGE__->table("JobsetInputs");
```
[41.689]
[10.16979]
```
__PACKAGE__->table("jobsetinputs");
```
Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 132 [41.590]
B:BD[41.1680] → [41.1680:1681]
B:BD[41.1681] → [11.19979:19994]
∅:D[42.861] → [41.1823:1824]
∅:D[43.991] → [41.1823:1824]
∅:D[44.1108] → [41.1823:1824]
∅:D[45.1143] → [41.1823:1824]
∅:D[46.1161] → [41.1823:1824]
∅:D[47.1221] → [41.1823:1824]
∅:D[48.1366] → [41.1823:1824]
∅:D[49.1385] → [41.1823:1824]
∅:D[50.1396] → [41.1823:1824]
∅:D[51.1429] → [41.1823:1824]
∅:D[52.1429] → [41.1823:1824]
∅:D[53.1492] → [41.1823:1824]
∅:D[54.1506] → [41.1823:1824]
∅:D[55.1508] → [41.1823:1824]
∅:D[56.1584] → [41.1823:1824]
∅:D[57.1612] → [41.1823:1824]
∅:D[58.1680] → [41.1823:1824]
∅:D[59.1731] → [41.1823:1824]
∅:D[60.1731] → [41.1823:1824]
∅:D[61.1751] → [41.1823:1824]
∅:D[12.1752] → [41.1823:1824]
∅:D[62.1773] → [41.1823:1824]
∅:D[63.1794] → [41.1823:1824]
∅:D[64.1802] → [41.1823:1824]
∅:D[65.1867] → [41.1823:1824]
∅:D[66.1987] → [41.1823:1824]
∅:D[67.2076] → [41.1823:1824]
∅:D[68.2092] → [41.1823:1824]
∅:D[69.2158] → [41.1823:1824]
∅:D[70.2168] → [41.1823:1824]
∅:D[71.2229] → [41.1823:1824]
∅:D[72.2309] → [41.1823:1824]
∅:D[40.2593] → [41.1823:1824]
∅:D[73.2676] → [41.1823:1824]
∅:D[74.2760] → [41.1823:1824]
∅:D[75.2778] → [41.1823:1824]
∅:D[76.2827] → [41.1823:1824]
∅:D[31.2915] → [41.1823:1824]
∅:D[77.3135] → [41.1823:1824]
∅:D[33.3168] → [41.1823:1824]
∅:D[14.3261] → [41.1823:1824]
∅:D[78.3273] → [41.1823:1824]
∅:D[23.3377] → [41.1823:1824]
∅:D[79.4424] → [41.1823:1824]
∅:D[80.4551] → [41.1823:1824]
∅:D[13.5120] → [41.1823:1824]
∅:D[81.7948] → [41.1823:1824]
∅:D[82.13082] → [41.1823:1824]
∅:D[11.19994] → [41.1823:1824]
B:BD[41.1823] → [41.1823:1824]
B:BD[41.1824] → [11.19995:20010]
```
=head2 jobsets
Type: has_many
```
Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 133 [41.590]
B:BD[11.20011] → [11.20011:20053]
```
Related object: L<Hydra::Schema::Jobsets>
```

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 134 [41.590]

B:BD[11.20054] → [11.20054:20059]

=cut

[11.20054]

[11.20059]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5uKwEhDXso4IR1TFmwRxiA

Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 137 [41.590]

B:BD[11.20060] → [11.20060:20267]

B:BD[11.20267] → [83.5600:5609]

∅:D[83.5609] → [11.20273:20277]

B:BD[11.20273] → [11.20273:20277]

∅:D[10.17827] → [41.1824:1825]

∅:D[11.20277] → [41.1824:1825]

B:BD[41.1824] → [41.1824:1825]

B:BD[41.1825] → [16.1006:1148]

B:BD[16.1148] → [84.211:212]

__PACKAGE__->has_many(
  "jobsets",
  "Hydra::Schema::Jobsets",
  {
    "foreign.name"         => "self.jobset",
    "foreign.nixexprinput" => "self.name",
    "foreign.project"      => "self.project",
  },
  undef,
);
# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-08 13:06:15
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mZZqLjQNwblb/EWW1alLQ

Replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 30 [85.709]
B:BD[85.1097] → [85.1097:1128]
```
=head1 TABLE: C<JobsetRenames>
```
[85.1097]
[85.1128]
```
=head1 TABLE: C<jobsetrenames>
```
Replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 34 [85.709]
B:BD[85.1135] → [85.1135:1172]
```
__PACKAGE__->table("JobsetRenames");
```
[85.1135]
[85.1172]
```
__PACKAGE__->table("jobsetrenames");
```

Replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 113 [85.709]

B:BD[85.2307] → [85.2307:2449]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2014-04-23 23:13:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SBpKWF9swFc9T1Uc0VFlgA

[85.2307]

[85.2449]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eOQbJ2O/p0G1317m3IC/KA

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 30 [41.1960]
B:BD[10.17861] → [11.20477:20502]
```
=head1 TABLE: C<Jobsets>
```
[10.17861]
[10.17873]
```
=head1 TABLE: C<jobsets>
```
Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 34 [41.1960]
∅:D[10.17904] → [13.5121:5152]
B:BD[41.2092] → [13.5121:5152]
```
__PACKAGE__->table("Jobsets");
```
[10.17904]
[10.17905]
```
__PACKAGE__->table("jobsets");
```
Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 41 [41.1960]
∅:D[11.20523] → [10.17978:17998]
B:BD[10.17978] → [10.17978:17998]
```
  is_foreign_key: 1
```
Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 57 [41.1960]
∅:D[11.20586] → [10.18294:18314]
B:BD[10.18294] → [10.18294:18314]
```
  is_foreign_key: 1
```
Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 144 [41.1960]
B:BD[41.2159] → [11.20794:20860]
```
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
[41.2159]
[41.2219]
```
  { data_type => "text", is_nullable => 0 },
```
Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 150 [41.1960]
B:BD[41.2387] → [11.20974:21040]
```
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
```
[41.2387]
[41.2447]
```
  { data_type => "text", is_nullable => 0 },
```
Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 270 [41.1960]
B:BD[86.3019] → [11.21932:21952]
```
=head2 jobsetinput
```
Deletion in src/lib/Hydra/Schema/Jobsets.pm at line 271 [41.1960]
B:BD[10.19550] → [11.21953:22170]
B:BD[11.22170] → [83.5783:5861]
∅:D[83.5861] → [11.22176:22179]
B:BD[11.22176] → [11.22176:22179]
∅:D[37.4899] → [10.19575:19576]
∅:D[11.22179] → [10.19575:19576]
B:BD[10.19575] → [10.19575:19576]
```
Type: belongs_to
Related object: L<Hydra::Schema::JobsetInputs>
=cut
__PACKAGE__->belongs_to(
  "jobsetinput",
  "Hydra::Schema::JobsetInputs",
  { jobset => "name", name => "nixexprinput", project => "project" },
  { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" },
);
```

Replacement in src/lib/Hydra/Schema/Jobsets.pm at line 338 [41.1960]

B:BD[11.22628] → [6.4342:4484]

# Created by DBIx::Class::Schema::Loader v0.07045 @ 2017-03-09 13:03:05
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ivYvsUyhEeaeI4EmRQ0/QQ

[11.22628]

[87.217]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fYKx6VRlNG5XiDZ73Qr6Rw

Replacement in src/lib/Hydra/Schema/NewsItems.pm at line 30 [88.2337]
B:BD[88.2517] → [11.22686:22713]
```
=head1 TABLE: C<NewsItems>
```
[88.2517]
[88.2517]
```
=head1 TABLE: C<newsitems>
```
Replacement in src/lib/Hydra/Schema/NewsItems.pm at line 34 [88.2337]
B:BD[88.2563] → [88.2563:2596]
```
__PACKAGE__->table("NewsItems");
```
[88.2563]
[88.2596]
```
__PACKAGE__->table("newsitems");
```
Insertion in src/lib/Hydra/Schema/NewsItems.pm at line 43 [88.2337]
[88.2710]
[88.2724]
```
  sequence: 'newsitems_id_seq'
```

Replacement in src/lib/Hydra/Schema/NewsItems.pm at line 65 [88.2337]

B:BD[88.3058] → [11.22804:22876]

  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },

[88.3058]

[88.3192]

  {
    data_type         => "integer",
    is_auto_increment => 1,
    is_nullable       => 0,
    sequence          => "newsitems_id_seq",
  },

Replacement in src/lib/Hydra/Schema/NewsItems.pm at line 109 [88.2337]

B:BD[88.3800] → [20.32173:32315]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3CRNsvd+YnZp9c80tuZREQ

[88.3800]

[88.4112]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r6vX8VG/+NQraIVKFgHzxQ

Replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 30 [89.203]
B:BD[89.581] → [89.581:607]
```
=head1 TABLE: C<NrBuilds>
```
[89.581]
[89.607]
```
=head1 TABLE: C<nrbuilds>
```
Replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 34 [89.203]
B:BD[89.614] → [89.614:646]
```
__PACKAGE__->table("NrBuilds");
```
[89.614]
[89.646]
```
__PACKAGE__->table("nrbuilds");
```

Replacement in src/lib/Hydra/Schema/NrBuilds.pm at line 70 [89.203]

B:BD[89.1021] → [89.1021:1163]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-08-12 17:59:18
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CK8eJGC803nGj0wnete9xg

[89.1021]

[89.1163]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qv1I8Wu7KXHAs+pyBn2ofA

Replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 30 [90.294]
B:BD[90.480] → [11.23304:23336]
```
=head1 TABLE: C<ProjectMembers>
```
[90.480]
[90.492]
```
=head1 TABLE: C<projectmembers>
```
Replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 34 [90.294]
B:BD[90.530] → [90.530:568]
```
__PACKAGE__->table("ProjectMembers");
```
[90.530]
[90.568]
```
__PACKAGE__->table("projectmembers");
```

Replacement in src/lib/Hydra/Schema/ProjectMembers.pm at line 106 [90.294]

B:BD[90.1559] → [20.32462:32604]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:imPoiaitrTbX0vVNlF6dPA

[90.1559]

[90.1701]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e/hYmoNmcEUoGhRqtwdyQw

Replacement in src/lib/Hydra/Schema/Projects.pm at line 30 [41.3266]
B:BD[10.19840] → [11.23799:23825]
```
=head1 TABLE: C<Projects>
```
[10.19840]
[10.19864]
```
=head1 TABLE: C<projects>
```
Replacement in src/lib/Hydra/Schema/Projects.pm at line 34 [41.3266]
∅:D[10.19871] → [13.5296:5328]
B:BD[41.3399] → [13.5296:5328]
```
__PACKAGE__->table("Projects");
```
[10.19871]
[10.19872]
```
__PACKAGE__->table("projects");
```

Replacement in src/lib/Hydra/Schema/Projects.pm at line 306 [41.3266]

B:BD[83.7308] → [3.3333:3475]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-03-11 10:39:17
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1ats3brIVhRTWLToIYSoaQ

[83.7308]

[91.171]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pcF/8351zyo9VL6N5eimdQ

Replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 30 [92.1847]
B:BD[10.21505] → [11.25775:25807]
```
=head1 TABLE: C<ReleaseMembers>
```
[10.21505]
[10.21549]
```
=head1 TABLE: C<releasemembers>
```
Replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 34 [92.1847]
B:BD[92.1978] → [92.1978:2016]
```
__PACKAGE__->table("ReleaseMembers");
```
[92.1940]
[10.21556]
```
__PACKAGE__->table("releasemembers");
```

Replacement in src/lib/Hydra/Schema/ReleaseMembers.pm at line 138 [92.1847]

B:BD[92.3083] → [20.33040:33182]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7M7WPlGQT6rNHKJ+82/KSA

[92.3083]

[10.22596]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k4z2YeB4gRAeAP6hmR93sQ

Replacement in src/lib/Hydra/Schema/Releases.pm at line 30 [92.3220]
B:BD[92.3282] → [11.26614:26640]
```
=head1 TABLE: C<Releases>
```
[92.3282]
[10.22630]
```
=head1 TABLE: C<releases>
```
Replacement in src/lib/Hydra/Schema/Releases.pm at line 34 [92.3220]
∅:D[10.22675] → [92.3345:3377]
B:BD[92.3345] → [92.3345:3377]
```
__PACKAGE__->table("Releases");
```
[10.22675]
[10.22676]
```
__PACKAGE__->table("releases");
```

Replacement in src/lib/Hydra/Schema/Releases.pm at line 122 [92.3220]

B:BD[92.4209] → [20.33329:33471]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qISBiwvboB8dIdinaE45mg

[92.4209]

[92.4355]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:b4M/tHOhsy234tgTf+wqjQ

Replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 30 [11.27170]
B:BD[11.27413] → [11.27413:27444]
```
=head1 TABLE: C<SchemaVersion>
```
[11.27413]
[11.27444]
```
=head1 TABLE: C<schemaversion>
```
Replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 34 [11.27170]
B:BD[11.27451] → [11.27451:27488]
```
__PACKAGE__->table("SchemaVersion");
```
[11.27451]
[11.27488]
```
__PACKAGE__->table("schemaversion");
```

Replacement in src/lib/Hydra/Schema/SchemaVersion.pm at line 48 [11.27170]

B:BD[11.27814] → [20.33618:33760]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:08/7gbEQp1TqBiWFJXVY0w

[11.27814]

[11.27956]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2wy4FsRYVVo2RTCWXcmgvg

Replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 30 [34.2467]
B:BD[34.2851] → [34.2851:2880]
```
=head1 TABLE: C<StarredJobs>
```
[34.2851]
[34.2880]
```
=head1 TABLE: C<starredjobs>
```
Replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 34 [34.2467]
B:BD[34.2887] → [34.2887:2922]
```
__PACKAGE__->table("StarredJobs");
```
[34.2887]
[34.2922]
```
__PACKAGE__->table("starredjobs");
```

Replacement in src/lib/Hydra/Schema/StarredJobs.pm at line 156 [34.2467]

B:BD[34.4849] → [34.4849:4991]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-10-14 15:46:29
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:naj5aKWuw8hLE6klmvW9Eg

[34.4849]

[34.4991]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fw4FfzmOhzDk0ZoSuNr2ww

Replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 30 [93.501]
B:BD[93.887] → [93.887:917]
```
=head1 TABLE: C<SystemStatus>
```
[93.887]
[93.917]
```
=head1 TABLE: C<systemstatus>
```
Replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 34 [93.501]
B:BD[93.924] → [93.924:960]
```
__PACKAGE__->table("SystemStatus");
```
[93.924]
[93.960]
```
__PACKAGE__->table("systemstatus");
```

Replacement in src/lib/Hydra/Schema/SystemStatus.pm at line 70 [93.501]

B:BD[93.1331] → [93.1331:1473]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2015-07-30 16:01:22
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JCYi4+HwM22iucdFkhBjMg

[93.1331]

[93.1473]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GeXpTVktMXjHENa/P3qOxw

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 30 [94.170]
B:BD[94.409] → [94.409:438]
```
=head1 TABLE: C<SystemTypes>
```
[94.409]
[94.438]
```
=head1 TABLE: C<systemtypes>
```
Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 34 [94.170]
B:BD[94.445] → [94.445:480]
```
__PACKAGE__->table("SystemTypes");
```
[94.445]
[94.480]
```
__PACKAGE__->table("systemtypes");
```

Replacement in src/lib/Hydra/Schema/SystemTypes.pm at line 71 [94.170]

B:BD[94.918] → [20.33907:34049]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:8cC34cEw9T3+x+7uRs4KHQ

[94.918]

[94.1060]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fYeKQQSS5J8rjO3t+Hbz0g

Replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 30 [95.1]
B:BD[95.184] → [11.28620:28650]
```
=head1 TABLE: C<UriRevMapper>
```
[95.184]
[95.226]
```
=head1 TABLE: C<urirevmapper>
```
Replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 34 [95.1]
B:BD[95.233] → [95.233:269]
```
__PACKAGE__->table("UriRevMapper");
```
[95.233]
[95.269]
```
__PACKAGE__->table("urirevmapper");
```

Replacement in src/lib/Hydra/Schema/UriRevMapper.pm at line 70 [95.1]

B:BD[95.768] → [20.34196:34338]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:G2GAF/Rb7cRkRegH94LwIA

[95.768]

[95.910]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FOg2/BVJK3yg8MAYMrqZOQ

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 30 [74.3263]
B:BD[10.23981] → [11.29051:29078]
```
=head1 TABLE: C<UserRoles>
```
[10.23981]
[10.24020]
```
=head1 TABLE: C<userroles>
```
Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 34 [74.3263]
B:BD[74.3389] → [74.3389:3422]
```
__PACKAGE__->table("UserRoles");
```
[74.3351]
[10.24027]
```
__PACKAGE__->table("userroles");
```

Replacement in src/lib/Hydra/Schema/UserRoles.pm at line 90 [74.3263]

B:BD[10.24455] → [20.34485:34627]

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-06-13 01:54:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aS+ivlFpndqIv8U578zz9A

[10.24455]

[10.24597]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LUw2PDFvUHs0E0UZ3oHFxw

Replacement in src/lib/Hydra/Schema/Users.pm at line 30 [76.3258]
B:BD[88.5185] → [11.29514:29537]
```
=head1 TABLE: C<Users>
```
[88.5185]
[88.5185]
```
=head1 TABLE: C<users>
```
Replacement in src/lib/Hydra/Schema/Users.pm at line 34 [76.3258]
B:BD[88.5227] → [88.5227:5256]
```
__PACKAGE__->table("Users");
```
[88.5227]
[88.5256]
```
__PACKAGE__->table("users");
```

Replacement in src/lib/Hydra/Schema/Users.pm at line 195 [76.3258]

B:BD[83.8787] → [4.1130:1272]

# Created by DBIx::Class::Schema::Loader v0.07043 @ 2016-05-27 11:32:14
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Az1+V+ztJoWUt50NLQR3xg

[83.8787]

[96.1838]

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-06 12:22:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4/WZ95asbnGmK+nEHb4sLQ

Deletion in src/sql/Makefile.am at line 5 [65.3409]
B:BD[97.69] → [97.69:93]
```
  hydra-sqlite.sql				\
```

Replacement in src/sql/Makefile.am at line 12 [65.3409]

B:BD[65.3555] → [65.3555:3735]

B:BD[65.3735] → [93.1658:1753]

hydra-sqlite.sql: hydra.sql
	cpp -P -E -traditional-cpp -DSQLITE hydra.sql > $@ || rm -f $@
update-dbix: hydra-sqlite.sql
	rm -f tmp.sqlite
	sqlite3 tmp.sqlite < hydra-sqlite.sql
	perl -I ../lib -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib update-dbix.pl

[65.3555]

update-dbix: hydra-postgresql.sql
	./update-dbix-harness.sh

File addition: update-dbix-harness.sh (---x------)

[98.3004]

#!/usr/bin/env bash
readonly scratch=$(mktemp -d -t tmp.XXXXXXXXXX)
readonly socket=$scratch/socket
readonly data=$scratch/data
readonly dbname=hydra-update-dbix
function finish {
    set +e
    pg_ctl -D "$data" \
           -o "-F -h '' -k \"$socket\"" \
           -w stop -m immediate
    if [ -f "$data/postmaster.pid" ]; then
        pg_ctl -D "$data" \
               -o "-F -h '' -k \"$socket\"" \
               -w kill TERM "$(cat "$data/postmaster.pid")"
    fi
    rm -rf "$scratch"
}
trap finish EXIT
set -e
mkdir -p "$socket"
initdb -D "$data"
pg_ctl -D "$data" \
       -o "-F -h '' -k \"${socket}\"" \
       -w start
createdb -h "$socket" "$dbname"
psql -h "$socket" "$dbname" -f ./hydra-postgresql.sql
perl -I ../lib \
     -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:../lib \
     update-dbix.pl "dbi:Pg:dbname=$dbname;host=$socket"

Insertion in src/sql/update-dbix.pl at line 1 [93.1755]

[93.1755]

[93.1756]

use Cwd;
die "$0: dbi connection string required \n" if scalar @ARGV != 1;

Replacement in src/sql/update-dbix.pl at line 8 [93.1755]

B:BD[93.1845] → [93.1845:1886]

    moniker_map => sub { return "$_"; },

[93.1845]

[93.1886]

    moniker_map => {
        "aggregateconstituents" => "AggregateConstituents",
            "buildinputs" => "BuildInputs",
            "buildmetrics" => "BuildMetrics",
            "buildoutputs" => "BuildOutputs",
            "buildproducts" => "BuildProducts",
            "builds" => "Builds",
            "buildstepoutputs" => "BuildStepOutputs",
            "buildsteps" => "BuildSteps",
            "cachedbazaarinputs" => "CachedBazaarInputs",
            "cachedcvsinputs" => "CachedCVSInputs",
            "cacheddarcsinputs" => "CachedDarcsInputs",
            "cachedgitinputs" => "CachedGitInputs",
            "cachedhginputs" => "CachedHgInputs",
            "cachedpathinputs" => "CachedPathInputs",
            "cachedsubversioninputs" => "CachedSubversionInputs",
            "failedpaths" => "FailedPaths",
            "jobs" => "Jobs",
            "jobsetevalinputs" => "JobsetEvalInputs",
            "jobsetevalmembers" => "JobsetEvalMembers",
            "jobsetevals" => "JobsetEvals",
            "jobsetinputalts" => "JobsetInputAlts",
            "jobsetinputs" => "JobsetInputs",
            "jobsetrenames" => "JobsetRenames",
            "jobsets" => "Jobsets",
            "newsitems" => "NewsItems",
            "nrbuilds" => "NrBuilds",
            "projectmembers" => "ProjectMembers",
            "projects" => "Projects",
            "releasemembers" => "ReleaseMembers",
            "releases" => "Releases",
            "schemaversion" => "SchemaVersion",
            "starredjobs" => "StarredJobs",
            "systemstatus" => "SystemStatus",
            "systemtypes" => "SystemTypes",
            "urirevmapper" => "UriRevMapper",
            "userroles" => "UserRoles",
            "users" => "Users",
    } , #sub { return "$_"; },

Replacement in src/sql/update-dbix.pl at line 49 [93.1755]
B:BD[93.1995] → [93.1995:2027]
```
}, ["dbi:SQLite:tmp.sqlite"]);
```
[93.1995]
```
}, [$ARGV[0]]);
```

sql: Generate models from postgresql

Dependencies

In channels

Change contents

Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 30 [8.1669]

Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 34 [8.1669]

Replacement in src/lib/Hydra/Schema/AggregateConstituents.pm at line 106 [8.1669]

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 30 [12.1]

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 34 [12.1]

Insertion in src/lib/Hydra/Schema/BuildInputs.pm at line 43 [12.1]

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 102 [12.1]

Replacement in src/lib/Hydra/Schema/BuildInputs.pm at line 185 [12.1]

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 30 [18.3245]

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 34 [18.3245]

Replacement in src/lib/Hydra/Schema/BuildMetrics.pm at line 180 [18.3245]

Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 30 [19.1]

Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 34 [19.1]

Replacement in src/lib/Hydra/Schema/BuildOutputs.pm at line 97 [19.1]

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 30 [22.4268]

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 34 [22.4268]

Replacement in src/lib/Hydra/Schema/BuildProducts.pm at line 146 [22.4268]

Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 30 [19.1415]

Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 34 [19.1415]

Replacement in src/lib/Hydra/Schema/BuildStepOutputs.pm at line 122 [19.1415]

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 30 [23.1675]

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

Replacement in src/lib/Hydra/Schema/BuildSteps.pm at line 218 [23.1675]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 30 [22.5202]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 34 [22.5202]

Insertion in src/lib/Hydra/Schema/Builds.pm at line 43 [22.5202]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 204 [22.5202]

Replacement in src/lib/Hydra/Schema/Builds.pm at line 553 [22.5202]

Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 30 [26.456]

Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 34 [26.456]

Replacement in src/lib/Hydra/Schema/CachedBazaarInputs.pm at line 86 [26.456]

Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 30 [27.1]

Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 34 [27.1]

Replacement in src/lib/Hydra/Schema/CachedCVSInputs.pm at line 102 [27.1]

Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 30 [29.3643]

Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 34 [29.3643]

Replacement in src/lib/Hydra/Schema/CachedDarcsInputs.pm at line 93 [29.3643]

Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 30 [27.1340]

Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 34 [27.1340]

Replacement in src/lib/Hydra/Schema/CachedGitInputs.pm at line 95 [27.1340]

Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 30 [30.1]

Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 34 [30.1]

Replacement in src/lib/Hydra/Schema/CachedHgInputs.pm at line 95 [30.1]

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 30 [31.859]

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 34 [31.859]

Replacement in src/lib/Hydra/Schema/CachedPathInputs.pm at line 93 [31.859]

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 30 [31.1780]

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 34 [31.1780]

Replacement in src/lib/Hydra/Schema/CachedSubversionInputs.pm at line 86 [31.1780]

Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 30 [32.3074]

Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 34 [32.3074]

Replacement in src/lib/Hydra/Schema/FailedPaths.pm at line 60 [32.3074]

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 30 [33.1454]

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 34 [33.1454]

Replacement in src/lib/Hydra/Schema/Jobs.pm at line 172 [33.1454]

Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 30 [35.378]

Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 34 [35.378]

Replacement in src/lib/Hydra/Schema/JobsetEvalInputs.pm at line 169 [35.378]

Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 30 [37.1327]

Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 34 [37.1327]

Replacement in src/lib/Hydra/Schema/JobsetEvalMembers.pm at line 113 [37.1327]

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 30 [38.65]

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 34 [38.65]

Insertion in src/lib/Hydra/Schema/JobsetEvals.pm at line 43 [38.65]

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 96 [38.65]

Replacement in src/lib/Hydra/Schema/JobsetEvals.pm at line 197 [38.65]

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 30 [40.825]

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

Replacement in src/lib/Hydra/Schema/JobsetInputAlts.pm at line 124 [40.825]

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 30 [41.590]

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 34 [41.590]

Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 132 [41.590]

Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 133 [41.590]

Replacement in src/lib/Hydra/Schema/JobsetInputs.pm at line 134 [41.590]

Deletion in src/lib/Hydra/Schema/JobsetInputs.pm at line 137 [41.590]

Replacement in src/lib/Hydra/Schema/JobsetRenames.pm at line 30 [85.709]