| Index: trunk/extensions/Storyboard/storyboard.sql |
| — | — | @@ -10,5 +10,7 @@ |
| 11 | 11 | story_modified CHAR(14) binary NOT NULL default '', |
| 12 | 12 | story_created CHAR(14) binary NOT NULL default '', |
| 13 | 13 | story_is_published TINYINT NOT NULL default '0', |
| 14 | | - story_is_hidden TINYINT NOT NULL default '0' |
| | 14 | + story_is_hidden TINYINT NOT NULL default '0', |
| | 15 | + INDEX story_is_published (story_is_published), |
| | 16 | + INDEX story_modified (story_modified) |
| 15 | 17 | ) /*$wgDBTableOptions*/; |
| \ No newline at end of file |
| Index: trunk/extensions/Storyboard/api/ApiStoryboardStoriesFeed.php |
| — | — | @@ -56,7 +56,7 @@ |
| 57 | 57 | 'story_is_published' => 1 |
| 58 | 58 | ) ); |
| 59 | 59 | $this->addOption( 'LIMIT', $params['limit'] ); |
| 60 | | - $this->addOption( 'ORDER BY', 'story_modified' ); |
| | 60 | + $this->addOption( 'ORDER BY', 'story_modified DESC' ); |
| 61 | 61 | |
| 62 | 62 | $stories = $this->select( __METHOD__ ); |
| 63 | 63 | |