includes/installer/MysqlUpdater.php

   1 <?php
   2 /**
   3  * MySQL-specific updater.
   4  *
   5  * @file
   6  * @ingroup Deployment
   7  */
   8
   9 /**
  10  * Mysql update list and mysql-specific update functions.
  11  *
  12  * @ingroup Deployment
  13  * @since 1.17
  14  */
  15 class MysqlUpdater extends DatabaseUpdater {
  16
  17         protected function getCoreUpdateList() {
  18                 return array(
  19                         // 1.2
  20                         array( 'addField', 'ipblocks',      'ipb_id',           'patch-ipblocks.sql' ),
  21                         array( 'addField', 'ipblocks',      'ipb_expiry',       'patch-ipb_expiry.sql' ),
  22                         array( 'do_interwiki_update' ),
  23                         array( 'do_index_update' ),
  24                         array( 'addTable', 'hitcounter',                        'patch-hitcounter.sql' ),
  25                         array( 'addField', 'recentchanges', 'rc_type',          'patch-rc_type.sql' ),
  26
  27                         // 1.3
  28                         array( 'addField', 'user',          'user_real_name',   'patch-user-realname.sql' ),
  29                         array( 'addTable', 'querycache',                        'patch-querycache.sql' ),
  30                         array( 'addTable', 'objectcache',                       'patch-objectcache.sql' ),
  31                         array( 'addTable', 'categorylinks',                     'patch-categorylinks.sql' ),
  32                         array( 'do_old_links_update' ),
  33                         array( 'fix_ancient_imagelinks' ),
  34                         array( 'addField', 'recentchanges', 'rc_ip',            'patch-rc_ip.sql' ),
  35
  36                         // 1.4
  37                         array( 'do_image_name_unique_update' ),
  38                         array( 'addField', 'recentchanges', 'rc_id',            'patch-rc_id.sql' ),
  39                         array( 'addField', 'recentchanges', 'rc_patrolled',     'patch-rc-patrol.sql' ),
  40                         array( 'addTable', 'logging',                           'patch-logging.sql' ),
  41                         array( 'addField', 'user',          'user_token',       'patch-user_token.sql' ),
  42                         array( 'do_watchlist_update' ),
  43                         array( 'dropField', 'user',         'user_emailauthenticationtimestamp', 'patch-email-authentication.sql' ),
  44
  45                         // 1.5
  46                         array( 'do_schema_restructuring' ),
  47                         array( 'addField', 'logging',       'log_params',       'patch-log_params.sql' ),
  48                         array( 'check_bin', 'logging',      'log_title',        'patch-logging-title.sql', ),
  49                         array( 'addField', 'archive',       'ar_rev_id',        'patch-archive-rev_id.sql' ),
  50                         array( 'addField', 'page',          'page_len',         'patch-page_len.sql' ),
  51                         array( 'dropField', 'revision',     'inverse_timestamp', 'patch-inverse_timestamp.sql' ),
  52                         array( 'addField', 'revision',      'rev_text_id',      'patch-rev_text_id.sql' ),
  53                         array( 'addField', 'revision',      'rev_deleted',      'patch-rev_deleted.sql' ),
  54                         array( 'addField', 'image',         'img_width',        'patch-img_width.sql' ),
  55                         array( 'addField', 'image',         'img_metadata',     'patch-img_metadata.sql' ),
  56                         array( 'addField', 'user',          'user_email_token', 'patch-user_email_token.sql' ),
  57                         array( 'addField', 'archive',       'ar_text_id',       'patch-archive-text_id.sql' ),
  58                         array( 'doNamespaceSize' ),
  59                         array( 'addField', 'image',         'img_media_type',   'patch-img_media_type.sql' ),
  60                         array( 'do_pagelinks_update' ),
  61                         array( 'dropField', 'image',        'img_type',         'patch-drop_img_type.sql' ),
  62                         array( 'do_user_unique_update' ),
  63                         array( 'do_user_groups_update' ),
  64                         array( 'addField', 'site_stats',    'ss_total_pages',   'patch-ss_total_articles.sql' ),
  65                         array( 'addTable', 'user_newtalk',                      'patch-usernewtalk2.sql' ),
  66                         array( 'addTable', 'transcache',                        'patch-transcache.sql' ),
  67                         array( 'addField', 'interwiki',     'iw_trans',         'patch-interwiki-trans.sql' ),
  68                         array( 'addTable', 'trackbacks',                        'patch-trackbacks.sql' ),
  69
  70                         // 1.6
  71                         array( 'do_watchlist_null' ),
  72                         array( 'addIndex', 'logging',         'times',            'patch-logging-times-index.sql' ),
  73                         array( 'addField', 'ipblocks',        'ipb_range_start',  'patch-ipb_range_start.sql' ),
  74                         array( 'do_page_random_update' ),
  75                         array( 'addField', 'user',            'user_registration', 'patch-user_registration.sql' ),
  76                         array( 'do_templatelinks_update' ),
  77                         array( 'addTable', 'externallinks',                       'patch-externallinks.sql' ),
  78                         array( 'addTable', 'job',                                 'patch-job.sql' ),
  79                         array( 'addField', 'site_stats',      'ss_images',        'patch-ss_images.sql' ),
  80                         array( 'addTable', 'langlinks',                           'patch-langlinks.sql' ),
  81                         array( 'addTable', 'querycache_info',                     'patch-querycacheinfo.sql' ),
  82                         array( 'addTable', 'filearchive',                         'patch-filearchive.sql' ),
  83                         array( 'addField', 'ipblocks',        'ipb_anon_only',    'patch-ipb_anon_only.sql' ),
  84                         array( 'do_rc_indices_update' ),
  85
  86                         // 1.9
  87                         array( 'addField', 'user',          'user_newpass_time', 'patch-user_newpass_time.sql' ),
  88                         array( 'addTable', 'redirect',                           'patch-redirect.sql' ),
  89                         array( 'addTable', 'querycachetwo',                      'patch-querycachetwo.sql' ),
  90                         array( 'addField', 'ipblocks',      'ipb_enable_autoblock', 'patch-ipb_optional_autoblock.sql' ),
  91                         array( 'do_backlinking_indices_update' ),
  92                         array( 'addField', 'recentchanges', 'rc_old_len',        'patch-rc_len.sql' ),
  93                         array( 'addField', 'user',          'user_editcount',    'patch-user_editcount.sql' ),
  94
  95                         // 1.10
  96                         array( 'do_restrictions_update' ),
  97                         array( 'addField', 'logging',       'log_id',           'patch-log_id.sql' ),
  98                         array( 'addField', 'revision',      'rev_parent_id',    'patch-rev_parent_id.sql' ),
  99                         array( 'addField', 'page_restrictions', 'pr_id',        'patch-page_restrictions_sortkey.sql' ),
 100                         array( 'addField', 'revision',      'rev_len',          'patch-rev_len.sql' ),
 101                         array( 'addField', 'recentchanges', 'rc_deleted',       'patch-rc_deleted.sql' ),
 102                         array( 'addField', 'logging',       'log_deleted',      'patch-log_deleted.sql' ),
 103                         array( 'addField', 'archive',       'ar_deleted',       'patch-ar_deleted.sql' ),
 104                         array( 'addField', 'ipblocks',      'ipb_deleted',      'patch-ipb_deleted.sql' ),
 105                         array( 'addField', 'filearchive',   'fa_deleted',       'patch-fa_deleted.sql' ),
 106                         array( 'addField', 'archive',       'ar_len',           'patch-ar_len.sql' ),
 107
 108                         // 1.11
 109                         array( 'addField', 'ipblocks',      'ipb_block_email',  'patch-ipb_emailban.sql' ),
 110                         array( 'do_categorylinks_indices_update' ),
 111                         array( 'addField', 'oldimage',      'oi_metadata',      'patch-oi_metadata.sql' ),
 112                         array( 'addIndex', 'archive',       'usertext_timestamp', 'patch-archive-user-index.sql' ),
 113                         array( 'addIndex', 'image',         'img_usertext_timestamp', 'patch-image-user-index.sql' ),
 114                         array( 'addIndex', 'oldimage',      'oi_usertext_timestamp', 'patch-oldimage-user-index.sql' ),
 115                         array( 'addField', 'archive',       'ar_page_id',       'patch-archive-page_id.sql' ),
 116                         array( 'addField', 'image',         'img_sha1',         'patch-img_sha1.sql' ),
 117
 118                         // 1.12
 119                         array( 'addTable', 'protected_titles',                  'patch-protected_titles.sql' ),
 120
 121                         // 1.13
 122                         array( 'addField', 'ipblocks',      'ipb_by_text',      'patch-ipb_by_text.sql' ),
 123                         array( 'addTable', 'page_props',                        'patch-page_props.sql' ),
 124                         array( 'addTable', 'updatelog',                         'patch-updatelog.sql' ),
 125                         array( 'addTable', 'category',                          'patch-category.sql' ),
 126                         array( 'do_category_population' ),
 127                         array( 'addField', 'archive',       'ar_parent_id',     'patch-ar_parent_id.sql' ),
 128                         array( 'addField', 'user_newtalk',  'user_last_timestamp', 'patch-user_last_timestamp.sql' ),
 129                         array( 'do_populate_parent_id' ),
 130                         array( 'check_bin', 'protected_titles', 'pt_title',      'patch-pt_title-encoding.sql', ),
 131                         array( 'maybe_do_profiling_memory_update' ),
 132                         array( 'do_filearchive_indices_update' ),
 133
 134                         // 1.14
 135                         array( 'addField', 'site_stats',    'ss_active_users',  'patch-ss_active_users.sql' ),
 136                         array( 'do_active_users_init' ),
 137                         array( 'addField', 'ipblocks',      'ipb_allow_usertalk', 'patch-ipb_allow_usertalk.sql' ),
 138
 139                         // 1.15
 140                         array( 'do_unique_pl_tl_il' ),
 141                         array( 'addTable', 'change_tag',                        'patch-change_tag.sql' ),
 142                         array( 'addTable', 'tag_summary',                       'patch-change_tag.sql' ),
 143                         array( 'addTable', 'valid_tag',                         'patch-change_tag.sql' ),
 144
 145                         // 1.16
 146                         array( 'addTable', 'user_properties',                   'patch-user_properties.sql' ),
 147                         array( 'addTable', 'log_search',                        'patch-log_search.sql' ),
 148                         array( 'do_log_search_population' ),
 149                         array( 'addField', 'logging',       'log_user_text',    'patch-log_user_text.sql' ),
 150                         array( 'addTable', 'l10n_cache',                        'patch-l10n_cache.sql' ),
 151                         array( 'addTable', 'external_user',                     'patch-external_user.sql' ),
 152                         array( 'addIndex', 'log_search',    'ls_field_val',     'patch-log_search-rename-index.sql' ),
 153                         array( 'addIndex', 'change_tag',    'change_tag_rc_tag', 'patch-change_tag-indexes.sql' ),
 154                         array( 'addField', 'redirect',      'rd_interwiki',     'patch-rd_interwiki.sql' ),
 155                         array( 'do_update_transcache_field' ),
 156                         array( 'rename_eu_wiki_id' ),
 157                         array( 'do_update_mime_minor_field' ),
 158                         array( 'do_populate_rev_len' ),
 159
 160                         // 1.17
 161                         array( 'addTable', 'iwlinks',                           'patch-iwlinks.sql' ),
 162                         array( 'addIndex', 'iwlinks', 'iwl_prefix_title_from',  'patch-rename-iwl_prefix.sql' ),
 163                         array( 'addField', 'updatelog', 'ul_value',              'patch-ul_value.sql' ),
 164                         array( 'addField', 'interwiki',     'iw_api',           'patch-iw_api_and_wikiid.sql' ),
 165                         array( 'drop_index_if_exists', 'iwlinks', 'iwl_prefix',  'patch-kill-iwl_prefix.sql' ),
 166                         array( 'drop_index_if_exists', 'iwlinks', 'iwl_prefix_from_title', 'patch-kill-iwl_pft.sql' ),
 167                         array( 'addField', 'categorylinks', 'cl_collation', 'patch-categorylinks-better-collation.sql' ),
 168                         array( 'do_cl_fields_update' ),
 169                         array( 'do_collation_update' ),
 170                         array( 'addTable', 'msg_resource',                      'patch-msg_resource.sql' ),
 171                         array( 'addTable', 'module_deps',                       'patch-module_deps.sql' ),
 172                 );
 173         }
 174
 175         protected function doNamespaceSize() {
 176                 $tables = array(
 177                         'page'          => 'page',
 178                         'archive'       => 'ar',
 179                         'recentchanges' => 'rc',
 180                         'watchlist'     => 'wl',
 181                         'querycache'    => 'qc',
 182                         'logging'       => 'log',
 183                 );
 184                 foreach ( $tables as $table => $prefix ) {
 185                         $field = $prefix . '_namespace';
 186
 187                         $tablename = $this->db->tableName( $table );
 188                         $result = $this->db->query( "SHOW COLUMNS FROM $tablename LIKE '$field'" );
 189                         $info = $this->db->fetchObject( $result );
 190
 191                         if ( substr( $info->Type, 0, 3 ) == 'int' ) {
 192                                 wfOut( "...$field is already a full int ($info->Type).\n" );
 193                         } else {
 194                                 wfOut( "Promoting $field from $info->Type to int... " );
 195
 196                                 $sql = "ALTER TABLE $tablename MODIFY $field int NOT NULL";
 197                                 $this->db->query( $sql );
 198
 199                                 wfOut( "ok\n" );
 200                         }
 201                 }
 202         }
 203 }