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,
CREATE TABLE problems (
id TEXT PRIMARY KEY,
- author TEXT NOT NULL,
+ author TEXT,
generator GENERATOR NOT NULL,
judge JUDGE NOT NULL,
level PLEVEL NOT NULL,
tests TEXT,
timeout REAL NOT NULL,
value INT,
+ genformat TEXT,
+ gensource TEXT,
verformat TEXT,
versource TEXT
);
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
);