From 5cc71db92febbbf8b7de67a883608efea0db3477 Mon Sep 17 00:00:00 2001 From: Marius Gavrilescu Date: Sun, 12 Apr 2015 18:16:55 +0300 Subject: [PATCH] Default job date to NOW() --- db.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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, -- 2.39.2