X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=46ddcdb7569e6fa7a84c15f32889d3adb9557af3;hb=f2005eb5cd6724b2001750178f752e18d8bb6452;hp=44e2420b88fd4ca354e6a9c4e68cf04c98d72c3f;hpb=cc6974a9fd40c60cc99785615b2b2d1e80ab91c6;p=gruntmaster-data.git

diff --git a/db.sql b/db.sql
index 44e2420..46ddcdb 100644
--- 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