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

diff --git a/db.sql b/db.sql
index 5992b41..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,
@@ -36,8 +37,11 @@ CREATE TABLE problems (
 	runner    RUNNER    NOT NULL,
 	statement TEXT      NOT NULL,
 	testcnt   INT       NOT NULL,
+	tests     TEXT,
 	timeout   REAL      NOT NULL,
 	value     INT,
+	genformat TEXT,
+	gensource TEXT,
 	verformat TEXT,
 	versource TEXT
 );
@@ -60,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
 );