This somewhat looks familiar. Kind of like what's on page 364 of "Writing Apache Modules with Perl and C" - A DBI Database Logger. Must be the table.
create table access_log (
`when` datetime not null,
host varchar(255) not null,
method varchar(4) not null,
url varchar(255) not null,
auth varchar(50),
referer varchar(255),
status smallint(3) default 0,
bytes int(8)
);
Yields:
+---------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------------------+-------+
| when | datetime | | | 0000-00-00 00:00:00 | |
| host | varchar(255) | | | | |
| method | varchar(4) | | | | |
| url | varchar(255) | | | | |
| auth | varchar(50) | YES | | NULL | |
| referer | varchar(255) | YES | | NULL | |
| status | smallint(3) | YES | | 0 | |
| bytes | int(8) | YES | | NULL | |
+---------+--------------+------+-----+---------------------+-------+
Note: since
when is a reserved word in MySQL you'll have to escape it with backticks. This isn't explained in the Eagle book.
This is a good tutorial. However, please give credit where its due if you used a book or another article as a reference to write it.
BMaximus