Add statement writer column to problems

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index e4decc24a2008c9036aa32d96c32de5b593f8814..01a31f35b83e8c946a83c2dab49cbe1d032918b6 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -27,6 +27,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,
@@ -40,6 +41,8 @@ CREATE TABLE problems (
        tests     TEXT,
        timeout   REAL      NOT NULL,
        value     INT,
+       genformat TEXT,
+       gensource TEXT,
        verformat TEXT,
        versource TEXT
 );