From e9a5aa2f191aa983bd4cdca6ddd6e184bce02e16 Mon Sep 17 00:00:00 2001 From: "Jean-Marc Pigeon (Delson)" Date: Sun, 27 Jul 2025 10:24:33 -0400 Subject: [PATCH] Adding the events table --- sql/mailleur.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/sql/mailleur.sql b/sql/mailleur.sql index cc5b8bf..f0a21cb 100644 --- a/sql/mailleur.sql +++ b/sql/mailleur.sql @@ -120,6 +120,17 @@ CREATE INDEX remotes_ndx ON remotes(lastscan,lastupdate); INSERT INTO remotes (remoteip,credit,lastscan) \ values ('127.0.0.1',99,now()); +//defining table about eventlog reference +CREATE TABLE events ( + creation DBTIMESTAMP //record creation + DFLT NOW(), + sessid TEXTUNIQUE, //Session id + start INTEGER, //Event log starting point + stop INTEGER //Event log ending point + ); +CREATE INDEX event_id_ndx ON events(sessid); +CREATE INDEX event_date_ndx ON events(creation); + //-------------------------------------------------------------- //Defining TRIGGER fonctions according database type //-------------------------------------------------------------- -- 2.47.3