From bba6e435e032e665dc8c7d86c034b361bf93def4 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Fri, 11 Jul 2025 22:15:32 -0400 Subject: [PATCH] Adding lastupdate to user email record --- conf/mailleur.conf.dvl | 2 +- sql/mailleur.sql | 4 +++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/conf/mailleur.conf.dvl b/conf/mailleur.conf.dvl index 81240f3..43ca12d 100644 --- a/conf/mailleur.conf.dvl +++ b/conf/mailleur.conf.dvl @@ -7,7 +7,7 @@ APPNAME=mailleur ROOTBASE="/home/jmp/safe-mailleur/mailleur/test_area/" #defining local default domain DFLTDOMAIN="example.com" -#defineing the local REALM +#defining the local REALM #Caution! the realm is hardcoded within data-base #and USED too to hash the user passwd #Changing this value coule be a trouble make diff --git a/sql/mailleur.sql b/sql/mailleur.sql index daaacf5..fb48f6d 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -50,9 +50,11 @@ /********************************************************/ //table to define LOCAL USER CREATE TABLE emails ( + email TEXTUNIQUE, //User email creation DBTIMESTAMP //record creation DFLT NOW(), - email TEXTUNIQUE, //User email + lastupdate DBTIMESTAMP //last record has been update + DFLT NOW(), password TEXT //user (encrypted) password DFLT '!', hash TEXT, //'email:realm:password' MD5 -- 2.47.3