| Index: branches/REL1_4/phase3/maintenance/tables.sql |
| — | — | @@ -60,7 +60,8 @@ |
| 61 | 61 | INDEX name_title_timestamp (cur_namespace,cur_title,inverse_timestamp), |
| 62 | 62 | INDEX user_timestamp (cur_user,inverse_timestamp), |
| 63 | 63 | INDEX usertext_timestamp (cur_user_text,inverse_timestamp), |
| 64 | | - INDEX namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp) |
| | 64 | + INDEX namespace_redirect_timestamp(cur_namespace,cur_is_redirect,cur_timestamp), |
| | 65 | + INDEX id_title_ns_red (cur_id,cur_title,cur_namespace,Cur_is_redirect) |
| 65 | 66 | ); |
| 66 | 67 | |
| 67 | 68 | CREATE TABLE /*$wgDBprefix*/old ( |
| — | — | @@ -159,7 +160,7 @@ |
| 160 | 161 | ); |
| 161 | 162 | |
| 162 | 163 | CREATE TABLE /*$wgDBprefix*/site_stats ( |
| 163 | | - ss_row_id int(8) unsigned NOT NULL, |
| | 164 | + ss_row_id int(8) unsigned NOT NULL default '1', |
| 164 | 165 | ss_total_views bigint(20) unsigned default '0', |
| 165 | 166 | ss_total_edits bigint(20) unsigned default '0', |
| 166 | 167 | ss_good_articles bigint(20) unsigned default '0', |