Add statement writer support to gruntmaster-problem

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index 3a43eb5c99b0747c69acfea559de6cf99e50aece..6f15c01af62050e110921fd887516d0bad900104 100644 (file)
--- 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,
@@ -26,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,
@@ -39,6 +43,8 @@ CREATE TABLE problems (
        tests     TEXT,
        timeout   REAL      NOT NULL,
        value     INT,
+       genformat TEXT,
+       gensource TEXT,
        verformat TEXT,
        versource TEXT
 );