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

diff --git a/db.sql b/db.sql
index 3a43eb5..01a31f3 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,
@@ -26,6 +27,7 @@ CREATE TABLE contests (
 CREATE TABLE problems (
 	id        TEXT      PRIMARY KEY,
 	author    TEXT,
+	writer    TEXT,
 	generator GENERATOR NOT NULL,
 	judge     JUDGE     NOT NULL,
 	level     PLEVEL    NOT NULL,
@@ -39,6 +41,8 @@ CREATE TABLE problems (
 	tests     TEXT,
 	timeout   REAL      NOT NULL,
 	value     INT,
+	genformat TEXT,
+	gensource TEXT,
 	verformat TEXT,
 	versource TEXT
 );