Remove unused Jobs columns

Dependencies

• [2] YTIDBFGU Drop unused "disabled" columns
• [3] S6OISBQ3 * Mark the "current" builds in a jobset, i.e. those corresponding to
• [4] AHTEIK7G * Added a maintainers field to the Builds table.
• [5] 3HCBU2FA
• [6] P5X4P6VK * Renaming "release sets" to "views" (not finished yet). Having
• [7] PMNWRTGJ Add multiple output support
• [8] RBNQKATL * Adding persistant releases. A release is a named set of builds.
• [9] 3PNG7NIB Remove trailing whitespace
• [10] KN3VYE5P * Cleaned up the foreign key constraints.
• [11] 2YXO5ZGQ Hydra/28: Rename "scheduler" to "evaluator"
• [12] MOX7XJ2E Merge the BuildSchedulingInfo table into the Builds table
• [13] 5O6E5SU5 hydra: store logfile/output path/closure size
• [14] JTRG7RDQ add support for git as jobinput
• [15] S5PV6IIM * Represent jobs explicitly in the DB.
• [16] L2E6EVE2 * Merged the Build and Job tables.
• [17] 3XTHEUMP * Implemented the clone feature.
• [18] Y6AHH4TH Remove the logfile and logSize columns from the database
• [19] 4D4U5IPY * Allow jobsets to be disabled.
• [20] SB2V735V Keep track of the database schema version
• [21] JM3DPYOM generated schema with new dbix class schema loader, grrrrrr
• [*] OOQ2D3KC * Refactoring: move fetchInput out of hydra_scheduler into a separate
• [*] N22GPKYT * Put info about logs / build products in the DB.
• [*] D5QIOJGP * Move everything up one directory.

Change contents

• edit in src/lib/Hydra/Helper/AddBuilds.pm at line 879
  [3.3898]→[3.3898:3957](∅→∅)
  − # Update the last evaluation time in the database.
• edit in src/lib/Hydra/Helper/AddBuilds.pm at line 881
  [3.4039]→[3.4039:4074](∅→∅)
  − , lastevaltime => time
• edit in src/lib/Hydra/Helper/AddBuilds.pm at line 883
  [3.4091]→[3.4091:4186](∅→∅)
  − $job->update({firstevaltime => time})

  − unless defined $job->firstevaltime;

  −
• edit in src/lib/Hydra/Schema/Jobs.pm at line 42
  [3.13937]→[3.13937:13952](∅→∅)
  −

  − =head2 active
• edit in src/lib/Hydra/Schema/Jobs.pm at line 43
  [3.13953]→[3.15260:15283](∅→∅),[3.15283]→[3.13974:14010](∅→∅),[3.13974]→[3.13974:14010](∅→∅),[3.14024]→[3.14024:14025](∅→∅)
  − data_type: 'integer'

  − default_value: 1

  − is_nullable: 0

  −
• edit in src/lib/Hydra/Schema/Jobs.pm at line 46
  [3.15304]→[3.14083:14100](∅→∅),[3.14083]→[3.14083:14100](∅→∅),[3.14114]→[3.14114:14137](∅→∅),[3.14137]→[3.15305:15328](∅→∅),[3.15328]→[3.14181:14198](∅→∅),[3.14181]→[3.14181:14198](∅→∅),[3.14212]→[3.14212:14234](∅→∅),[3.14234]→[3.15329:15352](∅→∅)
  − is_nullable: 1

  −

  − =head2 firstevaltime

  −

  − data_type: 'integer'

  − is_nullable: 1

  −

  − =head2 lastevaltime

  −

  − data_type: 'integer'
• edit in src/lib/Hydra/Schema/Jobs.pm at line 57
  [3.10870]→[3.1844:1856](∅→∅),[3.15556]→[3.1844:1856](∅→∅),[3.1844]→[3.1844:1856](∅→∅),[3.1856]→[3.15557:15625](∅→∅)
  − "active",

  − { data_type => "integer", default_value => 1, is_nullable => 0 },
• edit in src/lib/Hydra/Schema/Jobs.pm at line 59
  [3.11058]→[3.1993:2012](∅→∅),[3.15671]→[3.1993:2012](∅→∅),[3.1993]→[3.1993:2012](∅→∅),[3.2012]→[3.15672:15720](∅→∅),[3.11165]→[3.2075:2093](∅→∅),[3.15720]→[3.2075:2093](∅→∅),[3.2075]→[3.2075:2093](∅→∅),[3.2093]→[3.15721:15769](∅→∅)
  − "firstevaltime",

  − { data_type => "integer", is_nullable => 1 },

  − "lastevaltime",

  − { data_type => "integer", is_nullable => 1 },
• replacement in src/lib/Hydra/Schema/Jobs.pm at line 129
  [3.2613]→[2.143:285](∅→∅)
  − # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-03 14:35:11

  − # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uZ27Dcbywi99pCW7Ml4j3A
  [3.2613]

  [3.2756]
  + # Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-23 16:09:46

  + # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JgxEaCz/TW9YKa+HavRzXw
• edit in src/sql/hydra.sql at line 102
  [3.6935]→[3.6935:7006](∅→∅)
  −

  − active integer not null default 1, -- !!! obsolete, remove
• edit in src/sql/hydra.sql at line 105
  [3.7064]→[3.473:608](∅→∅),[3.7272]→[3.7272:7273](∅→∅)
  − firstEvalTime integer, -- first time the evaluator saw this job

  − lastEvalTime integer, -- last time the evaluator saw this job

  −
• file addition: upgrade-16.sql (----------)
  [25.3004]
  + alter table Jobs drop column active, drop column firstEvalTime, drop column lastEvalTime;