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

diff --git a/db.sql b/db.sql
index eafd89e..6f15c01 100644
--- a/db.sql
+++ b/db.sql
@@ -5,9 +5,12 @@ CREATE TYPE RUNNER    AS ENUM ('File', 'Verifier', 'Interactive');
 CREATE TYPE JUDGE     AS ENUM ('Absolute', 'Points');
 
 CREATE TABLE users (
-	id         TEXT  PRIMARY KEY,
+	id         TEXT    PRIMARY KEY,
+	passphrase TEXT    NOT NULL,
+	admin      BOOLEAN NOT NULL DEFAULT FALSE,
 	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 +28,8 @@ CREATE TABLE contests (
 
 CREATE TABLE problems (
 	id        TEXT      PRIMARY KEY,
-	author    TEXT      NOT NULL,
+	author    TEXT,
+	writer    TEXT,
 	generator GENERATOR NOT NULL,
 	judge     JUDGE     NOT NULL,
 	level     PLEVEL    NOT NULL,
@@ -39,6 +43,8 @@ CREATE TABLE problems (
 	tests     TEXT,
 	timeout   REAL      NOT NULL,
 	value     INT,
+	genformat TEXT,
+	gensource TEXT,
 	verformat TEXT,
 	versource TEXT
 );
@@ -61,7 +67,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
 );