| Index: branches/stable/phase3/maintenance/archives/patch-indexes.sql |
| — | — | @@ -5,21 +5,20 @@ |
| 6 | 6 | -- |
| 7 | 7 | |
| 8 | 8 | ALTER TABLE links |
| 9 | | - DROP INDEX l_from (l_from (10)), |
| | 9 | + DROP INDEX l_from, |
| 10 | 10 | ADD INDEX l_from (l_from); |
| 11 | 11 | |
| 12 | 12 | ALTER TABLE brokenlinks |
| 13 | | - DROP INDEX bl_to (bl_to(10)), |
| 14 | | - ADD INDEX bl_to (bo_to); |
| | 13 | + DROP INDEX bl_to, |
| | 14 | + ADD INDEX bl_to (bL_to); |
| 15 | 15 | |
| 16 | 16 | ALTER TABLE recentchanges |
| 17 | | - ADD INDEX rc_timestamp (rc_timestamp), |
| 18 | | - ADD INDEX rc_namespace_title (rc_namespace, rc_title), |
| 19 | | - ADD INDEX rc_cur_id (rc_cur_id); |
| | 17 | + ADD INDEX rc_timestamp (rc_timestamp), |
| | 18 | + ADD INDEX rc_namespace_title (rc_namespace, rc_title), |
| | 19 | + ADD INDEX rc_cur_id (rc_cur_id); |
| 20 | 20 | |
| 21 | 21 | ALTER TABLE archive |
| 22 | | - ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp); |
| | 22 | + ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp); |
| 23 | 23 | |
| 24 | 24 | ALTER TABLE watchlist |
| 25 | | - ADD KEY namespace_title (wl_namespace,wl_title); |
| 26 | | - |
| | 25 | + ADD KEY namespace_title (wl_namespace,wl_title); |