From 6eff371018e78925510ff71cb255a64a441a9fc8 Mon Sep 17 00:00:00 2001
From: Christopher Powell <chris@grubbybaby.com>
Date: Mon, 03 Dec 2001 19:54:02 +0000
Subject: Big changes including reworked cookie code, new directives, SSL logging,

new formatting characters, bugfixes, etc.

---
(limited to 'access_log.sql')

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 @@
 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_uri varchar(50) not null,
 	request_duration smallint not null,
-	virtual_host varchar(50) not null,
-	time_stamp int unsigned not null,
+	request_line varchar(255),
+	request_method not null,
+	request_protocol not null,
+	request_time char(28),
+	request_uri varchar(50) not null,
+	server_port smallint unsigned,
+	ssl_cipher varchar(25),
+	ssl_keysize smallint
+	ssl_maxkeysize smallint,
 	status smallint not null,
-	bytes_sent int not null,
-	referer varchar(255) not null,
-	agent varchar(255) not null
+	time_stamp int unsigned not null,
+	virtual_host varchar(50) not null,
 )
 
--
cgit v0.9.2