Add a "solution" column to problem

diff --git a/db.sql b/db.sql
index 0daf3477ae3b7a08045a56c067ef1e6c5b663d6e..1556202076909318c6718fc10d3189caeac78a28 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -32,6 +32,7 @@ CREATE TABLE problems (
        owner     TEXT    NOT NULL REFERENCES users ON DELETE CASCADE,
        private   BOOLEAN NOT NULL DEFAULT FALSE,
        runner    TEXT    NOT NULL,
        owner     TEXT    NOT NULL REFERENCES users ON DELETE CASCADE,
        private   BOOLEAN NOT NULL DEFAULT FALSE,
        runner    TEXT    NOT NULL,

+       solution  TEXT ,

        statement TEXT    NOT NULL,
        testcnt   INT     NOT NULL,
        tests     TEXT,
        statement TEXT    NOT NULL,
        testcnt   INT     NOT NULL,
        tests     TEXT,

diff --git a/lib/Gruntmaster/Data/Result/Problem.pm b/lib/Gruntmaster/Data/Result/Problem.pm
index 0f4667e3ccc6cc2e1c26636388b116330eb1ed5b..098701eb10d4c2e3e981aa705b37f8630a2e2733 100644 (file)
--- a/lib/Gruntmaster/Data/Result/Problem.pm
+++ b/lib/Gruntmaster/Data/Result/Problem.pm
@@ -80,6 +80,11 @@ __PACKAGE__->table("problems");
   data_type: 'text'
   is_nullable: 0
 
   data_type: 'text'
   is_nullable: 0
 

+=head2 solution
+
+  data_type: 'text'
+  is_nullable: 1
+

 =head2 statement
 
   data_type: 'text'
 =head2 statement
 
   data_type: 'text'


@@ -150,6 +155,8 @@ __PACKAGE__->add_columns(
   { data_type => "boolean", default_value => \"false", is_nullable => 0 },
   "runner",
   { data_type => "text", is_nullable => 0 },
   { data_type => "boolean", default_value => \"false", is_nullable => 0 },
   "runner",
   { data_type => "text", is_nullable => 0 },

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

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


@@ -255,8 +262,8 @@ Composing rels: L</contest_problems> -> contest
 __PACKAGE__->many_to_many("contests", "contest_problems", "contest");
 
 
 __PACKAGE__->many_to_many("contests", "contest_problems", "contest");
 
 

-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-01 14:39:28
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/p3BIfVYSG5AKSSgVgOoOQ
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-07 00:51:56
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KjAtOerTqBqtcMrBtwJ3Bw

 
 sub is_private {
        my ($self, $time) = @_;
 
 sub is_private {
        my ($self, $time) = @_;