1 -- phpwiki 1.3.11 upgrade from 1.3.10
3 -- if ACCESS_LOG_SQL > 0
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);
25 -- and use ?action=upgrade as WIKI_ADMIN then
26 ALTER TABLE page ADD cached_html MEDIUMBLOB;
29 ALTER TABLE session CHANGE sess_ip sess_ip CHAR(40) NOT NULL;