diff options
author | David Sommerseth <dazo@users.sourceforge.net> | 2008-09-19 14:30:27 +0200 |
---|---|---|
committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-09-19 14:30:27 +0200 |
commit | 9e938792700fe96bf714efca5c234c0aeab44a91 (patch) | |
tree | 3397a2f5f2d8254adabfee4e7b9d124bd6f16b6f /database | |
parent | 832829e2ec3ba315fee14ac81198e46cb0a1c565 (diff) | |
download | eurephia-9e938792700fe96bf714efca5c234c0aeab44a91.tar.gz eurephia-9e938792700fe96bf714efca5c234c0aeab44a91.tar.xz eurephia-9e938792700fe96bf714efca5c234c0aeab44a91.zip |
Renamed openvpn_lastlog.session_del to session_deleted
Diffstat (limited to 'database')
-rw-r--r-- | database/eurephiadb-driver_template.c | 2 | ||||
-rw-r--r-- | database/sqlite/eurephiadb-sqlite.c | 2 | ||||
-rw-r--r-- | database/sqlite/sql-schema.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/database/eurephiadb-driver_template.c b/database/eurephiadb-driver_template.c index 8f04268..b44c833 100644 --- a/database/eurephiadb-driver_template.c +++ b/database/eurephiadb-driver_template.c @@ -779,7 +779,7 @@ int eDBdestroy_session(eurephiaCTX *ctx, const char *macaddr) // 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 sesskey = '%s' AND sessionstatus = 3", skey); if( res == NULL ) { eurephia_log(ctx, LOG_CRITICAL, 0, 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 , |