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