diff options
| author | Pierre Schmitz <pierre@archlinux.de> | 2010-09-16 21:49:19 +0200 |
|---|---|---|
| committer | Pierre Schmitz <pierre@archlinux.de> | 2010-09-16 21:49:19 +0200 |
| commit | 91da036ca57d692fba4faad573aa4bca1435eda7 (patch) | |
| tree | 97d4e9b74fc15dd9ff6cac4e023db04843375dbc /extensions/CheckUser/archives/patch-cu_changes_indexes2.sql | |
| parent | bda2edfb2799e73eaab83b775eda8afbe8bcb15d (diff) | |
Add CheckUser extension
* revision 73143
* url: http://www.mediawiki.org/wiki/Extension:CheckUser
Diffstat (limited to 'extensions/CheckUser/archives/patch-cu_changes_indexes2.sql')
| -rw-r--r-- | extensions/CheckUser/archives/patch-cu_changes_indexes2.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql new file mode 100644 index 00000000..645962ba --- /dev/null +++ b/extensions/CheckUser/archives/patch-cu_changes_indexes2.sql @@ -0,0 +1,7 @@ +-- Improves indexes for better peformance with large result sets +-- vim: autoindent syn=mysql sts=2 sw=2 +-- Replace /*$wgDBprefix*/ with the proper prefix + +ALTER TABLE /*$wgDBprefix*/cu_changes + ADD INDEX cuc_user_ip_time (cuc_user,cuc_ip,cuc_timestamp), + DROP INDEX cuc_user_time; |