| Dmitry Shmidt | df5a7e4 | 2014-04-02 12:59:59 -0700 | [diff] [blame^] | 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 | ); |