http://www.mediawiki.org/wiki/Special:Code/MediaWiki/89526
Revision: 89526
Author: maxsem
Date: 2011-06-05 19:39:28 +0000 (Sun, 05 Jun 2011)
Log Message:
-----------
SQLite: sync a couple of indexes with MySQL
Modified Paths:
--------------
trunk/phase3/includes/installer/SqliteUpdater.php
trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql
Added Paths:
-----------
trunk/phase3/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql
Modified: trunk/phase3/includes/installer/SqliteUpdater.php
===================================================================
--- trunk/phase3/includes/installer/SqliteUpdater.php 2011-06-05 19:37:08 UTC
(rev 89525)
+++ trunk/phase3/includes/installer/SqliteUpdater.php 2011-06-05 19:39:28 UTC
(rev 89526)
@@ -52,6 +52,8 @@
array( 'doCollationUpdate' ),
array( 'addTable', 'msg_resource',
'patch-msg_resource.sql' ),
array( 'addTable', 'module_deps',
'patch-module_deps.sql' ),
+ array( 'dropIndex', 'archive', 'ar_page_revid',
'patch-archive_kill_ar_page_revid.sql' ),
+ array( 'addIndex', 'archive', 'ar_revid',
'patch-archive_ar_revid.sql' ),
// 1.19
array( 'addTable', 'config', 'patch-config.sql' ),
Modified: trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql
===================================================================
--- trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql
2011-06-05 19:37:08 UTC (rev 89525)
+++ trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql
2011-06-05 19:39:28 UTC (rev 89526)
@@ -1,4 +1,3 @@
-- Hopefully temporary index.
-- For https://bugzilla.wikimedia.org/show_bug.cgi?id=21279
-ALTER TABLE /*$wgDBprefix*/archive
- ADD INDEX ar_revid ( ar_rev_id );
\ No newline at end of file
+CREATE INDEX /*i*/ar_revid ON /*$wgDBprefix*/archive ( ar_rev_id );
\ No newline at end of file
Added:
trunk/phase3/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql
===================================================================
---
trunk/phase3/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql
(rev 0)
+++
trunk/phase3/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql
2011-06-05 19:39:28 UTC (rev 89526)
@@ -0,0 +1,3 @@
+-- Used for killing the wrong index added during SVN for 1.17
+-- Won't affect most people, but it doesn't need to exist
+DROP INDEX IF EXISTS ar_page_revid;
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
