| Index: branches/wmf/1.18wmf1/maintenance/tables.sql |
| — | — | @@ -1090,7 +1090,32 @@ |
| 1091 | 1091 | CREATE UNIQUE INDEX /*i*/wl_user ON /*_*/watchlist (wl_user, wl_namespace, wl_title); |
| 1092 | 1092 | CREATE INDEX /*i*/namespace_title ON /*_*/watchlist (wl_namespace, wl_title); |
| 1093 | 1093 | |
| | 1094 | + |
| 1094 | 1095 | -- |
| | 1096 | +-- When using the default MySQL search backend, page titles |
| | 1097 | +-- and text are munged to strip markup, do Unicode case folding, |
| | 1098 | +-- and prepare the result for MySQL's fulltext index. |
| | 1099 | +-- |
| | 1100 | +-- This table must be MyISAM; InnoDB does not support the needed |
| | 1101 | +-- fulltext index. |
| | 1102 | +-- |
| | 1103 | +CREATE TABLE /*_*/searchindex ( |
| | 1104 | + -- Key to page_id |
| | 1105 | + si_page int unsigned NOT NULL, |
| | 1106 | + |
| | 1107 | + -- Munged version of title |
| | 1108 | + si_title varchar(255) NOT NULL default '', |
| | 1109 | + |
| | 1110 | + -- Munged version of body text |
| | 1111 | + si_text mediumtext NOT NULL |
| | 1112 | +) ENGINE=MyISAM; |
| | 1113 | + |
| | 1114 | +CREATE UNIQUE INDEX /*i*/si_page ON /*_*/searchindex (si_page); |
| | 1115 | +CREATE FULLTEXT INDEX /*i*/si_title ON /*_*/searchindex (si_title); |
| | 1116 | +--CREATE FULLTEXT INDEX /*i*/si_text ON /*_*/searchindex (si_text); |
| | 1117 | + |
| | 1118 | + |
| | 1119 | +-- |
| 1095 | 1120 | -- Recognized interwiki link prefixes |
| 1096 | 1121 | -- |
| 1097 | 1122 | CREATE TABLE /*_*/interwiki ( |