]>
Commit | Line | Data |
---|---|---|
ee431d77 JM |
1 | CREATE TABLE users( |
2 | identity TEXT PRIMARY KEY, | |
3 | methods TEXT, | |
4 | password TEXT, | |
8d2a9921 | 5 | remediation TEXT, |
45260380 JM |
6 | phase2 INTEGER, |
7 | t_c_timestamp INTEGER | |
ee431d77 JM |
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'); | |
8a57da7e JM |
20 | |
21 | CREATE TABLE authlog( | |
22 | timestamp TEXT, | |
23 | session TEXT, | |
24 | nas_ip TEXT, | |
25 | username TEXT, | |
26 | note TEXT | |
27 | ); | |
04ee197f JM |
28 | |
29 | CREATE TABLE pending_tc( | |
30 | mac_addr TEXT PRIMARY KEY, | |
31 | identity TEXT | |
32 | ); | |
2122fc83 JM |
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 | ); |