summaryrefslogtreecommitdiffstats
path: root/database/sqlite/sql-schema.sql
Commit message (Collapse)AuthorAgeFilesLines
* Added a new eDBregister_login2() to replace eDBregister_login() database ↵David Sommerseth2012-12-261-4/+1
| | | | | | | | | | | | | | 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>
* sqlite3: Implement eDBregister_vpnclientaddr()David Sommerseth2012-09-131-6/+9
| | | | | | | | | | | | | This commit implements the eDBregister_vpnclientaddr() needed by the newer eurephia-auth plug-in. This is needed to improve the tun support in eurephia. In addition, this also updates the SQL schema to include IPv4 and in the future IPv6 addresses in the lastlog and VPN address history (openvpn_vpnaddr_history). The old openvpn_macaddr_history table is deprecated. Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
* Updated Copyright dates to include 2010David Sommerseth2010-07-301-1/+1
|
* Updated copyright info in the SQLite3 SQL schema fileDavid Sommerseth2009-09-021-2/+17
|
* Added more comments to the SQLite3 database schemaDavid Sommerseth2009-09-021-7/+38
|
* Made the licence explicit GPLv2 onlyDavid Sommerseth2009-03-261-1/+1
|
* Cleaned up the code a little bitDavid Sommerseth2009-03-261-0/+6
| | | | | Made sure we only include needed include files and checked that the copyright headers are equal and correct
* Enhanced the access control by introducing access levelsDavid Sommerseth2008-12-021-1/+7
|
* Login seems to work from database driver sideDavid Sommerseth2008-11-291-0/+14
|
* BUGFIX: Changed SQLite database schema to allow mulitple identical sessionseedsDavid Sommerseth2008-09-261-1/+2
| | | | | | | | | This is to comply to the new behaviour after commit fc8a177bc86fc7e68b15045ba7a791e2504f4b5c. Now we might get several identical session seeds, but some of them might be connected to sessions getting destroyed, while one of them would be connected to an already active session. sessionkey is now the primary key.
* Renamed openvpn_lastlog.session_del to session_deletedDavid Sommerseth2008-09-191-1/+1
|
* Added (untested) logging of time_duration into openvpn_lastlog.session_durationDavid Sommerseth2008-09-191-16/+17
|
* Added (untested) logging of VPN MAC addresses into openvpn_macaddr_historyDavid Sommerseth2008-09-191-0/+9
|
* Changed from SHA1 hash to SHA512.David Sommerseth2008-08-211-3/+3
| | | | | | | | | | | Using code from the SourceForge.net project: sha https://sourceforge.net/projects/sha/ Written by Allan Saddi. Wrote today to the developer and asked for permission to include sha512.[ch] under the BSD licence in this GPLv2 project. If it is denied, I'll need to find another SHA512 implementation.
* Renamed database column from sesskey to sessionkeyDavid Sommerseth2008-08-071-5/+5
|
* Imported eurephia into gitDavid Sommerseth2008-08-061-0/+105
generated by cgit (git 2.34.1) at 2026-01-11 22:43:57 +0000