From 3a1e17ca0380d76b29b98ab2a59022f4303da633 Mon Sep 17 00:00:00 2001 From: Magnus Hagander Date: Mon, 3 Dec 2018 16:18:21 +0100 Subject: [PATCH] Track load date of messages --- loader/sql/schema.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/loader/sql/schema.sql b/loader/sql/schema.sql index a360129..d9b5d5f 100644 --- a/loader/sql/schema.sql +++ b/loader/sql/schema.sql @@ -11,6 +11,7 @@ CREATE TABLE messages ( cc text NOT NULL, subject text NOT NULL, date timestamptz NOT NULL, + loaddate timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP, has_attachment boolean NOT NULL, hiddenstatus int NULL, messageid text NOT NULL, -- 2.39.5