aboutsummaryrefslogtreecommitdiffstats
path: root/hs20
diff options
context:
space:
mode:
authorJouni Malinen <jouni@codeaurora.org>2018-04-30 14:45:13 (GMT)
committerJouni Malinen <j@w1.fi>2018-04-30 17:19:32 (GMT)
commit42f4169166950f823cebef535b0788f9a7c96830 (patch)
tree195a79642445c33bd64f3faa8bab67ca3e47b06c /hs20
parent5bd5eb54d1154baf222baa386461bcf442612a36 (diff)
downloadhostap-42f4169166950f823cebef535b0788f9a7c96830.zip
hostap-42f4169166950f823cebef535b0788f9a7c96830.tar.gz
hostap-42f4169166950f823cebef535b0788f9a7c96830.tar.bz2
HS 2.0: Update server SQL DB initialization to cover new fields
Signed-off-by: Jouni Malinen <jouni@codeaurora.org>
Diffstat (limited to 'hs20')
-rw-r--r--hs20/server/sql.txt16
1 files changed, 15 insertions, 1 deletions
diff --git a/hs20/server/sql.txt b/hs20/server/sql.txt
index 6609538..f5a7355 100644
--- a/hs20/server/sql.txt
+++ b/hs20/server/sql.txt
@@ -50,10 +50,24 @@ CREATE TABLE users(
osu_password TEXT,
shared INTEGER,
cert TEXT,
- cert_pem TEXT
+ cert_pem TEXT,
+ t_c_timestamp INTEGER
);
CREATE TABLE wildcards(
identity TEXT PRIMARY KEY,
methods TEXT
);
+
+CREATE TABLE authlog(
+ timestamp TEXT,
+ session TEXT,
+ nas_ip TEXT,
+ username TEXT,
+ note TEXT
+);
+
+CREATE TABLE pending_tc(
+ mac_addr TEXT PRIMARY KEY,
+ identity TEXT
+);