Fixed bug: timestamp in context table gets current server time as default.

1 files changed, 1 insertions, 1 deletions

diff --git a/database/scripts/tabledefs.sql b/database/scripts/tabledefs.sql
index 9d1fb2c..1964011 100644
--- a/database/scripts/tabledefs.sql
+++ b/database/scripts/tabledefs.sql
@@ -12,7 +12,7 @@ CREATE TABLE context
     sha1Id BIGINT NOT NULL REFERENCES sha1 ON DELETE CASCADE,
 
     -- Timestamp: (approximated with earliest known startTime)
-    timestamp TIMESTAMP NOT NULL,
+    timestamp TIMESTAMP NOT NULL DEFAULT now(),
 
     UNIQUE(hostId, platformId, branchId, sha1Id)
 ) WITH (OIDS=FALSE);