[Summary view] [Print] [Text view]

   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 varchar(255) binary 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;