summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-ipb_by_text.sql
blob: c0b620d3383397aa60d791100423526de24b4539 (plain)
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;