maintenance/archives/patch-ipb_by_text.sql


1
2
3
4
5
6
7
8
9
10

-- Adding colomn with username of blocker and sets it.
-- Required for crosswiki blocks.

ALTER TABLE /*$wgDBprefix*/ipblocks
	ADD ipb_by_text varchar(255) binary NOT NULL default '';

UPDATE /*$wgDBprefix*/ipblocks
	JOIN /*$wgDBprefix*/user ON ipb_by = user_id
	SET ipb_by_text = user_name
	WHERE ipb_by != 0;