r63010 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r63009‎ | r63010 | r63011 >
Date:17:03, 26 February 2010
Author:catrope
Status:ok
Tags:
Comment:
Storyboard: Fix up r63009: make index declaration SQLite-compatible, and add an index on the combination of the two field rather than having two separate indices
Modified paths:
  • /trunk/extensions/Storyboard/storyboard.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/Storyboard/storyboard.sql
@@ -10,7 +10,7 @@
1111 story_modified CHAR(14) binary NOT NULL default '',
1212 story_created CHAR(14) binary NOT NULL default '',
1313 story_is_published 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)
17 -) /*$wgDBTableOptions*/;
\ No newline at end of file
 14+ story_is_hidden TINYINT NOT NULL default '0'
 15+) /*$wgDBTableOptions*/;
 16+
 17+CREATE INDEX story_published_modified ON /*$wgDBprefix*/storyboard (story_is_published, story_is_modified);

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r63009Adressed comment at http://www.mediawiki.org/wiki/Special:Code/MediaWiki/6298...jeroendedauw15:35, 26 February 2010

Status & tagging log