extensions/CheckUser/archives/patch-cu_changes_indexes2.sql


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