1 CREATE 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 10 CREATE TABLE wildcards( 11 identity TEXT PRIMARY KEY, 12 methods TEXT 13 ); 14 15 INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); 16 INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); 17 18 INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); 19 INSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); 20 21 CREATE TABLE authlog( 22 timestamp TEXT, 23 session TEXT, 24 nas_ip TEXT, 25 username TEXT, 26 note TEXT 27 ); 28 29 CREATE TABLE pending_tc( 30 mac_addr TEXT PRIMARY KEY, 31 identity TEXT 32 ); 33 34 CREATE 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
