4 -- Fix up table indexes; new to stable release in November 2003
7 ALTER TABLE IF EXISTS /*$wgDBprefix*/links
9 ADD INDEX l_from (l_from
);
11 ALTER TABLE /*$wgDBprefix*/brokenlinks
13 ADD INDEX bl_to (bL_to
);
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
);
20 ALTER TABLE /*$wgDBprefix*/archive
21 ADD KEY name_title_timestamp (ar_namespace
,ar_title
,ar_timestamp
);
23 ALTER TABLE /*$wgDBprefix*/watchlist
24 ADD KEY namespace_title (wl_namespace
,wl_title
);