1CREATE TABLE users(
2	identity TEXT PRIMARY KEY,
3	methods TEXT,
4	password TEXT,
5	remediation TEXT,
6	phase2 INTEGER
7);
8
9CREATE TABLE wildcards(
10	identity TEXT PRIMARY KEY,
11	methods TEXT
12);
13
14INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
15INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
16
17INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
18INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
19
20CREATE TABLE authlog(
21	timestamp TEXT,
22	session TEXT,
23	nas_ip TEXT,
24	username TEXT,
25	note TEXT
26);
27