| 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, |
| Dmitry Shmidt | f21452a | 2014-02-26 10:55:25 -0800 | [diff] [blame^] | 5 | remediation TEXT, |
| Dmitry Shmidt | d5e4923 | 2012-12-03 15:08:10 -0800 | [diff] [blame] | 6 | phase2 INTEGER |
| 7 | ); |
| 8 | |
| 9 | CREATE TABLE wildcards( |
| 10 | identity TEXT PRIMARY KEY, |
| 11 | methods TEXT |
| 12 | ); |
| 13 | |
| 14 | INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); |
| 15 | INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); |
| 16 | |
| 17 | INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); |
| 18 | INSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); |