diff options
Diffstat (limited to 'database/sqlite/sql-schema.sql')
| -rw-r--r-- | database/sqlite/sql-schema.sql | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/database/sqlite/sql-schema.sql b/database/sqlite/sql-schema.sql index 581aaac..6d2befb 100644 --- a/database/sqlite/sql-schema.sql +++ b/database/sqlite/sql-schema.sql @@ -1,7 +1,7 @@ -- -- eurephia database schema for SQLite3 -- --- GPLv2 only - Copyright (C) 2008 - 2010 +-- GPLv2 only - Copyright (C) 2008 - 2012 -- David Sommerseth <dazo@users.sourceforge.net> -- -- This program is free software; you can redistribute it and/or @@ -72,6 +72,7 @@ CREATE TABLE openvpn_lastlog ( 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 , @@ -84,16 +85,18 @@ CREATE TABLE openvpn_lastlog ( ); CREATE UNIQUE INDEX openvpn_lastlog_sessionkey ON openvpn_lastlog(sessionkey); --- openvpn_macaddr_history - This keeps an overview over which MAC addresses a session --- have used, in case the client changes the MAC address. -CREATE TABLE openvpn_macaddr_history ( +-- openvpn_vpnaddr_history - This keeps an overview over which VPN client addresses +-- a session have used, in case the client changes the address. +CREATE TABLE openvpn_vpnaddr_history ( sessionkey varchar(64) NOT NULL, macaddr varchar(20) NOT NULL, + ip4addr varchar(32) , + ip6addr varchar(48) , registered timestamp DEFAULT CURRENT_TIMESTAMP, semaid integer PRIMARY KEY AUTOINCREMENT ); -CREATE INDEX openvpn_macaddr_hist_sessionkey ON openvpn_macaddr_history(sessionkey); -CREATE INDEX openvpn_macaddr_hist_macaddr ON openvpn_macaddr_history(macaddr); +CREATE INDEX openvpn_vpnaddr_hist_sessionkey ON openvpn_vpnaddr_history(sessionkey); +CREATE INDEX openvpn_vpnaddr_hist_macaddr ON openvpn_vpnaddr_history(macaddr); -- openvpn_sessions - A little storage of variables needed by eurephia to keep track -- of all the sessions |