summaryrefslogtreecommitdiffstats
path: root/access_log.sql
diff options
context:
space:
mode:
authorGravatar Christopher Powell 2002-05-14 21:47:15 +0000
committerGravatar Christopher Powell 2002-05-14 21:47:15 +0000
commitaed1f25397eff242228dadb33f934d2722ba684d (patch)
tree37a784d4de9562c611c7d70f271f83d9c32ff299 /access_log.sql
parent3a3c68117e1fdb7814815568a39b042b92b4df5d (diff)
Added notes logging capability. This is a commit prior to a lot of work
that will rename mod_log_mysql to mod_log_sql.
Diffstat (limited to 'access_log.sql')
-rw-r--r--access_log.sql26
1 files changed, 13 insertions, 13 deletions
diff --git a/access_log.sql b/access_log.sql
index a667494..4966c62 100644
--- a/access_log.sql
+++ b/access_log.sql
@@ -1,25 +1,25 @@
1create table access_log ( 1create table access_log (
2 agent varchar(255) not null, 2 agent varchar(255) ,
3 bytes_sent int not null, 3 bytes_sent int ,
4 child_pid smallint unsigned, 4 child_pid smallint unsigned,
5 cookie varchar(255), 5 cookie varchar(255),
6 request_file varchar(255), 6 request_file varchar(255),
7 referer varchar(255) not null, 7 referer varchar(255) ,
8 remote_host varchar(50) not null, 8 remote_host varchar(50) ,
9 remote_logname varchar(50) not null, 9 remote_logname varchar(50) ,
10 remote_user varchar(50) not null, 10 remote_user varchar(50) ,
11 request_duration smallint not null, 11 request_duration smallint ,
12 request_line varchar(255), 12 request_line varchar(255),
13 request_method varchar(6) not null, 13 request_method varchar(6) ,
14 request_protocol varchar(10) not null, 14 request_protocol varchar(10) ,
15 request_time char(28), 15 request_time char(28),
16 request_uri varchar(50) not null, 16 request_uri varchar(50) ,
17 server_port smallint unsigned, 17 server_port smallint unsigned,
18 ssl_cipher varchar(25), 18 ssl_cipher varchar(25),
19 ssl_keysize smallint unsigned, 19 ssl_keysize smallint unsigned,
20 ssl_maxkeysize smallint unsigned, 20 ssl_maxkeysize smallint unsigned,
21 status smallint not null, 21 status smallint ,
22 time_stamp int unsigned not null, 22 time_stamp int unsigned ,
23 virtual_host varchar(50) not null 23 virtual_host varchar(50)
24) 24)
25 25