1 files changed, 7 insertions, 0 deletions
diff --git a/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql
new file mode 100644
index 00000000..645962ba
--- /dev/null
+++ b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql
@@ -0,0 +1,7 @@
+-- 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_user_ip_time (cuc_user,cuc_ip,cuc_timestamp),
+  DROP INDEX cuc_user_time;