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

diff --git a/db.sql b/db.sql
index eafd89e..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,
@@ -61,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
 );