Add a column precnt - number of pretests

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index 475138b627c8e755d9a6edc259b1ff74bd0cccd4..56b1a7e2c0a80d13fdcde39a0fa85422da3bd4fc 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -46,6 +46,7 @@ CREATE TABLE problems (
        solution  TEXT ,
        statement TEXT    NOT NULL,
        testcnt   INT     NOT NULL,
+       precnt    INT,
        tests     TEXT,
        timeout   REAL    NOT NULL,
        value     INT     NOT NULL,
@@ -136,6 +137,7 @@ INSERT INTO column_comments VALUES ('problems', 'timeout', 'Time limit (in secon
 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');