| Index: trunk/extensions/Wikilog/archives/patch-comments-indexes.sql |
| — | — | @@ -0,0 +1,9 @@ |
| | 2 | +-- MediaWiki Wikilog extension database patch. |
| | 3 | +-- |
| | 4 | +-- Version: 1.0.99.1dev |
| | 5 | +-- Add wlc_timestamp and wlc_updated indexes to wikilog_comments table. |
| | 6 | +-- |
| | 7 | + |
| | 8 | +ALTER TABLE /*$wgDBprefix*/wikilog_comments |
| | 9 | + ADD INDEX wlc_timestamp (wlc_timestamp), |
| | 10 | + ADD INDEX wlc_updated (wlc_updated); |
| Property changes on: trunk/extensions/Wikilog/archives/patch-comments-indexes.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 11 | + native |
| Index: trunk/extensions/Wikilog/WikilogHooks.php |
| — | — | @@ -365,6 +365,7 @@ |
| 366 | 366 | |
| 367 | 367 | if ( $wgDBtype == 'mysql' ) { |
| 368 | 368 | $wgExtNewTables[] = array( "wikilog_wikilogs", "{$dir}wikilog-tables.sql" ); |
| | 369 | + $wgExtNewIndexes[] = array( "wikilog_comments", "wlc_timestamp", "{$dir}archives/patch-comments-indexes.sql" ); |
| 369 | 370 | } else { |
| 370 | 371 | // TODO: PostgreSQL, SQLite, etc... |
| 371 | 372 | print "\n" . |
| Index: trunk/extensions/Wikilog/wikilog-tables.sql |
| — | — | @@ -1,5 +1,4 @@ |
| 2 | 2 | -- Tables used by the MediaWiki Wikilog extension. |
| 3 | 3 | -- |
| 4 | 4 | -- You should not have to create these tables manually unless you are doing |
| 5 | 5 | -- a manual installation. In normal conditions, maintenance/update.php should |
| — | — | @@ -156,6 +155,8 @@ |
| 157 | 156 | |
| 158 | 157 | PRIMARY KEY (wlc_id), |
| 159 | 158 | INDEX wlc_post_thread (wlc_post, wlc_thread), |
| | 159 | + INDEX wlc_timestamp (wlc_timestamp), |
| | 160 | + INDEX wlc_updated (wlc_updated), |
| 160 | 161 | INDEX wlc_comment_page (wlc_comment_page) |
| 161 | 162 | |
| 162 | 163 | ) /*$wgDBTableOptions*/; |