1CREATE 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
11CREATE 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
28CREATE index sessions_id_index ON sessions(id);
29
30CREATE TABLE osu_config(
31       realm TEXT,
32       field TEXT,
33       value TEXT
34);
35
36CREATE 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
56CREATE TABLE wildcards(
57	identity TEXT PRIMARY KEY,
58	methods TEXT
59);
60