summaryrefslogtreecommitdiffstats
path: root/access_log.sql
diff options
context:
space:
mode:
authorGravatar Christopher Powell 2001-12-03 19:54:02 +0000
committerGravatar Christopher Powell 2001-12-03 19:54:02 +0000
commit6eff371018e78925510ff71cb255a64a441a9fc8 (patch)
tree3dc78ec12b8cc45ef79528d4ed271eef8129b410 /access_log.sql
parent69fa0ad0d21465573b9dcb07c87ae27f993dfe31 (diff)
Big changes including reworked cookie code, new directives, SSL logging,
new formatting characters, bugfixes, etc.
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