From: Marius Gavrilescu <marius@ieval.ro>
Date: Sun, 12 Apr 2015 15:16:55 +0000 (+0300)
Subject: Default job date to NOW()
X-Git-Tag: 5999.000_014~24
X-Git-Url: http://git.ieval.ro/?p=gruntmaster-data.git;a=commitdiff_plain;h=5cc71db92febbbf8b7de67a883608efea0db3477

Default job date to NOW()
---

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,