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