1 -- This file should be phased out.
2 -- It's useless importing dumps that already have indexes in their definitions.
5 -- SQL to add non-unique indexes to Wikipedia database tables.
6 -- This is read and executed by the install script; you should
7 -- never have to run it by itself.
11 ADD INDEX user_name (user_name(10));
13 ALTER TABLE user_newtalk
14 ADD INDEX user_id (user_id
),
15 ADD INDEX user_ip (user_ip
);
18 ADD INDEX cur_namespace (cur_namespace
),
19 ADD INDEX cur_title (cur_title(20)),
20 ADD INDEX cur_timestamp (cur_timestamp
),
21 ADD INDEX (cur_random
),
22 ADD INDEX name_title_timestamp (cur_namespace
,cur_title
,inverse_timestamp
),
23 ADD INDEX user_timestamp (cur_user
,inverse_timestamp
),
24 ADD INDEX usertext_timestamp (cur_user_text
,inverse_timestamp
),
25 ADD INDEX namespace_redirect_timestamp(cur_namespace
,cur_is_redirect
,cur_timestamp
);
28 ADD INDEX (old_namespace
,old_title(20)),
29 ADD INDEX old_timestamp (old_timestamp
),
30 ADD INDEX name_title_timestamp (old_namespace
,old_title
,inverse_timestamp
),
31 ADD INDEX user_timestamp (old_user
,inverse_timestamp
),
32 ADD INDEX usertext_timestamp (old_user_text
,inverse_timestamp
);
35 ADD INDEX ipb_address (ipb_address
),
36 ADD INDEX ipb_user (ipb_user
);
39 ADD INDEX img_name (img_name(10)),
40 ADD INDEX img_size (img_size
),
41 ADD INDEX img_timestamp (img_timestamp
);
44 ADD INDEX oi_name (oi_name(10));
46 ALTER TABLE searchindex
47 ADD FULLTEXT
si_title (si_title
),
48 ADD FULLTEXT
si_text (si_text
);
50 ALTER TABLE recentchanges
51 ADD INDEX rc_timestamp (rc_timestamp
),
52 ADD INDEX rc_namespace_title (rc_namespace
, rc_title
),
53 ADD INDEX rc_cur_id (rc_cur_id
),
54 ADD INDEX new_name_timestamp(rc_new
,rc_namespace
,rc_timestamp
);
57 ADD KEY `name_title_timestamp`
(`ar_namespace`
,`ar_title`
,`ar_timestamp`
);
60 ADD KEY namespace_title (wl_namespace
,wl_title
);