MediaWiki REL1_28
MysqlUpdater.php
Go to the documentation of this file.
1<?php
30class MysqlUpdater extends DatabaseUpdater {
31 protected function getCoreUpdateList() {
32 return [
33 [ 'disableContentHandlerUseDB' ],
34
35 // 1.2
36 [ 'addField', 'ipblocks', 'ipb_id', 'patch-ipblocks.sql' ],
37 [ 'addField', 'ipblocks', 'ipb_expiry', 'patch-ipb_expiry.sql' ],
38 [ 'doInterwikiUpdate' ],
39 [ 'doIndexUpdate' ],
40 [ 'addField', 'recentchanges', 'rc_type', 'patch-rc_type.sql' ],
41 [ 'addIndex', 'recentchanges', 'new_name_timestamp', 'patch-rc-newindex.sql' ],
42
43 // 1.3
44 [ 'addField', 'user', 'user_real_name', 'patch-user-realname.sql' ],
45 [ 'addTable', 'querycache', 'patch-querycache.sql' ],
46 [ 'addTable', 'objectcache', 'patch-objectcache.sql' ],
47 [ 'addTable', 'categorylinks', 'patch-categorylinks.sql' ],
48 [ 'doOldLinksUpdate' ],
49 [ 'doFixAncientImagelinks' ],
50 [ 'addField', 'recentchanges', 'rc_ip', 'patch-rc_ip.sql' ],
51
52 // 1.4
53 [ 'addIndex', 'image', 'PRIMARY', 'patch-image_name_primary.sql' ],
54 [ 'addField', 'recentchanges', 'rc_id', 'patch-rc_id.sql' ],
55 [ 'addField', 'recentchanges', 'rc_patrolled', 'patch-rc-patrol.sql' ],
56 [ 'addTable', 'logging', 'patch-logging.sql' ],
57 [ 'addField', 'user', 'user_token', 'patch-user_token.sql' ],
58 [ 'addField', 'watchlist', 'wl_notificationtimestamp', 'patch-email-notification.sql' ],
59 [ 'doWatchlistUpdate' ],
60 [ 'dropField', 'user', 'user_emailauthenticationtimestamp',
61 'patch-email-authentication.sql' ],
62
63 // 1.5
64 [ 'doSchemaRestructuring' ],
65 [ 'addField', 'logging', 'log_params', 'patch-log_params.sql' ],
66 [ 'checkBin', 'logging', 'log_title', 'patch-logging-title.sql', ],
67 [ 'addField', 'archive', 'ar_rev_id', 'patch-archive-rev_id.sql' ],
68 [ 'addField', 'page', 'page_len', 'patch-page_len.sql' ],
69 [ 'dropField', 'revision', 'inverse_timestamp', 'patch-inverse_timestamp.sql' ],
70 [ 'addField', 'revision', 'rev_text_id', 'patch-rev_text_id.sql' ],
71 [ 'addField', 'revision', 'rev_deleted', 'patch-rev_deleted.sql' ],
72 [ 'addField', 'image', 'img_width', 'patch-img_width.sql' ],
73 [ 'addField', 'image', 'img_metadata', 'patch-img_metadata.sql' ],
74 [ 'addField', 'user', 'user_email_token', 'patch-user_email_token.sql' ],
75 [ 'addField', 'archive', 'ar_text_id', 'patch-archive-text_id.sql' ],
76 [ 'doNamespaceSize' ],
77 [ 'addField', 'image', 'img_media_type', 'patch-img_media_type.sql' ],
78 [ 'doPagelinksUpdate' ],
79 [ 'dropField', 'image', 'img_type', 'patch-drop_img_type.sql' ],
80 [ 'doUserUniqueUpdate' ],
81 [ 'doUserGroupsUpdate' ],
82 [ 'addField', 'site_stats', 'ss_total_pages', 'patch-ss_total_articles.sql' ],
83 [ 'addTable', 'user_newtalk', 'patch-usernewtalk2.sql' ],
84 [ 'addTable', 'transcache', 'patch-transcache.sql' ],
85 [ 'addField', 'interwiki', 'iw_trans', 'patch-interwiki-trans.sql' ],
86
87 // 1.6
88 [ 'doWatchlistNull' ],
89 [ 'addIndex', 'logging', 'times', 'patch-logging-times-index.sql' ],
90 [ 'addField', 'ipblocks', 'ipb_range_start', 'patch-ipb_range_start.sql' ],
91 [ 'doPageRandomUpdate' ],
92 [ 'addField', 'user', 'user_registration', 'patch-user_registration.sql' ],
93 [ 'doTemplatelinksUpdate' ],
94 [ 'addTable', 'externallinks', 'patch-externallinks.sql' ],
95 [ 'addTable', 'job', 'patch-job.sql' ],
96 [ 'addField', 'site_stats', 'ss_images', 'patch-ss_images.sql' ],
97 [ 'addTable', 'langlinks', 'patch-langlinks.sql' ],
98 [ 'addTable', 'querycache_info', 'patch-querycacheinfo.sql' ],
99 [ 'addTable', 'filearchive', 'patch-filearchive.sql' ],
100 [ 'addField', 'ipblocks', 'ipb_anon_only', 'patch-ipb_anon_only.sql' ],
101 [ 'addIndex', 'recentchanges', 'rc_ns_usertext', 'patch-recentchanges-utindex.sql' ],
102 [ 'addIndex', 'recentchanges', 'rc_user_text', 'patch-rc_user_text-index.sql' ],
103
104 // 1.9
105 [ 'addField', 'user', 'user_newpass_time', 'patch-user_newpass_time.sql' ],
106 [ 'addTable', 'redirect', 'patch-redirect.sql' ],
107 [ 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ],
108 [ 'addField', 'ipblocks', 'ipb_enable_autoblock', 'patch-ipb_optional_autoblock.sql' ],
109 [ 'doBacklinkingIndicesUpdate' ],
110 [ 'addField', 'recentchanges', 'rc_old_len', 'patch-rc_len.sql' ],
111 [ 'addField', 'user', 'user_editcount', 'patch-user_editcount.sql' ],
112
113 // 1.10
114 [ 'doRestrictionsUpdate' ],
115 [ 'addField', 'logging', 'log_id', 'patch-log_id.sql' ],
116 [ 'addField', 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ],
117 [ 'addField', 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ],
118 [ 'addField', 'revision', 'rev_len', 'patch-rev_len.sql' ],
119 [ 'addField', 'recentchanges', 'rc_deleted', 'patch-rc_deleted.sql' ],
120 [ 'addField', 'logging', 'log_deleted', 'patch-log_deleted.sql' ],
121 [ 'addField', 'archive', 'ar_deleted', 'patch-ar_deleted.sql' ],
122 [ 'addField', 'ipblocks', 'ipb_deleted', 'patch-ipb_deleted.sql' ],
123 [ 'addField', 'filearchive', 'fa_deleted', 'patch-fa_deleted.sql' ],
124 [ 'addField', 'archive', 'ar_len', 'patch-ar_len.sql' ],
125
126 // 1.11
127 [ 'addField', 'ipblocks', 'ipb_block_email', 'patch-ipb_emailban.sql' ],
128 [ 'doCategorylinksIndicesUpdate' ],
129 [ 'addField', 'oldimage', 'oi_metadata', 'patch-oi_metadata.sql' ],
130 [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-archive-user-index.sql' ],
131 [ 'addIndex', 'image', 'img_usertext_timestamp', 'patch-image-user-index.sql' ],
132 [ 'addIndex', 'oldimage', 'oi_usertext_timestamp', 'patch-oldimage-user-index.sql' ],
133 [ 'addField', 'archive', 'ar_page_id', 'patch-archive-page_id.sql' ],
134 [ 'addField', 'image', 'img_sha1', 'patch-img_sha1.sql' ],
135
136 // 1.12
137 [ 'addTable', 'protected_titles', 'patch-protected_titles.sql' ],
138
139 // 1.13
140 [ 'addField', 'ipblocks', 'ipb_by_text', 'patch-ipb_by_text.sql' ],
141 [ 'addTable', 'page_props', 'patch-page_props.sql' ],
142 [ 'addTable', 'updatelog', 'patch-updatelog.sql' ],
143 [ 'addTable', 'category', 'patch-category.sql' ],
144 [ 'doCategoryPopulation' ],
145 [ 'addField', 'archive', 'ar_parent_id', 'patch-ar_parent_id.sql' ],
146 [ 'addField', 'user_newtalk', 'user_last_timestamp', 'patch-user_last_timestamp.sql' ],
147 [ 'doPopulateParentId' ],
148 [ 'checkBin', 'protected_titles', 'pt_title', 'patch-pt_title-encoding.sql', ],
149 [ 'doMaybeProfilingMemoryUpdate' ],
150 [ 'doFilearchiveIndicesUpdate' ],
151
152 // 1.14
153 [ 'addField', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ],
154 [ 'doActiveUsersInit' ],
155 [ 'addField', 'ipblocks', 'ipb_allow_usertalk', 'patch-ipb_allow_usertalk.sql' ],
156
157 // 1.15
158 [ 'addTable', 'change_tag', 'patch-change_tag.sql' ],
159 [ 'addTable', 'tag_summary', 'patch-tag_summary.sql' ],
160 [ 'addTable', 'valid_tag', 'patch-valid_tag.sql' ],
161
162 // 1.16
163 [ 'addTable', 'user_properties', 'patch-user_properties.sql' ],
164 [ 'addTable', 'log_search', 'patch-log_search.sql' ],
165 [ 'addField', 'logging', 'log_user_text', 'patch-log_user_text.sql' ],
166 # listed separately from the previous update because 1.16 was released without this update
167 [ 'doLogUsertextPopulation' ],
168 [ 'doLogSearchPopulation' ],
169 [ 'addTable', 'l10n_cache', 'patch-l10n_cache.sql' ],
170 [ 'addIndex', 'log_search', 'ls_field_val', 'patch-log_search-rename-index.sql' ],
171 [ 'addIndex', 'change_tag', 'change_tag_rc_tag', 'patch-change_tag-indexes.sql' ],
172 [ 'addField', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ],
173 [ 'doUpdateTranscacheField' ],
174 [ 'doUpdateMimeMinorField' ],
175
176 // 1.17
177 [ 'addTable', 'iwlinks', 'patch-iwlinks.sql' ],
178 [ 'addIndex', 'iwlinks', 'iwl_prefix_title_from', 'patch-rename-iwl_prefix.sql' ],
179 [ 'addField', 'updatelog', 'ul_value', 'patch-ul_value.sql' ],
180 [ 'addField', 'interwiki', 'iw_api', 'patch-iw_api_and_wikiid.sql' ],
181 [ 'dropIndex', 'iwlinks', 'iwl_prefix', 'patch-kill-iwl_prefix.sql' ],
182 [ 'addField', 'categorylinks', 'cl_collation', 'patch-categorylinks-better-collation.sql' ],
183 [ 'doClFieldsUpdate' ],
184 [ 'addTable', 'module_deps', 'patch-module_deps.sql' ],
185 [ 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ],
186 [ 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ],
187 [ 'doLangLinksLengthUpdate' ],
188
189 // 1.18
190 [ 'doUserNewTalkTimestampNotNull' ],
191 [ 'addIndex', 'user', 'user_email', 'patch-user_email_index.sql' ],
192 [ 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ],
193 [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
194 [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
195
196 // 1.19
197 [ 'addIndex', 'logging', 'type_action', 'patch-logging-type-action-index.sql' ],
198 [ 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1.sql' ],
199 [ 'doMigrateUserOptions' ],
200 [ 'dropField', 'user', 'user_options', 'patch-drop-user_options.sql' ],
201 [ 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1.sql' ],
202 [ 'addIndex', 'page', 'page_redirect_namespace_len',
203 'patch-page_redirect_namespace_len.sql' ],
204 [ 'addField', 'uploadstash', 'us_chunk_inx', 'patch-uploadstash_chunk.sql' ],
205 [ 'addfield', 'job', 'job_timestamp', 'patch-jobs-add-timestamp.sql' ],
206
207 // 1.20
208 [ 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ],
209 [ 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ],
210 [ 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ],
211 [ 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ],
212
213 // 1.21
214 [ 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ],
215 [ 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ],
216 [ 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ],
217 [ 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ],
218 [ 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ],
219 [ 'enableContentHandlerUseDB' ],
220 [ 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ],
221 [ 'dropField', 'recentchanges', 'rc_moved_to_title', 'patch-rc_moved.sql' ],
222 [ 'addTable', 'sites', 'patch-sites.sql' ],
223 [ 'addField', 'filearchive', 'fa_sha1', 'patch-fa_sha1.sql' ],
224 [ 'addField', 'job', 'job_token', 'patch-job_token.sql' ],
225 [ 'addField', 'job', 'job_attempts', 'patch-job_attempts.sql' ],
226 [ 'doEnableProfiling' ],
227 [ 'addField', 'uploadstash', 'us_props', 'patch-uploadstash-us_props.sql' ],
228 [ 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ],
229 [ 'modifyField', 'user_former_groups', 'ufg_group',
230 'patch-ufg_group-length-increase-255.sql' ],
231 [ 'addIndex', 'page_props', 'pp_propname_page',
232 'patch-page_props-propname-page-index.sql' ],
233 [ 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ],
234
235 // 1.22
236 [ 'doIwlinksIndexNonUnique' ],
237 [ 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
238 'patch-iwlinks-from-title-index.sql' ],
239 [ 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ],
240 [ 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ],
241
242 // 1.23
243 [ 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ],
244 [ 'addIndex', 'logging', 'log_user_text_type_time',
245 'patch-logging_user_text_type_time_index.sql' ],
246 [ 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ],
247 [ 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ],
248 [ 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ],
249
250 // 1.24
251 [ 'addField', 'page_props', 'pp_sortkey', 'patch-pp_sortkey.sql' ],
252 [ 'dropField', 'recentchanges', 'rc_cur_time', 'patch-drop-rc_cur_time.sql' ],
253 [ 'addIndex', 'watchlist', 'wl_user_notificationtimestamp',
254 'patch-watchlist-user-notificationtimestamp-index.sql' ],
255 [ 'addField', 'page', 'page_lang', 'patch-page_lang.sql' ],
256 [ 'addField', 'pagelinks', 'pl_from_namespace', 'patch-pl_from_namespace.sql' ],
257 [ 'addField', 'templatelinks', 'tl_from_namespace', 'patch-tl_from_namespace.sql' ],
258 [ 'addField', 'imagelinks', 'il_from_namespace', 'patch-il_from_namespace.sql' ],
259 [ 'modifyField', 'image', 'img_major_mime',
260 'patch-img_major_mime-chemical.sql' ],
261 [ 'modifyField', 'oldimage', 'oi_major_mime',
262 'patch-oi_major_mime-chemical.sql' ],
263 [ 'modifyField', 'filearchive', 'fa_major_mime',
264 'patch-fa_major_mime-chemical.sql' ],
265
266 // 1.25
267 [ 'doUserNewTalkUseridUnsigned' ],
268 // note this patch covers other _comment and _description fields too
269 [ 'modifyField', 'recentchanges', 'rc_comment', 'patch-editsummary-length.sql' ],
270
271 // 1.26
272 [ 'dropTable', 'hitcounter' ],
273 [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
274 [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
275
276 // 1.27
277 [ 'dropTable', 'msg_resource_links' ],
278 [ 'dropTable', 'msg_resource' ],
279 [ 'addTable', 'bot_passwords', 'patch-bot_passwords.sql' ],
280 [ 'addField', 'watchlist', 'wl_id', 'patch-watchlist-wl_id.sql' ],
281 [ 'dropIndex', 'categorylinks', 'cl_collation', 'patch-kill-cl_collation_index.sql' ],
282 [ 'addIndex', 'categorylinks', 'cl_collation_ext',
283 'patch-add-cl_collation_ext_index.sql' ],
284 [ 'doCollationUpdate' ],
285
286 // 1.28
287 [ 'addIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
288 'patch-add-rc_name_type_patrolled_timestamp_index.sql' ],
289 [ 'doRevisionPageRevIndexNonUnique' ],
290 [ 'doNonUniquePlTlIl' ],
291 [ 'addField', 'change_tag', 'ct_id', 'patch-change_tag-ct_id.sql' ],
292 [ 'addField', 'tag_summary', 'ts_id', 'patch-tag_summary-ts_id.sql' ],
293 [ 'modifyField', 'recentchanges', 'rc_ip', 'patch-rc_ip_modify.sql' ],
294 [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-rename-ar_usertext_timestamp.sql' ],
295 ];
296 }
297
307 protected function checkBin( $table, $field, $patchFile ) {
308 if ( !$this->doTable( $table ) ) {
309 return true;
310 }
311
313 $fieldInfo = $this->db->fieldInfo( $table, $field );
314 if ( $fieldInfo->isBinary() ) {
315 $this->output( "...$table table has correct $field encoding.\n" );
316 } else {
317 $this->applyPatch( $patchFile, false, "Fixing $field encoding on $table table" );
318 }
319 }
320
329 protected function indexHasField( $table, $index, $field ) {
330 if ( !$this->doTable( $table ) ) {
331 return true;
332 }
333
334 $info = $this->db->indexInfo( $table, $index, __METHOD__ );
335 if ( $info ) {
336 foreach ( $info as $row ) {
337 if ( $row->Column_name == $field ) {
338 $this->output( "...index $index on table $table includes field $field.\n" );
339
340 return true;
341 }
342 }
343 }
344 $this->output( "...index $index on table $table has no field $field; added.\n" );
345
346 return false;
347 }
348
352 protected function doInterwikiUpdate() {
353 global $IP;
354
355 if ( !$this->doTable( 'interwiki' ) ) {
356 return true;
357 }
358
359 if ( $this->db->tableExists( "interwiki", __METHOD__ ) ) {
360 $this->output( "...already have interwiki table\n" );
361
362 return;
363 }
364
365 $this->applyPatch( 'patch-interwiki.sql', false, 'Creating interwiki table' );
366 $this->applyPatch(
367 "$IP/maintenance/interwiki.sql",
368 true,
369 'Adding default interwiki definitions'
370 );
371 }
372
376 protected function doIndexUpdate() {
377 $meta = $this->db->fieldInfo( 'recentchanges', 'rc_timestamp' );
378 if ( $meta === false ) {
379 throw new MWException( 'Missing rc_timestamp field of recentchanges table. Should not happen.' );
380 }
381 if ( $meta->isMultipleKey() ) {
382 $this->output( "...indexes seem up to 20031107 standards.\n" );
383
384 return;
385 }
386
387 $this->applyPatch( 'patch-indexes.sql', true, "Updating indexes to 20031107" );
388 }
389
390 protected function doOldLinksUpdate() {
391 $cl = $this->maintenance->runChild( 'ConvertLinks' );
392 $cl->execute();
393 }
394
395 protected function doFixAncientImagelinks() {
396 $info = $this->db->fieldInfo( 'imagelinks', 'il_from' );
397 if ( !$info || $info->type() !== 'string' ) {
398 $this->output( "...il_from OK\n" );
399
400 return;
401 }
402
403 $applied = $this->applyPatch(
404 'patch-fix-il_from.sql',
405 false,
406 'Fixing ancient broken imagelinks table.'
407 );
408
409 if ( $applied ) {
410 $this->output( "NOTE: you will have to run maintenance/refreshLinks.php after this." );
411 }
412 }
413
417 function doWatchlistUpdate() {
418 $talk = $this->db->selectField( 'watchlist', 'count(*)', 'wl_namespace & 1', __METHOD__ );
419 $nontalk = $this->db->selectField(
420 'watchlist',
421 'count(*)',
422 'NOT (wl_namespace & 1)',
423 __METHOD__
424 );
425 if ( $talk == $nontalk ) {
426 $this->output( "...watchlist talk page rows already present.\n" );
427
428 return;
429 }
430
431 $this->output( "Adding missing watchlist talk page rows... " );
432 $this->db->insertSelect( 'watchlist', 'watchlist',
433 [
434 'wl_user' => 'wl_user',
435 'wl_namespace' => 'wl_namespace | 1',
436 'wl_title' => 'wl_title',
437 'wl_notificationtimestamp' => 'wl_notificationtimestamp'
438 ], [ 'NOT (wl_namespace & 1)' ], __METHOD__, 'IGNORE' );
439 $this->output( "done.\n" );
440
441 $this->output( "Adding missing watchlist subject page rows... " );
442 $this->db->insertSelect( 'watchlist', 'watchlist',
443 [
444 'wl_user' => 'wl_user',
445 'wl_namespace' => 'wl_namespace & ~1',
446 'wl_title' => 'wl_title',
447 'wl_notificationtimestamp' => 'wl_notificationtimestamp'
448 ], [ 'wl_namespace & 1' ], __METHOD__, 'IGNORE' );
449 $this->output( "done.\n" );
450 }
451
452 function doSchemaRestructuring() {
453 if ( $this->db->tableExists( 'page', __METHOD__ ) ) {
454 $this->output( "...page table already exists.\n" );
455
456 return;
457 }
458
459 $this->output( "...converting from cur/old to page/revision/text DB structure.\n" );
460 $this->output( wfTimestamp( TS_DB ) );
461 $this->output( "......checking for duplicate entries.\n" );
462
463 list( $cur, $old, $page, $revision, $text ) = $this->db->tableNamesN(
464 'cur',
465 'old',
466 'page',
467 'revision',
468 'text'
469 );
470
471 $rows = $this->db->query( "
472 SELECT cur_title, cur_namespace, COUNT(cur_namespace) AS c
473 FROM $cur
474 GROUP BY cur_title, cur_namespace
475 HAVING c>1",
476 __METHOD__
477 );
478
479 if ( $rows->numRows() > 0 ) {
480 $this->output( wfTimestamp( TS_DB ) );
481 $this->output( "......<b>Found duplicate entries</b>\n" );
482 $this->output( sprintf( "<b> %-60s %3s %5s</b>\n", 'Title', 'NS', 'Count' ) );
483 $duplicate = [];
484 foreach ( $rows as $row ) {
485 if ( !isset( $duplicate[$row->cur_namespace] ) ) {
486 $duplicate[$row->cur_namespace] = [];
487 }
488
489 $duplicate[$row->cur_namespace][] = $row->cur_title;
490 $this->output( sprintf(
491 " %-60s %3s %5s\n",
492 $row->cur_title, $row->cur_namespace,
493 $row->c
494 ) );
495 }
496 $sql = "SELECT cur_title, cur_namespace, cur_id, cur_timestamp FROM $cur WHERE ";
497 $firstCond = true;
498 foreach ( $duplicate as $ns => $titles ) {
499 if ( $firstCond ) {
500 $firstCond = false;
501 } else {
502 $sql .= ' OR ';
503 }
504 $sql .= "( cur_namespace = {$ns} AND cur_title in (";
505 $first = true;
506 foreach ( $titles as $t ) {
507 if ( $first ) {
508 $sql .= $this->db->addQuotes( $t );
509 $first = false;
510 } else {
511 $sql .= ', ' . $this->db->addQuotes( $t );
512 }
513 }
514 $sql .= ") ) \n";
515 }
516 # By sorting descending, the most recent entry will be the first in the list.
517 # All following entries will be deleted by the next while-loop.
518 $sql .= 'ORDER BY cur_namespace, cur_title, cur_timestamp DESC';
519
520 $rows = $this->db->query( $sql, __METHOD__ );
521
522 $prev_title = $prev_namespace = false;
523 $deleteId = [];
524
525 foreach ( $rows as $row ) {
526 if ( $prev_title == $row->cur_title && $prev_namespace == $row->cur_namespace ) {
527 $deleteId[] = $row->cur_id;
528 }
529 $prev_title = $row->cur_title;
530 $prev_namespace = $row->cur_namespace;
531 }
532 $sql = "DELETE FROM $cur WHERE cur_id IN ( " . implode( ',', $deleteId ) . ')';
533 $this->db->query( $sql, __METHOD__ );
534 $this->output( wfTimestamp( TS_DB ) );
535 $this->output( "......<b>Deleted</b> " . $this->db->affectedRows() . " records.\n" );
536 }
537
538 $this->output( wfTimestamp( TS_DB ) );
539 $this->output( "......Creating tables.\n" );
540 $this->db->query( "CREATE TABLE $page (
541 page_id int(8) unsigned NOT NULL auto_increment,
542 page_namespace int NOT NULL,
543 page_title varchar(255) binary NOT NULL,
544 page_restrictions tinyblob NOT NULL,
545 page_is_redirect tinyint(1) unsigned NOT NULL default '0',
546 page_is_new tinyint(1) unsigned NOT NULL default '0',
547 page_random real unsigned NOT NULL,
548 page_touched char(14) binary NOT NULL default '',
549 page_latest int(8) unsigned NOT NULL,
550 page_len int(8) unsigned NOT NULL,
551
552 PRIMARY KEY page_id (page_id),
553 UNIQUE INDEX name_title (page_namespace,page_title),
554 INDEX (page_random),
555 INDEX (page_len)
556 ) ENGINE=InnoDB", __METHOD__ );
557 $this->db->query( "CREATE TABLE $revision (
558 rev_id int(8) unsigned NOT NULL auto_increment,
559 rev_page int(8) unsigned NOT NULL,
560 rev_comment tinyblob NOT NULL,
561 rev_user int(5) unsigned NOT NULL default '0',
562 rev_user_text varchar(255) binary NOT NULL default '',
563 rev_timestamp char(14) binary NOT NULL default '',
564 rev_minor_edit tinyint(1) unsigned NOT NULL default '0',
565 rev_deleted tinyint(1) unsigned NOT NULL default '0',
566 rev_len int(8) unsigned,
567 rev_parent_id int(8) unsigned default NULL,
568 PRIMARY KEY rev_page_id (rev_page, rev_id),
569 UNIQUE INDEX rev_id (rev_id),
570 INDEX rev_timestamp (rev_timestamp),
571 INDEX page_timestamp (rev_page,rev_timestamp),
572 INDEX user_timestamp (rev_user,rev_timestamp),
573 INDEX usertext_timestamp (rev_user_text,rev_timestamp)
574 ) ENGINE=InnoDB", __METHOD__ );
575
576 $this->output( wfTimestamp( TS_DB ) );
577 $this->output( "......Locking tables.\n" );
578 $this->db->query(
579 "LOCK TABLES $page WRITE, $revision WRITE, $old WRITE, $cur WRITE",
580 __METHOD__
581 );
582
583 $maxold = intval( $this->db->selectField( 'old', 'max(old_id)', '', __METHOD__ ) );
584 $this->output( wfTimestamp( TS_DB ) );
585 $this->output( "......maxold is {$maxold}\n" );
586
587 $this->output( wfTimestamp( TS_DB ) );
588 global $wgLegacySchemaConversion;
589 if ( $wgLegacySchemaConversion ) {
590 // Create HistoryBlobCurStub entries.
591 // Text will be pulled from the leftover 'cur' table at runtime.
592 $this->output( "......Moving metadata from cur; using blob references to text in cur table.\n" );
593 $cur_text = "concat('O:18:\"historyblobcurstub\":1:{s:6:\"mCurId\";i:',cur_id,';}')";
594 $cur_flags = "'object'";
595 } else {
596 // Copy all cur text in immediately: this may take longer but avoids
597 // having to keep an extra table around.
598 $this->output( "......Moving text from cur.\n" );
599 $cur_text = 'cur_text';
600 $cur_flags = "''";
601 }
602 $this->db->query(
603 "INSERT INTO $old (old_namespace, old_title, old_text, old_comment, old_user,
604 old_user_text, old_timestamp, old_minor_edit, old_flags)
605 SELECT cur_namespace, cur_title, $cur_text, cur_comment, cur_user, cur_user_text,
606 cur_timestamp, cur_minor_edit, $cur_flags
607 FROM $cur",
608 __METHOD__
609 );
610
611 $this->output( wfTimestamp( TS_DB ) );
612 $this->output( "......Setting up revision table.\n" );
613 $this->db->query(
614 "INSERT INTO $revision (rev_id, rev_page, rev_comment, rev_user,
615 rev_user_text, rev_timestamp, rev_minor_edit)
616 SELECT old_id, cur_id, old_comment, old_user, old_user_text,
617 old_timestamp, old_minor_edit
618 FROM $old,$cur WHERE old_namespace=cur_namespace AND old_title=cur_title",
619 __METHOD__
620 );
621
622 $this->output( wfTimestamp( TS_DB ) );
623 $this->output( "......Setting up page table.\n" );
624 $this->db->query(
625 "INSERT INTO $page (page_id, page_namespace, page_title,
626 page_restrictions, page_is_redirect, page_is_new, page_random,
627 page_touched, page_latest, page_len)
628 SELECT cur_id, cur_namespace, cur_title, cur_restrictions,
629 cur_is_redirect, cur_is_new, cur_random, cur_touched, rev_id, LENGTH(cur_text)
630 FROM $cur,$revision
631 WHERE cur_id=rev_page AND rev_timestamp=cur_timestamp AND rev_id > {$maxold}",
632 __METHOD__
633 );
634
635 $this->output( wfTimestamp( TS_DB ) );
636 $this->output( "......Unlocking tables.\n" );
637 $this->db->query( "UNLOCK TABLES", __METHOD__ );
638
639 $this->output( wfTimestamp( TS_DB ) );
640 $this->output( "......Renaming old.\n" );
641 $this->db->query( "ALTER TABLE $old RENAME TO $text", __METHOD__ );
642
643 $this->output( wfTimestamp( TS_DB ) );
644 $this->output( "...done.\n" );
645 }
646
647 protected function doNamespaceSize() {
648 $tables = [
649 'page' => 'page',
650 'archive' => 'ar',
651 'recentchanges' => 'rc',
652 'watchlist' => 'wl',
653 'querycache' => 'qc',
654 'logging' => 'log',
655 ];
656 foreach ( $tables as $table => $prefix ) {
657 $field = $prefix . '_namespace';
658
659 $tablename = $this->db->tableName( $table );
660 $result = $this->db->query( "SHOW COLUMNS FROM $tablename LIKE '$field'", __METHOD__ );
661 $info = $this->db->fetchObject( $result );
662
663 if ( substr( $info->Type, 0, 3 ) == 'int' ) {
664 $this->output( "...$field is already a full int ($info->Type).\n" );
665 } else {
666 $this->output( "Promoting $field from $info->Type to int... " );
667 $this->db->query( "ALTER TABLE $tablename MODIFY $field int NOT NULL", __METHOD__ );
668 $this->output( "done.\n" );
669 }
670 }
671 }
672
673 protected function doPagelinksUpdate() {
674 if ( $this->db->tableExists( 'pagelinks', __METHOD__ ) ) {
675 $this->output( "...already have pagelinks table.\n" );
676
677 return;
678 }
679
680 $this->applyPatch(
681 'patch-pagelinks.sql',
682 false,
683 'Converting links and brokenlinks tables to pagelinks'
684 );
685
686 global $wgContLang;
687 foreach ( $wgContLang->getNamespaces() as $ns => $name ) {
688 if ( $ns == 0 ) {
689 continue;
690 }
691
692 $this->output( "Cleaning up broken links for namespace $ns... " );
693 $this->db->update( 'pagelinks',
694 [
695 'pl_namespace' => $ns,
696 "pl_title = TRIM(LEADING {$this->db->addQuotes( "$name:" )} FROM pl_title)",
697 ],
698 [
699 'pl_namespace' => 0,
700 'pl_title' . $this->db->buildLike( "$name:", $this->db->anyString() ),
701 ],
702 __METHOD__
703 );
704 $this->output( "done.\n" );
705 }
706 }
707
708 protected function doUserUniqueUpdate() {
709 if ( !$this->doTable( 'user' ) ) {
710 return true;
711 }
712
713 $duper = new UserDupes( $this->db, [ $this, 'output' ] );
714 if ( $duper->hasUniqueIndex() ) {
715 $this->output( "...already have unique user_name index.\n" );
716
717 return;
718 }
719
720 if ( !$duper->clearDupes() ) {
721 $this->output( "WARNING: This next step will probably fail due to unfixed duplicates...\n" );
722 }
723 $this->applyPatch( 'patch-user_nameindex.sql', false, "Adding unique index on user_name" );
724 }
725
726 protected function doUserGroupsUpdate() {
727 if ( !$this->doTable( 'user_groups' ) ) {
728 return true;
729 }
730
731 if ( $this->db->tableExists( 'user_groups', __METHOD__ ) ) {
732 $info = $this->db->fieldInfo( 'user_groups', 'ug_group' );
733 if ( $info->type() == 'int' ) {
734 $oldug = $this->db->tableName( 'user_groups' );
735 $newug = $this->db->tableName( 'user_groups_bogus' );
736 $this->output( "user_groups table exists but is in bogus intermediate " .
737 "format. Renaming to $newug... " );
738 $this->db->query( "ALTER TABLE $oldug RENAME TO $newug", __METHOD__ );
739 $this->output( "done.\n" );
740
741 $this->applyPatch( 'patch-user_groups.sql', false, "Re-adding fresh user_groups table" );
742
743 $this->output( "***\n" );
744 $this->output( "*** WARNING: You will need to manually fix up user " .
745 "permissions in the user_groups\n" );
746 $this->output( "*** table. Old 1.5 alpha versions did some pretty funky stuff...\n" );
747 $this->output( "***\n" );
748 } else {
749 $this->output( "...user_groups table exists and is in current format.\n" );
750 }
751
752 return;
753 }
754
755 $this->applyPatch( 'patch-user_groups.sql', false, "Adding user_groups table" );
756
757 if ( !$this->db->tableExists( 'user_rights', __METHOD__ ) ) {
758 if ( $this->db->fieldExists( 'user', 'user_rights', __METHOD__ ) ) {
759 $this->applyPatch(
760 'patch-user_rights.sql',
761 false,
762 'Upgrading from a 1.3 or older database? Breaking out user_rights for conversion'
763 );
764 } else {
765 $this->output( "*** WARNING: couldn't locate user_rights table or field for upgrade.\n" );
766 $this->output( "*** You may need to manually configure some sysops by manipulating\n" );
767 $this->output( "*** the user_groups table.\n" );
768
769 return;
770 }
771 }
772
773 $this->output( "Converting user_rights table to user_groups... " );
774 $result = $this->db->select( 'user_rights',
775 [ 'ur_user', 'ur_rights' ],
776 [ "ur_rights != ''" ],
777 __METHOD__ );
778
779 foreach ( $result as $row ) {
780 $groups = array_unique(
781 array_map( 'trim',
782 explode( ',', $row->ur_rights ) ) );
783
784 foreach ( $groups as $group ) {
785 $this->db->insert( 'user_groups',
786 [
787 'ug_user' => $row->ur_user,
788 'ug_group' => $group ],
789 __METHOD__ );
790 }
791 }
792 $this->output( "done.\n" );
793 }
794
799 protected function doWatchlistNull() {
800 $info = $this->db->fieldInfo( 'watchlist', 'wl_notificationtimestamp' );
801 if ( !$info ) {
802 return;
803 }
804 if ( $info->isNullable() ) {
805 $this->output( "...wl_notificationtimestamp is already nullable.\n" );
806
807 return;
808 }
809
810 $this->applyPatch(
811 'patch-watchlist-null.sql',
812 false,
813 'Making wl_notificationtimestamp nullable'
814 );
815 }
816
822 protected function doPageRandomUpdate() {
823 $page = $this->db->tableName( 'page' );
824 $this->db->query( "UPDATE $page SET page_random = RAND() WHERE page_random = 0", __METHOD__ );
825 $rows = $this->db->affectedRows();
826
827 if ( $rows ) {
828 $this->output( "Set page_random to a random value on $rows rows where it was set to 0\n" );
829 } else {
830 $this->output( "...no page_random rows needed to be set\n" );
831 }
832 }
833
834 protected function doTemplatelinksUpdate() {
835 if ( $this->db->tableExists( 'templatelinks', __METHOD__ ) ) {
836 $this->output( "...templatelinks table already exists\n" );
837
838 return;
839 }
840
841 $this->applyPatch( 'patch-templatelinks.sql', false, "Creating templatelinks table" );
842
843 $this->output( "Populating...\n" );
844 if ( wfGetLB()->getServerCount() > 1 ) {
845 // Slow, replication-friendly update
846 $res = $this->db->select( 'pagelinks', [ 'pl_from', 'pl_namespace', 'pl_title' ],
847 [ 'pl_namespace' => NS_TEMPLATE ], __METHOD__ );
848 $count = 0;
849 foreach ( $res as $row ) {
850 $count = ( $count + 1 ) % 100;
851 if ( $count == 0 ) {
852 wfGetLBFactory()->waitForReplication( [ 'wiki' => wfWikiID() ] );
853 }
854 $this->db->insert( 'templatelinks',
855 [
856 'tl_from' => $row->pl_from,
857 'tl_namespace' => $row->pl_namespace,
858 'tl_title' => $row->pl_title,
859 ], __METHOD__
860 );
861 }
862 } else {
863 // Fast update
864 $this->db->insertSelect( 'templatelinks', 'pagelinks',
865 [
866 'tl_from' => 'pl_from',
867 'tl_namespace' => 'pl_namespace',
868 'tl_title' => 'pl_title'
869 ], [
870 'pl_namespace' => 10
871 ], __METHOD__
872 );
873 }
874 $this->output( "Done. Please run maintenance/refreshLinks.php for a more " .
875 "thorough templatelinks update.\n" );
876 }
877
878 protected function doBacklinkingIndicesUpdate() {
879 if ( !$this->indexHasField( 'pagelinks', 'pl_namespace', 'pl_from' ) ||
880 !$this->indexHasField( 'templatelinks', 'tl_namespace', 'tl_from' ) ||
881 !$this->indexHasField( 'imagelinks', 'il_to', 'il_from' )
882 ) {
883 $this->applyPatch( 'patch-backlinkindexes.sql', false, "Updating backlinking indices" );
884 }
885 }
886
892 protected function doRestrictionsUpdate() {
893 if ( $this->db->tableExists( 'page_restrictions', __METHOD__ ) ) {
894 $this->output( "...page_restrictions table already exists.\n" );
895
896 return;
897 }
898
899 $this->applyPatch(
900 'patch-page_restrictions.sql',
901 false,
902 'Creating page_restrictions table (1/2)'
903 );
904 $this->applyPatch(
905 'patch-page_restrictions_sortkey.sql',
906 false,
907 'Creating page_restrictions table (2/2)'
908 );
909 $this->output( "done.\n" );
910
911 $this->output( "Migrating old restrictions to new table...\n" );
912 $task = $this->maintenance->runChild( 'UpdateRestrictions' );
913 $task->execute();
914 }
915
916 protected function doCategorylinksIndicesUpdate() {
917 if ( !$this->indexHasField( 'categorylinks', 'cl_sortkey', 'cl_from' ) ) {
918 $this->applyPatch( 'patch-categorylinksindex.sql', false, "Updating categorylinks Indices" );
919 }
920 }
921
922 protected function doCategoryPopulation() {
923 if ( $this->updateRowExists( 'populate category' ) ) {
924 $this->output( "...category table already populated.\n" );
925
926 return;
927 }
928
929 $this->output(
930 "Populating category table, printing progress markers. " .
931 "For large databases, you\n" .
932 "may want to hit Ctrl-C and do this manually with maintenance/\n" .
933 "populateCategory.php.\n"
934 );
935 $task = $this->maintenance->runChild( 'PopulateCategory' );
936 $task->execute();
937 $this->output( "Done populating category table.\n" );
938 }
939
940 protected function doPopulateParentId() {
941 if ( !$this->updateRowExists( 'populate rev_parent_id' ) ) {
942 $this->output(
943 "Populating rev_parent_id fields, printing progress markers. For large\n" .
944 "databases, you may want to hit Ctrl-C and do this manually with\n" .
945 "maintenance/populateParentId.php.\n" );
946
947 $task = $this->maintenance->runChild( 'PopulateParentId' );
948 $task->execute();
949 }
950 }
951
952 protected function doMaybeProfilingMemoryUpdate() {
953 if ( !$this->doTable( 'profiling' ) ) {
954 return true;
955 }
956
957 if ( !$this->db->tableExists( 'profiling', __METHOD__ ) ) {
958 return true;
959 } elseif ( $this->db->fieldExists( 'profiling', 'pf_memory', __METHOD__ ) ) {
960 $this->output( "...profiling table has pf_memory field.\n" );
961
962 return true;
963 }
964
965 return $this->applyPatch(
966 'patch-profiling-memory.sql',
967 false,
968 'Adding pf_memory field to table profiling'
969 );
970 }
971
972 protected function doFilearchiveIndicesUpdate() {
973 $info = $this->db->indexInfo( 'filearchive', 'fa_user_timestamp', __METHOD__ );
974 if ( !$info ) {
975 $this->applyPatch( 'patch-filearchive-user-index.sql', false, "Updating filearchive indices" );
976 }
977
978 return true;
979 }
980
981 protected function doNonUniquePlTlIl() {
982 $info = $this->db->indexInfo( 'pagelinks', 'pl_namespace' );
983 if ( is_array( $info ) && $info[0]->Non_unique ) {
984 $this->output( "...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE.\n" );
985
986 return true;
987 }
988 if ( $this->skipSchema ) {
989 $this->output( "...skipping schema change (making pl_namespace, tl_namespace " .
990 "and il_to indices non-UNIQUE).\n" );
991
992 return false;
993 }
994
995 return $this->applyPatch(
996 'patch-pl-tl-il-nonunique.sql',
997 false,
998 'Making pl_namespace, tl_namespace and il_to indices non-UNIQUE'
999 );
1000 }
1001
1002 protected function doUpdateMimeMinorField() {
1003 if ( $this->updateRowExists( 'mime_minor_length' ) ) {
1004 $this->output( "...*_mime_minor fields are already long enough.\n" );
1005
1006 return;
1007 }
1008
1009 $this->applyPatch(
1010 'patch-mime_minor_length.sql',
1011 false,
1012 'Altering all *_mime_minor fields to 100 bytes in size'
1013 );
1014 }
1015
1016 protected function doClFieldsUpdate() {
1017 if ( $this->updateRowExists( 'cl_fields_update' ) ) {
1018 $this->output( "...categorylinks up-to-date.\n" );
1019
1020 return;
1021 }
1022
1023 $this->applyPatch(
1024 'patch-categorylinks-better-collation2.sql',
1025 false,
1026 'Updating categorylinks (again)'
1027 );
1028 }
1029
1030 protected function doLangLinksLengthUpdate() {
1031 $langlinks = $this->db->tableName( 'langlinks' );
1032 $res = $this->db->query( "SHOW COLUMNS FROM $langlinks LIKE 'll_lang'" );
1033 $row = $this->db->fetchObject( $res );
1034
1035 if ( $row && $row->Type == "varbinary(10)" ) {
1036 $this->applyPatch(
1037 'patch-langlinks-ll_lang-20.sql',
1038 false,
1039 'Updating length of ll_lang in langlinks'
1040 );
1041 } else {
1042 $this->output( "...ll_lang is up-to-date.\n" );
1043 }
1044 }
1045
1046 protected function doUserNewTalkTimestampNotNull() {
1047 if ( !$this->doTable( 'user_newtalk' ) ) {
1048 return true;
1049 }
1050
1051 $info = $this->db->fieldInfo( 'user_newtalk', 'user_last_timestamp' );
1052 if ( $info === false ) {
1053 return;
1054 }
1055 if ( $info->isNullable() ) {
1056 $this->output( "...user_last_timestamp is already nullable.\n" );
1057
1058 return;
1059 }
1060
1061 $this->applyPatch(
1062 'patch-user-newtalk-timestamp-null.sql',
1063 false,
1064 'Making user_last_timestamp nullable'
1065 );
1066 }
1067
1068 protected function doIwlinksIndexNonUnique() {
1069 $info = $this->db->indexInfo( 'iwlinks', 'iwl_prefix_title_from' );
1070 if ( is_array( $info ) && $info[0]->Non_unique ) {
1071 $this->output( "...iwl_prefix_title_from index is already non-UNIQUE.\n" );
1072
1073 return true;
1074 }
1075 if ( $this->skipSchema ) {
1076 $this->output( "...skipping schema change (making iwl_prefix_title_from index non-UNIQUE).\n" );
1077
1078 return false;
1079 }
1080
1081 return $this->applyPatch(
1082 'patch-iwl_prefix_title_from-non-unique.sql',
1083 false,
1084 'Making iwl_prefix_title_from index non-UNIQUE'
1085 );
1086 }
1087
1088 protected function doUserNewTalkUseridUnsigned() {
1089 if ( !$this->doTable( 'user_newtalk' ) ) {
1090 return true;
1091 }
1092
1093 $info = $this->db->fieldInfo( 'user_newtalk', 'user_id' );
1094 if ( $info === false ) {
1095 return true;
1096 }
1097 if ( $info->isUnsigned() ) {
1098 $this->output( "...user_id is already unsigned int.\n" );
1099
1100 return true;
1101 }
1102
1103 return $this->applyPatch(
1104 'patch-user-newtalk-userid-unsigned.sql',
1105 false,
1106 'Making user_id unsigned int'
1107 );
1108 }
1109
1110 protected function doRevisionPageRevIndexNonUnique() {
1111 if ( !$this->doTable( 'revision' ) ) {
1112 return true;
1113 } elseif ( !$this->db->indexExists( 'revision', 'rev_page_id' ) ) {
1114 $this->output( "...rev_page_id index not found on revision.\n" );
1115 return true;
1116 }
1117
1118 if ( !$this->db->indexUnique( 'revision', 'rev_page_id' ) ) {
1119 $this->output( "...rev_page_id index already non-unique.\n" );
1120 return true;
1121 }
1122
1123 return $this->applyPatch(
1124 'patch-revision-page-rev-index-nonunique.sql',
1125 false,
1126 'Making rev_page_id index non-unique'
1127 );
1128 }
1129
1130 public function getSchemaVars() {
1131 global $wgDBTableOptions;
1132
1133 $vars = [];
1134 $vars['wgDBTableOptions'] = str_replace( 'TYPE', 'ENGINE', $wgDBTableOptions );
1135 $vars['wgDBTableOptions'] = str_replace(
1136 'CHARSET=mysql4',
1137 'CHARSET=binary',
1138 $vars['wgDBTableOptions']
1139 );
1140
1141 return $vars;
1142 }
1143}
$wgLegacySchemaConversion
$wgLegacySchemaConversion
If set to true, the MediaWiki 1.4 to 1.5 schema conversion will create stub reference rows in the tex...
Definition DefaultSettings.php:2998
$wgDBTableOptions
$wgDBTableOptions
MySQL table options to use during installation or update.
Definition DefaultSettings.php:1827
wfGetLB
wfGetLB( $wiki=false)
Get a load balancer object.
Definition GlobalFunctions.php:3087
wfGetLBFactory
wfGetLBFactory()
Get the load balancer factory object.
Definition GlobalFunctions.php:3103
wfTimestamp
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
Definition GlobalFunctions.php:2008
wfWikiID
wfWikiID()
Get an ASCII string identifying this wiki This is used as a prefix in memcached keys.
Definition GlobalFunctions.php:3025
$IP
$IP
Definition WebStart.php:58
DatabaseUpdater
Class for handling database updates.
Definition DatabaseUpdater.php:34
DatabaseUpdater\updateRowExists
updateRowExists( $key)
Helper function: check if the given key is present in the updatelog table.
Definition DatabaseUpdater.php:509
DatabaseUpdater\applyPatch
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Definition DatabaseUpdater.php:672
DatabaseUpdater\doTable
doTable( $name)
Returns whether updates should be executed on the database table $name.
Definition DatabaseUpdater.php:559
MWException
MediaWiki exception.
Definition MWException.php:26
MysqlUpdater
Mysql update list and mysql-specific update functions.
Definition MysqlUpdater.php:30
MysqlUpdater\doWatchlistNull
doWatchlistNull()
Make sure wl_notificationtimestamp can be NULL, and update old broken items.
Definition MysqlUpdater.php:799
MysqlUpdater\doInterwikiUpdate
doInterwikiUpdate()
Check that interwiki table exists; if it doesn't source it.
Definition MysqlUpdater.php:352
MysqlUpdater\getSchemaVars
getSchemaVars()
Get appropriate schema variables in the current database connection.
Definition MysqlUpdater.php:1130
MysqlUpdater\doRestrictionsUpdate
doRestrictionsUpdate()
Adding page_restrictions table, obsoleting page.page_restrictions.
Definition MysqlUpdater.php:892
MysqlUpdater\doCategorylinksIndicesUpdate
doCategorylinksIndicesUpdate()
Definition MysqlUpdater.php:916
MysqlUpdater\checkBin
checkBin( $table, $field, $patchFile)
1.4 betas were missing the 'binary' marker from logging.log_title, which causes a collation mismatch ...
Definition MysqlUpdater.php:307
MysqlUpdater\doIndexUpdate
doIndexUpdate()
Check that proper indexes are in place.
Definition MysqlUpdater.php:376
MysqlUpdater\getCoreUpdateList
getCoreUpdateList()
Get an array of updates to perform on the database.
Definition MysqlUpdater.php:31
MysqlUpdater\doRevisionPageRevIndexNonUnique
doRevisionPageRevIndexNonUnique()
Definition MysqlUpdater.php:1110
MysqlUpdater\doMaybeProfilingMemoryUpdate
doMaybeProfilingMemoryUpdate()
Definition MysqlUpdater.php:952
MysqlUpdater\indexHasField
indexHasField( $table, $index, $field)
Check whether an index contain a field.
Definition MysqlUpdater.php:329
MysqlUpdater\doPageRandomUpdate
doPageRandomUpdate()
Set page_random field to a random value where it is equals to 0.
Definition MysqlUpdater.php:822
MysqlUpdater\doWatchlistUpdate
doWatchlistUpdate()
Check if we need to add talk page rows to the watchlist.
Definition MysqlUpdater.php:417
MysqlUpdater\doUserNewTalkTimestampNotNull
doUserNewTalkTimestampNotNull()
Definition MysqlUpdater.php:1046
UserDupes
Look for duplicate user table entries and optionally prune them.
Definition userDupes.inc:35
$res
$res
Definition database.txt:21
list
deferred txt A few of the database updates required by various functions here can be deferred until after the result page is displayed to the user For updating the view updating the linked to tables after a etc PHP does not yet have any way to tell the server to actually return and disconnect while still running these but it might have such a feature in the future We handle these by creating a deferred update object and putting those objects on a global list
Definition deferred.txt:11
$wgContLang
this class mediates it Skin Encapsulates a look and feel for the wiki All of the functions that render HTML and make choices about how to render it are here and are called from various other places when and is meant to be subclassed with other skins that may override some of its functions The User object contains a reference to a and so rather than having a global skin object we just rely on the global User and get the skin with $wgUser and also has some character encoding functions and other locale stuff The current user interface language is instantiated as and the local content language as $wgContLang
Definition design.txt:57
output
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add in any and then calling output() to send it all. It could be easily changed to send incrementally if that becomes useful
global
when a variable name is used in a it is silently declared as a new local masking the global
Definition design.txt:95
as
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition distributors.txt:22
NS_TEMPLATE
const NS_TEMPLATE
Definition Defines.php:66
$vars
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
Definition hooks.txt:2162
$tables
this hook is for auditing only RecentChangesLinked and Watchlist RecentChangesLinked and Watchlist e g Watchlist & $tables
Definition hooks.txt:1028
$result
The index of the header message $result[1]=The index of the body text message $result[2 through n]=Parameters passed to body text message. Please note the header message cannot receive/use parameters. 'ImportHandleLogItemXMLTag':When parsing a XML tag in a log item. Return false to stop further processing of the tag $reader:XMLReader object $logInfo:Array of information 'ImportHandlePageXMLTag':When parsing a XML tag in a page. Return false to stop further processing of the tag $reader:XMLReader object & $pageInfo:Array of information 'ImportHandleRevisionXMLTag':When parsing a XML tag in a page revision. Return false to stop further processing of the tag $reader:XMLReader object $pageInfo:Array of page information $revisionInfo:Array of revision information 'ImportHandleToplevelXMLTag':When parsing a top level XML tag. Return false to stop further processing of the tag $reader:XMLReader object 'ImportHandleUploadXMLTag':When parsing a XML tag in a file upload. Return false to stop further processing of the tag $reader:XMLReader object $revisionInfo:Array of information 'ImportLogInterwikiLink':Hook to change the interwiki link used in log entries and edit summaries for transwiki imports. & $fullInterwikiPrefix:Interwiki prefix, may contain colons. & $pageTitle:String that contains page title. 'ImportSources':Called when reading from the $wgImportSources configuration variable. Can be used to lazy-load the import sources list. & $importSources:The value of $wgImportSources. Modify as necessary. See the comment in DefaultSettings.php for the detail of how to structure this array. 'InfoAction':When building information to display on the action=info page. $context:IContextSource object & $pageInfo:Array of information 'InitializeArticleMaybeRedirect':MediaWiki check to see if title is a redirect. & $title:Title object for the current page & $request:WebRequest & $ignoreRedirect:boolean to skip redirect check & $target:Title/string of redirect target & $article:Article object 'InternalParseBeforeLinks':during Parser 's internalParse method before links but after nowiki/noinclude/includeonly/onlyinclude and other processings. & $parser:Parser object & $text:string containing partially parsed text & $stripState:Parser 's internal StripState object 'InternalParseBeforeSanitize':during Parser 's internalParse method just before the parser removes unwanted/dangerous HTML tags and after nowiki/noinclude/includeonly/onlyinclude and other processings. Ideal for syntax-extensions after template/parser function execution which respect nowiki and HTML-comments. & $parser:Parser object & $text:string containing partially parsed text & $stripState:Parser 's internal StripState object 'InterwikiLoadPrefix':When resolving if a given prefix is an interwiki or not. Return true without providing an interwiki to continue interwiki search. $prefix:interwiki prefix we are looking for. & $iwData:output array describing the interwiki with keys iw_url, iw_local, iw_trans and optionally iw_api and iw_wikiid. 'InvalidateEmailComplete':Called after a user 's email has been invalidated successfully. $user:user(object) whose email is being invalidated 'IRCLineURL':When constructing the URL to use in an IRC notification. Callee may modify $url and $query, URL will be constructed as $url . $query & $url:URL to index.php & $query:Query string $rc:RecentChange object that triggered url generation 'IsFileCacheable':Override the result of Article::isFileCacheable()(if true) & $article:article(object) being checked 'IsTrustedProxy':Override the result of IP::isTrustedProxy() & $ip:IP being check & $result:Change this value to override the result of IP::isTrustedProxy() 'IsUploadAllowedFromUrl':Override the result of UploadFromUrl::isAllowedUrl() $url:URL used to upload from & $allowed:Boolean indicating if uploading is allowed for given URL 'isValidEmailAddr':Override the result of Sanitizer::validateEmail(), for instance to return false if the domain name doesn 't match your organization. $addr:The e-mail address entered by the user & $result:Set this and return false to override the internal checks 'isValidPassword':Override the result of User::isValidPassword() $password:The password entered by the user & $result:Set this and return false to override the internal checks $user:User the password is being validated for 'Language::getMessagesFileName':$code:The language code or the language we 're looking for a messages file for & $file:The messages file path, you can override this to change the location. 'LanguageGetMagic':DEPRECATED! Use $magicWords in a file listed in $wgExtensionMessagesFiles instead. Use this to define synonyms of magic words depending of the language & $magicExtensions:associative array of magic words synonyms $lang:language code(string) 'LanguageGetNamespaces':Provide custom ordering for namespaces or remove namespaces. Do not use this hook to add namespaces. Use CanonicalNamespaces for that. & $namespaces:Array of namespaces indexed by their numbers 'LanguageGetSpecialPageAliases':DEPRECATED! Use $specialPageAliases in a file listed in $wgExtensionMessagesFiles instead. Use to define aliases of special pages names depending of the language & $specialPageAliases:associative array of magic words synonyms $lang:language code(string) 'LanguageGetTranslatedLanguageNames':Provide translated language names. & $names:array of language code=> language name $code:language of the preferred translations 'LanguageLinks':Manipulate a page 's language links. This is called in various places to allow extensions to define the effective language links for a page. $title:The page 's Title. & $links:Associative array mapping language codes to prefixed links of the form "language:title". & $linkFlags:Associative array mapping prefixed links to arrays of flags. Currently unused, but planned to provide support for marking individual language links in the UI, e.g. for featured articles. 'LanguageSelector':Hook to change the language selector available on a page. $out:The output page. $cssClassName:CSS class name of the language selector. 'LinkBegin':DEPRECATED! Use HtmlPageLinkRendererBegin instead. Used when generating internal and interwiki links in Linker::link(), before processing starts. Return false to skip default processing and return $ret. See documentation for Linker::link() for details on the expected meanings of parameters. $skin:the Skin object $target:the Title that the link is pointing to & $html:the contents that the< a > tag should have(raw HTML) $result
Definition hooks.txt:1937
$name
Allows to change the fields on the form that will be generated $name
Definition hooks.txt:304
$page
namespace are movable Hooks may change this value to override the return value of MWNamespace::isMovable(). 'NewDifferenceEngine' do that in ParserLimitReportFormat instead use this to modify the parameters of the image and a DIV can begin in one section and end in another Make sure your code can handle that case gracefully See the EditSectionClearerLink extension for an example zero but section is usually empty its values are the globals values before the output is cached $page
Definition hooks.txt:2534
php
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition injection.txt:37
$titles
linkcache txt The LinkCache class maintains a list of article titles and the information about whether or not the article exists in the database This is used to mark up links when displaying a page If the same link appears more than once on any page then it only has to be looked up once In most cases link lookups are done in batches with the LinkBatch class or the equivalent in so the link cache is mostly useful for short snippets of parsed and for links in the navigation areas of the skin The link cache was formerly used to track links used in a document for the purposes of updating the link tables This application is now deprecated To create a you can use the following $titles
Definition linkcache.txt:17
TS_DB
const TS_DB
MySQL DATETIME (YYYY-MM-DD HH:MM:SS)
Definition defines.php:16