| Index: trunk/extensions/CheckUser/cu_changes.pg.sql |
| — | — | @@ -27,8 +27,6 @@ |
| 28 | 28 | cuc_agent TEXT |
| 29 | 29 | ); |
| 30 | 30 | |
| 31 | | -CREATE INDEX cu_changes_timestamp ON cu_changes(cuc_timestamp); |
| 32 | | -CREATE INDEX cu_changes_user ON cu_changes(cuc_user); |
| 33 | | -CREATE INDEX cu_changes_iphex ON cu_changes(cuc_ip_hex, cuc_xff_hex); |
| | 31 | +CREATE INDEX cu_changes_index ON cu_changes(cuc_user, cuc_ip_hex, cuc_xff_hex, cuc_timestamp); |
| 34 | 32 | |
| 35 | 33 | COMMIT; |