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