X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=46ddcdb7569e6fa7a84c15f32889d3adb9557af3;hb=5cc71db92febbbf8b7de67a883608efea0db3477;hp=d2f658e03f979a8b90ba7942aba685ad67203bc0;hpb=686bacca70a42bb30472d8d1db02ed8ce77fda4d;p=gruntmaster-data.git

diff --git a/db.sql b/db.sql
index d2f658e..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,