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

diff --git a/db.sql b/db.sql
index 01a31f3..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,