diff options
| author | Sam Reed <reedy@users.mediawiki.org> | 2012-03-06 00:09:18 +0000 |
|---|---|---|
| committer | Sam Reed <reedy@users.mediawiki.org> | 2012-03-06 00:09:18 +0000 |
| commit | 921c862c972b5b1b3875d822bcfa50808e98ac47 (patch) | |
| tree | 79e019516c1ba91e0d1f3338c16159b09e992d80 /maintenance/sqlite/archives | |
| parent | 64ac200ca31b77fdb244496e5d1571c77839db84 (diff) | |
| download | mediawikicore-921c862c972b5b1b3875d822bcfa50808e98ac47.tar.gz mediawikicore-921c862c972b5b1b3875d822bcfa50808e98ac47.zip | |
Followup r113109, forward port the rest of r25267 for Bug 10788 - Filter page histories by user, or contributions by title
Notes
Notes:
http://mediawiki.org/wiki/Special:Code/MediaWiki/113110
Diffstat (limited to 'maintenance/sqlite/archives')
| -rw-r--r-- | maintenance/sqlite/archives/patch-revision-user-page-index.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/maintenance/sqlite/archives/patch-revision-user-page-index.sql b/maintenance/sqlite/archives/patch-revision-user-page-index.sql new file mode 100644 index 000000000000..9058e4e9fca7 --- /dev/null +++ b/maintenance/sqlite/archives/patch-revision-user-page-index.sql @@ -0,0 +1,5 @@ +-- New index on revision table to allow searches for all edits by a given user +-- to a given page. Added 2007-08-28 + +ALTER TABLE /*$wgDBprefix*/revision + ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); |