* Upgrade notes:
  alter table builds add column longDescription text;
  alter table builds add column license text;
  alter table projects add column homepage text;
  alter table builds add column homepage text;
  alter table BuildProducts add column defaultPath text;
  alter table BuildResultInfo add column failedDepBuild integer;
  alter table BuildResultInfo add column failedDepStepNr integer;
  alter table ReleaseSetJobs add column jobset text not null default "trunk";
  === (DB dump/load needed after Sqlite upgrade) ===
  insert into jobs(project, jobset, name, active) select distinct project, jobset, job, 0 from builds b where not exists (select 1 from jobs where project = b.project and jobset = b.jobset and name = b.job);
  create index IndexBuildInputsByBuild on BuildInputs(build);
  create index IndexBuildInputsByDependency on BuildInputs(dependency);
  
  create index IndexBuildsByTimestamp on Builds(timestamp);
  alter table jobs add column disabled integer not null default 0;
  alter table builds add column maintainers text;
  # Add the isCurrent column to Builds and use the obsolete Jobs.active to fill it in.
  alter table builds add column isCurrent integer default 0;
  update builds set isCurrent = 1 where id in (select max(id) from builds natural join (select distinct b.project, b.jobset, b.job, b.system from builds b join (select project, jobset, name from jobs where active = 1) j on b.project = j.project and b.jobset = j.jobset and b.job = j.name) b2 group by project, jobset, job, system);

  alter table Jobsets add column enabled integer not null default 1;

  # Releases -> Views.
  alter table ReleaseSets rename to Views;
  alter table ReleaseSetJobs rename to ViewJobs;
  alter table ViewJobs rename column release_ to view_;
  alter table ViewJobs drop column mayFail;
  alter table ViewJobs add column autorelease integer not null default 0;
  alter table Builds add column nixExprInput text;
  alter table Builds add column nixExprPath text;
  # Adding JobsetEvals.
  drop table JobsetInputHashes;
  (add JobsetEvals, JobsetEvalMembers)
  

=head2 disabled
  data_type: 'integer'
  default_value: 0
  is_nullable: 0

  "disabled",
  { data_type => "integer", default_value => 0, is_nullable => 0 },

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-30 16:22:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YBdqPWScG4dtGx+U3dJcwA

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-03 14:35:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aYVEk+AeDsgTRi5GAqOhEw

=head2 disabled
  data_type: 'integer'
  default_value: 0
  is_nullable: 0

  "disabled",
  { data_type => "integer", default_value => 0, is_nullable => 0 },

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vfl4QtuyeKeEk9+Ap7FP2A

# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-05-03 14:35:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uZ27Dcbywi99pCW7Ml4j3A

        { drvpath => [ @deps ], finished => 0, enabled => 1, disabled => 0 },

        { drvpath => [ @deps ], finished => 0, enabled => 1 },

            { finished => 0, busy => 0, enabled => 1, disabled => 0 },

            { finished => 0, busy => 0, enabled => 1 },

                { finished => 0, busy => 0, system => $system->system, enabled => 1, disabled => 0 },

                { finished => 0, busy => 0, system => $system->system, enabled => 1 },

    disabled      integer not null default 0, -- !!! not currently used

    disabled      integer not null default 0, -- !!! boolean

alter table Jobs drop column disabled;
alter table Builds drop column disabled;