summaryrefslogtreecommitdiffstats
path: root/database/scripts/tabledefs.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database/scripts/tabledefs.sql')
-rw-r--r--database/scripts/tabledefs.sql2
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);