From b2725d9d3f2603f7adfa0743862d666e21b1cd32 Mon Sep 17 00:00:00 2001 From: Marius Gavrilescu Date: Mon, 24 Mar 2014 09:26:44 +0200 Subject: [PATCH] Update schema --- db.sql | 1 + lib/Gruntmaster/Data/Result/Job.pm | 15 ++++++++++----- lib/Gruntmaster/Data/Result/Open.pm | 4 ++-- lib/Gruntmaster/Data/Result/Problem.pm | 14 +++++++++++--- 4 files changed, 24 insertions(+), 10 deletions(-) diff --git a/db.sql b/db.sql index 5992b41..eafd89e 100644 --- a/db.sql +++ b/db.sql @@ -36,6 +36,7 @@ CREATE TABLE problems ( runner RUNNER NOT NULL, statement TEXT NOT NULL, testcnt INT NOT NULL, + tests TEXT, timeout REAL NOT NULL, value INT, verformat TEXT, diff --git a/lib/Gruntmaster/Data/Result/Job.pm b/lib/Gruntmaster/Data/Result/Job.pm index 6f1084f..b52ddfc 100644 --- a/lib/Gruntmaster/Data/Result/Job.pm +++ b/lib/Gruntmaster/Data/Result/Job.pm @@ -34,7 +34,7 @@ __PACKAGE__->table("jobs"); data_type: 'text' is_foreign_key: 1 - is_nullable: 0 + is_nullable: 1 =head2 daemon @@ -110,7 +110,7 @@ __PACKAGE__->add_columns( sequence => "jobs_id_seq", }, "contest", - { data_type => "text", is_foreign_key => 1, is_nullable => 0 }, + { data_type => "text", is_foreign_key => 1, is_nullable => 1 }, "daemon", { data_type => "text", is_nullable => 1 }, "date", @@ -163,7 +163,12 @@ __PACKAGE__->belongs_to( "contest", "Gruntmaster::Data::Result::Contest", { id => "contest" }, - { is_deferrable => 0, on_delete => "NO ACTION", on_update => "NO ACTION" }, + { + is_deferrable => 0, + join_type => "LEFT", + on_delete => "NO ACTION", + on_update => "NO ACTION", + }, ); =head2 owner @@ -197,8 +202,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-06 12:41:16 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lIETgGgMTSOUUuDuFa/+SQ +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-24 09:25:07 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mDHQWFk/K7q/nHu+Z3a0+A # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/lib/Gruntmaster/Data/Result/Open.pm b/lib/Gruntmaster/Data/Result/Open.pm index cd0c7e1..52b7578 100644 --- a/lib/Gruntmaster/Data/Result/Open.pm +++ b/lib/Gruntmaster/Data/Result/Open.pm @@ -123,8 +123,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-06 12:41:16 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+zXnz+V4BYSNwxN65ovu2w +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-24 09:25:07 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MgoDt8QyQeSpjIJZEd5RXQ # You can replace this text with custom code or comments, and it will be preserved on regeneration diff --git a/lib/Gruntmaster/Data/Result/Problem.pm b/lib/Gruntmaster/Data/Result/Problem.pm index 5359df7..6b12ac5 100644 --- a/lib/Gruntmaster/Data/Result/Problem.pm +++ b/lib/Gruntmaster/Data/Result/Problem.pm @@ -70,6 +70,7 @@ __PACKAGE__->table("problems"); =head2 private data_type: 'boolean' + default_value: false is_nullable: 0 =head2 runner @@ -88,6 +89,11 @@ __PACKAGE__->table("problems"); data_type: 'integer' is_nullable: 0 +=head2 tests + + data_type: 'text' + is_nullable: 1 + =head2 timeout data_type: 'real' @@ -143,7 +149,7 @@ __PACKAGE__->add_columns( "owner", { data_type => "text", is_foreign_key => 1, is_nullable => 0 }, "private", - { data_type => "boolean", is_nullable => 0 }, + { data_type => "boolean", default_value => \"false", is_nullable => 0 }, "runner", { data_type => "enum", @@ -157,6 +163,8 @@ __PACKAGE__->add_columns( { data_type => "text", is_nullable => 0 }, "testcnt", { data_type => "integer", is_nullable => 0 }, + "tests", + { data_type => "text", is_nullable => 1 }, "timeout", { data_type => "real", is_nullable => 0 }, "value", @@ -252,8 +260,8 @@ Composing rels: L -> contest __PACKAGE__->many_to_many("contests", "contest_problems", "contest"); -# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-06 12:41:16 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y1LUGcxNJxUMgMXqvAkKYQ +# Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-03-24 09:25:07 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dZicbasR8lUFGhIabrWxXw # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.39.2