| Index: trunk/extensions/CheckUser/CheckUser.php |
| — | — | @@ -271,9 +271,9 @@ |
| 272 | 272 | # FIXME: do postgres index changes! |
| 273 | 273 | if ($wgDBtype == 'mysql') { |
| 274 | 274 | $wgExtNewFields[] = array('cu_changes', |
| 275 | | - 'cuc_cookie_user', dirname(__FILE__) . '/Archives/patch-cuc_cookie_user.sql'); |
| | 275 | + 'cuc_cookie_user', dirname(__FILE__) . '/archives/patch-cuc_cookie_user.sql'); |
| 276 | 276 | $wgExtNewIndexes[] = array('cu_changes', |
| 277 | | - 'cuc_user_time', dirname(__FILE__) . '/Archives/patch-cu_changes_indexes.sql'); |
| | 277 | + 'cuc_user_time', dirname(__FILE__) . '/archives/patch-cu_changes_indexes.sql'); |
| 278 | 278 | } else { |
| 279 | 279 | $wgExtNewFields[] = array('cu_changes', |
| 280 | 280 | 'cuc_cookie_user', dirname(__FILE__) . 'TEXT'); |
| 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;
|