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
|
create table access_log (
agent varchar(255) not null,
bytes_sent int not null,
child_pid smallint unsigned,
cookie varchar(255),
request_file varchar(255),
referer varchar(255) not null,
remote_host varchar(50) not null,
remote_logname varchar(50) not null,
remote_user varchar(50) not null,
request_duration smallint not null,
request_line varchar(255),
request_method varchar(6) not null,
request_protocol varchar(10) not null,
request_time char(28),
request_uri varchar(50) not null,
server_port smallint unsigned,
ssl_cipher varchar(25),
ssl_keysize smallint unsigned,
ssl_maxkeysize smallint unsigned,
status smallint not null,
time_stamp int unsigned not null,
virtual_host varchar(50) not null
)
|
