1 ALTER TABLE /*$wgDBprefix*/logging
2 ADD log_user_text
varchar(255) binary NOT NULL default '',
3 ADD log_target_id
int unsigned
NULL,
4 CHANGE `log_type` `log_type`
VARBINARY( 15 ) NOT NULL,
5 CHANGE `log_action` `log_action`
VARBINARY( 15 ) NOT NULL;
7 CREATE INDEX /*i*/user_type_time
ON /*_*/logging (log_user
, log_type
, log_timestamp
);