diff options
Diffstat (limited to 'maintenance/archives/patch-ipb_by_text.sql')
-rw-r--r-- | maintenance/archives/patch-ipb_by_text.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/maintenance/archives/patch-ipb_by_text.sql b/maintenance/archives/patch-ipb_by_text.sql new file mode 100644 index 00000000..c0b620d3 --- /dev/null +++ b/maintenance/archives/patch-ipb_by_text.sql @@ -0,0 +1,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;
\ No newline at end of file |