extensions/CheckUser/archives/patch-cu_changes_indexes.sql


1
2
3
4
5
6
7
8
9
10
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;