university TEXT, -- NOT NULL,
level TEXT, -- NOT NULL,
country TEXT,
- lastjob BIGINT
+ lastjob BIGINT,
+ since BIGINT DEFAULT CAST(EXTRACT(epoch from now()) AS bigint)
);
CREATE TABLE contests (
solution TEXT ,
statement TEXT NOT NULL,
testcnt INT NOT NULL,
+ precnt INT,
tests TEXT,
timeout REAL NOT NULL,
value INT NOT NULL,
INSERT INTO column_comments VALUES ('users', 'name', 'Full name of user');
INSERT INTO column_comments VALUES ('users', 'level', 'Highschool, Undergraduate, Master, Doctorate or Other');
INSERT INTO column_comments VALUES ('users', 'lastjob', 'Unix time when this user last submitted a job');
+INSERT INTO column_comments VALUES ('users', 'since', 'Unix time when this user was created');
INSERT INTO column_comments VALUES ('contests', 'start', 'Unix time when contest starts');
INSERT INTO column_comments VALUES ('contests', 'stop', 'Unix time when contest ends');
INSERT INTO column_comments VALUES ('problems', 'solution', 'Solution (HTML)');
INSERT INTO column_comments VALUES ('problems', 'statement', 'Statement (HTML)');
INSERT INTO column_comments VALUES ('problems', 'testcnt', 'Number of tests');
+INSERT INTO column_comments VALUES ('problems', 'precnt', 'Number of pretests. NULL indicates full feedback.');
INSERT INTO column_comments VALUES ('problems', 'tests', 'JSON array of test values for ::Runner::File');
INSERT INTO column_comments VALUES ('problems', 'value', 'Problem value when used in a contest.');
INSERT INTO column_comments VALUES ('problems', 'genformat', 'Format (programming language) of the generator if using the Run generator');