From b2725d9d3f2603f7adfa0743862d666e21b1cd32 Mon Sep 17 00:00:00 2001
From: Marius Gavrilescu <marius@ieval.ro>
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_problems> -> 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.30.2