| 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'); |
| Dmitry Shmidt | 818ea48 | 2014-03-10 13:15:21 -0700 | [diff] [blame] | 19 | |
| 20 | CREATE TABLE authlog( |
| 21 | timestamp TEXT, |
| 22 | session TEXT, |
| 23 | nas_ip TEXT, |
| 24 | username TEXT, |
| 25 | note TEXT |
| 26 | ); |