Added notes logging capability. This is a commit prior to a lot of work

that will rename mod_log_mysql to mod_log_sql.

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 @@
 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) 
 )