+-- 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.
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);
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);
+