X-Git-Url: http://git.ieval.ro/?a=blobdiff_plain;f=db.sql;h=46ddcdb7569e6fa7a84c15f32889d3adb9557af3;hb=f2005eb5cd6724b2001750178f752e18d8bb6452;hp=d2f658e03f979a8b90ba7942aba685ad67203bc0;hpb=89dadd7b183137904770e9d40121263680f789de;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,