From aed1f25397eff242228dadb33f934d2722ba684d Mon Sep 17 00:00:00 2001
From: Christopher Powell <chris@grubbybaby.com>
Date: Tue, 14 May 2002 21:47:15 +0000
Subject: Added notes logging capability.  This is a commit prior to a lot of work

that will rename mod_log_mysql to mod_log_sql.

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

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 @@
 create table access_log (
-	agent varchar(255) not null,
-	bytes_sent int not null,
+	agent varchar(255) ,
+	bytes_sent int ,
 	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,
+	referer varchar(255) ,
+	remote_host varchar(50) ,
+	remote_logname varchar(50) ,
+	remote_user varchar(50) ,
+	request_duration smallint ,
 	request_line varchar(255),
-	request_method varchar(6) not null,
-	request_protocol varchar(10) not null,
+	request_method varchar(6) ,
+	request_protocol varchar(10) ,
 	request_time char(28),
-	request_uri varchar(50) not null,
+	request_uri varchar(50) ,
 	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
+	status smallint ,
+	time_stamp int unsigned ,
+	virtual_host varchar(50) 
 )
 
--
cgit v0.9.2