From 40e66aed101e5a448fe012f24abe33d15a68cee9 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Tue, 25 Dec 2012 22:08:53 +0100
Subject: Added a new eDBregister_login2() to replace eDBregister_login()
 database function

This will save the access profile in the lastlog table.  However, it will not save
the VPN IP address and netmask any more.  This should be saved in the vpnaddr_history
table, using the eDBregister_vpnclientaddr() function.

eDBregister_login() is now just a wrapper around the eDBregister_login2(), ignoring
the access profile id and VPN addresses.  This exists purely as a compatibility layer
if the updated driver is used against an older eurephia-auth.so plug-in.

Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
---
 database/sqlite/sql-schema.sql | 5 +----
 1 file changed, 1 insertion(+), 4 deletions(-)

(limited to 'database/sqlite/sql-schema.sql')

diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql
index 6d2befb..4d05222 100644
--- a/database/sqlite/sql-schema.sql
+++ b/database/sqlite/sql-schema.sql
@@ -66,13 +66,10 @@ CREATE TABLE openvpn_accesses (
 CREATE TABLE openvpn_lastlog (
        uid              integer      ,
        certid           integer      ,
+       accessprofile    integer      ,
        protocol         varchar(4)   NOT NULL,
        remotehost       varchar(128) NOT NULL,
        remoteport       integer      NOT NULL,
-       macaddr          varchar(20)  ,
-       vpnipaddr        varchar(32)  NOT NULL,
-       vpnipmask        varchar(32)  NOT NULL,
-       vpnipv6addr      varchar(48)  ,
        sessionstatus    integer      NOT NULL DEFAULT 0,
        sessionkey       varchar(128) ,
        login            timestamp    ,
-- 
cgit 

