[Summary view] [Print] [Text view]

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