r89589 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r89588‎ | r89589 | r89590 >
Date:19:10, 6 June 2011
Author:reedy
Status:ok
Tags:
Comment:
* (bug 29287) Path searching input need a suggest list


Adding index on (cp_repo_id, cp_path)
Modified paths:
  • /trunk/extensions/CodeReview/CodeReview.php (modified) (history)
  • /trunk/extensions/CodeReview/archives/codereview-repopath.sql (added) (history)
  • /trunk/extensions/CodeReview/codereview.sql (modified) (history)

Diff [purge]

Index: trunk/extensions/CodeReview/CodeReview.php
@@ -278,6 +278,9 @@
279279 $updater->addExtensionUpdate( array( 'modifyField', 'code_prop_changes', 'cpc_attrib',
280280 "$base/archives/codereview-cpc_attrib_varchar.sql", true ) );
281281 }
 282+
 283+ $updater->addExtensionUpdate( array( 'addIndex', 'code_paths', 'repo_path',
 284+ "$base/archives/codereview-repopath.sql", true ) );
282285 break;
283286 case 'sqlite':
284287 $updater->addNewExtension( 'CodeReview', "$base/codereview.sql" );
Index: trunk/extensions/CodeReview/codereview.sql
@@ -116,6 +116,7 @@
117117 primary key (cp_repo_id, cp_rev_id, cp_path)
118118 ) /*$wgDBTableOptions*/;
119119
 120+CREATE INDEX /*i*/repo_path ON /*_*/code_paths (cp_repo_id, cp_path);
120121
121122 -- And for our commenting system...
122123 -- To specify follow-up relationships...
Index: trunk/extensions/CodeReview/archives/codereview-repopath.sql
@@ -0,0 +1 @@
 2+CREATE INDEX /*i*/repo_path ON /*_*/code_paths (cp_repo_id, cp_path);
\ No newline at end of file
Property changes on: trunk/extensions/CodeReview/archives/codereview-repopath.sql
___________________________________________________________________
Added: svn:eol-style
13 + native

Follow-up revisions

RevisionCommit summaryAuthorDate
r89592adding index on (cp_repo_id, cp_path) for sqlite...hashar19:22, 6 June 2011
r89645Followup r89589, r89588...reedy13:43, 7 June 2011

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r89588* (bug 29287) Path searching input need a suggest list...reedy19:01, 6 June 2011

Status & tagging log