is_nullable: 1
=head2 flake
  data_type: 'text'

  "flake",
  { data_type => "text", is_nullable => 1 },

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

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Ar6GRni8AcAQmuZyg6tFKw

  is_nullable: 0

  is_nullable: 1

  is_nullable: 0

  is_nullable: 1

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

=head2 flake
  data_type: 'text'
  is_nullable: 1

  { data_type => "text", is_nullable => 0 },

  { data_type => "text", is_nullable => 1 },

  { data_type => "text", is_nullable => 0 },

  { data_type => "text", is_nullable => 1 },

  "type",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "flake",
  { data_type => "text", is_nullable => 1 },

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

# Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-02-09 15:21:11
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FVP1/AWjdKTlY6djrG592A

    nixExprInput  text not null, -- name of the jobsetInput containing the Nix or Guix expression
    nixExprPath   text not null, -- relative path of the Nix or Guix expression

    nixExprInput  text, -- name of the jobsetInput containing the Nix or Guix expression
    nixExprPath   text, -- relative path of the Nix or Guix expression

    type          integer not null default 0, -- 0 == legacy, 1 == flake
    flake         text,

    check ((type = 0) = (nixExprInput is not null and nixExprPath is not null)),
    check ((type = 1) = (flake is not null)),

    -- build.

    -- build.  FIXME: this should be stored in JobsetEvals, storing it
    -- here is denormal.

    flake         text, -- immutable flake reference

alter table Jobsets alter column nixExprInput drop not null;
alter table Jobsets alter column nixExprPath drop not null;
alter table Jobsets add column type integer default 0;
alter table Jobsets add column flake text;
alter table Jobsets add check ((type = 0) = (nixExprInput is not null and nixExprPath is not null));
alter table Jobsets add check ((type = 1) = (flake is not null));
alter table JobsetEvals add column flake text;