1 CREATE TABLE users( 2 identity TEXT PRIMARY KEY, 3 methods TEXT, 4 password TEXT, 5 phase2 INTEGER 6 ); 7 8 CREATE TABLE wildcards( 9 identity TEXT PRIMARY KEY, 10 methods TEXT 11 ); 12 13 INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); 14 INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); 15 16 INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); 17 INSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); 18