From b596b2a96d793d7f96d4886abc63f48501d79e8e Mon Sep 17 00:00:00 2001
From: Marius Gavrilescu <marius@ieval.ro>
Date: Sat, 14 Feb 2015 10:53:58 +0200
Subject: [PATCH] Add editorial and description columns

---
 db.sql                                 | 16 ++++++++++------
 lib/Gruntmaster/Data/Result/Contest.pm | 22 ++++++++++++++++++++--
 2 files changed, 30 insertions(+), 8 deletions(-)

diff --git a/db.sql b/db.sql
index 56b1a7e..706265e 100644
--- a/db.sql
+++ b/db.sql
@@ -14,12 +14,14 @@ CREATE TABLE users (
 );
 
 CREATE TABLE contests (
-	id    TEXT PRIMARY KEY,
-	name  TEXT NOT NULL,
-	start INT  NOT NULL,
-	stop  INT  NOT NULL,
-	owner TEXT NOT NULL REFERENCES users ON DELETE CASCADE,
-	CONSTRAINT positive_duration CHECK (stop > start)
+	id          TEXT PRIMARY KEY,
+	name        TEXT NOT NULL,
+	editorial   TEXT,
+	description TEXT,
+	start       INT  NOT NULL,
+	stop        INT  NOT NULL,
+	owner       TEXT NOT NULL REFERENCES users ON DELETE CASCADE,
+	CONSTRAINT  positive_duration CHECK (stop > start)
 );
 
 CREATE TABLE contest_status (
@@ -125,6 +127,8 @@ INSERT INTO column_comments VALUES ('users', 'since', 'Unix time when this user
 
 INSERT INTO column_comments VALUES ('contests', 'start', 'Unix time when contest starts');
 INSERT INTO column_comments VALUES ('contests', 'stop', 'Unix time when contest ends');
+INSERT INTO column_comments VALUES ('contests', 'editorial', 'HTML fragment placed before the editorial');
+INSERT INTO column_comments VALUES ('contests', 'description', 'HTML fragment placed on contest page');
 
 INSERT INTO column_comments VALUES ('problems', 'author', 'Full name(s) of problem author(s)/problemsetter(s)/tester(s)/etc');
 INSERT INTO column_comments VALUES ('problems', 'writer', 'Full name(s) of statement writer(s) (DEPRECATED)');
diff --git a/lib/Gruntmaster/Data/Result/Contest.pm b/lib/Gruntmaster/Data/Result/Contest.pm
index 2a57c95..1da4bad 100644
--- a/lib/Gruntmaster/Data/Result/Contest.pm
+++ b/lib/Gruntmaster/Data/Result/Contest.pm
@@ -33,6 +33,20 @@ __PACKAGE__->table("contests");
   data_type: 'text'
   is_nullable: 0
 
+=head2 editorial
+
+  data_type: 'text'
+  is_nullable: 1
+
+HTML fragment placed before the editorial
+
+=head2 description
+
+  data_type: 'text'
+  is_nullable: 1
+
+HTML fragment placed on contest page
+
 =head2 start
 
   data_type: 'integer'
@@ -60,6 +74,10 @@ __PACKAGE__->add_columns(
   { data_type => "text", is_nullable => 0 },
   "name",
   { data_type => "text", is_nullable => 0 },
+  "editorial",
+  { data_type => "text", is_nullable => 1 },
+  "description",
+  { data_type => "text", is_nullable => 1 },
   "start",
   { data_type => "integer", is_nullable => 0 },
   "stop",
@@ -168,8 +186,8 @@ Composing rels: L</contest_problems> -> problem
 __PACKAGE__->many_to_many("problems", "contest_problems", "problem");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-19 16:54:00
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IxxZqQwKisBwDabCNUD55Q
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-02-14 10:52:58
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UTfqBbyhmo0r1HyWtGXidA
 
 use Class::Method::Modifiers qw/after/;
 use List::Util qw/sum/;
-- 
2.39.2