1f05cddf9SRui PauloCREATE TABLE users( 2f05cddf9SRui Paulo identity TEXT PRIMARY KEY, 3f05cddf9SRui Paulo methods TEXT, 4f05cddf9SRui Paulo password TEXT, 55b9c547cSRui Paulo remediation TEXT, 6*85732ac8SCy Schubert phase2 INTEGER, 7*85732ac8SCy Schubert t_c_timestamp INTEGER 8f05cddf9SRui Paulo); 9f05cddf9SRui Paulo 10f05cddf9SRui PauloCREATE TABLE wildcards( 11f05cddf9SRui Paulo identity TEXT PRIMARY KEY, 12f05cddf9SRui Paulo methods TEXT 13f05cddf9SRui Paulo); 14f05cddf9SRui Paulo 15f05cddf9SRui PauloINSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); 16f05cddf9SRui PauloINSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); 17f05cddf9SRui Paulo 18f05cddf9SRui PauloINSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); 19f05cddf9SRui PauloINSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); 205b9c547cSRui Paulo 215b9c547cSRui PauloCREATE TABLE authlog( 225b9c547cSRui Paulo timestamp TEXT, 235b9c547cSRui Paulo session TEXT, 245b9c547cSRui Paulo nas_ip TEXT, 255b9c547cSRui Paulo username TEXT, 265b9c547cSRui Paulo note TEXT 275b9c547cSRui Paulo); 28*85732ac8SCy Schubert 29*85732ac8SCy SchubertCREATE TABLE pending_tc( 30*85732ac8SCy Schubert mac_addr TEXT PRIMARY KEY, 31*85732ac8SCy Schubert identity TEXT 32*85732ac8SCy Schubert); 33*85732ac8SCy Schubert 34*85732ac8SCy SchubertCREATE TABLE current_sessions( 35*85732ac8SCy Schubert mac_addr TEXT PRIMARY KEY, 36*85732ac8SCy Schubert identity TEXT, 37*85732ac8SCy Schubert start_time TEXT, 38*85732ac8SCy Schubert nas TEXT, 39*85732ac8SCy Schubert hs20_t_c_filtering BOOLEAN, 40*85732ac8SCy Schubert waiting_coa_ack BOOLEAN, 41*85732ac8SCy Schubert coa_ack_received BOOLEAN 42*85732ac8SCy Schubert); 43