| Index: trunk/extensions/CheckUser/cu_changes.sql |
| — | — | @@ -52,9 +52,8 @@ |
| 53 | 53 | cuc_agent VARCHAR(255) BINARY default NULL, |
| 54 | 54 | |
| 55 | 55 | PRIMARY KEY cuc_id (cuc_id), |
| 56 | | - INDEX (cuc_ip_hex), |
| 57 | | - INDEX (cuc_user), |
| 58 | | - INDEX (cuc_xff_hex), |
| | 56 | + INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp), |
| | 57 | + INDEX cuc_user_time (cuc_user,cuc_timestamp), |
| | 58 | + INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp), |
| 59 | 59 | INDEX (cuc_timestamp) |
| 60 | 60 | ) TYPE=InnoDB; |
| 61 | | - |