http://www.mediawiki.org/wiki/Special:Code/MediaWiki/97525
Revision: 97525
Author: asher
Date: 2011-09-19 18:24:53 +0000 (Mon, 19 Sep 2011)
Log Message:
-----------
customized patch-fr_page_rev-index.sql for wmf
Modified Paths:
--------------
branches/wmf/1.18wmf1/maintenance/upgrade-1.18wmf1-1.php
Added Paths:
-----------
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
Added:
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
===================================================================
---
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
(rev 0)
+++
branches/wmf/1.18wmf1/extensions/FlaggedRevs/schema/mysql/patch-fr_page_rev-index-wmf1.8.sql
2011-09-19 18:24:53 UTC (rev 97525)
@@ -0,0 +1,11 @@
+ALTER TABLE /*_*/flaggedrevs
+ ADD COLUMN fr_rev_timestamp varbinary(14) NOT NULL default '',
+-- Old (fr_page_id,fr_rev_id) key
+ DROP PRIMARY KEY;
+
+-- Take the first row of any duplicates on new key
+ALTER IGNORE TABLE /*_*/flaggedrevs ADD PRIMARY KEY (fr_rev_id);
+
+CREATE INDEX /*i*/page_rev ON /*_*/flaggedrevs (fr_page_id,fr_rev_id);
+CREATE INDEX /*i*/page_time ON /*_*/flaggedrevs (fr_page_id,fr_rev_timestamp);
+CREATE INDEX /*i*/page_qal_time ON /*_*/flaggedrevs
(fr_page_id,fr_quality,fr_rev_timestamp);
Modified: branches/wmf/1.18wmf1/maintenance/upgrade-1.18wmf1-1.php
===================================================================
--- branches/wmf/1.18wmf1/maintenance/upgrade-1.18wmf1-1.php 2011-09-19
18:11:47 UTC (rev 97524)
+++ branches/wmf/1.18wmf1/maintenance/upgrade-1.18wmf1-1.php 2011-09-19
18:24:53 UTC (rev 97525)
@@ -74,7 +74,7 @@
if ( isFlaggedRevsWiki( $wiki ) ) {
echo " FlaggedRevs";
sourceUpgradeFile( $db,
dirname(__FILE__).'/../extensions/FlaggedRevs/schema/mysql/' .
- 'patch-fr_page_rev-index.sql' );
+ 'patch-fr_page_rev-index-wmf1.8.sql' );
}
if ( $db->fieldExists( 'article_feedback', 'aa_page_id' ) ) {
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
