Add gm set --file test

[gruntmaster-data.git] / db.sql

diff --git a/db.sql b/db.sql
index 44e2420b88fd4ca354e6a9c4e68cf04c98d72c3f..46ddcdb7569e6fa7a84c15f32889d3adb9557af3 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -68,7 +68,7 @@ CREATE TABLE jobs (
        id          SERIAL  PRIMARY KEY,
        contest     TEXT    REFERENCES contests ON DELETE CASCADE,
        daemon      TEXT,
-       date        BIGINT  NOT NULL,
+       date        BIGINT  NOT NULL DEFAULT CAST(EXTRACT(epoch from now()) AS bigint),
        errors      TEXT,
        extension   TEXT    NOT NULL,
        format      TEXT    NOT NULL,
@@ -173,7 +173,7 @@ CREATE OR REPLACE VIEW user_list AS (SELECT
        ORDER BY solved DESC, attempted DESC, id);
 
 CREATE OR REPLACE VIEW contest_entry AS (SELECT
-       id,name,description,editorial,start,stop,owner,
+       id,name,description,start,stop,owner,
        (EXTRACT(epoch from NOW()) >= start) AS started,
        (EXTRACT(epoch from NOW()) >= stop) AS finished
        FROM contests