http://www.mediawiki.org/wiki/Special:Code/MediaWiki/73758
Revision: 73758
Author: maxsem
Date: 2010-09-25 17:45:00 +0000 (Sat, 25 Sep 2010)
Log Message:
-----------
A few index-related fixes in SQLite DB patches, ping r66920.
The need to drop index patch-rename-iwl_prefix.sql arose from development
versions that had discrepancies between tables.sql and updater. Let's just DROP
IF EXISTS it.
Modified Paths:
--------------
trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_pft.sql
trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql
trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
Modified: trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_pft.sql
===================================================================
--- trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_pft.sql
2010-09-25 17:17:27 UTC (rev 73757)
+++ trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_pft.sql
2010-09-25 17:45:00 UTC (rev 73758)
@@ -3,5 +3,5 @@
-- installs if they ran update.php between it being added and being renamed
--
-DROP INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks;
+DROP INDEX /*i*/iwl_prefix_from_title;
Modified: trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql
===================================================================
--- trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql
2010-09-25 17:17:27 UTC (rev 73757)
+++ trunk/phase3/maintenance/sqlite/archives/patch-kill-iwl_prefix.sql
2010-09-25 17:45:00 UTC (rev 73758)
@@ -3,5 +3,5 @@
-- installs if they ran update.php between it being added and being renamed
--
-DROP INDEX /*i*/iwl_prefix ON /*_*/iwlinks;
+DROP INDEX /*i*/iwl_prefix;
Modified: trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
===================================================================
--- trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
2010-09-25 17:17:27 UTC (rev 73757)
+++ trunk/phase3/maintenance/sqlite/archives/patch-rename-iwl_prefix.sql
2010-09-25 17:45:00 UTC (rev 73758)
@@ -1,5 +1,5 @@
--
-- Recreates the iwl_prefix for the iwlinks table
--
-DROP INDEX /*i*/iwl_prefix;
+DROP INDEX IF EXISTS /*i*/iwl_prefix;
CREATE INDEX /*i*/iwl_prefix_from_title ON /*_*/iwlinks (iwl_prefix, iwl_from,
iwl_title);
\ No newline at end of file
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
