Make redis-to-postgres also copy problems which are only in a contest

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index eafd89ed66f0f79870200ef168a763e3a3e744c8..3a43eb5c99b0747c69acfea559de6cf99e50aece 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -25,7 +25,7 @@ CREATE TABLE contests (
 
 CREATE TABLE problems (
        id        TEXT      PRIMARY KEY,
-       author    TEXT      NOT NULL,
+       author    TEXT,
        generator GENERATOR NOT NULL,
        judge     JUDGE     NOT NULL,
        level     PLEVEL    NOT NULL,
@@ -61,7 +61,7 @@ CREATE TABLE jobs (
        problem     TEXT    NOT NULL REFERENCES problems,
        result      INT,
        result_text TEXT,
-       results     JSON,
+       results     TEXT,
        source      TEXT    NOT NULL,
        owner       TEXT    NOT NULL REFERENCES users
 );