1 -- $Id: mysql-1_3_11.sql,v 1.3 2005-02-07 15:18:52 rurban Exp $
2 -- phpwiki 1.3.11 upgrade from 1.3.10
4 -- only if you need fast log-analysis (spam prevention, recent referrers)
5 -- see http://www.outoforder.cc/projects/apache/mod_log_sql/docs-2.0/#id2756178
6 CREATE TABLE accesslog (
7 time_stamp int unsigned,
8 remote_host varchar(50),
9 remote_user varchar(50),
10 request_method varchar(10),
11 request_line varchar(255),
12 request_args varchar(255),
13 request_file varchar(255),
14 request_uri varchar(255),
15 request_time char(28),
16 status smallint unsigned,
17 bytes_sent smallint unsigned,
20 request_duration float
22 CREATE INDEX log_time ON accesslog (time_stamp);
23 CREATE INDEX log_host ON accesslog (remote_host);