Add CheckUser extension

* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser

2 files changed, 18 insertions, 0 deletions

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;
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;