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