1e604d861SchristosCREATE TABLE users( 2e604d861Schristos identity TEXT PRIMARY KEY, 3e604d861Schristos methods TEXT, 4e604d861Schristos password TEXT, 53c260e60Schristos remediation TEXT, 6*0a73ee0aSchristos phase2 INTEGER, 7*0a73ee0aSchristos t_c_timestamp INTEGER 8e604d861Schristos); 9e604d861Schristos 10e604d861SchristosCREATE TABLE wildcards( 11e604d861Schristos identity TEXT PRIMARY KEY, 12e604d861Schristos methods TEXT 13e604d861Schristos); 14e604d861Schristos 15e604d861SchristosINSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); 16e604d861SchristosINSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); 17e604d861Schristos 18e604d861SchristosINSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); 19e604d861SchristosINSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); 203c260e60Schristos 213c260e60SchristosCREATE TABLE authlog( 223c260e60Schristos timestamp TEXT, 233c260e60Schristos session TEXT, 243c260e60Schristos nas_ip TEXT, 253c260e60Schristos username TEXT, 263c260e60Schristos note TEXT 273c260e60Schristos); 28*0a73ee0aSchristos 29*0a73ee0aSchristosCREATE TABLE pending_tc( 30*0a73ee0aSchristos mac_addr TEXT PRIMARY KEY, 31*0a73ee0aSchristos identity TEXT 32*0a73ee0aSchristos); 33*0a73ee0aSchristos 34*0a73ee0aSchristosCREATE TABLE current_sessions( 35*0a73ee0aSchristos mac_addr TEXT PRIMARY KEY, 36*0a73ee0aSchristos identity TEXT, 37*0a73ee0aSchristos start_time TEXT, 38*0a73ee0aSchristos nas TEXT, 39*0a73ee0aSchristos hs20_t_c_filtering BOOLEAN, 40*0a73ee0aSchristos waiting_coa_ack BOOLEAN, 41*0a73ee0aSchristos coa_ack_received BOOLEAN 42*0a73ee0aSchristos); 43