maintenance/archives/patch-log_user_text.sql

   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;
   6
   7 CREATE INDEX /*i*/user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);