1234567891011121314151617181920212223242526 |
- CREATE TABLE users(
- identity TEXT PRIMARY KEY,
- methods TEXT,
- password TEXT,
- remediation TEXT,
- phase2 INTEGER
- );
- CREATE TABLE wildcards(
- identity TEXT PRIMARY KEY,
- methods TEXT
- );
- INSERT INTO users(identity,methods,password,phase2) VALUES ('user','TTLS-MSCHAPV2','password',1);
- INSERT INTO users(identity,methods,password,phase2) VALUES ('DOMAIN\mschapv2 user','TTLS-MSCHAPV2','password',1);
- INSERT INTO wildcards(identity,methods) VALUES ('','TTLS,TLS');
- INSERT INTO wildcards(identity,methods) VALUES ('0','AKA');
- CREATE TABLE authlog(
- timestamp TEXT,
- session TEXT,
- nas_ip TEXT,
- username TEXT,
- note TEXT
- );
|