| [ Index ] |
PHP Cross Reference of MediaWiki-1.24.0 |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * PostgreSQL-specific updater. 4 * 5 * This program is free software; you can redistribute it and/or modify 6 * it under the terms of the GNU General Public License as published by 7 * the Free Software Foundation; either version 2 of the License, or 8 * (at your option) any later version. 9 * 10 * This program is distributed in the hope that it will be useful, 11 * but WITHOUT ANY WARRANTY; without even the implied warranty of 12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 * GNU General Public License for more details. 14 * 15 * You should have received a copy of the GNU General Public License along 16 * with this program; if not, write to the Free Software Foundation, Inc., 17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. 18 * http://www.gnu.org/copyleft/gpl.html 19 * 20 * @file 21 * @ingroup Deployment 22 */ 23 24 /** 25 * Class for handling updates to Postgres databases. 26 * 27 * @ingroup Deployment 28 * @since 1.17 29 */ 30 class PostgresUpdater extends DatabaseUpdater { 31 32 /** 33 * @var DatabasePostgres 34 */ 35 protected $db; 36 37 /** 38 * @todo FIXME: Postgres should use sequential updates like Mysql, Sqlite 39 * and everybody else. It never got refactored like it should've. 40 * @return array 41 */ 42 protected function getCoreUpdateList() { 43 return array( 44 # rename tables 1.7.3 45 # r15791 Change reserved word table names "user" and "text" 46 array( 'renameTable', 'user', 'mwuser' ), 47 array( 'renameTable', 'text', 'pagecontent' ), 48 array( 'renameIndex', 'mwuser', 'user_pkey', 'mwuser_pkey' ), 49 array( 'renameIndex', 'mwuser', 'user_user_name_key', 'mwuser_user_name_key' ), 50 array( 'renameIndex', 'pagecontent', 'text_pkey', 'pagecontent_pkey' ), 51 52 # renamed sequences 53 array( 'renameSequence', 'ipblocks_ipb_id_val', 'ipblocks_ipb_id_seq' ), 54 array( 'renameSequence', 'rev_rev_id_val', 'revision_rev_id_seq' ), 55 array( 'renameSequence', 'text_old_id_val', 'text_old_id_seq' ), 56 array( 'renameSequence', 'rc_rc_id_seq', 'recentchanges_rc_id_seq' ), 57 array( 'renameSequence', 'log_log_id_seq', 'logging_log_id_seq' ), 58 array( 'renameSequence', 'pr_id_val', 'page_restrictions_pr_id_seq' ), 59 array( 'renameSequence', 'us_id_seq', 'uploadstash_us_id_seq' ), 60 61 # since r58263 62 array( 'renameSequence', 'category_id_seq', 'category_cat_id_seq' ), 63 64 # new sequences if not renamed above 65 array( 'addSequence', 'logging', false, 'logging_log_id_seq' ), 66 array( 'addSequence', 'page_restrictions', false, 'page_restrictions_pr_id_seq' ), 67 array( 'addSequence', 'filearchive', 'fa_id', 'filearchive_fa_id_seq' ), 68 array( 'addSequence', 'archive', false, 'archive_ar_id_seq' ), 69 array( 'addSequence', 'externallinks', false, 'externallinks_el_id_seq' ), 70 71 # new tables 72 array( 'addTable', 'category', 'patch-category.sql' ), 73 array( 'addTable', 'page', 'patch-page.sql' ), 74 array( 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ), 75 array( 'addTable', 'page_props', 'patch-page_props.sql' ), 76 array( 'addTable', 'page_restrictions', 'patch-page_restrictions.sql' ), 77 array( 'addTable', 'profiling', 'patch-profiling.sql' ), 78 array( 'addTable', 'protected_titles', 'patch-protected_titles.sql' ), 79 array( 'addTable', 'redirect', 'patch-redirect.sql' ), 80 array( 'addTable', 'updatelog', 'patch-updatelog.sql' ), 81 array( 'addTable', 'change_tag', 'patch-change_tag.sql' ), 82 array( 'addTable', 'tag_summary', 'patch-tag_summary.sql' ), 83 array( 'addTable', 'valid_tag', 'patch-valid_tag.sql' ), 84 array( 'addTable', 'user_properties', 'patch-user_properties.sql' ), 85 array( 'addTable', 'log_search', 'patch-log_search.sql' ), 86 array( 'addTable', 'l10n_cache', 'patch-l10n_cache.sql' ), 87 array( 'addTable', 'iwlinks', 'patch-iwlinks.sql' ), 88 array( 'addTable', 'msg_resource', 'patch-msg_resource.sql' ), 89 array( 'addTable', 'msg_resource_links', 'patch-msg_resource_links.sql' ), 90 array( 'addTable', 'module_deps', 'patch-module_deps.sql' ), 91 array( 'addTable', 'uploadstash', 'patch-uploadstash.sql' ), 92 array( 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ), 93 array( 'addTable', 'sites', 'patch-sites.sql' ), 94 95 # Needed before new field 96 array( 'convertArchive2' ), 97 98 # new fields 99 array( 'addPgField', 'updatelog', 'ul_value', 'TEXT' ), 100 array( 'addPgField', 'archive', 'ar_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 101 array( 'addPgField', 'archive', 'ar_len', 'INTEGER' ), 102 array( 'addPgField', 'archive', 'ar_page_id', 'INTEGER' ), 103 array( 'addPgField', 'archive', 'ar_parent_id', 'INTEGER' ), 104 array( 'addPgField', 'archive', 'ar_content_model', 'TEXT' ), 105 array( 'addPgField', 'archive', 'ar_content_format', 'TEXT' ), 106 array( 'addPgField', 'categorylinks', 'cl_sortkey_prefix', "TEXT NOT NULL DEFAULT ''" ), 107 array( 'addPgField', 'categorylinks', 'cl_collation', "TEXT NOT NULL DEFAULT 0" ), 108 array( 'addPgField', 'categorylinks', 'cl_type', "TEXT NOT NULL DEFAULT 'page'" ), 109 array( 'addPgField', 'image', 'img_sha1', "TEXT NOT NULL DEFAULT ''" ), 110 array( 'addPgField', 'ipblocks', 'ipb_allow_usertalk', 'SMALLINT NOT NULL DEFAULT 0' ), 111 array( 'addPgField', 'ipblocks', 'ipb_anon_only', 'SMALLINT NOT NULL DEFAULT 0' ), 112 array( 'addPgField', 'ipblocks', 'ipb_by_text', "TEXT NOT NULL DEFAULT ''" ), 113 array( 'addPgField', 'ipblocks', 'ipb_block_email', 'SMALLINT NOT NULL DEFAULT 0' ), 114 array( 'addPgField', 'ipblocks', 'ipb_create_account', 'SMALLINT NOT NULL DEFAULT 1' ), 115 array( 'addPgField', 'ipblocks', 'ipb_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 116 array( 'addPgField', 'ipblocks', 'ipb_enable_autoblock', 'SMALLINT NOT NULL DEFAULT 1' ), 117 array( 'addPgField', 'ipblocks', 'ipb_parent_block_id', 118 'INTEGER DEFAULT NULL REFERENCES ipblocks(ipb_id) ' . 119 'ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED' ), 120 array( 'addPgField', 'filearchive', 'fa_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 121 array( 'addPgField', 'filearchive', 'fa_sha1', "TEXT NOT NULL DEFAULT ''" ), 122 array( 'addPgField', 'logging', 'log_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 123 array( 'addPgField', 'logging', 'log_id', 124 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('logging_log_id_seq')" ), 125 array( 'addPgField', 'logging', 'log_params', 'TEXT' ), 126 array( 'addPgField', 'mwuser', 'user_editcount', 'INTEGER' ), 127 array( 'addPgField', 'mwuser', 'user_newpass_time', 'TIMESTAMPTZ' ), 128 array( 'addPgField', 'oldimage', 'oi_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 129 array( 'addPgField', 'oldimage', 'oi_major_mime', "TEXT NOT NULL DEFAULT 'unknown'" ), 130 array( 'addPgField', 'oldimage', 'oi_media_type', 'TEXT' ), 131 array( 'addPgField', 'oldimage', 'oi_metadata', "BYTEA NOT NULL DEFAULT ''" ), 132 array( 'addPgField', 'oldimage', 'oi_minor_mime', "TEXT NOT NULL DEFAULT 'unknown'" ), 133 array( 'addPgField', 'oldimage', 'oi_sha1', "TEXT NOT NULL DEFAULT ''" ), 134 array( 'addPgField', 'page', 'page_content_model', 'TEXT' ), 135 array( 'addPgField', 'page_restrictions', 'pr_id', 136 "INTEGER NOT NULL UNIQUE DEFAULT nextval('page_restrictions_pr_id_seq')" ), 137 array( 'addPgField', 'profiling', 'pf_memory', 'NUMERIC(18,10) NOT NULL DEFAULT 0' ), 138 array( 'addPgField', 'recentchanges', 'rc_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 139 array( 'addPgField', 'recentchanges', 'rc_log_action', 'TEXT' ), 140 array( 'addPgField', 'recentchanges', 'rc_log_type', 'TEXT' ), 141 array( 'addPgField', 'recentchanges', 'rc_logid', 'INTEGER NOT NULL DEFAULT 0' ), 142 array( 'addPgField', 'recentchanges', 'rc_new_len', 'INTEGER' ), 143 array( 'addPgField', 'recentchanges', 'rc_old_len', 'INTEGER' ), 144 array( 'addPgField', 'recentchanges', 'rc_params', 'TEXT' ), 145 array( 'addPgField', 'redirect', 'rd_interwiki', 'TEXT NULL' ), 146 array( 'addPgField', 'redirect', 'rd_fragment', 'TEXT NULL' ), 147 array( 'addPgField', 'revision', 'rev_deleted', 'SMALLINT NOT NULL DEFAULT 0' ), 148 array( 'addPgField', 'revision', 'rev_len', 'INTEGER' ), 149 array( 'addPgField', 'revision', 'rev_parent_id', 'INTEGER DEFAULT NULL' ), 150 array( 'addPgField', 'revision', 'rev_content_model', 'TEXT' ), 151 array( 'addPgField', 'revision', 'rev_content_format', 'TEXT' ), 152 array( 'addPgField', 'site_stats', 'ss_active_users', "INTEGER DEFAULT '-1'" ), 153 array( 'addPgField', 'user_newtalk', 'user_last_timestamp', 'TIMESTAMPTZ' ), 154 array( 'addPgField', 'logging', 'log_user_text', "TEXT NOT NULL DEFAULT ''" ), 155 array( 'addPgField', 'logging', 'log_page', 'INTEGER' ), 156 array( 'addPgField', 'interwiki', 'iw_api', "TEXT NOT NULL DEFAULT ''" ), 157 array( 'addPgField', 'interwiki', 'iw_wikiid', "TEXT NOT NULL DEFAULT ''" ), 158 array( 'addPgField', 'revision', 'rev_sha1', "TEXT NOT NULL DEFAULT ''" ), 159 array( 'addPgField', 'archive', 'ar_sha1', "TEXT NOT NULL DEFAULT ''" ), 160 array( 'addPgField', 'uploadstash', 'us_chunk_inx', "INTEGER NULL" ), 161 array( 'addPgField', 'job', 'job_timestamp', "TIMESTAMPTZ" ), 162 array( 'addPgField', 'job', 'job_random', "INTEGER NOT NULL DEFAULT 0" ), 163 array( 'addPgField', 'job', 'job_attempts', "INTEGER NOT NULL DEFAULT 0" ), 164 array( 'addPgField', 'job', 'job_token', "TEXT NOT NULL DEFAULT ''" ), 165 array( 'addPgField', 'job', 'job_token_timestamp', "TIMESTAMPTZ" ), 166 array( 'addPgField', 'job', 'job_sha1', "TEXT NOT NULL DEFAULT ''" ), 167 array( 'addPgField', 'archive', 'ar_id', 168 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('archive_ar_id_seq')" ), 169 array( 'addPgField', 'externallinks', 'el_id', 170 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('externallinks_el_id_seq')" ), 171 array( 'addPgField', 'uploadstash', 'us_props', "BYTEA" ), 172 173 # type changes 174 array( 'changeField', 'archive', 'ar_deleted', 'smallint', '' ), 175 array( 'changeField', 'archive', 'ar_minor_edit', 'smallint', 176 'ar_minor_edit::smallint DEFAULT 0' ), 177 array( 'changeField', 'filearchive', 'fa_deleted', 'smallint', '' ), 178 array( 'changeField', 'filearchive', 'fa_height', 'integer', '' ), 179 array( 'changeField', 'filearchive', 'fa_metadata', 'bytea', "decode(fa_metadata,'escape')" ), 180 array( 'changeField', 'filearchive', 'fa_size', 'integer', '' ), 181 array( 'changeField', 'filearchive', 'fa_width', 'integer', '' ), 182 array( 'changeField', 'filearchive', 'fa_storage_group', 'text', '' ), 183 array( 'changeField', 'filearchive', 'fa_storage_key', 'text', '' ), 184 array( 'changeField', 'image', 'img_metadata', 'bytea', "decode(img_metadata,'escape')" ), 185 array( 'changeField', 'image', 'img_size', 'integer', '' ), 186 array( 'changeField', 'image', 'img_width', 'integer', '' ), 187 array( 'changeField', 'image', 'img_height', 'integer', '' ), 188 array( 'changeField', 'interwiki', 'iw_local', 'smallint', 'iw_local::smallint' ), 189 array( 'changeField', 'interwiki', 'iw_trans', 'smallint', 'iw_trans::smallint DEFAULT 0' ), 190 array( 'changeField', 'ipblocks', 'ipb_auto', 'smallint', 'ipb_auto::smallint DEFAULT 0' ), 191 array( 'changeField', 'ipblocks', 'ipb_anon_only', 'smallint', 192 "CASE WHEN ipb_anon_only=' ' THEN 0 ELSE ipb_anon_only::smallint END DEFAULT 0" ), 193 array( 'changeField', 'ipblocks', 'ipb_create_account', 'smallint', 194 "CASE WHEN ipb_create_account=' ' THEN 0 ELSE ipb_create_account::smallint END DEFAULT 1" ), 195 array( 'changeField', 'ipblocks', 'ipb_enable_autoblock', 'smallint', 196 "CASE WHEN ipb_enable_autoblock=' ' THEN 0 ELSE ipb_enable_autoblock::smallint END DEFAULT 1" ), 197 array( 'changeField', 'ipblocks', 'ipb_block_email', 'smallint', 198 "CASE WHEN ipb_block_email=' ' THEN 0 ELSE ipb_block_email::smallint END DEFAULT 0" ), 199 array( 'changeField', 'ipblocks', 'ipb_address', 'text', 'ipb_address::text' ), 200 array( 'changeField', 'ipblocks', 'ipb_deleted', 'smallint', 'ipb_deleted::smallint DEFAULT 0' ), 201 array( 'changeField', 'mwuser', 'user_token', 'text', '' ), 202 array( 'changeField', 'mwuser', 'user_email_token', 'text', '' ), 203 array( 'changeField', 'objectcache', 'keyname', 'text', '' ), 204 array( 'changeField', 'oldimage', 'oi_height', 'integer', '' ), 205 array( 'changeField', 'oldimage', 'oi_metadata', 'bytea', "decode(img_metadata,'escape')" ), 206 array( 'changeField', 'oldimage', 'oi_size', 'integer', '' ), 207 array( 'changeField', 'oldimage', 'oi_width', 'integer', '' ), 208 array( 'changeField', 'page', 'page_is_redirect', 'smallint', 209 'page_is_redirect::smallint DEFAULT 0' ), 210 array( 'changeField', 'page', 'page_is_new', 'smallint', 'page_is_new::smallint DEFAULT 0' ), 211 array( 'changeField', 'querycache', 'qc_value', 'integer', '' ), 212 array( 'changeField', 'querycachetwo', 'qcc_value', 'integer', '' ), 213 array( 'changeField', 'recentchanges', 'rc_bot', 'smallint', 'rc_bot::smallint DEFAULT 0' ), 214 array( 'changeField', 'recentchanges', 'rc_deleted', 'smallint', '' ), 215 array( 'changeField', 'recentchanges', 'rc_minor', 'smallint', 'rc_minor::smallint DEFAULT 0' ), 216 array( 'changeField', 'recentchanges', 'rc_new', 'smallint', 'rc_new::smallint DEFAULT 0' ), 217 array( 'changeField', 'recentchanges', 'rc_type', 'smallint', 'rc_type::smallint DEFAULT 0' ), 218 array( 'changeField', 'recentchanges', 'rc_patrolled', 'smallint', 219 'rc_patrolled::smallint DEFAULT 0' ), 220 array( 'changeField', 'revision', 'rev_deleted', 'smallint', 'rev_deleted::smallint DEFAULT 0' ), 221 array( 'changeField', 'revision', 'rev_minor_edit', 'smallint', 222 'rev_minor_edit::smallint DEFAULT 0' ), 223 array( 'changeField', 'templatelinks', 'tl_namespace', 'smallint', 'tl_namespace::smallint' ), 224 array( 'changeField', 'user_newtalk', 'user_ip', 'text', 'host(user_ip)' ), 225 array( 'changeField', 'uploadstash', 'us_image_bits', 'smallint', '' ), 226 array( 'changeField', 'profiling', 'pf_time', 'float', '' ), 227 array( 'changeField', 'profiling', 'pf_memory', 'float', '' ), 228 229 # null changes 230 array( 'changeNullableField', 'oldimage', 'oi_bits', 'NULL' ), 231 array( 'changeNullableField', 'oldimage', 'oi_timestamp', 'NULL' ), 232 array( 'changeNullableField', 'oldimage', 'oi_major_mime', 'NULL' ), 233 array( 'changeNullableField', 'oldimage', 'oi_minor_mime', 'NULL' ), 234 array( 'changeNullableField', 'image', 'img_metadata', 'NOT NULL' ), 235 array( 'changeNullableField', 'filearchive', 'fa_metadata', 'NOT NULL' ), 236 array( 'changeNullableField', 'recentchanges', 'rc_cur_id', 'NULL' ), 237 array( 'changeNullableField', 'recentchanges', 'rc_cur_time', 'NULL' ), 238 239 array( 'checkOiDeleted' ), 240 241 # New indexes 242 array( 'addPgIndex', 'archive', 'archive_user_text', '(ar_user_text)' ), 243 array( 'addPgIndex', 'image', 'img_sha1', '(img_sha1)' ), 244 array( 'addPgIndex', 'ipblocks', 'ipb_parent_block_id', '(ipb_parent_block_id)' ), 245 array( 'addPgIndex', 'oldimage', 'oi_sha1', '(oi_sha1)' ), 246 array( 'addPgIndex', 'page', 'page_mediawiki_title', '(page_title) WHERE page_namespace = 8' ), 247 array( 'addPgIndex', 'pagelinks', 'pagelinks_title', '(pl_title)' ), 248 array( 'addPgIndex', 'page_props', 'pp_propname_page', '(pp_propname, pp_page)' ), 249 array( 'addPgIndex', 'revision', 'rev_text_id_idx', '(rev_text_id)' ), 250 array( 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ), 251 array( 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ), 252 array( 'addPgIndex', 'watchlist', 'wl_user', '(wl_user)' ), 253 array( 'addPgIndex', 'watchlist', 'wl_user_notificationtimestamp', '(wl_user, wl_notificationtimestamp)' ), 254 array( 'addPgIndex', 'logging', 'logging_user_type_time', 255 '(log_user, log_type, log_timestamp)' ), 256 array( 'addPgIndex', 'logging', 'logging_page_id_time', '(log_page,log_timestamp)' ), 257 array( 'addPgIndex', 'iwlinks', 'iwl_prefix_from_title', '(iwl_prefix, iwl_from, iwl_title)' ), 258 array( 'addPgIndex', 'iwlinks', 'iwl_prefix_title_from', '(iwl_prefix, iwl_title, iwl_from)' ), 259 array( 'addPgIndex', 'job', 'job_timestamp_idx', '(job_timestamp)' ), 260 array( 'addPgIndex', 'job', 'job_sha1', '(job_sha1)' ), 261 array( 'addPgIndex', 'job', 'job_cmd_token', '(job_cmd, job_token, job_random)' ), 262 array( 'addPgIndex', 'job', 'job_cmd_token_id', '(job_cmd, job_token, job_id)' ), 263 array( 'addPgIndex', 'filearchive', 'fa_sha1', '(fa_sha1)' ), 264 array( 'addPgIndex', 'logging', 'logging_user_text_type_time', 265 '(log_user_text, log_type, log_timestamp)' ), 266 array( 'addPgIndex', 'logging', 'logging_user_text_time', '(log_user_text, log_timestamp)' ), 267 268 array( 'checkIndex', 'pagelink_unique', array( 269 array( 'pl_from', 'int4_ops', 'btree', 0 ), 270 array( 'pl_namespace', 'int2_ops', 'btree', 0 ), 271 array( 'pl_title', 'text_ops', 'btree', 0 ), 272 ), 273 'CREATE UNIQUE INDEX pagelink_unique ON pagelinks (pl_from,pl_namespace,pl_title)' ), 274 array( 'checkIndex', 'cl_sortkey', array( 275 array( 'cl_to', 'text_ops', 'btree', 0 ), 276 array( 'cl_sortkey', 'text_ops', 'btree', 0 ), 277 array( 'cl_from', 'int4_ops', 'btree', 0 ), 278 ), 279 'CREATE INDEX cl_sortkey ON "categorylinks" ' . 280 'USING "btree" ("cl_to", "cl_sortkey", "cl_from")' ), 281 array( 'checkIndex', 'iwl_prefix_title_from', array( 282 array( 'iwl_prefix', 'text_ops', 'btree', 0 ), 283 array( 'iwl_title', 'text_ops', 'btree', 0 ), 284 array( 'iwl_from', 'int4_ops', 'btree', 0 ), 285 ), 286 'CREATE INDEX iwl_prefix_title_from ON "iwlinks" ' . 287 'USING "btree" ("iwl_prefix", "iwl_title", "iwl_from")' ), 288 array( 'checkIndex', 'logging_times', array( 289 array( 'log_timestamp', 'timestamptz_ops', 'btree', 0 ), 290 ), 291 'CREATE INDEX "logging_times" ON "logging" USING "btree" ("log_timestamp")' ), 292 array( 'dropIndex', 'oldimage', 'oi_name' ), 293 array( 'checkIndex', 'oi_name_archive_name', array( 294 array( 'oi_name', 'text_ops', 'btree', 0 ), 295 array( 'oi_archive_name', 'text_ops', 'btree', 0 ), 296 ), 297 'CREATE INDEX "oi_name_archive_name" ON "oldimage" ' . 298 'USING "btree" ("oi_name", "oi_archive_name")' ), 299 array( 'checkIndex', 'oi_name_timestamp', array( 300 array( 'oi_name', 'text_ops', 'btree', 0 ), 301 array( 'oi_timestamp', 'timestamptz_ops', 'btree', 0 ), 302 ), 303 'CREATE INDEX "oi_name_timestamp" ON "oldimage" ' . 304 'USING "btree" ("oi_name", "oi_timestamp")' ), 305 array( 'checkIndex', 'page_main_title', array( 306 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 307 ), 308 'CREATE INDEX "page_main_title" ON "page" ' . 309 'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 0)' ), 310 array( 'checkIndex', 'page_mediawiki_title', array( 311 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 312 ), 313 'CREATE INDEX "page_mediawiki_title" ON "page" ' . 314 'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 8)' ), 315 array( 'checkIndex', 'page_project_title', array( 316 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 317 ), 318 'CREATE INDEX "page_project_title" ON "page" ' . 319 'USING "btree" ("page_title" "text_pattern_ops") ' . 320 'WHERE ("page_namespace" = 4)' ), 321 array( 'checkIndex', 'page_talk_title', array( 322 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 323 ), 324 'CREATE INDEX "page_talk_title" ON "page" ' . 325 'USING "btree" ("page_title" "text_pattern_ops") ' . 326 'WHERE ("page_namespace" = 1)' ), 327 array( 'checkIndex', 'page_user_title', array( 328 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 329 ), 330 'CREATE INDEX "page_user_title" ON "page" ' . 331 'USING "btree" ("page_title" "text_pattern_ops") WHERE ' . 332 '("page_namespace" = 2)' ), 333 array( 'checkIndex', 'page_utalk_title', array( 334 array( 'page_title', 'text_pattern_ops', 'btree', 0 ), 335 ), 336 'CREATE INDEX "page_utalk_title" ON "page" ' . 337 'USING "btree" ("page_title" "text_pattern_ops") ' . 338 'WHERE ("page_namespace" = 3)' ), 339 array( 'checkIndex', 'ts2_page_text', array( 340 array( 'textvector', 'tsvector_ops', 'gist', 0 ), 341 ), 342 'CREATE INDEX "ts2_page_text" ON "pagecontent" USING "gist" ("textvector")' ), 343 array( 'checkIndex', 'ts2_page_title', array( 344 array( 'titlevector', 'tsvector_ops', 'gist', 0 ), 345 ), 346 'CREATE INDEX "ts2_page_title" ON "page" USING "gist" ("titlevector")' ), 347 348 array( 'checkOiNameConstraint' ), 349 array( 'checkPageDeletedTrigger' ), 350 array( 'checkRevUserFkey' ), 351 array( 'dropIndex', 'ipblocks', 'ipb_address' ), 352 array( 'checkIndex', 'ipb_address_unique', array( 353 array( 'ipb_address', 'text_ops', 'btree', 0 ), 354 array( 'ipb_user', 'int4_ops', 'btree', 0 ), 355 array( 'ipb_auto', 'int2_ops', 'btree', 0 ), 356 array( 'ipb_anon_only', 'int2_ops', 'btree', 0 ), 357 ), 358 'CREATE UNIQUE INDEX ipb_address_unique ' . 359 'ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only)' ), 360 361 array( 'checkIwlPrefix' ), 362 363 # All FK columns should be deferred 364 array( 'changeFkeyDeferrable', 'archive', 'ar_user', 'mwuser(user_id) ON DELETE SET NULL' ), 365 array( 'changeFkeyDeferrable', 'categorylinks', 'cl_from', 'page(page_id) ON DELETE CASCADE' ), 366 array( 'changeFkeyDeferrable', 'externallinks', 'el_from', 'page(page_id) ON DELETE CASCADE' ), 367 array( 'changeFkeyDeferrable', 'filearchive', 'fa_deleted_user', 368 'mwuser(user_id) ON DELETE SET NULL' ), 369 array( 'changeFkeyDeferrable', 'filearchive', 'fa_user', 'mwuser(user_id) ON DELETE SET NULL' ), 370 array( 'changeFkeyDeferrable', 'image', 'img_user', 'mwuser(user_id) ON DELETE SET NULL' ), 371 array( 'changeFkeyDeferrable', 'imagelinks', 'il_from', 'page(page_id) ON DELETE CASCADE' ), 372 array( 'changeFkeyDeferrable', 'ipblocks', 'ipb_by', 'mwuser(user_id) ON DELETE CASCADE' ), 373 array( 'changeFkeyDeferrable', 'ipblocks', 'ipb_user', 'mwuser(user_id) ON DELETE SET NULL' ), 374 array( 'changeFkeyDeferrable', 'ipblocks', 'ipb_parent_block_id', 375 'ipblocks(ipb_id) ON DELETE SET NULL' ), 376 array( 'changeFkeyDeferrable', 'langlinks', 'll_from', 'page(page_id) ON DELETE CASCADE' ), 377 array( 'changeFkeyDeferrable', 'logging', 'log_user', 'mwuser(user_id) ON DELETE SET NULL' ), 378 array( 'changeFkeyDeferrable', 'oldimage', 'oi_name', 379 'image(img_name) ON DELETE CASCADE ON UPDATE CASCADE' ), 380 array( 'changeFkeyDeferrable', 'oldimage', 'oi_user', 'mwuser(user_id) ON DELETE SET NULL' ), 381 array( 'changeFkeyDeferrable', 'pagelinks', 'pl_from', 'page(page_id) ON DELETE CASCADE' ), 382 array( 'changeFkeyDeferrable', 'page_props', 'pp_page', 'page (page_id) ON DELETE CASCADE' ), 383 array( 'changeFkeyDeferrable', 'page_restrictions', 'pr_page', 384 'page(page_id) ON DELETE CASCADE' ), 385 array( 'changeFkeyDeferrable', 'protected_titles', 'pt_user', 386 'mwuser(user_id) ON DELETE SET NULL' ), 387 array( 'changeFkeyDeferrable', 'recentchanges', 'rc_cur_id', 388 'page(page_id) ON DELETE SET NULL' ), 389 array( 'changeFkeyDeferrable', 'recentchanges', 'rc_user', 390 'mwuser(user_id) ON DELETE SET NULL' ), 391 array( 'changeFkeyDeferrable', 'redirect', 'rd_from', 'page(page_id) ON DELETE CASCADE' ), 392 array( 'changeFkeyDeferrable', 'revision', 'rev_page', 'page (page_id) ON DELETE CASCADE' ), 393 array( 'changeFkeyDeferrable', 'revision', 'rev_user', 'mwuser(user_id) ON DELETE RESTRICT' ), 394 array( 'changeFkeyDeferrable', 'templatelinks', 'tl_from', 'page(page_id) ON DELETE CASCADE' ), 395 array( 'changeFkeyDeferrable', 'user_groups', 'ug_user', 'mwuser(user_id) ON DELETE CASCADE' ), 396 array( 'changeFkeyDeferrable', 'user_newtalk', 'user_id', 'mwuser(user_id) ON DELETE CASCADE' ), 397 array( 'changeFkeyDeferrable', 'user_properties', 'up_user', 398 'mwuser(user_id) ON DELETE CASCADE' ), 399 array( 'changeFkeyDeferrable', 'watchlist', 'wl_user', 'mwuser(user_id) ON DELETE CASCADE' ), 400 401 # r81574 402 array( 'addInterwikiType' ), 403 # end 404 array( 'tsearchFixes' ), 405 406 // 1.23 407 array( 'addPgField', 'recentchanges', 'rc_source', "TEXT NOT NULL DEFAULT ''" ), 408 array( 'addPgField', 'page', 'page_links_updated', "TIMESTAMPTZ NULL" ), 409 array( 'addPgField', 'mwuser', 'user_password_expires', 'TIMESTAMPTZ NULL' ), 410 array( 'changeFieldPurgeTable', 'l10n_cache', 'lc_value', 'bytea', 411 "replace(lc_value,'\','\\\\')::bytea" ), 412 413 // 1.24 414 array( 'addPgField', 'page_props', 'pp_sortkey', 'float NULL' ), 415 array( 'addPgIndex', 'page_props', 'pp_propname_sortkey_page', 416 '( pp_propname, pp_sortkey, pp_page ) WHERE ( pp_sortkey IS NOT NULL )' ), 417 array( 'addPgField', 'page', 'page_lang', 'TEXT default NULL' ), 418 array( 'addPgField', 'pagelinks', 'pl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ), 419 array( 'addPgField', 'templatelinks', 'tl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ), 420 array( 'addPgField', 'imagelinks', 'il_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ), 421 ); 422 } 423 424 protected function getOldGlobalUpdates() { 425 global $wgExtNewTables, $wgExtPGNewFields, $wgExtPGAlteredFields, $wgExtNewIndexes; 426 427 $updates = array(); 428 429 # Add missing extension tables 430 foreach ( $wgExtNewTables as $tableRecord ) { 431 $updates[] = array( 432 'addTable', $tableRecord[0], $tableRecord[1], true 433 ); 434 } 435 436 # Add missing extension fields 437 foreach ( $wgExtPGNewFields as $fieldRecord ) { 438 $updates[] = array( 439 'addPgField', $fieldRecord[0], $fieldRecord[1], 440 $fieldRecord[2] 441 ); 442 } 443 444 # Change altered columns 445 foreach ( $wgExtPGAlteredFields as $fieldRecord ) { 446 $updates[] = array( 447 'changeField', $fieldRecord[0], $fieldRecord[1], 448 $fieldRecord[2] 449 ); 450 } 451 452 # Add missing extension indexes 453 foreach ( $wgExtNewIndexes as $fieldRecord ) { 454 $updates[] = array( 455 'addPgExtIndex', $fieldRecord[0], $fieldRecord[1], 456 $fieldRecord[2] 457 ); 458 } 459 460 return $updates; 461 } 462 463 protected function describeTable( $table ) { 464 $q = <<<END 465 SELECT attname, attnum FROM pg_namespace, pg_class, pg_attribute 466 WHERE pg_class.relnamespace = pg_namespace.oid 467 AND attrelid=pg_class.oid AND attnum > 0 468 AND relname=%s AND nspname=%s 469 END; 470 $res = $this->db->query( sprintf( $q, 471 $this->db->addQuotes( $table ), 472 $this->db->addQuotes( $this->db->getCoreSchema() ) ) ); 473 if ( !$res ) { 474 return null; 475 } 476 477 $cols = array(); 478 foreach ( $res as $r ) { 479 $cols[] = array( 480 "name" => $r[0], 481 "ord" => $r[1], 482 ); 483 } 484 485 return $cols; 486 } 487 488 function describeIndex( $idx ) { 489 // first fetch the key (which is a list of columns ords) and 490 // the table the index applies to (an oid) 491 $q = <<<END 492 SELECT indkey, indrelid FROM pg_namespace, pg_class, pg_index 493 WHERE nspname=%s 494 AND pg_class.relnamespace = pg_namespace.oid 495 AND relname=%s 496 AND indexrelid=pg_class.oid 497 END; 498 $res = $this->db->query( 499 sprintf( 500 $q, 501 $this->db->addQuotes( $this->db->getCoreSchema() ), 502 $this->db->addQuotes( $idx ) 503 ) 504 ); 505 if ( !$res ) { 506 return null; 507 } 508 if ( !( $r = $this->db->fetchRow( $res ) ) ) { 509 return null; 510 } 511 512 $indkey = $r[0]; 513 $relid = intval( $r[1] ); 514 $indkeys = explode( ' ', $indkey ); 515 516 $colnames = array(); 517 foreach ( $indkeys as $rid ) { 518 $query = <<<END 519 SELECT attname FROM pg_class, pg_attribute 520 WHERE attrelid=$relid 521 AND attnum=%d 522 AND attrelid=pg_class.oid 523 END; 524 $r2 = $this->db->query( sprintf( $query, $rid ) ); 525 if ( !$r2 ) { 526 return null; 527 } 528 if ( !( $row2 = $this->db->fetchRow( $r2 ) ) ) { 529 return null; 530 } 531 $colnames[] = $row2[0]; 532 } 533 534 return $colnames; 535 } 536 537 function fkeyDeltype( $fkey ) { 538 $q = <<<END 539 SELECT confdeltype FROM pg_constraint, pg_namespace 540 WHERE connamespace=pg_namespace.oid 541 AND nspname=%s 542 AND conname=%s; 543 END; 544 $r = $this->db->query( 545 sprintf( 546 $q, 547 $this->db->addQuotes( $this->db->getCoreSchema() ), 548 $this->db->addQuotes( $fkey ) 549 ) 550 ); 551 if ( !( $row = $this->db->fetchRow( $r ) ) ) { 552 return null; 553 } 554 555 return $row[0]; 556 } 557 558 function ruleDef( $table, $rule ) { 559 $q = <<<END 560 SELECT definition FROM pg_rules 561 WHERE schemaname = %s 562 AND tablename = %s 563 AND rulename = %s 564 END; 565 $r = $this->db->query( 566 sprintf( 567 $q, 568 $this->db->addQuotes( $this->db->getCoreSchema() ), 569 $this->db->addQuotes( $table ), 570 $this->db->addQuotes( $rule ) 571 ) 572 ); 573 $row = $this->db->fetchRow( $r ); 574 if ( !$row ) { 575 return null; 576 } 577 $d = $row[0]; 578 579 return $d; 580 } 581 582 protected function addSequence( $table, $pkey, $ns ) { 583 if ( !$this->db->sequenceExists( $ns ) ) { 584 $this->output( "Creating sequence $ns\n" ); 585 $this->db->query( "CREATE SEQUENCE $ns" ); 586 if ( $pkey !== false ) { 587 $this->setDefault( $table, $pkey, '"nextval"(\'"' . $ns . '"\'::"regclass")' ); 588 } 589 } 590 } 591 592 protected function renameSequence( $old, $new ) { 593 if ( $this->db->sequenceExists( $new ) ) { 594 $this->output( "...sequence $new already exists.\n" ); 595 596 return; 597 } 598 if ( $this->db->sequenceExists( $old ) ) { 599 $this->output( "Renaming sequence $old to $new\n" ); 600 $this->db->query( "ALTER SEQUENCE $old RENAME TO $new" ); 601 } 602 } 603 604 protected function renameTable( $old, $new, $patch = false ) { 605 if ( $this->db->tableExists( $old ) ) { 606 $this->output( "Renaming table $old to $new\n" ); 607 $old = $this->db->realTableName( $old, "quoted" ); 608 $new = $this->db->realTableName( $new, "quoted" ); 609 $this->db->query( "ALTER TABLE $old RENAME TO $new" ); 610 if ( $patch !== false ) { 611 $this->applyPatch( $patch ); 612 } 613 } 614 } 615 616 protected function renameIndex( 617 $table, $old, $new, $skipBothIndexExistWarning = false, $a = false, $b = false 618 ) { 619 // First requirement: the table must exist 620 if ( !$this->db->tableExists( $table, __METHOD__ ) ) { 621 $this->output( "...skipping: '$table' table doesn't exist yet.\n" ); 622 623 return; 624 } 625 626 // Second requirement: the new index must be missing 627 if ( $this->db->indexExists( $table, $new, __METHOD__ ) ) { 628 $this->output( "...index $new already set on $table table.\n" ); 629 if ( !$skipBothIndexExistWarning 630 && $this->db->indexExists( $table, $old, __METHOD__ ) 631 ) { 632 $this->output( "...WARNING: $old still exists, despite it has been " . 633 "renamed into $new (which also exists).\n" . 634 " $old should be manually removed if not needed anymore.\n" ); 635 } 636 637 return; 638 } 639 640 // Third requirement: the old index must exist 641 if ( !$this->db->indexExists( $table, $old, __METHOD__ ) ) { 642 $this->output( "...skipping: index $old doesn't exist.\n" ); 643 644 return; 645 } 646 647 $this->db->query( "ALTER INDEX $old RENAME TO $new" ); 648 } 649 650 protected function addPgField( $table, $field, $type ) { 651 $fi = $this->db->fieldInfo( $table, $field ); 652 if ( !is_null( $fi ) ) { 653 $this->output( "...column '$table.$field' already exists\n" ); 654 655 return; 656 } else { 657 $this->output( "Adding column '$table.$field'\n" ); 658 $this->db->query( "ALTER TABLE $table ADD $field $type" ); 659 } 660 } 661 662 protected function changeField( $table, $field, $newtype, $default ) { 663 $fi = $this->db->fieldInfo( $table, $field ); 664 if ( is_null( $fi ) ) { 665 $this->output( "...ERROR: expected column $table.$field to exist\n" ); 666 exit( 1 ); 667 } 668 669 if ( $fi->type() === $newtype ) { 670 $this->output( "...column '$table.$field' is already of type '$newtype'\n" ); 671 } else { 672 $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" ); 673 $sql = "ALTER TABLE $table ALTER $field TYPE $newtype"; 674 if ( strlen( $default ) ) { 675 $res = array(); 676 if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) { 677 $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]"; 678 $this->db->query( $sqldef ); 679 $default = preg_replace( '/\s*DEFAULT .+/', '', $default ); 680 } 681 $sql .= " USING $default"; 682 } 683 $this->db->query( $sql ); 684 } 685 } 686 687 protected function changeFieldPurgeTable( $table, $field, $newtype, $default ) { 688 ## For a cache table, empty it if the field needs to be changed, because the old contents 689 ## may be corrupted. If the column is already the desired type, refrain from purging. 690 $fi = $this->db->fieldInfo( $table, $field ); 691 if ( is_null( $fi ) ) { 692 $this->output( "...ERROR: expected column $table.$field to exist\n" ); 693 exit( 1 ); 694 } 695 696 if ( $fi->type() === $newtype ) { 697 $this->output( "...column '$table.$field' is already of type '$newtype'\n" ); 698 } else { 699 $this->output( "Purging data from cache table '$table'\n" ); 700 $this->db->query( "DELETE from $table" ); 701 $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" ); 702 $sql = "ALTER TABLE $table ALTER $field TYPE $newtype"; 703 if ( strlen( $default ) ) { 704 $res = array(); 705 if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) { 706 $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]"; 707 $this->db->query( $sqldef ); 708 $default = preg_replace( '/\s*DEFAULT .+/', '', $default ); 709 } 710 $sql .= " USING $default"; 711 } 712 $this->db->query( $sql ); 713 } 714 } 715 716 protected function setDefault( $table, $field, $default ) { 717 718 $info = $this->db->fieldInfo( $table, $field ); 719 if ( $info->defaultValue() !== $default ) { 720 $this->output( "Changing '$table.$field' default value\n" ); 721 $this->db->query( "ALTER TABLE $table ALTER $field SET DEFAULT " . $default ); 722 } 723 } 724 725 protected function changeNullableField( $table, $field, $null ) { 726 $fi = $this->db->fieldInfo( $table, $field ); 727 if ( is_null( $fi ) ) { 728 $this->output( "...ERROR: expected column $table.$field to exist\n" ); 729 exit( 1 ); 730 } 731 if ( $fi->isNullable() ) { 732 # # It's NULL - does it need to be NOT NULL? 733 if ( 'NOT NULL' === $null ) { 734 $this->output( "Changing '$table.$field' to not allow NULLs\n" ); 735 $this->db->query( "ALTER TABLE $table ALTER $field SET NOT NULL" ); 736 } else { 737 $this->output( "...column '$table.$field' is already set as NULL\n" ); 738 } 739 } else { 740 # # It's NOT NULL - does it need to be NULL? 741 if ( 'NULL' === $null ) { 742 $this->output( "Changing '$table.$field' to allow NULLs\n" ); 743 $this->db->query( "ALTER TABLE $table ALTER $field DROP NOT NULL" ); 744 } else { 745 $this->output( "...column '$table.$field' is already set as NOT NULL\n" ); 746 } 747 } 748 } 749 750 public function addPgIndex( $table, $index, $type ) { 751 if ( $this->db->indexExists( $table, $index ) ) { 752 $this->output( "...index '$index' on table '$table' already exists\n" ); 753 } else { 754 $this->output( "Creating index '$index' on table '$table' $type\n" ); 755 $this->db->query( "CREATE INDEX $index ON $table $type" ); 756 } 757 } 758 759 public function addPgExtIndex( $table, $index, $type ) { 760 if ( $this->db->indexExists( $table, $index ) ) { 761 $this->output( "...index '$index' on table '$table' already exists\n" ); 762 } else { 763 if ( preg_match( '/^\(/', $type ) ) { 764 $this->output( "Creating index '$index' on table '$table'\n" ); 765 $this->db->query( "CREATE INDEX $index ON $table $type" ); 766 } else { 767 $this->applyPatch( $type, true, "Creating index '$index' on table '$table'" ); 768 } 769 } 770 } 771 772 protected function changeFkeyDeferrable( $table, $field, $clause ) { 773 $fi = $this->db->fieldInfo( $table, $field ); 774 if ( is_null( $fi ) ) { 775 $this->output( "WARNING! Column '$table.$field' does not exist but it should! " . 776 "Please report this.\n" ); 777 778 return; 779 } 780 if ( $fi->is_deferred() && $fi->is_deferrable() ) { 781 return; 782 } 783 $this->output( "Altering column '$table.$field' to be DEFERRABLE INITIALLY DEFERRED\n" ); 784 $conname = $fi->conname(); 785 if ( $fi->conname() ) { 786 $conclause = "CONSTRAINT \"$conname\""; 787 $command = "ALTER TABLE $table DROP CONSTRAINT $conname"; 788 $this->db->query( $command ); 789 } else { 790 $this->output( "Column '$table.$field' does not have a foreign key " . 791 "constraint, will be added\n" ); 792 $conclause = ""; 793 } 794 $command = 795 "ALTER TABLE $table ADD $conclause " . 796 "FOREIGN KEY ($field) REFERENCES $clause DEFERRABLE INITIALLY DEFERRED"; 797 $this->db->query( $command ); 798 } 799 800 protected function convertArchive2() { 801 if ( $this->db->tableExists( "archive2" ) ) { 802 if ( $this->db->ruleExists( 'archive', 'archive_insert' ) ) { 803 $this->output( "Dropping rule 'archive_insert'\n" ); 804 $this->db->query( 'DROP RULE archive_insert ON archive' ); 805 } 806 if ( $this->db->ruleExists( 'archive', 'archive_delete' ) ) { 807 $this->output( "Dropping rule 'archive_delete'\n" ); 808 $this->db->query( 'DROP RULE archive_delete ON archive' ); 809 } 810 $this->applyPatch( 811 'patch-remove-archive2.sql', 812 false, 813 "Converting 'archive2' back to normal archive table" 814 ); 815 } else { 816 $this->output( "...obsolete table 'archive2' does not exist\n" ); 817 } 818 } 819 820 protected function checkOiDeleted() { 821 if ( $this->db->fieldInfo( 'oldimage', 'oi_deleted' )->type() !== 'smallint' ) { 822 $this->output( "Changing 'oldimage.oi_deleted' to type 'smallint'\n" ); 823 $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted DROP DEFAULT" ); 824 $this->db->query( 825 "ALTER TABLE oldimage ALTER oi_deleted TYPE SMALLINT USING (oi_deleted::smallint)" ); 826 $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted SET DEFAULT 0" ); 827 } else { 828 $this->output( "...column 'oldimage.oi_deleted' is already of type 'smallint'\n" ); 829 } 830 } 831 832 protected function checkOiNameConstraint() { 833 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascaded" ) ) { 834 $this->output( "...table 'oldimage' has correct cascading delete/update " . 835 "foreign key to image\n" ); 836 } else { 837 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey" ) ) { 838 $this->db->query( 839 "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey" ); 840 } 841 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascade" ) ) { 842 $this->db->query( 843 "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey_cascade" ); 844 } 845 $this->output( "Making foreign key on table 'oldimage' (to image) a cascade delete/update\n" ); 846 $this->db->query( 847 "ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascaded " . 848 "FOREIGN KEY (oi_name) REFERENCES image(img_name) " . 849 "ON DELETE CASCADE ON UPDATE CASCADE" ); 850 } 851 } 852 853 protected function checkPageDeletedTrigger() { 854 if ( !$this->db->triggerExists( 'page', 'page_deleted' ) ) { 855 $this->applyPatch( 856 'patch-page_deleted.sql', 857 false, 858 "Adding function and trigger 'page_deleted' to table 'page'" 859 ); 860 } else { 861 $this->output( "...table 'page' has 'page_deleted' trigger\n" ); 862 } 863 } 864 865 protected function dropIndex( $table, $index, $patch = '', $fullpath = false ) { 866 if ( $this->db->indexExists( $table, $index ) ) { 867 $this->output( "Dropping obsolete index '$index'\n" ); 868 $this->db->query( "DROP INDEX \"" . $index . "\"" ); 869 } 870 } 871 872 protected function checkIndex( $index, $should_be, $good_def ) { 873 $pu = $this->db->indexAttributes( $index ); 874 if ( !empty( $pu ) && $pu != $should_be ) { 875 $this->output( "Dropping obsolete version of index '$index'\n" ); 876 $this->db->query( "DROP INDEX \"" . $index . "\"" ); 877 $pu = array(); 878 } else { 879 $this->output( "...no need to drop index '$index'\n" ); 880 } 881 882 if ( empty( $pu ) ) { 883 $this->output( "Creating index '$index'\n" ); 884 $this->db->query( $good_def ); 885 } else { 886 $this->output( "...index '$index' exists\n" ); 887 } 888 } 889 890 protected function checkRevUserFkey() { 891 if ( $this->fkeyDeltype( 'revision_rev_user_fkey' ) == 'r' ) { 892 $this->output( "...constraint 'revision_rev_user_fkey' is ON DELETE RESTRICT\n" ); 893 } else { 894 $this->applyPatch( 895 'patch-revision_rev_user_fkey.sql', 896 false, 897 "Changing constraint 'revision_rev_user_fkey' to ON DELETE RESTRICT" 898 ); 899 } 900 } 901 902 protected function checkIwlPrefix() { 903 if ( $this->db->indexExists( 'iwlinks', 'iwl_prefix' ) ) { 904 $this->applyPatch( 905 'patch-rename-iwl_prefix.sql', 906 false, 907 "Replacing index 'iwl_prefix' with 'iwl_prefix_title_from'" 908 ); 909 } 910 } 911 912 protected function addInterwikiType() { 913 $this->applyPatch( 'patch-add_interwiki.sql', false, "Refreshing add_interwiki()" ); 914 } 915 916 protected function tsearchFixes() { 917 # Tweak the page_title tsearch2 trigger to filter out slashes 918 # This is create or replace, so harmless to call if not needed 919 $this->applyPatch( 'patch-ts2pagetitle.sql', false, "Refreshing ts2_page_title()" ); 920 921 # If the server is 8.3 or higher, rewrite the tsearch2 triggers 922 # in case they have the old 'default' versions 923 # Gather version numbers in case we need them 924 if ( $this->db->getServerVersion() >= 8.3 ) { 925 $this->applyPatch( 'patch-tsearch2funcs.sql', false, "Rewriting tsearch2 triggers" ); 926 } 927 } 928 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Fri Nov 28 14:03:12 2014 | Cross-referenced by PHPXref 0.7.1 |