From b32ea22f97160446d984f4b356d63e47307993e4 Mon Sep 17 00:00:00 2001 From: Victor Vasiliev Date: Mon, 18 Feb 2008 12:18:28 +0000 Subject: [PATCH] Patch itself --- maintenance/archives/patch-ipb_by_text.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 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 0000000000..c0b620d338 --- /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 -- 2.20.1