1e5b75505Sopenharmony_ciCREATE TABLE users( 2e5b75505Sopenharmony_ci identity TEXT PRIMARY KEY, 3e5b75505Sopenharmony_ci methods TEXT, 4e5b75505Sopenharmony_ci password TEXT, 5e5b75505Sopenharmony_ci remediation TEXT, 6e5b75505Sopenharmony_ci phase2 INTEGER, 7e5b75505Sopenharmony_ci t_c_timestamp INTEGER 8e5b75505Sopenharmony_ci); 9e5b75505Sopenharmony_ci 10e5b75505Sopenharmony_ciCREATE TABLE wildcards( 11e5b75505Sopenharmony_ci identity TEXT PRIMARY KEY, 12e5b75505Sopenharmony_ci methods TEXT 13e5b75505Sopenharmony_ci); 14e5b75505Sopenharmony_ci 15e5b75505Sopenharmony_ciINSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); 16e5b75505Sopenharmony_ciINSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); 17e5b75505Sopenharmony_ci 18e5b75505Sopenharmony_ciINSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); 19e5b75505Sopenharmony_ciINSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); 20e5b75505Sopenharmony_ci 21e5b75505Sopenharmony_ciCREATE TABLE authlog( 22e5b75505Sopenharmony_ci timestamp TEXT, 23e5b75505Sopenharmony_ci session TEXT, 24e5b75505Sopenharmony_ci nas_ip TEXT, 25e5b75505Sopenharmony_ci username TEXT, 26e5b75505Sopenharmony_ci note TEXT 27e5b75505Sopenharmony_ci); 28e5b75505Sopenharmony_ci 29e5b75505Sopenharmony_ciCREATE TABLE pending_tc( 30e5b75505Sopenharmony_ci mac_addr TEXT PRIMARY KEY, 31e5b75505Sopenharmony_ci identity TEXT 32e5b75505Sopenharmony_ci); 33e5b75505Sopenharmony_ci 34e5b75505Sopenharmony_ciCREATE TABLE current_sessions( 35e5b75505Sopenharmony_ci mac_addr TEXT PRIMARY KEY, 36e5b75505Sopenharmony_ci identity TEXT, 37e5b75505Sopenharmony_ci start_time TEXT, 38e5b75505Sopenharmony_ci nas TEXT, 39e5b75505Sopenharmony_ci hs20_t_c_filtering BOOLEAN, 40e5b75505Sopenharmony_ci waiting_coa_ack BOOLEAN, 41e5b75505Sopenharmony_ci coa_ack_received BOOLEAN 42e5b75505Sopenharmony_ci); 43