From a782579fe9c7ff2d65bea78077b884afef03e8b1 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Sun, 29 Jun 2025 12:53:39 -0400 Subject: [PATCH] Adding creation field within table (to allow easy rotate log) --- sql/mailleur.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index 130693d..ed22b2f 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -50,6 +50,8 @@ /********************************************************/ //table to define LOCAL user CREATE TABLE emails ( + creation DBTIMESTAMP //record creation + DFLT NOW(), email TEXTUNIQUE, //User email password TEXT //User password DFLT '!', @@ -66,6 +68,8 @@ GRANT SELECT ON emails TO maildove; //table about session CREATE TABLE sessions ( + creation DBTIMESTAMP //record creation + DFLT NOW(), sessid TEXTUNIQUE, //Session id sesstitle TEXT, //The session email title sessfrom TEXT, //The session from @@ -76,3 +80,15 @@ CREATE TABLE sessions ( DFLT 'NULL' ); GRANT SELECT ON sessions TO mailapache; + +//table about recipient email information +//summerize all emails recived status according sessions and recipient +CREATE TABLE infos ( + creation DBTIMESTAMP //record creation + DFLT NOW(), + sessid TEXT, //Session id + rcptto text, //Recipient status + numline INTEGER, //status line + info TEXT //line info + ); +GRANT SELECT ON sessions TO mailapache; -- 2.47.3