| Index: trunk/extensions/CheckUser/patch-cu_cookie_user.sql |
| — | — | @@ -1,6 +0,0 @@ |
| 2 | | -
|
| 3 | | -ALTER TABLE /*$wgDBprefix*/cu_changes
|
| 4 | | - ADD cuc_cookie_user VARCHAR(255) BINARY default NULL;
|
| Index: trunk/extensions/CheckUser/Archives/patch-cu_changes_indexes.sql |
| — | — | @@ -0,0 +1,11 @@ |
| | 2 | +-- Improves indexes for better peformance with large result sets
|
| | 3 | +-- vim: autoindent syn=mysql sts=2 sw=2
|
| | 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix
|
| | 5 | +
|
| | 6 | +ALTER TABLE /*$wgDBprefix*/cu_changes
|
| | 7 | + DROP INDEX cuc_ip_hex,
|
| | 8 | + DROP INDEX cuc_user,
|
| | 9 | + DROP INDEX cuc_xff,
|
| | 10 | + ADD INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp),
|
| | 11 | + ADD INDEX cuc_user_time (cuc_user,cuc_timestamp),
|
| | 12 | + ADD INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp);
|
| Index: trunk/extensions/CheckUser/Archives/patch-cuc_cookie_user.sql |
| — | — | @@ -0,0 +1,6 @@ |
| | 2 | +-- Adds the cookie data column needed to enable $wgCURecordCookies
|
| | 3 | +-- vim: autoindent syn=mysql sts=2 sw=2
|
| | 4 | +-- Replace /*$wgDBprefix*/ with the proper prefix
|
| | 5 | +
|
| | 6 | +ALTER TABLE /*$wgDBprefix*/cu_changes
|
| | 7 | + ADD cuc_cookie_user VARCHAR(255) BINARY default NULL;
|