1 ALTER TABLE /*$wgDBprefix*/logging
2 ADD log_user_text
varchar(255) binary NOT NULL default '',
3 ADD log_page
int unsigned
NULL,
4 CHANGE log_type log_type
varbinary(32) NOT NULL,
5 CHANGE log_action log_action
varbinary(32) NOT NULL;
7 CREATE INDEX /*i*/log_user_type_time
ON /*_*/logging (log_user
, log_type
, log_timestamp
);
8 CREATE INDEX /*i*/log_page_id_time
ON /*_*/logging (log_page
,log_timestamp
);