X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=3a43eb5c99b0747c69acfea559de6cf99e50aece;hb=20fa6cfca71c44400d5f7ec237c3e56ea83e90a3;hp=5992b412da70e5e0b206f1eb30500027a778b059;hpb=4ed3f8e7c64594bb4ea26abb1c4fb51a5a8258d6;p=gruntmaster-data.git

diff --git a/db.sql b/db.sql
index 5992b41..3a43eb5 100644
--- a/db.sql
+++ b/db.sql
@@ -25,7 +25,7 @@ CREATE TABLE contests (
 
 CREATE TABLE problems (
 	id        TEXT      PRIMARY KEY,
-	author    TEXT      NOT NULL,
+	author    TEXT,
 	generator GENERATOR NOT NULL,
 	judge     JUDGE     NOT NULL,
 	level     PLEVEL    NOT NULL,
@@ -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,
@@ -60,7 +61,7 @@ CREATE TABLE jobs (
 	problem     TEXT    NOT NULL REFERENCES problems,
 	result      INT,
 	result_text TEXT,
-	results     JSON,
+	results     TEXT,
 	source      TEXT    NOT NULL,
 	owner       TEXT    NOT NULL REFERENCES users
 );