| Dmitry Shmidt | d5e4923 | 2012-12-03 15:08:10 -0800 | [diff] [blame^] | 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'); |