X-Git-Url: https://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Findexes.sql;h=64a9ce27e3146a86fb8767c2e996a3f8c49d690f;hb=70b54c56a2c81e171e7ce8a91c5bf5e11d66e08c;hp=279105c7b926ab8b0db74af313977a1075db9028;hpb=4b37e34dc6653e8192cfa30895bb8a9d5d09f842;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/indexes.sql b/maintenance/indexes.sql
index 279105c7b9..64a9ce27e3 100644
--- a/maintenance/indexes.sql
+++ b/maintenance/indexes.sql
@@ -1,3 +1,7 @@
+-- This file should be phased out.
+-- It's useless importing dumps that already have indexes in their definitions.
+--
+
 -- SQL to add non-unique indexes to Wikipedia database tables.
 -- This is read and executed by the install script; you should
 -- never have to run it by itself.
@@ -27,24 +31,11 @@ ALTER TABLE old
   ADD INDEX user_timestamp (old_user,inverse_timestamp),
   ADD INDEX usertext_timestamp (old_user_text,inverse_timestamp);
 
-ALTER TABLE links
-  ADD INDEX l_from (l_from (10)),
-  ADD INDEX l_to (l_to);
-
-ALTER TABLE brokenlinks
-  ADD INDEX bl_from (bl_from),
-  ADD INDEX bl_to (bl_to(10));
-
-ALTER TABLE imagelinks
-  ADD INDEX il_from (il_from(10)),
-  ADD INDEX il_to (il_to(10));
-
 ALTER TABLE ipblocks
   ADD INDEX ipb_address (ipb_address),
   ADD INDEX ipb_user (ipb_user);
 
 ALTER TABLE image
-  ADD INDEX img_name (img_name(10)),
   ADD INDEX img_size (img_size),
   ADD INDEX img_timestamp (img_timestamp);
 
@@ -55,3 +46,16 @@ ALTER TABLE searchindex
   ADD FULLTEXT si_title (si_title),
   ADD FULLTEXT si_text (si_text);
 
+ALTER TABLE recentchanges
+  ADD INDEX rc_timestamp (rc_timestamp),
+  ADD INDEX rc_namespace_title (rc_namespace, rc_title),
+  ADD INDEX rc_cur_id (rc_cur_id),
+  ADD INDEX new_name_timestamp(rc_new,rc_namespace,rc_timestamp),
+  ADD INDEX rc_ip (rc_ip);
+
+ALTER TABLE archive
+  ADD KEY `name_title_timestamp` (`ar_namespace`,`ar_title`,`ar_timestamp`);
+
+ALTER TABLE watchlist
+  ADD KEY namespace_title (wl_namespace,wl_title);
+