summaryrefslogtreecommitdiffstats
path: root/database/sqlite
diff options
context:
space:
mode:
Diffstat (limited to 'database/sqlite')
-rw-r--r--database/sqlite/eurephiadb-sqlite.c2
-rw-r--r--database/sqlite/sql-schema.sql2
2 files changed, 2 insertions, 2 deletions
diff --git a/database/sqlite/eurephiadb-sqlite.c b/database/sqlite/eurephiadb-sqlite.c
index 67b22f4..1abcfeb 100644
--- a/database/sqlite/eurephiadb-sqlite.c
+++ b/database/sqlite/eurephiadb-sqlite.c
@@ -828,7 +828,7 @@ int eDBdestroy_session(eurephiaCTX *ctx, eurephiaSESSION *session) {
// Update session status
res = sqlite_query(ctx,
"UPDATE openvpn_lastlog "
- " SET sessionstatus = 4, session_del = CURRENT_TIMESTAMP "
+ " SET sessionstatus = 4, session_deleted = CURRENT_TIMESTAMP "
" WHERE sessionkey = '%q' AND sessionstatus = 3", session->sessionkey);
if( res == NULL ) {
eurephia_log(ctx, LOG_CRITICAL, 0,
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index 490669d..b677554 100644
--- a/database/sqlite/sql-schema.sql
+++ b/database/sqlite/sql-schema.sql
@@ -48,7 +48,7 @@ CREATE TABLE openvpn_lastlog (
sessionkey varchar(128) ,
login timestamp ,
logout timestamp ,
- session_del timestamp ,
+ session_deleted timestamp ,
session_duration timestamp,
bytes_sent integer ,
bytes_received integer ,