Added new task: Log MAC addresses per session into db table

1 files changed, 12 insertions, 0 deletions

diff --git a/TODO b/TODO
index 12af85e..f4686d0 100644
--- a/TODO
+++ b/TODO
@@ -13,6 +13,18 @@
    - Needs probably to be an own thread with root permission and a
      socket to send ADD/DELETE commands
 
+* Logg MACaddresses per session into openvpn_macaddr_history
+   - Can change during a session
+      CREATE TABLE openvpn_macaddr_history (
+             sessionkey varchar(64)  NOT NULL,
+             macaddr    varchar(20)  NOT NULL,
+             registered timestamp    DEFAULT CURRENT_TIMESTAMP,
+             semaid     integer      PRIMARY KEY AUTOINCREMENT,
+             KEY(sessionkey),
+             KEY(macaddr)
+      );
+    - Add insert in database/sqlite/eurphia-sqlite.c -- eDBregister_vpnaddr(...)
+
 * Write admin program
    - Add / Delete / Modify users
    - Add / Delete / Modify certificates (by loading the certfile)