package Hydra::Schema::BuildMachineSystemTypes;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
use strict;
use warnings;
use base 'DBIx::Class::Core';
=head1 TABLE: C<BuildMachineSystemTypes>
=cut
__PACKAGE__->table("BuildMachineSystemTypes");
=head1 ACCESSORS
=head2 hostname
  data_type: 'text'
  is_foreign_key: 1
  is_nullable: 0
=head2 system
  data_type: 'text'
  is_nullable: 0
=cut
__PACKAGE__->add_columns(
  "hostname",
  { data_type => "text", is_foreign_key => 1, is_nullable => 0 },
  "system",
  { data_type => "text", is_nullable => 0 },
);
__PACKAGE__->set_primary_key("hostname", "system");
=head1 RELATIONS
=head2 hostname
Type: belongs_to
Related object: L<Hydra::Schema::BuildMachines>
=cut
__PACKAGE__->belongs_to(
  "hostname",
  "Hydra::Schema::BuildMachines",
  { hostname => "hostname" },
);
# You can replace this text with custom content, and it will be preserved on regeneration
1;
# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:im3sfvrv5YY3i1IAOozeiA
  { is_deferrable => 0, on_delete => "CASCADE", on_update => "NO ACTION" },
=head1 PRIMARY KEY
=over 4
=item * L</hostname>
=item * L</system>
=back
=cut
Hydra::Schema::BuildMachineSystemTypes
=cut
=head1 NAME
use utf8;

package Hydra::Schema::BuildMachines;
# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE
use strict;
use warnings;
use base 'DBIx::Class::Core';
=cut
__PACKAGE__->table("BuildMachines");
=head1 ACCESSORS
=head2 hostname
  data_type: 'text'
  is_nullable: 0
=head2 username
  data_type: 'text'
  default_value: (empty string)
  is_nullable: 0
=head2 ssh_key
  data_type: 'text'
  default_value: (empty string)
  is_nullable: 0
=head2 options
  data_type: 'text'
  default_value: (empty string)
  is_nullable: 0
=head2 maxconcurrent
  data_type: 'integer'
  default_value: 2
  is_nullable: 0
=head2 speedfactor
  data_type: 'integer'
  default_value: 1
  is_nullable: 0
=head2 enabled
  data_type: 'integer'
  default_value: 0
  is_nullable: 0
=cut
__PACKAGE__->add_columns(
  "hostname",
  { data_type => "text", is_nullable => 0 },
  "username",
  { data_type => "text", default_value => "", is_nullable => 0 },
  "ssh_key",
  { data_type => "text", default_value => "", is_nullable => 0 },
  "options",
  { data_type => "text", default_value => "", is_nullable => 0 },
  "maxconcurrent",
  { data_type => "integer", default_value => 2, is_nullable => 0 },
  "speedfactor",
  { data_type => "integer", default_value => 1, is_nullable => 0 },
  "enabled",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
);
__PACKAGE__->set_primary_key("hostname");
=head1 RELATIONS
=head2 buildmachinesystemtypes
Type: has_many
Related object: L<Hydra::Schema::BuildMachineSystemTypes>
=cut
__PACKAGE__->has_many(
  "buildmachinesystemtypes",
  "Hydra::Schema::BuildMachineSystemTypes",
  { "foreign.hostname" => "self.hostname" },
);
# You can replace this text with custom content, and it will be preserved on regeneration
1;
# Created by DBIx::Class::Schema::Loader v0.07033 @ 2013-01-22 13:29:36
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OST5IMcvHKsXlNMCRazXhg
  undef,
=head1 PRIMARY KEY
=over 4
=item * L</hostname>
=back
=cut
=head1 TABLE: C<BuildMachines>
=head1 NAME
Hydra::Schema::BuildMachines
=cut
use utf8;

create table BuildMachines (
    hostname text primary key not null,
    username text default '' not null,
    ssh_key text default '' not null,
    options text default '' not null,
    maxconcurrent integer default 2 not null,
    speedfactor integer default 1 not null,
    enabled integer default 0 not null
);

create table BuildMachineSystemTypes (
    hostname text NOT NULL,
    system text NOT NULL,
    primary key (hostname, system),
    foreign key (hostname) references BuildMachines(hostname) on delete cascade
);

drop table BuildMachineSystemTypes;
drop table BuildMachines;

use Test::Simple tests => 45;

use Test::Simple tests => 43;