maintenance/archives/patch-indexes.sql

   1 --
   2 -- patch-indexes.sql
   3 --
   4 -- Fix up table indexes; new to stable release in November 2003
   5 --
   6
   7 ALTER TABLE IF EXISTS /*$wgDBprefix*/links
   8    DROP INDEX l_from,
   9    ADD INDEX l_from (l_from);
  10
  11 ALTER TABLE /*$wgDBprefix*/brokenlinks
  12    DROP INDEX bl_to,
  13    ADD INDEX bl_to (bL_to);
  14
  15 ALTER TABLE /*$wgDBprefix*/recentchanges
  16    ADD INDEX rc_timestamp (rc_timestamp),
  17    ADD INDEX rc_namespace_title (rc_namespace, rc_title),
  18    ADD INDEX rc_cur_id (rc_cur_id);
  19
  20 ALTER TABLE /*$wgDBprefix*/archive
  21    ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp);
  22
  23 ALTER TABLE /*$wgDBprefix*/watchlist
  24    ADD KEY namespace_title (wl_namespace,wl_title);