From 91da036ca57d692fba4faad573aa4bca1435eda7 Mon Sep 17 00:00:00 2001
From: Pierre Schmitz <pierre@archlinux.de>
Date: Thu, 16 Sep 2010 21:49:19 +0200
Subject: Add CheckUser extension

* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser
---
 extensions/CheckUser/archives/patch-cu_changes_indexes.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 extensions/CheckUser/archives/patch-cu_changes_indexes.sql

(limited to 'extensions/CheckUser/archives/patch-cu_changes_indexes.sql')

diff --git a/extensions/CheckUser/archives/patch-cu_changes_indexes.sql b/extensions/CheckUser/archives/patch-cu_changes_indexes.sql
new file mode 100644
index 00000000..9c81058f
--- /dev/null
+++ b/extensions/CheckUser/archives/patch-cu_changes_indexes.sql
@@ -0,0 +1,11 @@
+-- Improves indexes for better peformance with large result sets
+-- vim: autoindent syn=mysql sts=2 sw=2
+-- Replace /*$wgDBprefix*/ with the proper prefix
+
+ALTER TABLE /*$wgDBprefix*/cu_changes
+  ADD INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp),
+  ADD INDEX cuc_user_ip_time (cuc_user,cuc_ip,cuc_timestamp),
+  ADD INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp),
+  DROP INDEX cuc_ip_hex,
+  DROP INDEX cuc_xff_hex,
+  DROP INDEX cuc_user;
-- 
cgit v1.2.3-54-g00ecf

