1 CREATE TABLE eventlog( 2 user TEXT, 3 realm TEXT, 4 sessionid TEXT COLLATE NOCASE, 5 timestamp TEXT, 6 notes TEXT, 7 dump TEXT, 8 addr TEXT 9 ); 10 11 CREATE TABLE sessions( 12 timestamp TEXT, 13 id TEXT COLLATE NOCASE, 14 user TEXT, 15 realm TEXT, 16 password TEXT, 17 machine_managed BOOLEAN, 18 operation INTEGER, 19 type TEXT, 20 pps TEXT, 21 redirect_uri TEXT, 22 devinfo TEXT, 23 devdetail TEXT, 24 cert TEXT, 25 cert_pem TEXT 26 ); 27 28 CREATE index sessions_id_index ON sessions(id); 29 30 CREATE TABLE osu_config( 31 realm TEXT, 32 field TEXT, 33 value TEXT 34 ); 35 36 CREATE TABLE users( 37 identity TEXT PRIMARY KEY, 38 methods TEXT, 39 password TEXT, 40 machine_managed BOOLEAN, 41 remediation TEXT, 42 phase2 INTEGER, 43 realm TEXT, 44 policy TEXT, 45 devinfo TEXT, 46 devdetail TEXT, 47 pps TEXT, 48 fetch_pps INTEGER, 49 osu_user TEXT, 50 osu_password TEXT, 51 shared INTEGER, 52 cert TEXT, 53 cert_pem TEXT 54 ); 55 56 CREATE TABLE wildcards( 57 identity TEXT PRIMARY KEY, 58 methods TEXT 59 ); 60
