r42436 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r42435‎ | r42436 | r42437 >
Date:00:13, 24 October 2008
Author:tparscal
Status:old
Tags:
Comment:
Added some indexes on commonly sorted columns.
Modified paths:
  • /trunk/extensions/Drafts/Drafts.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/Drafts/Drafts.sql
@@ -1,5 +1,5 @@
22 create table /*$wgDBPrefix*/drafts (
3 - draft_id INTEGER AUTO_INCREMENT PRIMARY KEY,
 3+ draft_id INTEGER AUTO_INCREMENT,
44 draft_token INTEGER,
55 draft_user INTEGER,
66 draft_namespace INTEGER,
@@ -11,5 +11,10 @@
1212 draft_scrolltop INTEGER,
1313 draft_text BLOB,
1414 draft_summary TINYBLOB,
15 - draft_minoredit BOOL
16 -) /*$wgDBTableOptions*/;
 15+ draft_minoredit BOOL,
 16+ PRIMARY KEY draft_id (draft_id),
 17+ INDEX draft_user (draft_user),
 18+ INDEX draft_namespace (draft_namespace),
 19+ INDEX draft_title (draft_title),
 20+ INDEX draft_savetime (draft_savetime)
 21+) /*$wgDBTableOptions*/;
\ No newline at end of file

Status & tagging log