summaryrefslogtreecommitdiffstats
path: root/access_log.sql
diff options
context:
space:
mode:
Diffstat (limited to 'access_log.sql')
-rw-r--r--access_log.sql24
1 files changed, 18 insertions, 6 deletions
diff --git a/access_log.sql b/access_log.sql
index c38cb50..46d5a6e 100644
--- a/access_log.sql
+++ b/access_log.sql
@@ -1,13 +1,25 @@
1create table access_log ( 1create table access_log (
2 agent varchar(255) not null,
3 bytes_sent int not null,
4 child_pid smallint unsigned,
5 cookie varchar(255),
6 request_file varchar(255),
7 referer varchar(255) not null,
2 remote_host varchar(50) not null, 8 remote_host varchar(50) not null,
9 remote_logname varchar(50) not null,
3 remote_user varchar(50) not null, 10 remote_user varchar(50) not null,
4 request_uri varchar(50) not null,
5 request_duration smallint not null, 11 request_duration smallint not null,
6 virtual_host varchar(50) not null, 12 request_line varchar(255),
7 time_stamp int unsigned not null, 13 request_method not null,
14 request_protocol not null,
15 request_time char(28),
16 request_uri varchar(50) not null,
17 server_port smallint unsigned,
18 ssl_cipher varchar(25),
19 ssl_keysize smallint
20 ssl_maxkeysize smallint,
8 status smallint not null, 21 status smallint not null,
9 bytes_sent int not null, 22 time_stamp int unsigned not null,
10 referer varchar(255) not null, 23 virtual_host varchar(50) not null,
11 agent varchar(255) not null
12) 24)
13 25