Add a "solution" column to problem

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index 0daf3477ae3b7a08045a56c067ef1e6c5b663d6e..1556202076909318c6718fc10d3189caeac78a28 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -32,6 +32,7 @@ CREATE TABLE problems (
        owner     TEXT    NOT NULL REFERENCES users ON DELETE CASCADE,
        private   BOOLEAN NOT NULL DEFAULT FALSE,
        runner    TEXT    NOT NULL,
        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,
        statement TEXT    NOT NULL,
        testcnt   INT     NOT NULL,
        tests     TEXT,