X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Findexes.sql;h=90155c0639b572c84bdc6b00917a39a8e1ca5fe7;hb=b53762cf69f3958e7d85498987daa41657e2f3a3;hp=46dc269ed8d8cc415d3943ff5e9f3eb5cc0ba637;hpb=6fc4b0854b596df8125014903793c55e26d314af;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/indexes.sql b/maintenance/indexes.sql
index 46dc269ed8..90155c0639 100644
--- a/maintenance/indexes.sql
+++ b/maintenance/indexes.sql
@@ -55,3 +55,15 @@ 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);
+
+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);
+