1CREATE TABLE users(
2          identity TEXT PRIMARY KEY,
3          methods TEXT,
4          password TEXT,
5          remediation TEXT,
6          phase2 INTEGER,
7          t_c_timestamp INTEGER
8);
9
10CREATE TABLE wildcards(
11          identity TEXT PRIMARY KEY,
12          methods TEXT
13);
14
15INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
16INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
17
18INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
19INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
20
21CREATE TABLE authlog(
22          timestamp TEXT,
23          session TEXT,
24          nas_ip TEXT,
25          username TEXT,
26          note TEXT
27);
28
29CREATE TABLE pending_tc(
30          mac_addr TEXT PRIMARY KEY,
31          identity TEXT
32);
33
34CREATE TABLE current_sessions(
35          mac_addr TEXT PRIMARY KEY,
36          identity TEXT,
37          start_time TEXT,
38          nas TEXT,
39          hs20_t_c_filtering BOOLEAN,
40          waiting_coa_ack BOOLEAN,
41          coa_ack_received BOOLEAN
42);
43