X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=6f15c01af62050e110921fd887516d0bad900104;hb=4a8747effd02a1e0f9dde86b1c81f6c26ce66f04;hp=e4decc24a2008c9036aa32d96c32de5b593f8814;hpb=9a987597aaf367c5a3b2fa291f6420569147f1b4;p=gruntmaster-data.git

diff --git a/db.sql b/db.sql
index e4decc2..6f15c01 100644
--- a/db.sql
+++ b/db.sql
@@ -5,7 +5,9 @@ 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,
@@ -27,6 +29,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,
@@ -40,6 +43,8 @@ CREATE TABLE problems (
 	tests     TEXT,
 	timeout   REAL      NOT NULL,
 	value     INT,
+	genformat TEXT,
+	gensource TEXT,
 	verformat TEXT,
 	versource TEXT
 );