From 2bee6c37ddd76e42df87aa6d87b645121c9b3e9c Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Fri, 11 Jul 2025 22:17:24 -0400 Subject: [PATCH] Adjusting emails table --- sql/mailleur.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index fb48f6d..c67489c 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -53,7 +53,9 @@ CREATE TABLE emails ( email TEXTUNIQUE, //User email creation DBTIMESTAMP //record creation DFLT NOW(), - lastupdate DBTIMESTAMP //last record has been update + lastemail DBTIMESTAMP //last email received + DFLT NOW(), + lastscan DBTIMESTAMP //last scaning date DFLT NOW(), password TEXT //user (encrypted) password DFLT '!', -- 2.47.3