From 370e83bb0dfd0c70de268c93bf07ad5ee0897192 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Fri, 15 Aug 2008 01:29:47 +0200
Subject: Update auf 1.13.0

---
 maintenance/archives/patch-ipb_by_text.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 maintenance/archives/patch-ipb_by_text.sql

(limited to 'maintenance/archives/patch-ipb_by_text.sql')

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
-- 
cgit v1.2.2