http://www.mediawiki.org/wiki/Special:Code/MediaWiki/98629
Revision: 98629
Author: nikerabbit
Date: 2011-10-01 21:26:57 +0000 (Sat, 01 Oct 2011)
Log Message:
-----------
Changed index on translate_sections database table to something useful
Modified Paths:
--------------
trunk/extensions/Translate/README
trunk/extensions/Translate/TranslateHooks.php
trunk/extensions/Translate/sql/translate_sections.sql
Added Paths:
-----------
trunk/extensions/Translate/sql/translate_sections-indexchange.sql
trunk/extensions/Translate/sql/translate_sections-indexchange2.sql
Modified: trunk/extensions/Translate/README
===================================================================
--- trunk/extensions/Translate/README 2011-10-01 21:24:07 UTC (rev 98628)
+++ trunk/extensions/Translate/README 2011-10-01 21:26:57 UTC (rev 98629)
@@ -30,6 +30,7 @@
== Change log ==
* 2011-10-01
+- Changed index on translate_sections database table
- Fixed escaping in PythonSingleFFS parser
- Fixed a bug in getSourceLanguage for certain message group classes
* 2011-09-29
Modified: trunk/extensions/Translate/TranslateHooks.php
===================================================================
--- trunk/extensions/Translate/TranslateHooks.php 2011-10-01 21:24:07 UTC
(rev 98628)
+++ trunk/extensions/Translate/TranslateHooks.php 2011-10-01 21:26:57 UTC
(rev 98629)
@@ -165,6 +165,9 @@
$updater->addExtensionUpdate( array( 'addField',
'translate_sections', 'trs_order',
"$dir/translate_sections-trs_order.patch.sql", true ) );
$updater->addExtensionUpdate( array( 'addTable', 'revtag',
"$dir/revtag.sql", true ) );
$updater->addExtensionUpdate( array( 'addTable',
'translate_groupstats', "$dir/translate_groupstats.sql", true ) );
+ $updater->addExtensionUpdate( array( 'addIndex',
'translate_sections', 'trs_page_order',
"$dir/translate_sections-indexchange.sql", true ) );
+ $updater->addExtensionUpdate( array( 'dropIndex',
'translate_sections', 'trs_page', "$dir/translate_sections-indexchange2.sql",
true ) );
+
return true;
}
Added: trunk/extensions/Translate/sql/translate_sections-indexchange.sql
===================================================================
--- trunk/extensions/Translate/sql/translate_sections-indexchange.sql
(rev 0)
+++ trunk/extensions/Translate/sql/translate_sections-indexchange.sql
2011-10-01 21:26:57 UTC (rev 98629)
@@ -0,0 +1 @@
+CREATE INDEX /*i*/trs_page_order on /*_*/translate_sections (trs_page,
trs_order);
Property changes on:
trunk/extensions/Translate/sql/translate_sections-indexchange.sql
___________________________________________________________________
Added: svn:eol-style
+ native
Added: trunk/extensions/Translate/sql/translate_sections-indexchange2.sql
===================================================================
--- trunk/extensions/Translate/sql/translate_sections-indexchange2.sql
(rev 0)
+++ trunk/extensions/Translate/sql/translate_sections-indexchange2.sql
2011-10-01 21:26:57 UTC (rev 98629)
@@ -0,0 +1 @@
+DROP INDEX /*i*/trs_page on /*_*/translate_sections;
Property changes on:
trunk/extensions/Translate/sql/translate_sections-indexchange2.sql
___________________________________________________________________
Added: svn:eol-style
+ native
Modified: trunk/extensions/Translate/sql/translate_sections.sql
===================================================================
--- trunk/extensions/Translate/sql/translate_sections.sql 2011-10-01
21:24:07 UTC (rev 98628)
+++ trunk/extensions/Translate/sql/translate_sections.sql 2011-10-01
21:26:57 UTC (rev 98629)
@@ -17,4 +17,4 @@
PRIMARY KEY (trs_page, trs_key)
) /*$wgDBTableOptions*/;
-CREATE INDEX /*i*/trs_page on /*_*/translate_sections (trs_page);
+CREATE INDEX /*i*/trs_page_order on /*_*/translate_sections (trs_page,
trs_order);
_______________________________________________
MediaWiki-CVS mailing list
MediaWiki-CVS@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
