| Index: trunk/extensions/CheckUser/archives/patch-cu_changes_indexes.sql |
| — | — | @@ -1,11 +1,11 @@ |
| 2 | | -
|
| 3 | | -ALTER TABLE /*$wgDBprefix*/cu_changes
|
| 4 | | - DROP INDEX cuc_ip_hex,
|
| 5 | | - DROP INDEX cuc_user,
|
| 6 | | - DROP INDEX cuc_xff,
|
| 7 | | - ADD INDEX cuc_ip_hex_time (cuc_ip_hex,cuc_timestamp),
|
| 8 | | - ADD INDEX cuc_user_time (cuc_user,cuc_timestamp),
|
| 9 | | - ADD INDEX cuc_xff_hex_time (cuc_xff_hex,cuc_timestamp);
|
| | 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); |
| Property changes on: trunk/extensions/CheckUser/archives/patch-cu_changes_indexes.sql |
| ___________________________________________________________________ |
| Added: eol-style |
| 10 | 13 | + native |
| Index: trunk/extensions/CheckUser/archives/patch-cuc_cookie_user.sql |
| — | — | @@ -1,6 +1,6 @@ |
| 2 | | -
|
| 3 | | -ALTER TABLE /*$wgDBprefix*/cu_changes
|
| 4 | | - ADD cuc_cookie_user VARCHAR(255) BINARY default NULL;
|
| | 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; |
| Property changes on: trunk/extensions/CheckUser/archives/patch-cuc_cookie_user.sql |
| ___________________________________________________________________ |
| Added: eol-style |
| 5 | 8 | + native |