maintenance/archives/patch-ipb_by_text.sql

   1 -- Adding colomn with username of blocker and sets it.
   2 -- Required for crosswiki blocks.
   3
   4 ALTER TABLE /*$wgDBprefix*/ipblocks
   5         ADD ipb_by_text varbinary(255) NOT NULL default '';
   6
   7 UPDATE /*$wgDBprefix*/ipblocks
   8         JOIN /*$wgDBprefix*/user ON ipb_by = user_id
   9         SET ipb_by_text = user_name
  10         WHERE ipb_by != 0;