http://www.mediawiki.org/wiki/Special:Code/MediaWiki/89589

Revision: 89589
Author:   reedy
Date:     2011-06-06 19:10:38 +0000 (Mon, 06 Jun 2011)
Log Message:
-----------
* (bug 29287) Path searching input need a suggest list


Adding index on (cp_repo_id, cp_path)

Modified Paths:
--------------
    trunk/extensions/CodeReview/CodeReview.php
    trunk/extensions/CodeReview/codereview.sql

Added Paths:
-----------
    trunk/extensions/CodeReview/archives/codereview-repopath.sql

Modified: trunk/extensions/CodeReview/CodeReview.php
===================================================================
--- trunk/extensions/CodeReview/CodeReview.php  2011-06-06 19:01:47 UTC (rev 
89588)
+++ trunk/extensions/CodeReview/CodeReview.php  2011-06-06 19:10:38 UTC (rev 
89589)
@@ -278,6 +278,9 @@
                        $updater->addExtensionUpdate( array( 'modifyField', 
'code_prop_changes', 'cpc_attrib',
                                
"$base/archives/codereview-cpc_attrib_varchar.sql", true ) );
                }
+
+               $updater->addExtensionUpdate( array( 'addIndex', 'code_paths', 
'repo_path',
+                       "$base/archives/codereview-repopath.sql", true ) );
                break;
        case 'sqlite':
                $updater->addNewExtension( 'CodeReview', "$base/codereview.sql" 
);

Added: trunk/extensions/CodeReview/archives/codereview-repopath.sql
===================================================================
--- trunk/extensions/CodeReview/archives/codereview-repopath.sql                
                (rev 0)
+++ trunk/extensions/CodeReview/archives/codereview-repopath.sql        
2011-06-06 19:10:38 UTC (rev 89589)
@@ -0,0 +1 @@
+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
   + native

Modified: trunk/extensions/CodeReview/codereview.sql
===================================================================
--- trunk/extensions/CodeReview/codereview.sql  2011-06-06 19:01:47 UTC (rev 
89588)
+++ trunk/extensions/CodeReview/codereview.sql  2011-06-06 19:10:38 UTC (rev 
89589)
@@ -116,6 +116,7 @@
   primary key (cp_repo_id, cp_rev_id, cp_path)
 ) /*$wgDBTableOptions*/;
 
+CREATE INDEX /*i*/repo_path ON /*_*/code_paths (cp_repo_id, cp_path);
 
 -- And for our commenting system...
 -- To specify follow-up relationships...


_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs

Reply via email to