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