Index: trunk/extensions/Drafts/Drafts.sql |
— | — | @@ -1,5 +1,5 @@ |
2 | 2 | create table /*$wgDBPrefix*/drafts ( |
3 | | - draft_id INTEGER AUTO_INCREMENT PRIMARY KEY, |
| 3 | + draft_id INTEGER AUTO_INCREMENT, |
4 | 4 | draft_token INTEGER, |
5 | 5 | draft_user INTEGER, |
6 | 6 | draft_namespace INTEGER, |
— | — | @@ -11,5 +11,10 @@ |
12 | 12 | draft_scrolltop INTEGER, |
13 | 13 | draft_text BLOB, |
14 | 14 | 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 |