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

diff --git a/db.sql b/db.sql
index eafd89e..ab499d8 100644
--- a/db.sql
+++ b/db.sql
@@ -8,6 +8,7 @@ CREATE TABLE users (
 	id         TEXT  PRIMARY KEY,
 	name       TEXT,  -- NOT NULL,
 	email      TEXT,  -- NOT NULL,
+	phone      TEXT,  -- NOT NULL,
 	town       TEXT,  -- NOT NULL,
 	university TEXT,  -- NOT NULL,
 	level      TEXT,  --ULEVEL NOT NULL,
@@ -25,7 +26,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,
@@ -39,6 +40,8 @@ CREATE TABLE problems (
 	tests     TEXT,
 	timeout   REAL      NOT NULL,
 	value     INT,
+	genformat TEXT,
+	gensource TEXT,
 	verformat TEXT,
 	versource TEXT
 );
@@ -61,7 +64,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
 );