summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-ipb_by_text.sql
diff options
context:
space:
mode:
authorPierre Schmitz <pierre@archlinux.de>2008-08-15 01:29:47 +0200
committerPierre Schmitz <pierre@archlinux.de>2008-08-15 01:29:47 +0200
commit370e83bb0dfd0c70de268c93bf07ad5ee0897192 (patch)
tree491674f4c242e4d6ba0d04eafa305174c35a3391 /maintenance/archives/patch-ipb_by_text.sql
parentf4debf0f12d0524d2b2427c55ea3f16b680fad97 (diff)
Update auf 1.13.0
Diffstat (limited to 'maintenance/archives/patch-ipb_by_text.sql')
-rw-r--r--maintenance/archives/patch-ipb_by_text.sql10
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