r99185 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r99184‎ | r99185 | r99186 >
Date:02:33, 7 October 2011
Author:jeroendedauw
Status:deferred
Tags:
Comment:
added a bunch of indexes
Modified paths:
  • /trunk/extensions/Contest/Contest.hooks.php (modified) (history)
  • /trunk/extensions/Contest/sql/IndexChallengeContestId.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexChallengeTitle.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexCommentTime.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexContestStatus.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexContestantInterests.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexContestantRating.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexVoteContestantId.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexVoteContestantUser.sql (added) (history)
  • /trunk/extensions/Contest/sql/IndexVoteUserId.sql (added) (history)

Diff [purge]

Index: trunk/extensions/Contest/Contest.hooks.php
——@@ -75,6 +75,78 @@
7676 dirname( __FILE__ ) . '/sql/IndexContestantUserContest.sql',
7777 true
7878 ) );
 79+
 80+ $updater->addExtensionUpdate( array(
 81+ 'addIndex',
 82+ 'contest_challenges',
 83+ 'challenge_contest_id',
 84+ dirname( __FILE__ ) . '/sql/IndexChallengeContestId.sql',
 85+ true
 86+ ) );
 87+
 88+ $updater->addExtensionUpdate( array(
 89+ 'addIndex',
 90+ 'contest_challenges',
 91+ 'challenge_title',
 92+ dirname( __FILE__ ) . '/sql/IndexChallengeTitle.sql',
 93+ true
 94+ ) );
 95+
 96+ $updater->addExtensionUpdate( array(
 97+ 'addIndex',
 98+ 'contest_comments',
 99+ 'comment_time',
 100+ dirname( __FILE__ ) . '/sql/IndexCommentTime.sql',
 101+ true
 102+ ) );
 103+
 104+ $updater->addExtensionUpdate( array(
 105+ 'addIndex',
 106+ 'contest_contestants',
 107+ 'contestant_interests',
 108+ dirname( __FILE__ ) . '/sql/IndexContestantInterests.sql',
 109+ true
 110+ ) );
 111+
 112+ $updater->addExtensionUpdate( array(
 113+ 'addIndex',
 114+ 'contest_contestants',
 115+ 'contestant_rating',
 116+ dirname( __FILE__ ) . '/sql/IndexContestantRating.sql',
 117+ true
 118+ ) );
 119+
 120+ $updater->addExtensionUpdate( array(
 121+ 'addIndex',
 122+ 'contests',
 123+ 'contest_status',
 124+ dirname( __FILE__ ) . '/sql/IndexContestStatus.sql',
 125+ true
 126+ ) );
 127+
 128+ $updater->addExtensionUpdate( array(
 129+ 'addIndex',
 130+ 'contest_votes',
 131+ 'vote_contestant_id',
 132+ dirname( __FILE__ ) . '/sql/IndexVoteContestantId.sql',
 133+ true
 134+ ) );
 135+
 136+ $updater->addExtensionUpdate( array(
 137+ 'addIndex',
 138+ 'contest_votes',
 139+ 'vote_contestant_user',
 140+ dirname( __FILE__ ) . '/sql/IndexVoteContestantUser.sql',
 141+ true
 142+ ) );
 143+
 144+ $updater->addExtensionUpdate( array(
 145+ 'addIndex',
 146+ 'contest_votes',
 147+ 'vote_user_id',
 148+ dirname( __FILE__ ) . '/sql/IndexVoteUserId.sql',
 149+ true
 150+ ) );
79151
80152 return true;
81153 }
Index: trunk/extensions/Contest/sql/IndexVoteUserId.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/vote_user_id ON /*_*/contest_votes (vote_user_id);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexVoteUserId.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexVoteContestantId.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/vote_contestant_id ON /*_*/contest_votes (vote_contestant_id);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexVoteContestantId.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexChallengeContestId.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/challenge_contest_id ON /*_*/contest_challenges (challenge_contest_id);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexChallengeContestId.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexVoteContestantUser.sql
——@@ -0,0 +1 @@
 2+CREATE UNIQUE INDEX /*i*/vote_contestant_user ON /*_*/contest_votes (vote_contestant_id, vote_user_id);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexVoteContestantUser.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexCommentTime.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/comment_time ON /*_*/contest_comments (comment_contestant_id, comment_time);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexCommentTime.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexContestStatus.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/contest_status ON /*_*/contests (contest_status, contest_end);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexContestStatus.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexContestantInterests.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/contestant_interests ON /*_*/contest_contestants (contestant_challenge_id, contestant_wmf, contestant_volunteer);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexContestantInterests.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexChallengeTitle.sql
——@@ -0,0 +1 @@
 2+CREATE UNIQUE INDEX /*i*/challenge_title ON /*_*/contest_challenges (challenge_title);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexChallengeTitle.sql
___________________________________________________________________
Added: svn:eol-style
13 + native
Index: trunk/extensions/Contest/sql/IndexContestantRating.sql
——@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/contestant_rating ON /*_*/contest_contestants (contestant_challenge_id, contestant_rating, contestant_rating_count);
\ No newline at end of file
Property changes on: trunk/extensions/Contest/sql/IndexContestantRating.sql
___________________________________________________________________
Added: svn:eol-style
13 + native

Status & tagging log