summaryrefslogtreecommitdiffstats
path: root/create_tables.sql
blob: 0266b527fae05df1dedd930ea3c54511467c01b6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
create table access_log (
	id char(19) ,
	agent varchar(255) ,
	bytes_sent int unsigned ,
	child_pid smallint unsigned,
	cookie varchar(255),
	machine_id varchar(25),
	request_file varchar(255),
	referer varchar(255) ,
	remote_host varchar(50) ,
	remote_logname varchar(50) ,
	remote_user varchar(50) ,
	request_duration smallint unsigned ,
	request_line varchar(255),
	request_method varchar(10) ,
	request_protocol varchar(10) ,
	request_time char(28),
	request_uri varchar(255),
	request_args varchar(255),
	server_port smallint unsigned,
	ssl_cipher varchar(25),
	ssl_keysize smallint unsigned,
	ssl_maxkeysize smallint unsigned,
	status smallint unsigned ,
	time_stamp int unsigned ,
	virtual_host varchar(50)
);

create table notes (
    id char(19),
    item varchar(80),
    val varchar(80)
);

create table headers_in (
    id char(19),
    item varchar(80),
    val varchar(80)
);

create table headers_out (
    id char(19),
    item varchar(80),
    val varchar(80)
);

create table cookies (
    id char(19),
    item varchar(80),
    val varchar(80)
);