Add statement writer column to problems

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index 5992b412da70e5e0b206f1eb30500027a778b059..01a31f35b83e8c946a83c2dab49cbe1d032918b6 100644 (file)
--- 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,
@@ -25,7 +26,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,
@@ -36,8 +38,11 @@ CREATE TABLE problems (
        runner    RUNNER    NOT NULL,
        statement TEXT      NOT NULL,
        testcnt   INT       NOT NULL,
+       tests     TEXT,
        timeout   REAL      NOT NULL,
        value     INT,
+       genformat TEXT,
+       gensource TEXT,
        verformat TEXT,
        versource TEXT
 );
@@ -60,7 +65,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
 );