MediaWiki  master
MysqlUpdater.php
Go to the documentation of this file.
1 <?php
26 
34  protected function getCoreUpdateList() {
35  return [
36  [ 'disableContentHandlerUseDB' ],
37 
38  // 1.2
39  [ 'addField', 'ipblocks', 'ipb_id', 'patch-ipblocks.sql' ],
40  [ 'addField', 'ipblocks', 'ipb_expiry', 'patch-ipb_expiry.sql' ],
41  [ 'doInterwikiUpdate' ],
42  [ 'doIndexUpdate' ],
43  [ 'addField', 'recentchanges', 'rc_type', 'patch-rc_type.sql' ],
44  [ 'addIndex', 'recentchanges', 'new_name_timestamp', 'patch-rc-newindex.sql' ],
45 
46  // 1.3
47  [ 'addField', 'user', 'user_real_name', 'patch-user-realname.sql' ],
48  [ 'addTable', 'querycache', 'patch-querycache.sql' ],
49  [ 'addTable', 'objectcache', 'patch-objectcache.sql' ],
50  [ 'addTable', 'categorylinks', 'patch-categorylinks.sql' ],
51  [ 'doOldLinksUpdate' ],
52  [ 'doFixAncientImagelinks' ],
53  [ 'addField', 'recentchanges', 'rc_ip', 'patch-rc_ip.sql' ],
54 
55  // 1.4
56  [ 'addIndex', 'image', 'PRIMARY', 'patch-image_name_primary.sql' ],
57  [ 'addField', 'recentchanges', 'rc_id', 'patch-rc_id.sql' ],
58  [ 'addField', 'recentchanges', 'rc_patrolled', 'patch-rc-patrol.sql' ],
59  [ 'addTable', 'logging', 'patch-logging.sql' ],
60  [ 'addField', 'user', 'user_token', 'patch-user_token.sql' ],
61  [ 'addField', 'watchlist', 'wl_notificationtimestamp', 'patch-email-notification.sql' ],
62  [ 'doWatchlistUpdate' ],
63  [ 'dropField', 'user', 'user_emailauthenticationtimestamp',
64  'patch-email-authentication.sql' ],
65 
66  // 1.5
67  [ 'doSchemaRestructuring' ],
68  [ 'addField', 'logging', 'log_params', 'patch-log_params.sql' ],
69  [ 'checkBin', 'logging', 'log_title', 'patch-logging-title.sql', ],
70  [ 'addField', 'archive', 'ar_rev_id', 'patch-archive-rev_id.sql' ],
71  [ 'addField', 'page', 'page_len', 'patch-page_len.sql' ],
72  [ 'dropField', 'revision', 'inverse_timestamp', 'patch-inverse_timestamp.sql' ],
73  [ 'addField', 'revision', 'rev_text_id', 'patch-rev_text_id.sql' ],
74  [ 'addField', 'revision', 'rev_deleted', 'patch-rev_deleted.sql' ],
75  [ 'addField', 'image', 'img_width', 'patch-img_width.sql' ],
76  [ 'addField', 'image', 'img_metadata', 'patch-img_metadata.sql' ],
77  [ 'addField', 'user', 'user_email_token', 'patch-user_email_token.sql' ],
78  [ 'addField', 'archive', 'ar_text_id', 'patch-archive-text_id.sql' ],
79  [ 'doNamespaceSize' ],
80  [ 'addField', 'image', 'img_media_type', 'patch-img_media_type.sql' ],
81  [ 'doPagelinksUpdate' ],
82  [ 'dropField', 'image', 'img_type', 'patch-drop_img_type.sql' ],
83  [ 'doUserUniqueUpdate' ],
84  [ 'doUserGroupsUpdate' ],
85  [ 'addField', 'site_stats', 'ss_total_pages', 'patch-ss_total_articles.sql' ],
86  [ 'addTable', 'user_newtalk', 'patch-usernewtalk.sql' ],
87  [ 'addField', 'interwiki', 'iw_trans', 'patch-interwiki-trans.sql' ],
88 
89  // 1.6
90  [ 'doWatchlistNull' ],
91  [ 'addIndex', 'logging', 'times', 'patch-logging-times-index.sql' ],
92  [ 'addField', 'ipblocks', 'ipb_range_start', 'patch-ipb_range_start.sql' ],
93  [ 'doPageRandomUpdate' ],
94  [ 'addField', 'user', 'user_registration', 'patch-user_registration.sql' ],
95  [ 'doTemplatelinksUpdate' ],
96  [ 'addTable', 'externallinks', 'patch-externallinks.sql' ],
97  [ 'addTable', 'job', 'patch-job.sql' ],
98  [ 'addField', 'site_stats', 'ss_images', 'patch-ss_images.sql' ],
99  [ 'addTable', 'langlinks', 'patch-langlinks.sql' ],
100  [ 'addTable', 'querycache_info', 'patch-querycacheinfo.sql' ],
101  [ 'addTable', 'filearchive', 'patch-filearchive.sql' ],
102  [ 'addField', 'ipblocks', 'ipb_anon_only', 'patch-ipb_anon_only.sql' ],
103  [ 'addIndex', 'recentchanges', 'rc_ns_usertext', 'patch-recentchanges-utindex.sql' ],
104  [ 'addIndex', 'recentchanges', 'rc_user_text', 'patch-rc_user_text-index.sql' ],
105 
106  // 1.9
107  [ 'addField', 'user', 'user_newpass_time', 'patch-user_newpass_time.sql' ],
108  [ 'addTable', 'redirect', 'patch-redirect.sql' ],
109  [ 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ],
110  [ 'addField', 'ipblocks', 'ipb_enable_autoblock', 'patch-ipb_optional_autoblock.sql' ],
111  [ 'doBacklinkingIndicesUpdate' ],
112  [ 'addField', 'recentchanges', 'rc_old_len', 'patch-rc_len.sql' ],
113  [ 'addField', 'user', 'user_editcount', 'patch-user_editcount.sql' ],
114 
115  // 1.10
116  [ 'doRestrictionsUpdate' ],
117  [ 'addField', 'logging', 'log_id', 'patch-log_id.sql' ],
118  [ 'addField', 'revision', 'rev_parent_id', 'patch-rev_parent_id.sql' ],
119  [ 'addField', 'page_restrictions', 'pr_id', 'patch-page_restrictions_sortkey.sql' ],
120  [ 'addField', 'revision', 'rev_len', 'patch-rev_len.sql' ],
121  [ 'addField', 'recentchanges', 'rc_deleted', 'patch-rc_deleted.sql' ],
122  [ 'addField', 'logging', 'log_deleted', 'patch-log_deleted.sql' ],
123  [ 'addField', 'archive', 'ar_deleted', 'patch-ar_deleted.sql' ],
124  [ 'addField', 'ipblocks', 'ipb_deleted', 'patch-ipb_deleted.sql' ],
125  [ 'addField', 'filearchive', 'fa_deleted', 'patch-fa_deleted.sql' ],
126  [ 'addField', 'archive', 'ar_len', 'patch-ar_len.sql' ],
127 
128  // 1.11
129  [ 'addField', 'ipblocks', 'ipb_block_email', 'patch-ipb_emailban.sql' ],
130  [ 'doCategorylinksIndicesUpdate' ],
131  [ 'addField', 'oldimage', 'oi_metadata', 'patch-oi_metadata.sql' ],
132  [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-archive-user-index.sql' ],
133  [ 'addIndex', 'image', 'img_usertext_timestamp', 'patch-image-user-index.sql' ],
134  [ 'addIndex', 'oldimage', 'oi_usertext_timestamp', 'patch-oldimage-user-index.sql' ],
135  [ 'addField', 'archive', 'ar_page_id', 'patch-archive-page_id.sql' ],
136  [ 'addField', 'image', 'img_sha1', 'patch-img_sha1.sql' ],
137 
138  // 1.12
139  [ 'addTable', 'protected_titles', 'patch-protected_titles.sql' ],
140 
141  // 1.13
142  [ 'addField', 'ipblocks', 'ipb_by_text', 'patch-ipb_by_text.sql' ],
143  [ 'addTable', 'page_props', 'patch-page_props.sql' ],
144  [ 'addTable', 'updatelog', 'patch-updatelog.sql' ],
145  [ 'addTable', 'category', 'patch-category.sql' ],
146  [ 'doCategoryPopulation' ],
147  [ 'addField', 'archive', 'ar_parent_id', 'patch-ar_parent_id.sql' ],
148  [ 'addField', 'user_newtalk', 'user_last_timestamp', 'patch-user_last_timestamp.sql' ],
149  [ 'doPopulateParentId' ],
150  [ 'checkBin', 'protected_titles', 'pt_title', 'patch-pt_title-encoding.sql', ],
151  [ 'doMaybeProfilingMemoryUpdate' ],
152  [ 'doFilearchiveIndicesUpdate' ],
153 
154  // 1.14
155  [ 'addField', 'site_stats', 'ss_active_users', 'patch-ss_active_users.sql' ],
156  [ 'doActiveUsersInit' ],
157  [ 'addField', 'ipblocks', 'ipb_allow_usertalk', 'patch-ipb_allow_usertalk.sql' ],
158 
159  // 1.15
160  [ 'addTable', 'change_tag', 'patch-change_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  [ 'dropIndex', 'change_tag', 'ct_rc_id', 'patch-change_tag-indexes.sql' ],
171  [ 'addField', 'redirect', 'rd_interwiki', 'patch-rd_interwiki.sql' ],
172  [ 'doUpdateMimeMinorField' ],
173 
174  // 1.17
175  [ 'addTable', 'iwlinks', 'patch-iwlinks.sql' ],
176  [ 'addIndex', 'iwlinks', 'iwl_prefix_title_from', 'patch-rename-iwl_prefix.sql' ],
177  [ 'addField', 'updatelog', 'ul_value', 'patch-ul_value.sql' ],
178  [ 'addField', 'interwiki', 'iw_api', 'patch-iw_api_and_wikiid.sql' ],
179  [ 'dropIndex', 'iwlinks', 'iwl_prefix', 'patch-kill-iwl_prefix.sql' ],
180  [ 'addField', 'categorylinks', 'cl_collation', 'patch-categorylinks-better-collation.sql' ],
181  [ 'doClFieldsUpdate' ],
182  [ 'addTable', 'module_deps', 'patch-module_deps.sql' ],
183  [ 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ],
184  [ 'addIndexIfNoneExist',
185  'archive', [ 'ar_revid', 'ar_revid_uniq' ], 'patch-archive_ar_revid.sql' ],
186  [ 'doLangLinksLengthUpdate' ],
187 
188  // 1.18
189  [ 'doUserNewTalkTimestampNotNull' ],
190  [ 'addIndex', 'user', 'user_email', 'patch-user_email_index.sql' ],
191  [ 'modifyField', 'user_properties', 'up_property', 'patch-up_property.sql' ],
192  [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
193  [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
194 
195  // 1.19
196  [ 'addField', 'revision', 'rev_sha1', 'patch-rev_sha1.sql' ],
197  [ 'doMigrateUserOptions' ],
198  [ 'dropField', 'user', 'user_options', 'patch-drop-user_options.sql' ],
199  [ 'addField', 'archive', 'ar_sha1', 'patch-ar_sha1.sql' ],
200  [ 'addIndex', 'page', 'page_redirect_namespace_len',
201  'patch-page_redirect_namespace_len.sql' ],
202  [ 'addField', 'uploadstash', 'us_chunk_inx', 'patch-uploadstash_chunk.sql' ],
203  [ 'addfield', 'job', 'job_timestamp', 'patch-jobs-add-timestamp.sql' ],
204 
205  // 1.20
206  [ 'addIndex', 'revision', 'page_user_timestamp', 'patch-revision-user-page-index.sql' ],
207  [ 'addField', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id.sql' ],
208  [ 'addIndex', 'ipblocks', 'ipb_parent_block_id', 'patch-ipb-parent-block-id-index.sql' ],
209  [ 'dropField', 'category', 'cat_hidden', 'patch-cat_hidden.sql' ],
210 
211  // 1.21
212  [ 'addField', 'revision', 'rev_content_format', 'patch-revision-rev_content_format.sql' ],
213  [ 'addField', 'revision', 'rev_content_model', 'patch-revision-rev_content_model.sql' ],
214  [ 'addField', 'archive', 'ar_content_format', 'patch-archive-ar_content_format.sql' ],
215  [ 'addField', 'archive', 'ar_content_model', 'patch-archive-ar_content_model.sql' ],
216  [ 'addField', 'page', 'page_content_model', 'patch-page-page_content_model.sql' ],
217  [ 'enableContentHandlerUseDB' ],
218  [ 'dropField', 'site_stats', 'ss_admins', 'patch-drop-ss_admins.sql' ],
219  [ 'dropField', 'recentchanges', 'rc_moved_to_title', 'patch-rc_moved.sql' ],
220  [ 'addTable', 'sites', 'patch-sites.sql' ],
221  [ 'addField', 'filearchive', 'fa_sha1', 'patch-fa_sha1.sql' ],
222  [ 'addField', 'job', 'job_token', 'patch-job_token.sql' ],
223  [ 'addField', 'job', 'job_attempts', 'patch-job_attempts.sql' ],
224  [ 'doEnableProfiling' ],
225  [ 'addField', 'uploadstash', 'us_props', 'patch-uploadstash-us_props.sql' ],
226  [ 'modifyField', 'user_groups', 'ug_group', 'patch-ug_group-length-increase-255.sql' ],
227  [ 'modifyField', 'user_former_groups', 'ufg_group',
228  'patch-ufg_group-length-increase-255.sql' ],
229  [ 'addIndex', 'page_props', 'pp_propname_page',
230  'patch-page_props-propname-page-index.sql' ],
231  [ 'addIndex', 'image', 'img_media_mime', 'patch-img_media_mime-index.sql' ],
232 
233  // 1.22
234  [ 'doIwlinksIndexNonUnique' ],
235  [ 'addIndex', 'iwlinks', 'iwl_prefix_from_title',
236  'patch-iwlinks-from-title-index.sql' ],
237  [ 'addField', 'archive', 'ar_id', 'patch-archive-ar_id.sql' ],
238  [ 'addField', 'externallinks', 'el_id', 'patch-externallinks-el_id.sql' ],
239 
240  // 1.23
241  [ 'addField', 'recentchanges', 'rc_source', 'patch-rc_source.sql' ],
242  [ 'addIndex', 'logging', 'log_user_text_type_time',
243  'patch-logging_user_text_type_time_index.sql' ],
244  [ 'addIndex', 'logging', 'log_user_text_time', 'patch-logging_user_text_time_index.sql' ],
245  [ 'addField', 'page', 'page_links_updated', 'patch-page_links_updated.sql' ],
246  [ 'addField', 'user', 'user_password_expires', 'patch-user_password_expire.sql' ],
247 
248  // 1.24
249  [ 'addField', 'page_props', 'pp_sortkey', 'patch-pp_sortkey.sql' ],
250  [ 'dropField', 'recentchanges', 'rc_cur_time', 'patch-drop-rc_cur_time.sql' ],
251  [ 'addIndex', 'watchlist', 'wl_user_notificationtimestamp',
252  'patch-watchlist-user-notificationtimestamp-index.sql' ],
253  [ 'addField', 'page', 'page_lang', 'patch-page_lang.sql' ],
254  [ 'addField', 'pagelinks', 'pl_from_namespace', 'patch-pl_from_namespace.sql' ],
255  [ 'addField', 'templatelinks', 'tl_from_namespace', 'patch-tl_from_namespace.sql' ],
256  [ 'addField', 'imagelinks', 'il_from_namespace', 'patch-il_from_namespace.sql' ],
257  [ 'modifyField', 'image', 'img_major_mime',
258  'patch-img_major_mime-chemical.sql' ],
259  [ 'modifyField', 'oldimage', 'oi_major_mime',
260  'patch-oi_major_mime-chemical.sql' ],
261  [ 'modifyField', 'filearchive', 'fa_major_mime',
262  'patch-fa_major_mime-chemical.sql' ],
263 
264  // 1.25
265  // note this patch covers other _comment and _description fields too
266  [ 'doExtendCommentLengths' ],
267 
268  // 1.26
269  [ 'dropTable', 'hitcounter' ],
270  [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
271  [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
272 
273  // 1.27
274  [ 'dropTable', 'msg_resource_links' ],
275  [ 'dropTable', 'msg_resource' ],
276  [ 'addTable', 'bot_passwords', 'patch-bot_passwords.sql' ],
277  [ 'addField', 'watchlist', 'wl_id', 'patch-watchlist-wl_id.sql' ],
278  [ 'dropIndex', 'categorylinks', 'cl_collation', 'patch-kill-cl_collation_index.sql' ],
279  [ 'addIndex', 'categorylinks', 'cl_collation_ext',
280  'patch-add-cl_collation_ext_index.sql' ],
281  [ 'doCollationUpdate' ],
282 
283  // 1.28
284  [ 'addIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
285  'patch-add-rc_name_type_patrolled_timestamp_index.sql' ],
286  [ 'doRevisionPageRevIndexNonUnique' ],
287  [ 'doNonUniquePlTlIl' ],
288  [ 'addField', 'change_tag', 'ct_id', 'patch-change_tag-ct_id.sql' ],
289  [ 'modifyField', 'recentchanges', 'rc_ip', 'patch-rc_ip_modify.sql' ],
290  [ 'addIndex', 'archive', 'usertext_timestamp', 'patch-rename-ar_usertext_timestamp.sql' ],
291 
292  // 1.29
293  [ 'addField', 'externallinks', 'el_index_60', 'patch-externallinks-el_index_60.sql' ],
294  [ 'dropIndex', 'user_groups', 'ug_user_group', 'patch-user_groups-primary-key.sql' ],
295  [ 'addField', 'user_groups', 'ug_expiry', 'patch-user_groups-ug_expiry.sql' ],
296  [ 'addIndex', 'image', 'img_user_timestamp', 'patch-image-user-index-2.sql' ],
297 
298  // 1.30
299  [ 'modifyField', 'image', 'img_media_type', 'patch-add-3d.sql' ],
300  [ 'addTable', 'ip_changes', 'patch-ip_changes.sql' ],
301  [ 'renameIndex', 'categorylinks', 'cl_from', 'PRIMARY', false,
302  'patch-categorylinks-fix-pk.sql' ],
303  [ 'renameIndex', 'templatelinks', 'tl_from', 'PRIMARY', false,
304  'patch-templatelinks-fix-pk.sql' ],
305  [ 'renameIndex', 'pagelinks', 'pl_from', 'PRIMARY', false, 'patch-pagelinks-fix-pk.sql' ],
306  [ 'renameIndex', 'text', 'old_id', 'PRIMARY', false, 'patch-text-fix-pk.sql' ],
307  [ 'renameIndex', 'imagelinks', 'il_from', 'PRIMARY', false, 'patch-imagelinks-fix-pk.sql' ],
308  [ 'renameIndex', 'iwlinks', 'iwl_from', 'PRIMARY', false, 'patch-iwlinks-fix-pk.sql' ],
309  [ 'renameIndex', 'langlinks', 'll_from', 'PRIMARY', false, 'patch-langlinks-fix-pk.sql' ],
310  [ 'renameIndex', 'log_search', 'ls_field_val', 'PRIMARY', false, 'patch-log_search-fix-pk.sql' ],
311  [ 'renameIndex', 'module_deps', 'md_module_skin', 'PRIMARY', false,
312  'patch-module_deps-fix-pk.sql' ],
313  [ 'renameIndex', 'objectcache', 'keyname', 'PRIMARY', false, 'patch-objectcache-fix-pk.sql' ],
314  [ 'renameIndex', 'querycache_info', 'qci_type', 'PRIMARY', false,
315  'patch-querycache_info-fix-pk.sql' ],
316  [ 'renameIndex', 'site_stats', 'ss_row_id', 'PRIMARY', false, 'patch-site_stats-fix-pk.sql' ],
317  [ 'renameIndex', 'user_former_groups', 'ufg_user_group', 'PRIMARY', false,
318  'patch-user_former_groups-fix-pk.sql' ],
319  [ 'renameIndex', 'user_properties', 'user_properties_user_property', 'PRIMARY', false,
320  'patch-user_properties-fix-pk.sql' ],
321  [ 'addTable', 'comment', 'patch-comment-table.sql' ],
322 
323  // This field was added in 1.31, but is put here so it can be used by 'migrateComments'
324  [ 'addField', 'image', 'img_description_id', 'patch-image-img_description_id.sql' ],
325 
326  [ 'migrateComments' ],
327  [ 'renameIndex', 'l10n_cache', 'lc_lang_key', 'PRIMARY', false,
328  'patch-l10n_cache-primary-key.sql' ],
329  [ 'doUnsignedSyncronisation' ],
330 
331  // 1.31
332  [ 'addTable', 'slots', 'patch-slots.sql' ],
333  [ 'addField', 'slots', 'slot_origin', 'patch-slot-origin.sql' ],
334  [ 'addTable', 'content', 'patch-content.sql' ],
335  [ 'addTable', 'slot_roles', 'patch-slot_roles.sql' ],
336  [ 'addTable', 'content_models', 'patch-content_models.sql' ],
337  [ 'migrateArchiveText' ],
338  [ 'addTable', 'actor', 'patch-actor-table.sql' ],
339  [ 'migrateActors' ],
340  [ 'modifyField', 'revision', 'rev_text_id', 'patch-rev_text_id-default.sql' ],
341  [ 'modifyTable', 'site_stats', 'patch-site_stats-modify.sql' ],
342  [ 'populateArchiveRevId' ],
343  [ 'addIndex', 'recentchanges', 'rc_namespace_title_timestamp',
344  'patch-recentchanges-nttindex.sql' ],
345 
346  // 1.32
347  [ 'addTable', 'change_tag_def', 'patch-change_tag_def.sql' ],
348  [ 'populateExternallinksIndex60' ],
349  [ 'modifyfield', 'externallinks', 'el_index_60',
350  'patch-externallinks-el_index_60-drop-default.sql' ],
351  [ 'runMaintenance', DeduplicateArchiveRevId::class, 'maintenance/deduplicateArchiveRevId.php' ],
352  [ 'addField', 'change_tag', 'ct_tag_id', 'patch-change_tag-tag_id.sql' ],
353  [ 'addIndex', 'archive', 'ar_revid_uniq', 'patch-archive-ar_rev_id-unique.sql' ],
354  [ 'populateContentTables' ],
355  [ 'addIndex', 'logging', 'log_type_action', 'patch-logging-log-type-action-index.sql' ],
356  [ 'dropIndex', 'logging', 'type_action', 'patch-logging-drop-type-action-index.sql' ],
357  [ 'renameIndex', 'interwiki', 'iw_prefix', 'PRIMARY', false, 'patch-interwiki-fix-pk.sql' ],
358  [ 'renameIndex', 'page_props', 'pp_page_propname', 'PRIMARY', false,
359  'patch-page_props-fix-pk.sql' ],
360  [ 'renameIndex', 'protected_titles', 'pt_namespace_title', 'PRIMARY', false,
361  'patch-protected_titles-fix-pk.sql' ],
362  [ 'renameIndex', 'site_identifiers', 'site_ids_type', 'PRIMARY', false,
363  'patch-site_identifiers-fix-pk.sql' ],
364  [ 'addIndex', 'recentchanges', 'rc_this_oldid', 'patch-recentchanges-rc_this_oldid-index.sql' ],
365  [ 'dropTable', 'transcache' ],
366  [ 'runMaintenance', PopulateChangeTagDef::class, 'maintenance/populateChangeTagDef.php' ],
367  [ 'addIndex', 'change_tag', 'change_tag_rc_tag_id',
368  'patch-change_tag-change_tag_rc_tag_id.sql' ],
369  [ 'addField', 'ipblocks', 'ipb_sitewide', 'patch-ipb_sitewide.sql' ],
370  [ 'addTable', 'ipblocks_restrictions', 'patch-ipblocks_restrictions-table.sql' ],
371  [ 'migrateImageCommentTemp' ],
372 
373  // 1,33
374  [ 'dropField', 'change_tag', 'ct_tag', 'patch-drop-ct_tag.sql' ],
375  [ 'dropTable', 'valid_tag' ],
376  [ 'dropTable', 'tag_summary' ],
377  [ 'dropField', 'protected_titles', 'pt_reason', 'patch-drop-comment-fields.sql' ],
378  [ 'modifyTable', 'job', 'patch-job-params-mediumblob.sql' ],
379  ];
380  }
381 
391  protected function checkBin( $table, $field, $patchFile ) {
392  if ( !$this->doTable( $table ) ) {
393  return true;
394  }
395 
397  $fieldInfo = $this->db->fieldInfo( $table, $field );
398  if ( $fieldInfo->isBinary() ) {
399  $this->output( "...$table table has correct $field encoding.\n" );
400  } else {
401  $this->applyPatch( $patchFile, false, "Fixing $field encoding on $table table" );
402  }
403  }
404 
413  protected function indexHasField( $table, $index, $field ) {
414  if ( !$this->doTable( $table ) ) {
415  return true;
416  }
417 
418  $info = $this->db->indexInfo( $table, $index, __METHOD__ );
419  if ( $info ) {
420  foreach ( $info as $row ) {
421  if ( $row->Column_name == $field ) {
422  $this->output( "...index $index on table $table includes field $field.\n" );
423 
424  return true;
425  }
426  }
427  }
428  $this->output( "...index $index on table $table has no field $field; added.\n" );
429 
430  return false;
431  }
432 
436  protected function doInterwikiUpdate() {
437  global $IP;
438 
439  if ( !$this->doTable( 'interwiki' ) ) {
440  return;
441  }
442 
443  if ( $this->db->tableExists( "interwiki", __METHOD__ ) ) {
444  $this->output( "...already have interwiki table\n" );
445 
446  return;
447  }
448 
449  $this->applyPatch( 'patch-interwiki.sql', false, 'Creating interwiki table' );
450  $this->applyPatch(
451  "$IP/maintenance/interwiki.sql",
452  true,
453  'Adding default interwiki definitions'
454  );
455  }
456 
460  protected function doIndexUpdate() {
461  $meta = $this->db->fieldInfo( 'recentchanges', 'rc_timestamp' );
462  if ( $meta === false ) {
463  throw new MWException( 'Missing rc_timestamp field of recentchanges table. Should not happen.' );
464  }
465  if ( $meta->isMultipleKey() ) {
466  $this->output( "...indexes seem up to 20031107 standards.\n" );
467 
468  return;
469  }
470 
471  $this->applyPatch( 'patch-indexes.sql', true, "Updating indexes to 20031107" );
472  }
473 
474  protected function doOldLinksUpdate() {
475  $cl = $this->maintenance->runChild( ConvertLinks::class );
476  $cl->execute();
477  }
478 
479  protected function doFixAncientImagelinks() {
480  $info = $this->db->fieldInfo( 'imagelinks', 'il_from' );
481  if ( !$info || $info->type() !== 'string' ) {
482  $this->output( "...il_from OK\n" );
483 
484  return;
485  }
486 
487  $applied = $this->applyPatch(
488  'patch-fix-il_from.sql',
489  false,
490  'Fixing ancient broken imagelinks table.'
491  );
492 
493  if ( $applied ) {
494  $this->output( "NOTE: you will have to run maintenance/refreshLinks.php after this." );
495  }
496  }
497 
501  function doWatchlistUpdate() {
502  $talk = $this->db->selectField( 'watchlist', 'count(*)', 'wl_namespace & 1', __METHOD__ );
503  $nontalk = $this->db->selectField(
504  'watchlist',
505  'count(*)',
506  'NOT (wl_namespace & 1)',
507  __METHOD__
508  );
509  if ( $talk == $nontalk ) {
510  $this->output( "...watchlist talk page rows already present.\n" );
511 
512  return;
513  }
514 
515  $insertOpts = [ 'IGNORE' ];
516  $selectOpts = [];
517 
518  // If wl_id exists, make insertSelect() more replication-safe by
519  // ordering on that column. If not, hint that it should be safe anyway.
520  if ( $this->db->fieldExists( 'watchlist', 'wl_id', __METHOD__ ) ) {
521  $selectOpts['ORDER BY'] = 'wl_id';
522  } else {
523  $insertOpts[] = 'NO_AUTO_COLUMNS';
524  }
525 
526  $this->output( "Adding missing watchlist talk page rows... " );
527  $this->db->insertSelect( 'watchlist', 'watchlist',
528  [
529  'wl_user' => 'wl_user',
530  'wl_namespace' => 'wl_namespace | 1',
531  'wl_title' => 'wl_title',
532  'wl_notificationtimestamp' => 'wl_notificationtimestamp'
533  ], [ 'NOT (wl_namespace & 1)' ], __METHOD__, $insertOpts, $selectOpts );
534  $this->output( "done.\n" );
535 
536  $this->output( "Adding missing watchlist subject page rows... " );
537  $this->db->insertSelect( 'watchlist', 'watchlist',
538  [
539  'wl_user' => 'wl_user',
540  'wl_namespace' => 'wl_namespace & ~1',
541  'wl_title' => 'wl_title',
542  'wl_notificationtimestamp' => 'wl_notificationtimestamp'
543  ], [ 'wl_namespace & 1' ], __METHOD__, $insertOpts, $selectOpts );
544  $this->output( "done.\n" );
545  }
546 
548  if ( $this->db->tableExists( 'page', __METHOD__ ) ) {
549  $this->output( "...page table already exists.\n" );
550 
551  return;
552  }
553 
554  $this->output( "...converting from cur/old to page/revision/text DB structure.\n" );
555  $this->output( wfTimestamp( TS_DB ) );
556  $this->output( "......checking for duplicate entries.\n" );
557 
558  list( $cur, $old, $page, $revision, $text ) = $this->db->tableNamesN(
559  'cur',
560  'old',
561  'page',
562  'revision',
563  'text'
564  );
565 
566  $rows = $this->db->query( "
567  SELECT cur_title, cur_namespace, COUNT(cur_namespace) AS c
568  FROM $cur
569  GROUP BY cur_title, cur_namespace
570  HAVING c>1",
571  __METHOD__
572  );
573 
574  if ( $rows->numRows() > 0 ) {
575  $this->output( wfTimestamp( TS_DB ) );
576  $this->output( "......<b>Found duplicate entries</b>\n" );
577  $this->output( sprintf( "<b> %-60s %3s %5s</b>\n", 'Title', 'NS', 'Count' ) );
578  $duplicate = [];
579  foreach ( $rows as $row ) {
580  if ( !isset( $duplicate[$row->cur_namespace] ) ) {
581  $duplicate[$row->cur_namespace] = [];
582  }
583 
584  $duplicate[$row->cur_namespace][] = $row->cur_title;
585  $this->output( sprintf(
586  " %-60s %3s %5s\n",
587  $row->cur_title, $row->cur_namespace,
588  $row->c
589  ) );
590  }
591  $sql = "SELECT cur_title, cur_namespace, cur_id, cur_timestamp FROM $cur WHERE ";
592  $dupeTitles = [];
593  foreach ( $duplicate as $ns => $titles ) {
594  $dupeTitles[] = "( cur_namespace = {$ns} AND cur_title in ("
595  . $this->db->makeList( $titles ) . ") ) \n";
596  }
597  $sql .= $this->db->makeList( $dupeTitles, IDatabase::LIST_OR );
598  # By sorting descending, the most recent entry will be the first in the list.
599  # All following entries will be deleted by the next while-loop.
600  $sql .= 'ORDER BY cur_namespace, cur_title, cur_timestamp DESC';
601 
602  $rows = $this->db->query( $sql, __METHOD__ );
603 
604  $prev_title = $prev_namespace = false;
605  $deleteId = [];
606 
607  foreach ( $rows as $row ) {
608  if ( $prev_title == $row->cur_title && $prev_namespace == $row->cur_namespace ) {
609  $deleteId[] = (int)$row->cur_id;
610  }
611  $prev_title = $row->cur_title;
612  $prev_namespace = $row->cur_namespace;
613  }
614  $sql = "DELETE FROM $cur WHERE cur_id IN ( " . implode( ',', $deleteId ) . ')';
615  $this->db->query( $sql, __METHOD__ );
616  $this->output( wfTimestamp( TS_DB ) );
617  $this->output( "......<b>Deleted</b> " . $this->db->affectedRows() . " records.\n" );
618  }
619 
620  $this->output( wfTimestamp( TS_DB ) );
621  $this->output( "......Creating tables.\n" );
622  $this->db->query( "CREATE TABLE $page (
623  page_id int(8) unsigned NOT NULL auto_increment,
624  page_namespace int NOT NULL,
625  page_title varchar(255) binary NOT NULL,
626  page_restrictions tinyblob NOT NULL,
627  page_is_redirect tinyint(1) unsigned NOT NULL default '0',
628  page_is_new tinyint(1) unsigned NOT NULL default '0',
629  page_random real unsigned NOT NULL,
630  page_touched char(14) binary NOT NULL default '',
631  page_latest int(8) unsigned NOT NULL,
632  page_len int(8) unsigned NOT NULL,
633 
634  PRIMARY KEY page_id (page_id),
635  UNIQUE INDEX name_title (page_namespace,page_title),
636  INDEX (page_random),
637  INDEX (page_len)
638  ) ENGINE=InnoDB", __METHOD__ );
639  $this->db->query( "CREATE TABLE $revision (
640  rev_id int(8) unsigned NOT NULL auto_increment,
641  rev_page int(8) unsigned NOT NULL,
642  rev_comment tinyblob NOT NULL,
643  rev_user int(5) unsigned NOT NULL default '0',
644  rev_user_text varchar(255) binary NOT NULL default '',
645  rev_timestamp char(14) binary NOT NULL default '',
646  rev_minor_edit tinyint(1) unsigned NOT NULL default '0',
647  rev_deleted tinyint(1) unsigned NOT NULL default '0',
648  rev_len int(8) unsigned,
649  rev_parent_id int(8) unsigned default NULL,
650  PRIMARY KEY rev_page_id (rev_page, rev_id),
651  UNIQUE INDEX rev_id (rev_id),
652  INDEX rev_timestamp (rev_timestamp),
653  INDEX page_timestamp (rev_page,rev_timestamp),
654  INDEX user_timestamp (rev_user,rev_timestamp),
655  INDEX usertext_timestamp (rev_user_text,rev_timestamp)
656  ) ENGINE=InnoDB", __METHOD__ );
657 
658  $this->output( wfTimestamp( TS_DB ) );
659  $this->output( "......Locking tables.\n" );
660  $this->db->query(
661  "LOCK TABLES $page WRITE, $revision WRITE, $old WRITE, $cur WRITE",
662  __METHOD__
663  );
664 
665  $maxold = intval( $this->db->selectField( 'old', 'max(old_id)', '', __METHOD__ ) );
666  $this->output( wfTimestamp( TS_DB ) );
667  $this->output( "......maxold is {$maxold}\n" );
668 
669  $this->output( wfTimestamp( TS_DB ) );
671  if ( $wgLegacySchemaConversion ) {
672  // Create HistoryBlobCurStub entries.
673  // Text will be pulled from the leftover 'cur' table at runtime.
674  $this->output( "......Moving metadata from cur; using blob references to text in cur table.\n" );
675  $cur_text = "concat('O:18:\"historyblobcurstub\":1:{s:6:\"mCurId\";i:',cur_id,';}')";
676  $cur_flags = "'object'";
677  } else {
678  // Copy all cur text in immediately: this may take longer but avoids
679  // having to keep an extra table around.
680  $this->output( "......Moving text from cur.\n" );
681  $cur_text = 'cur_text';
682  $cur_flags = "''";
683  }
684  $this->db->query(
685  "INSERT INTO $old (old_namespace, old_title, old_text, old_comment, old_user,
686  old_user_text, old_timestamp, old_minor_edit, old_flags)
687  SELECT cur_namespace, cur_title, $cur_text, cur_comment, cur_user, cur_user_text,
688  cur_timestamp, cur_minor_edit, $cur_flags
689  FROM $cur",
690  __METHOD__
691  );
692 
693  $this->output( wfTimestamp( TS_DB ) );
694  $this->output( "......Setting up revision table.\n" );
695  $this->db->query(
696  "INSERT INTO $revision (rev_id, rev_page, rev_comment, rev_user,
697  rev_user_text, rev_timestamp, rev_minor_edit)
698  SELECT old_id, cur_id, old_comment, old_user, old_user_text,
699  old_timestamp, old_minor_edit
700  FROM $old,$cur WHERE old_namespace=cur_namespace AND old_title=cur_title",
701  __METHOD__
702  );
703 
704  $this->output( wfTimestamp( TS_DB ) );
705  $this->output( "......Setting up page table.\n" );
706  $this->db->query(
707  "INSERT INTO $page (page_id, page_namespace, page_title,
708  page_restrictions, page_is_redirect, page_is_new, page_random,
709  page_touched, page_latest, page_len)
710  SELECT cur_id, cur_namespace, cur_title, cur_restrictions,
711  cur_is_redirect, cur_is_new, cur_random, cur_touched, rev_id, LENGTH(cur_text)
712  FROM $cur,$revision
713  WHERE cur_id=rev_page AND rev_timestamp=cur_timestamp AND rev_id > {$maxold}",
714  __METHOD__
715  );
716 
717  $this->output( wfTimestamp( TS_DB ) );
718  $this->output( "......Unlocking tables.\n" );
719  $this->db->query( "UNLOCK TABLES", __METHOD__ );
720 
721  $this->output( wfTimestamp( TS_DB ) );
722  $this->output( "......Renaming old.\n" );
723  $this->db->query( "ALTER TABLE $old RENAME TO $text", __METHOD__ );
724 
725  $this->output( wfTimestamp( TS_DB ) );
726  $this->output( "...done.\n" );
727  }
728 
729  protected function doNamespaceSize() {
730  $tables = [
731  'page' => 'page',
732  'archive' => 'ar',
733  'recentchanges' => 'rc',
734  'watchlist' => 'wl',
735  'querycache' => 'qc',
736  'logging' => 'log',
737  ];
738  foreach ( $tables as $table => $prefix ) {
739  $field = $prefix . '_namespace';
740 
741  $tablename = $this->db->tableName( $table );
742  $result = $this->db->query( "SHOW COLUMNS FROM $tablename LIKE '$field'", __METHOD__ );
743  $info = $this->db->fetchObject( $result );
744 
745  if ( substr( $info->Type, 0, 3 ) == 'int' ) {
746  $this->output( "...$field is already a full int ($info->Type).\n" );
747  } else {
748  $this->output( "Promoting $field from $info->Type to int... " );
749  $this->db->query( "ALTER TABLE $tablename MODIFY $field int NOT NULL", __METHOD__ );
750  $this->output( "done.\n" );
751  }
752  }
753  }
754 
755  protected function doPagelinksUpdate() {
756  if ( $this->db->tableExists( 'pagelinks', __METHOD__ ) ) {
757  $this->output( "...already have pagelinks table.\n" );
758 
759  return;
760  }
761 
762  $this->applyPatch(
763  'patch-pagelinks.sql',
764  false,
765  'Converting links and brokenlinks tables to pagelinks'
766  );
767 
768  foreach (
769  MediaWikiServices::getInstance()->getContentLanguage()->getNamespaces() as $ns => $name
770  ) {
771  if ( $ns == 0 ) {
772  continue;
773  }
774 
775  $this->output( "Cleaning up broken links for namespace $ns... " );
776  $this->db->update( 'pagelinks',
777  [
778  'pl_namespace' => $ns,
779  "pl_title = TRIM(LEADING {$this->db->addQuotes( "$name:" )} FROM pl_title)",
780  ],
781  [
782  'pl_namespace' => 0,
783  'pl_title' . $this->db->buildLike( "$name:", $this->db->anyString() ),
784  ],
785  __METHOD__
786  );
787  $this->output( "done.\n" );
788  }
789  }
790 
791  protected function doUserUniqueUpdate() {
792  if ( !$this->doTable( 'user' ) ) {
793  return true;
794  }
795 
796  $duper = new UserDupes( $this->db, [ $this, 'output' ] );
797  if ( $duper->hasUniqueIndex() ) {
798  $this->output( "...already have unique user_name index.\n" );
799 
800  return;
801  }
802 
803  if ( !$duper->clearDupes() ) {
804  $this->output( "WARNING: This next step will probably fail due to unfixed duplicates...\n" );
805  }
806  $this->applyPatch( 'patch-user_nameindex.sql', false, "Adding unique index on user_name" );
807  }
808 
809  protected function doUserGroupsUpdate() {
810  if ( !$this->doTable( 'user_groups' ) ) {
811  return true;
812  }
813 
814  if ( $this->db->tableExists( 'user_groups', __METHOD__ ) ) {
815  $info = $this->db->fieldInfo( 'user_groups', 'ug_group' );
816  if ( $info->type() == 'int' ) {
817  $oldug = $this->db->tableName( 'user_groups' );
818  $newug = $this->db->tableName( 'user_groups_bogus' );
819  $this->output( "user_groups table exists but is in bogus intermediate " .
820  "format. Renaming to $newug... " );
821  $this->db->query( "ALTER TABLE $oldug RENAME TO $newug", __METHOD__ );
822  $this->output( "done.\n" );
823 
824  $this->applyPatch( 'patch-user_groups.sql', false, "Re-adding fresh user_groups table" );
825 
826  $this->output( "***\n" );
827  $this->output( "*** WARNING: You will need to manually fix up user " .
828  "permissions in the user_groups\n" );
829  $this->output( "*** table. Old 1.5 alpha versions did some pretty funky stuff...\n" );
830  $this->output( "***\n" );
831  } else {
832  $this->output( "...user_groups table exists and is in current format.\n" );
833  }
834 
835  return;
836  }
837 
838  $this->applyPatch( 'patch-user_groups.sql', false, "Adding user_groups table" );
839 
840  if ( !$this->db->tableExists( 'user_rights', __METHOD__ ) ) {
841  if ( $this->db->fieldExists( 'user', 'user_rights', __METHOD__ ) ) {
842  $this->applyPatch(
843  'patch-user_rights.sql',
844  false,
845  'Upgrading from a 1.3 or older database? Breaking out user_rights for conversion'
846  );
847  } else {
848  $this->output( "*** WARNING: couldn't locate user_rights table or field for upgrade.\n" );
849  $this->output( "*** You may need to manually configure some sysops by manipulating\n" );
850  $this->output( "*** the user_groups table.\n" );
851 
852  return;
853  }
854  }
855 
856  $this->output( "Converting user_rights table to user_groups... " );
857  $result = $this->db->select( 'user_rights',
858  [ 'ur_user', 'ur_rights' ],
859  [ "ur_rights != ''" ],
860  __METHOD__ );
861 
862  foreach ( $result as $row ) {
863  $groups = array_unique(
864  array_map( 'trim',
865  explode( ',', $row->ur_rights ) ) );
866 
867  foreach ( $groups as $group ) {
868  $this->db->insert( 'user_groups',
869  [
870  'ug_user' => $row->ur_user,
871  'ug_group' => $group ],
872  __METHOD__ );
873  }
874  }
875  $this->output( "done.\n" );
876  }
877 
882  protected function doWatchlistNull() {
883  $info = $this->db->fieldInfo( 'watchlist', 'wl_notificationtimestamp' );
884  if ( !$info ) {
885  return;
886  }
887  if ( $info->isNullable() ) {
888  $this->output( "...wl_notificationtimestamp is already nullable.\n" );
889 
890  return;
891  }
892 
893  $this->applyPatch(
894  'patch-watchlist-null.sql',
895  false,
896  'Making wl_notificationtimestamp nullable'
897  );
898  }
899 
905  protected function doPageRandomUpdate() {
906  $page = $this->db->tableName( 'page' );
907  $this->db->query( "UPDATE $page SET page_random = RAND() WHERE page_random = 0", __METHOD__ );
908  $rows = $this->db->affectedRows();
909 
910  if ( $rows ) {
911  $this->output( "Set page_random to a random value on $rows rows where it was set to 0\n" );
912  } else {
913  $this->output( "...no page_random rows needed to be set\n" );
914  }
915  }
916 
917  protected function doTemplatelinksUpdate() {
918  if ( $this->db->tableExists( 'templatelinks', __METHOD__ ) ) {
919  $this->output( "...templatelinks table already exists\n" );
920 
921  return;
922  }
923 
924  $this->applyPatch( 'patch-templatelinks.sql', false, "Creating templatelinks table" );
925 
926  $this->output( "Populating...\n" );
927  $services = MediaWikiServices::getInstance();
928  if ( $services->getDBLoadBalancer()->getServerCount() > 1 ) {
929  // Slow, replication-friendly update
930  $res = $this->db->select( 'pagelinks', [ 'pl_from', 'pl_namespace', 'pl_title' ],
931  [ 'pl_namespace' => NS_TEMPLATE ], __METHOD__ );
932  $count = 0;
933  foreach ( $res as $row ) {
934  $count = ( $count + 1 ) % 100;
935  if ( $count == 0 ) {
936  $lbFactory = $services->getDBLoadBalancerFactory();
937  $lbFactory->waitForReplication( [
938  'domain' => $lbFactory->getLocalDomainID(),
939  'timeout' => self::REPLICATION_WAIT_TIMEOUT
940  ] );
941  }
942  $this->db->insert( 'templatelinks',
943  [
944  'tl_from' => $row->pl_from,
945  'tl_namespace' => $row->pl_namespace,
946  'tl_title' => $row->pl_title,
947  ], __METHOD__
948  );
949  }
950  } else {
951  // Fast update
952  $this->db->insertSelect( 'templatelinks', 'pagelinks',
953  [
954  'tl_from' => 'pl_from',
955  'tl_namespace' => 'pl_namespace',
956  'tl_title' => 'pl_title'
957  ], [
958  'pl_namespace' => 10
959  ], __METHOD__,
960  [ 'NO_AUTO_COLUMNS' ] // There's no "tl_id" auto-increment field
961  );
962  }
963  $this->output( "Done. Please run maintenance/refreshLinks.php for a more " .
964  "thorough templatelinks update.\n" );
965  }
966 
967  protected function doBacklinkingIndicesUpdate() {
968  if ( !$this->indexHasField( 'pagelinks', 'pl_namespace', 'pl_from' ) ||
969  !$this->indexHasField( 'templatelinks', 'tl_namespace', 'tl_from' ) ||
970  !$this->indexHasField( 'imagelinks', 'il_to', 'il_from' )
971  ) {
972  $this->applyPatch( 'patch-backlinkindexes.sql', false, "Updating backlinking indices" );
973  }
974  }
975 
981  protected function doRestrictionsUpdate() {
982  if ( $this->db->tableExists( 'page_restrictions', __METHOD__ ) ) {
983  $this->output( "...page_restrictions table already exists.\n" );
984 
985  return;
986  }
987 
988  $this->applyPatch(
989  'patch-page_restrictions.sql',
990  false,
991  'Creating page_restrictions table (1/2)'
992  );
993  $this->applyPatch(
994  'patch-page_restrictions_sortkey.sql',
995  false,
996  'Creating page_restrictions table (2/2)'
997  );
998  $this->output( "done.\n" );
999 
1000  $this->output( "Migrating old restrictions to new table...\n" );
1001  $task = $this->maintenance->runChild( UpdateRestrictions::class );
1002  $task->execute();
1003  }
1004 
1005  protected function doCategorylinksIndicesUpdate() {
1006  if ( !$this->indexHasField( 'categorylinks', 'cl_sortkey', 'cl_from' ) ) {
1007  $this->applyPatch( 'patch-categorylinksindex.sql', false, "Updating categorylinks Indices" );
1008  }
1009  }
1010 
1011  protected function doCategoryPopulation() {
1012  if ( $this->updateRowExists( 'populate category' ) ) {
1013  $this->output( "...category table already populated.\n" );
1014 
1015  return;
1016  }
1017 
1018  $this->output(
1019  "Populating category table, printing progress markers. " .
1020  "For large databases, you\n" .
1021  "may want to hit Ctrl-C and do this manually with maintenance/\n" .
1022  "populateCategory.php.\n"
1023  );
1024  $task = $this->maintenance->runChild( PopulateCategory::class );
1025  $task->execute();
1026  $this->output( "Done populating category table.\n" );
1027  }
1028 
1029  protected function doPopulateParentId() {
1030  if ( !$this->updateRowExists( 'populate rev_parent_id' ) ) {
1031  $this->output(
1032  "Populating rev_parent_id fields, printing progress markers. For large\n" .
1033  "databases, you may want to hit Ctrl-C and do this manually with\n" .
1034  "maintenance/populateParentId.php.\n" );
1035 
1036  $task = $this->maintenance->runChild( PopulateParentId::class );
1037  $task->execute();
1038  }
1039  }
1040 
1041  protected function doMaybeProfilingMemoryUpdate() {
1042  if ( !$this->doTable( 'profiling' ) ) {
1043  return true;
1044  }
1045 
1046  if ( !$this->db->tableExists( 'profiling', __METHOD__ ) ) {
1047  return true;
1048  } elseif ( $this->db->fieldExists( 'profiling', 'pf_memory', __METHOD__ ) ) {
1049  $this->output( "...profiling table has pf_memory field.\n" );
1050 
1051  return true;
1052  }
1053 
1054  return $this->applyPatch(
1055  'patch-profiling-memory.sql',
1056  false,
1057  'Adding pf_memory field to table profiling'
1058  );
1059  }
1060 
1061  protected function doFilearchiveIndicesUpdate() {
1062  $info = $this->db->indexInfo( 'filearchive', 'fa_user_timestamp', __METHOD__ );
1063  if ( !$info ) {
1064  $this->applyPatch( 'patch-filearchive-user-index.sql', false, "Updating filearchive indices" );
1065  }
1066 
1067  return true;
1068  }
1069 
1070  protected function doNonUniquePlTlIl() {
1071  $info = $this->db->indexInfo( 'pagelinks', 'pl_namespace' );
1072  if ( is_array( $info ) && $info[0]->Non_unique ) {
1073  $this->output( "...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE.\n" );
1074 
1075  return true;
1076  }
1077  if ( $this->skipSchema ) {
1078  $this->output( "...skipping schema change (making pl_namespace, tl_namespace " .
1079  "and il_to indices non-UNIQUE).\n" );
1080 
1081  return false;
1082  }
1083 
1084  return $this->applyPatch(
1085  'patch-pl-tl-il-nonunique.sql',
1086  false,
1087  'Making pl_namespace, tl_namespace and il_to indices non-UNIQUE'
1088  );
1089  }
1090 
1091  protected function doUpdateMimeMinorField() {
1092  if ( $this->updateRowExists( 'mime_minor_length' ) ) {
1093  $this->output( "...*_mime_minor fields are already long enough.\n" );
1094 
1095  return;
1096  }
1097 
1098  $this->applyPatch(
1099  'patch-mime_minor_length.sql',
1100  false,
1101  'Altering all *_mime_minor fields to 100 bytes in size'
1102  );
1103  }
1104 
1105  protected function doClFieldsUpdate() {
1106  if ( $this->updateRowExists( 'cl_fields_update' ) ) {
1107  $this->output( "...categorylinks up-to-date.\n" );
1108 
1109  return;
1110  }
1111 
1112  $this->applyPatch(
1113  'patch-categorylinks-better-collation2.sql',
1114  false,
1115  'Updating categorylinks (again)'
1116  );
1117  }
1118 
1119  protected function doLangLinksLengthUpdate() {
1120  $langlinks = $this->db->tableName( 'langlinks' );
1121  $res = $this->db->query( "SHOW COLUMNS FROM $langlinks LIKE 'll_lang'" );
1122  $row = $this->db->fetchObject( $res );
1123 
1124  if ( $row && $row->Type == "varbinary(10)" ) {
1125  $this->applyPatch(
1126  'patch-langlinks-ll_lang-20.sql',
1127  false,
1128  'Updating length of ll_lang in langlinks'
1129  );
1130  } else {
1131  $this->output( "...ll_lang is up-to-date.\n" );
1132  }
1133  }
1134 
1135  protected function doUserNewTalkTimestampNotNull() {
1136  if ( !$this->doTable( 'user_newtalk' ) ) {
1137  return true;
1138  }
1139 
1140  $info = $this->db->fieldInfo( 'user_newtalk', 'user_last_timestamp' );
1141  if ( $info === false ) {
1142  return;
1143  }
1144  if ( $info->isNullable() ) {
1145  $this->output( "...user_last_timestamp is already nullable.\n" );
1146 
1147  return;
1148  }
1149 
1150  $this->applyPatch(
1151  'patch-user-newtalk-timestamp-null.sql',
1152  false,
1153  'Making user_last_timestamp nullable'
1154  );
1155  }
1156 
1157  protected function doIwlinksIndexNonUnique() {
1158  $info = $this->db->indexInfo( 'iwlinks', 'iwl_prefix_title_from' );
1159  if ( is_array( $info ) && $info[0]->Non_unique ) {
1160  $this->output( "...iwl_prefix_title_from index is already non-UNIQUE.\n" );
1161 
1162  return true;
1163  }
1164  if ( $this->skipSchema ) {
1165  $this->output( "...skipping schema change (making iwl_prefix_title_from index non-UNIQUE).\n" );
1166 
1167  return false;
1168  }
1169 
1170  return $this->applyPatch(
1171  'patch-iwl_prefix_title_from-non-unique.sql',
1172  false,
1173  'Making iwl_prefix_title_from index non-UNIQUE'
1174  );
1175  }
1176 
1177  protected function doUnsignedSyncronisation() {
1178  $sync = [
1179  [ 'table' => 'bot_passwords', 'field' => 'bp_user' ],
1180  [ 'table' => 'change_tag', 'field' => 'ct_log_id' ],
1181  [ 'table' => 'change_tag', 'field' => 'ct_rev_id' ],
1182  [ 'table' => 'page_restrictions', 'field' => 'pr_user' ],
1183  [ 'table' => 'user_newtalk', 'field' => 'user_id' ],
1184  [ 'table' => 'user_properties', 'field' => 'up_user' ],
1185  ];
1186 
1187  foreach ( $sync as $s ) {
1188  if ( !$this->doTable( $s['table'] ) ) {
1189  continue;
1190  }
1191 
1192  $info = $this->db->fieldInfo( $s['table'], $s['field'] );
1193  if ( $info === false ) {
1194  continue;
1195  }
1196  $fullName = "{$s['table']}.{$s['field']}";
1197  if ( $info->isUnsigned() ) {
1198  $this->output( "...$fullName is already unsigned int.\n" );
1199 
1200  continue;
1201  }
1202 
1203  $this->applyPatch(
1204  "patch-{$s['table']}-{$s['field']}-unsigned.sql",
1205  false,
1206  "Making $fullName into an unsigned int"
1207  );
1208  }
1209 
1210  return true;
1211  }
1212 
1213  protected function doRevisionPageRevIndexNonUnique() {
1214  if ( !$this->doTable( 'revision' ) ) {
1215  return true;
1216  } elseif ( !$this->db->indexExists( 'revision', 'rev_page_id' ) ) {
1217  $this->output( "...rev_page_id index not found on revision.\n" );
1218  return true;
1219  }
1220 
1221  if ( !$this->db->indexUnique( 'revision', 'rev_page_id' ) ) {
1222  $this->output( "...rev_page_id index already non-unique.\n" );
1223  return true;
1224  }
1225 
1226  return $this->applyPatch(
1227  'patch-revision-page-rev-index-nonunique.sql',
1228  false,
1229  'Making rev_page_id index non-unique'
1230  );
1231  }
1232 
1233  protected function doExtendCommentLengths() {
1234  $table = $this->db->tableName( 'revision' );
1235  $res = $this->db->query( "SHOW COLUMNS FROM $table LIKE 'rev_comment'" );
1236  $row = $this->db->fetchObject( $res );
1237 
1238  if ( $row && ( $row->Type !== "varbinary(767)" || $row->Default !== "" ) ) {
1239  $this->applyPatch(
1240  'patch-editsummary-length.sql',
1241  false,
1242  'Extending edit summary lengths (and setting defaults)'
1243  );
1244  } else {
1245  $this->output( "...comment fields are up to date.\n" );
1246  }
1247  }
1248 
1249  public function getSchemaVars() {
1250  global $wgDBTableOptions;
1251 
1252  $vars = [];
1253  $vars['wgDBTableOptions'] = str_replace( 'TYPE', 'ENGINE', $wgDBTableOptions );
1254  $vars['wgDBTableOptions'] = str_replace(
1255  'CHARSET=mysql4',
1256  'CHARSET=binary',
1257  $vars['wgDBTableOptions']
1258  );
1259 
1260  return $vars;
1261  }
1262 }
do that in ParserLimitReportFormat instead use this to modify the parameters of the image all existing parser cache entries will be invalid To avoid you ll need to handle that somehow(e.g. with the RejectParserCacheValue hook) because MediaWiki won 't do it for you. & $defaults also a ContextSource after deleting those rows but within the same transaction $rows
Definition: hooks.txt:2633
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
doWatchlistUpdate()
Check if we need to add talk page rows to the watchlist.
doMaybeProfilingMemoryUpdate()
$IP
Definition: WebStart.php:41
Apache License January AND DISTRIBUTION Definitions License shall mean the terms and conditions for use
Class for handling database updates.
doBacklinkingIndicesUpdate()
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 MediaWikiServices
Definition: injection.txt:23
const NS_TEMPLATE
Definition: Defines.php:70
this hook is for auditing only RecentChangesLinked and Watchlist Do not use this to implement individual filters if they are compatible with the ChangesListFilter and ChangesListFilterGroup structure use sub classes of those in conjunction with the ChangesListSpecialPageStructuredFilters hook This hook can be used to implement filters that do not implement that or custom behavior that is not an individual filter e g Watchlist & $tables
Definition: hooks.txt:979
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 'ImportHandleUnknownUser':When a user doesn 't exist locally, this hook is called to give extensions an opportunity to auto-create it. If the auto-creation is successful, return false. $name:User name '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. '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 '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:Array with elements of the form "language:title" in the order that they will be output. & $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 since 1.28! 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:1980
$fullName
doRestrictionsUpdate()
Adding page_restrictions table, obsoleting page.page_restrictions.
wfTimestamp( $outputtype=TS_UNIX, $ts=0)
Get a timestamp string in one of various formats.
doUserNewTalkTimestampNotNull()
static configuration should be added through ResourceLoaderGetConfigVars instead can be used to get the real title e g db for database replication lag or jobqueue for job queue size converted to pseudo seconds It is possible to add more fields and they will be returned to the user in the API response after the basic globals have been set but before ordinary actions take place or wrap services the preferred way to define a new service is the $wgServiceWiringFiles array $services
Definition: hooks.txt:2217
Mysql update list and mysql-specific update functions.
doRevisionPageRevIndexNonUnique()
$res
Definition: database.txt:21
indexHasField( $table, $index, $field)
Check whether an index contain a field.
$wgDBTableOptions
MySQL table options to use during installation or update.
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:9
const LIST_OR
Definition: Defines.php:42
doInterwikiUpdate()
Check that interwiki table exists; if it doesn&#39;t source it.
doWatchlistNull()
Make sure wl_notificationtimestamp can be NULL, and update old broken items.
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:35
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
checkBin( $table, $field, $patchFile)
1.4 betas were missing the &#39;binary&#39; marker from logging.log_title, which causes a collation mismatch ...
you have access to all of the normal MediaWiki so you can get a DB use the etc For full docs on the Maintenance class
Definition: maintenance.txt:52
output( $str)
Output some text.
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
$wgLegacySchemaConversion
If set to true, the MediaWiki 1.4 to 1.5 schema conversion will create stub reference rows in the tex...
doFilearchiveIndicesUpdate()
Allows to change the fields on the form that will be generated $name
Definition: hooks.txt:271
doCategorylinksIndicesUpdate()
updateRowExists( $key)
Helper function: check if the given key is present in the updatelog table.
doPageRandomUpdate()
Set page_random field to a random value where it is equals to 0.
Look for duplicate user table entries and optionally prune them.
Definition: userDupes.inc:35
doIndexUpdate()
Check that proper indexes are in place.
doTable( $name)
Returns whether updates should be executed on the database table $name.
static configuration should be added through ResourceLoaderGetConfigVars instead & $vars
Definition: hooks.txt:2217