| yuezonghe | 824eb0c | 2024-06-27 02:32:26 -0700 | [diff] [blame] | 1 | CREATE TABLE users( |
| 2 | identity TEXT PRIMARY KEY, |
| 3 | methods TEXT, |
| 4 | password TEXT, |
| 5 | remediation TEXT, |
| 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'); |
| 19 | |
| 20 | CREATE TABLE authlog( |
| 21 | timestamp TEXT, |
| 22 | session TEXT, |
| 23 | nas_ip TEXT, |
| 24 | username TEXT, |
| 25 | note TEXT |
| 26 | ); |