Add the solution to pb_entry when not in contest

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index d06521796abc8adeb0df656d78490520dc21e9f7..1556202076909318c6718fc10d3189caeac78a28 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -32,11 +32,12 @@ CREATE TABLE problems (
        owner     TEXT    NOT NULL REFERENCES users ON DELETE CASCADE,
        private   BOOLEAN NOT NULL DEFAULT FALSE,
        runner    TEXT    NOT NULL,
+       solution  TEXT ,
        statement TEXT    NOT NULL,
        testcnt   INT     NOT NULL,
        tests     TEXT,
        timeout   REAL    NOT NULL,
-       value     INT,
+       value     INT     NOT NULL,
        genformat TEXT,
        gensource TEXT,
        verformat TEXT,