1 -- $Id: mysql-1_3_11.sql,v 1.5 2005-06-21 05:59:18 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);
26 -- and use ?action=upgrade as WIKI_ADMIN then
27 ALTER TABLE page ADD cached_html MEDIUMBLOB;
30 ALTER TABLE session CHANGE sess_ip sess_ip CHAR(40) NOT NULL;