| 1 |
CREATE TABLE users( |
| 2 |
identity TEXT PRIMARY KEY, |
| 3 |
methods TEXT, |
| 4 |
password TEXT, |
| 5 |
remediation TEXT, |
| 6 |
phase2 INTEGER, |
| 7 |
t_c_timestamp INTEGER |
| 8 |
); |
| 9 |
|
| 10 |
CREATE TABLE wildcards( |
| 11 |
identity TEXT PRIMARY KEY, |
| 12 |
methods TEXT |
| 13 |
); |
| 14 |
|
| 15 |
INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1); |
| 16 |
INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1); |
| 17 |
|
| 18 |
INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS'); |
| 19 |
INSERT INTO wildcards(identity,methods) VALUES ('0','AKA'); |
| 20 |
|
| 21 |
CREATE TABLE authlog( |
| 22 |
timestamp TEXT, |
| 23 |
session TEXT, |
| 24 |
nas_ip TEXT, |
| 25 |
username TEXT, |
| 26 |
note TEXT |
| 27 |
); |
| 28 |
|
| 29 |
CREATE TABLE pending_tc( |
| 30 |
mac_addr TEXT PRIMARY KEY, |
| 31 |
identity TEXT |
| 32 |
); |
| 33 |
|
| 34 |
CREATE TABLE current_sessions( |
| 35 |
mac_addr TEXT PRIMARY KEY, |
| 36 |
identity TEXT, |
| 37 |
start_time TEXT, |
| 38 |
nas TEXT, |
| 39 |
hs20_t_c_filtering BOOLEAN, |
| 40 |
waiting_coa_ack BOOLEAN, |
| 41 |
coa_ack_received BOOLEAN |
| 42 |
); |