From be0efb3fb0fb17a21fba739fb2e5d6987fd7ac5c Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Fri, 27 Jun 2025 11:48:56 -0400 Subject: [PATCH] Starting to have sessions table --- lib/unisql.h | 1 + sql/mailleur.sql | 12 ++++++++++++ 2 files changed, 13 insertions(+) diff --git a/lib/unisql.h b/lib/unisql.h index 273319e..2f8bee9 100644 --- a/lib/unisql.h +++ b/lib/unisql.h @@ -11,6 +11,7 @@ typedef enum { sql_select, //select a record + sql_insert, //create a record sql_update, //update a record sql_delete, //delete a record sql_uknown //No action diff --git a/sql/mailleur.sql b/sql/mailleur.sql index 51a6bc5..de7edb3 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -48,6 +48,7 @@ /* User available email definition table */ /* */ /********************************************************/ +//table to define LOCAL user CREATE TABLE emails ( email TEXTUNIQUE, //User email password TEXT //User password @@ -61,3 +62,14 @@ CREATE TABLE emails ( ); GRANT SELECT,INSERT,UPDATE,DELETE ON emails TO mailapache; GRANT SELECT ON emails TO maildove; + + +//table about session +CREATE TABLE sessions ( + sessid TEXTUNIQUE, //Session id + sessfrom TEXT, //The session from + emailfrom TEXT, //The from within the email itself + taille INTEGER //The email size + DFLT 0 + ); +GRANT SELECT ON sessions TO mailapache; -- 2.47.3