X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;fp=db.sql;h=706265ea6b49f0eff9ce6f6c220b6e74ad86d0e6;hb=b596b2a96d793d7f96d4886abc63f48501d79e8e;hp=56b1a7e2c0a80d13fdcde39a0fa85422da3bd4fc;hpb=f7c095d32cc618c2463e6bea69a7f18ba7799187;p=gruntmaster-data.git

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)');