MediaWiki REL1_30
PostgresUpdater.php
Go to the documentation of this file.
1<?php
24use Wikimedia\Rdbms\DatabasePostgres;
25
32class PostgresUpdater extends DatabaseUpdater {
33
37 protected $db;
38
44 protected function getCoreUpdateList() {
45 return [
46 # rename tables 1.7.3
47 # r15791 Change reserved word table names "user" and "text"
48 [ 'renameTable', 'user', 'mwuser' ],
49 [ 'renameTable', 'text', 'pagecontent' ],
50 [ 'renameIndex', 'mwuser', 'user_pkey', 'mwuser_pkey' ],
51 [ 'renameIndex', 'mwuser', 'user_user_name_key', 'mwuser_user_name_key' ],
52 [ 'renameIndex', 'pagecontent', 'text_pkey', 'pagecontent_pkey' ],
53
54 # renamed sequences
55 [ 'renameSequence', 'ipblocks_ipb_id_val', 'ipblocks_ipb_id_seq' ],
56 [ 'renameSequence', 'rev_rev_id_val', 'revision_rev_id_seq' ],
57 [ 'renameSequence', 'text_old_id_val', 'text_old_id_seq' ],
58 [ 'renameSequence', 'rc_rc_id_seq', 'recentchanges_rc_id_seq' ],
59 [ 'renameSequence', 'log_log_id_seq', 'logging_log_id_seq' ],
60 [ 'renameSequence', 'pr_id_val', 'page_restrictions_pr_id_seq' ],
61 [ 'renameSequence', 'us_id_seq', 'uploadstash_us_id_seq' ],
62
63 # since r58263
64 [ 'renameSequence', 'category_id_seq', 'category_cat_id_seq' ],
65
66 # new sequences if not renamed above
67 [ 'addSequence', 'logging', false, 'logging_log_id_seq' ],
68 [ 'addSequence', 'page_restrictions', false, 'page_restrictions_pr_id_seq' ],
69 [ 'addSequence', 'filearchive', 'fa_id', 'filearchive_fa_id_seq' ],
70 [ 'addSequence', 'archive', false, 'archive_ar_id_seq' ],
71 [ 'addSequence', 'externallinks', false, 'externallinks_el_id_seq' ],
72 [ 'addSequence', 'watchlist', false, 'watchlist_wl_id_seq' ],
73 [ 'addSequence', 'change_tag', false, 'change_tag_ct_id_seq' ],
74 [ 'addSequence', 'tag_summary', false, 'tag_summary_ts_id_seq' ],
75
76 # new tables
77 [ 'addTable', 'category', 'patch-category.sql' ],
78 [ 'addTable', 'page', 'patch-page.sql' ],
79 [ 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ],
80 [ 'addTable', 'page_props', 'patch-page_props.sql' ],
81 [ 'addTable', 'page_restrictions', 'patch-page_restrictions.sql' ],
82 [ 'addTable', 'profiling', 'patch-profiling.sql' ],
83 [ 'addTable', 'protected_titles', 'patch-protected_titles.sql' ],
84 [ 'addTable', 'redirect', 'patch-redirect.sql' ],
85 [ 'addTable', 'updatelog', 'patch-updatelog.sql' ],
86 [ 'addTable', 'change_tag', 'patch-change_tag.sql' ],
87 [ 'addTable', 'tag_summary', 'patch-tag_summary.sql' ],
88 [ 'addTable', 'valid_tag', 'patch-valid_tag.sql' ],
89 [ 'addTable', 'user_properties', 'patch-user_properties.sql' ],
90 [ 'addTable', 'log_search', 'patch-log_search.sql' ],
91 [ 'addTable', 'l10n_cache', 'patch-l10n_cache.sql' ],
92 [ 'addTable', 'iwlinks', 'patch-iwlinks.sql' ],
93 [ 'addTable', 'module_deps', 'patch-module_deps.sql' ],
94 [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
95 [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
96 [ 'addTable', 'sites', 'patch-sites.sql' ],
97 [ 'addTable', 'bot_passwords', 'patch-bot_passwords.sql' ],
98
99 # Needed before new field
100 [ 'convertArchive2' ],
101
102 # new fields
103 [ 'addPgField', 'updatelog', 'ul_value', 'TEXT' ],
104 [ 'addPgField', 'archive', 'ar_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
105 [ 'addPgField', 'archive', 'ar_len', 'INTEGER' ],
106 [ 'addPgField', 'archive', 'ar_page_id', 'INTEGER' ],
107 [ 'addPgField', 'archive', 'ar_parent_id', 'INTEGER' ],
108 [ 'addPgField', 'archive', 'ar_content_model', 'TEXT' ],
109 [ 'addPgField', 'archive', 'ar_content_format', 'TEXT' ],
110 [ 'addPgField', 'categorylinks', 'cl_sortkey_prefix', "TEXT NOT NULL DEFAULT ''" ],
111 [ 'addPgField', 'categorylinks', 'cl_collation', "TEXT NOT NULL DEFAULT 0" ],
112 [ 'addPgField', 'categorylinks', 'cl_type', "TEXT NOT NULL DEFAULT 'page'" ],
113 [ 'addPgField', 'image', 'img_sha1', "TEXT NOT NULL DEFAULT ''" ],
114 [ 'addPgField', 'ipblocks', 'ipb_allow_usertalk', 'SMALLINT NOT NULL DEFAULT 0' ],
115 [ 'addPgField', 'ipblocks', 'ipb_anon_only', 'SMALLINT NOT NULL DEFAULT 0' ],
116 [ 'addPgField', 'ipblocks', 'ipb_by_text', "TEXT NOT NULL DEFAULT ''" ],
117 [ 'addPgField', 'ipblocks', 'ipb_block_email', 'SMALLINT NOT NULL DEFAULT 0' ],
118 [ 'addPgField', 'ipblocks', 'ipb_create_account', 'SMALLINT NOT NULL DEFAULT 1' ],
119 [ 'addPgField', 'ipblocks', 'ipb_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
120 [ 'addPgField', 'ipblocks', 'ipb_enable_autoblock', 'SMALLINT NOT NULL DEFAULT 1' ],
121 [ 'addPgField', 'ipblocks', 'ipb_parent_block_id',
122 'INTEGER DEFAULT NULL REFERENCES ipblocks(ipb_id) ' .
123 'ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED' ],
124 [ 'addPgField', 'filearchive', 'fa_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
125 [ 'addPgField', 'filearchive', 'fa_sha1', "TEXT NOT NULL DEFAULT ''" ],
126 [ 'addPgField', 'logging', 'log_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
127 [ 'addPgField', 'logging', 'log_id',
128 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('logging_log_id_seq')" ],
129 [ 'addPgField', 'logging', 'log_params', 'TEXT' ],
130 [ 'addPgField', 'mwuser', 'user_editcount', 'INTEGER' ],
131 [ 'addPgField', 'mwuser', 'user_newpass_time', 'TIMESTAMPTZ' ],
132 [ 'addPgField', 'oldimage', 'oi_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
133 [ 'addPgField', 'oldimage', 'oi_major_mime', "TEXT NOT NULL DEFAULT 'unknown'" ],
134 [ 'addPgField', 'oldimage', 'oi_media_type', 'TEXT' ],
135 [ 'addPgField', 'oldimage', 'oi_metadata', "BYTEA NOT NULL DEFAULT ''" ],
136 [ 'addPgField', 'oldimage', 'oi_minor_mime', "TEXT NOT NULL DEFAULT 'unknown'" ],
137 [ 'addPgField', 'oldimage', 'oi_sha1', "TEXT NOT NULL DEFAULT ''" ],
138 [ 'addPgField', 'page', 'page_content_model', 'TEXT' ],
139 [ 'addPgField', 'page_restrictions', 'pr_id',
140 "INTEGER NOT NULL UNIQUE DEFAULT nextval('page_restrictions_pr_id_seq')" ],
141 [ 'addPgField', 'profiling', 'pf_memory', 'NUMERIC(18,10) NOT NULL DEFAULT 0' ],
142 [ 'addPgField', 'recentchanges', 'rc_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
143 [ 'addPgField', 'recentchanges', 'rc_log_action', 'TEXT' ],
144 [ 'addPgField', 'recentchanges', 'rc_log_type', 'TEXT' ],
145 [ 'addPgField', 'recentchanges', 'rc_logid', 'INTEGER NOT NULL DEFAULT 0' ],
146 [ 'addPgField', 'recentchanges', 'rc_new_len', 'INTEGER' ],
147 [ 'addPgField', 'recentchanges', 'rc_old_len', 'INTEGER' ],
148 [ 'addPgField', 'recentchanges', 'rc_params', 'TEXT' ],
149 [ 'addPgField', 'redirect', 'rd_interwiki', 'TEXT NULL' ],
150 [ 'addPgField', 'redirect', 'rd_fragment', 'TEXT NULL' ],
151 [ 'addPgField', 'revision', 'rev_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
152 [ 'addPgField', 'revision', 'rev_len', 'INTEGER' ],
153 [ 'addPgField', 'revision', 'rev_parent_id', 'INTEGER DEFAULT NULL' ],
154 [ 'addPgField', 'revision', 'rev_content_model', 'TEXT' ],
155 [ 'addPgField', 'revision', 'rev_content_format', 'TEXT' ],
156 [ 'addPgField', 'site_stats', 'ss_active_users', "INTEGER DEFAULT '-1'" ],
157 [ 'addPgField', 'user_newtalk', 'user_last_timestamp', 'TIMESTAMPTZ' ],
158 [ 'addPgField', 'logging', 'log_user_text', "TEXT NOT NULL DEFAULT ''" ],
159 [ 'addPgField', 'logging', 'log_page', 'INTEGER' ],
160 [ 'addPgField', 'interwiki', 'iw_api', "TEXT NOT NULL DEFAULT ''" ],
161 [ 'addPgField', 'interwiki', 'iw_wikiid', "TEXT NOT NULL DEFAULT ''" ],
162 [ 'addPgField', 'revision', 'rev_sha1', "TEXT NOT NULL DEFAULT ''" ],
163 [ 'addPgField', 'archive', 'ar_sha1', "TEXT NOT NULL DEFAULT ''" ],
164 [ 'addPgField', 'uploadstash', 'us_chunk_inx', "INTEGER NULL" ],
165 [ 'addPgField', 'job', 'job_timestamp', "TIMESTAMPTZ" ],
166 [ 'addPgField', 'job', 'job_random', "INTEGER NOT NULL DEFAULT 0" ],
167 [ 'addPgField', 'job', 'job_attempts', "INTEGER NOT NULL DEFAULT 0" ],
168 [ 'addPgField', 'job', 'job_token', "TEXT NOT NULL DEFAULT ''" ],
169 [ 'addPgField', 'job', 'job_token_timestamp', "TIMESTAMPTZ" ],
170 [ 'addPgField', 'job', 'job_sha1', "TEXT NOT NULL DEFAULT ''" ],
171 [ 'addPgField', 'archive', 'ar_id',
172 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('archive_ar_id_seq')" ],
173 [ 'addPgField', 'externallinks', 'el_id',
174 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('externallinks_el_id_seq')" ],
175 [ 'addPgField', 'uploadstash', 'us_props', "BYTEA" ],
176
177 # type changes
178 [ 'changeField', 'archive', 'ar_deleted', 'smallint', '' ],
179 [ 'changeField', 'archive', 'ar_minor_edit', 'smallint',
180 'ar_minor_edit::smallint DEFAULT 0' ],
181 [ 'changeField', 'filearchive', 'fa_deleted', 'smallint', '' ],
182 [ 'changeField', 'filearchive', 'fa_height', 'integer', '' ],
183 [ 'changeField', 'filearchive', 'fa_metadata', 'bytea', "decode(fa_metadata,'escape')" ],
184 [ 'changeField', 'filearchive', 'fa_size', 'integer', '' ],
185 [ 'changeField', 'filearchive', 'fa_width', 'integer', '' ],
186 [ 'changeField', 'filearchive', 'fa_storage_group', 'text', '' ],
187 [ 'changeField', 'filearchive', 'fa_storage_key', 'text', '' ],
188 [ 'changeField', 'image', 'img_metadata', 'bytea', "decode(img_metadata,'escape')" ],
189 [ 'changeField', 'image', 'img_size', 'integer', '' ],
190 [ 'changeField', 'image', 'img_width', 'integer', '' ],
191 [ 'changeField', 'image', 'img_height', 'integer', '' ],
192 [ 'changeField', 'interwiki', 'iw_local', 'smallint', 'iw_local::smallint' ],
193 [ 'changeField', 'interwiki', 'iw_trans', 'smallint', 'iw_trans::smallint DEFAULT 0' ],
194 [ 'changeField', 'ipblocks', 'ipb_auto', 'smallint', 'ipb_auto::smallint DEFAULT 0' ],
195 [ 'changeField', 'ipblocks', 'ipb_anon_only', 'smallint',
196 "CASE WHEN ipb_anon_only=' ' THEN 0 ELSE ipb_anon_only::smallint END DEFAULT 0" ],
197 [ 'changeField', 'ipblocks', 'ipb_create_account', 'smallint',
198 "CASE WHEN ipb_create_account=' ' THEN 0 ELSE ipb_create_account::smallint END DEFAULT 1" ],
199 [ 'changeField', 'ipblocks', 'ipb_enable_autoblock', 'smallint',
200 "CASE WHEN ipb_enable_autoblock=' ' THEN 0 ELSE ipb_enable_autoblock::smallint END DEFAULT 1" ],
201 [ 'changeField', 'ipblocks', 'ipb_block_email', 'smallint',
202 "CASE WHEN ipb_block_email=' ' THEN 0 ELSE ipb_block_email::smallint END DEFAULT 0" ],
203 [ 'changeField', 'ipblocks', 'ipb_address', 'text', 'ipb_address::text' ],
204 [ 'changeField', 'ipblocks', 'ipb_deleted', 'smallint', 'ipb_deleted::smallint DEFAULT 0' ],
205 [ 'changeField', 'mwuser', 'user_token', 'text', '' ],
206 [ 'changeField', 'mwuser', 'user_email_token', 'text', '' ],
207 [ 'changeField', 'objectcache', 'keyname', 'text', '' ],
208 [ 'changeField', 'oldimage', 'oi_height', 'integer', '' ],
209 [ 'changeField', 'oldimage', 'oi_metadata', 'bytea', "decode(img_metadata,'escape')" ],
210 [ 'changeField', 'oldimage', 'oi_size', 'integer', '' ],
211 [ 'changeField', 'oldimage', 'oi_width', 'integer', '' ],
212 [ 'changeField', 'page', 'page_is_redirect', 'smallint',
213 'page_is_redirect::smallint DEFAULT 0' ],
214 [ 'changeField', 'page', 'page_is_new', 'smallint', 'page_is_new::smallint DEFAULT 0' ],
215 [ 'changeField', 'querycache', 'qc_value', 'integer', '' ],
216 [ 'changeField', 'querycachetwo', 'qcc_value', 'integer', '' ],
217 [ 'changeField', 'recentchanges', 'rc_bot', 'smallint', 'rc_bot::smallint DEFAULT 0' ],
218 [ 'changeField', 'recentchanges', 'rc_deleted', 'smallint', '' ],
219 [ 'changeField', 'recentchanges', 'rc_minor', 'smallint', 'rc_minor::smallint DEFAULT 0' ],
220 [ 'changeField', 'recentchanges', 'rc_new', 'smallint', 'rc_new::smallint DEFAULT 0' ],
221 [ 'changeField', 'recentchanges', 'rc_type', 'smallint', 'rc_type::smallint DEFAULT 0' ],
222 [ 'changeField', 'recentchanges', 'rc_patrolled', 'smallint',
223 'rc_patrolled::smallint DEFAULT 0' ],
224 [ 'changeField', 'revision', 'rev_deleted', 'smallint', 'rev_deleted::smallint DEFAULT 0' ],
225 [ 'changeField', 'revision', 'rev_minor_edit', 'smallint',
226 'rev_minor_edit::smallint DEFAULT 0' ],
227 [ 'changeField', 'templatelinks', 'tl_namespace', 'smallint', 'tl_namespace::smallint' ],
228 [ 'changeField', 'user_newtalk', 'user_ip', 'text', 'host(user_ip)' ],
229 [ 'changeField', 'uploadstash', 'us_image_bits', 'smallint', '' ],
230 [ 'changeField', 'profiling', 'pf_time', 'float', '' ],
231 [ 'changeField', 'profiling', 'pf_memory', 'float', '' ],
232
233 # null changes
234 [ 'changeNullableField', 'oldimage', 'oi_bits', 'NULL' ],
235 [ 'changeNullableField', 'oldimage', 'oi_timestamp', 'NULL' ],
236 [ 'changeNullableField', 'oldimage', 'oi_major_mime', 'NULL' ],
237 [ 'changeNullableField', 'oldimage', 'oi_minor_mime', 'NULL' ],
238 [ 'changeNullableField', 'image', 'img_metadata', 'NOT NULL' ],
239 [ 'changeNullableField', 'filearchive', 'fa_metadata', 'NOT NULL' ],
240 [ 'changeNullableField', 'recentchanges', 'rc_cur_id', 'NULL' ],
241 [ 'changeNullableField', 'recentchanges', 'rc_cur_time', 'NULL' ],
242
243 [ 'checkOiDeleted' ],
244
245 # New indexes
246 [ 'addPgIndex', 'archive', 'archive_user_text', '(ar_user_text)' ],
247 [ 'addPgIndex', 'image', 'img_sha1', '(img_sha1)' ],
248 [ 'addPgIndex', 'ipblocks', 'ipb_parent_block_id', '(ipb_parent_block_id)' ],
249 [ 'addPgIndex', 'oldimage', 'oi_sha1', '(oi_sha1)' ],
250 [ 'addPgIndex', 'page', 'page_mediawiki_title', '(page_title) WHERE page_namespace = 8' ],
251 [ 'addPgIndex', 'pagelinks', 'pagelinks_title', '(pl_title)' ],
252 [ 'addPgIndex', 'page_props', 'pp_propname_page', '(pp_propname, pp_page)' ],
253 [ 'addPgIndex', 'revision', 'rev_text_id_idx', '(rev_text_id)' ],
254 [ 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ],
255 [ 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ],
256 [ 'addPgIndex', 'watchlist', 'wl_user', '(wl_user)' ],
257 [ 'addPgIndex', 'watchlist', 'wl_user_notificationtimestamp',
258 '(wl_user, wl_notificationtimestamp)' ],
259 [ 'addPgIndex', 'logging', 'logging_user_type_time',
260 '(log_user, log_type, log_timestamp)' ],
261 [ 'addPgIndex', 'logging', 'logging_page_id_time', '(log_page,log_timestamp)' ],
262 [ 'addPgIndex', 'iwlinks', 'iwl_prefix_from_title', '(iwl_prefix, iwl_from, iwl_title)' ],
263 [ 'addPgIndex', 'iwlinks', 'iwl_prefix_title_from', '(iwl_prefix, iwl_title, iwl_from)' ],
264 [ 'addPgIndex', 'job', 'job_timestamp_idx', '(job_timestamp)' ],
265 [ 'addPgIndex', 'job', 'job_sha1', '(job_sha1)' ],
266 [ 'addPgIndex', 'job', 'job_cmd_token', '(job_cmd, job_token, job_random)' ],
267 [ 'addPgIndex', 'job', 'job_cmd_token_id', '(job_cmd, job_token, job_id)' ],
268 [ 'addPgIndex', 'filearchive', 'fa_sha1', '(fa_sha1)' ],
269 [ 'addPgIndex', 'logging', 'logging_user_text_type_time',
270 '(log_user_text, log_type, log_timestamp)' ],
271 [ 'addPgIndex', 'logging', 'logging_user_text_time', '(log_user_text, log_timestamp)' ],
272
273 [ 'checkIndex', 'pagelink_unique', [
274 [ 'pl_from', 'int4_ops', 'btree', 0 ],
275 [ 'pl_namespace', 'int2_ops', 'btree', 0 ],
276 [ 'pl_title', 'text_ops', 'btree', 0 ],
277 ],
278 'CREATE UNIQUE INDEX pagelink_unique ON pagelinks (pl_from,pl_namespace,pl_title)' ],
279 [ 'checkIndex', 'cl_sortkey', [
280 [ 'cl_to', 'text_ops', 'btree', 0 ],
281 [ 'cl_sortkey', 'text_ops', 'btree', 0 ],
282 [ 'cl_from', 'int4_ops', 'btree', 0 ],
283 ],
284 'CREATE INDEX cl_sortkey ON "categorylinks" ' .
285 'USING "btree" ("cl_to", "cl_sortkey", "cl_from")' ],
286 [ 'checkIndex', 'iwl_prefix_title_from', [
287 [ 'iwl_prefix', 'text_ops', 'btree', 0 ],
288 [ 'iwl_title', 'text_ops', 'btree', 0 ],
289 [ 'iwl_from', 'int4_ops', 'btree', 0 ],
290 ],
291 'CREATE INDEX iwl_prefix_title_from ON "iwlinks" ' .
292 'USING "btree" ("iwl_prefix", "iwl_title", "iwl_from")' ],
293 [ 'checkIndex', 'logging_times', [
294 [ 'log_timestamp', 'timestamptz_ops', 'btree', 0 ],
295 ],
296 'CREATE INDEX "logging_times" ON "logging" USING "btree" ("log_timestamp")' ],
297 [ 'dropIndex', 'oldimage', 'oi_name' ],
298 [ 'checkIndex', 'oi_name_archive_name', [
299 [ 'oi_name', 'text_ops', 'btree', 0 ],
300 [ 'oi_archive_name', 'text_ops', 'btree', 0 ],
301 ],
302 'CREATE INDEX "oi_name_archive_name" ON "oldimage" ' .
303 'USING "btree" ("oi_name", "oi_archive_name")' ],
304 [ 'checkIndex', 'oi_name_timestamp', [
305 [ 'oi_name', 'text_ops', 'btree', 0 ],
306 [ 'oi_timestamp', 'timestamptz_ops', 'btree', 0 ],
307 ],
308 'CREATE INDEX "oi_name_timestamp" ON "oldimage" ' .
309 'USING "btree" ("oi_name", "oi_timestamp")' ],
310 [ 'checkIndex', 'page_main_title', [
311 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
312 ],
313 'CREATE INDEX "page_main_title" ON "page" ' .
314 'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 0)' ],
315 [ 'checkIndex', 'page_mediawiki_title', [
316 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
317 ],
318 'CREATE INDEX "page_mediawiki_title" ON "page" ' .
319 'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 8)' ],
320 [ 'checkIndex', 'page_project_title', [
321 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
322 ],
323 'CREATE INDEX "page_project_title" ON "page" ' .
324 'USING "btree" ("page_title" "text_pattern_ops") ' .
325 'WHERE ("page_namespace" = 4)' ],
326 [ 'checkIndex', 'page_talk_title', [
327 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
328 ],
329 'CREATE INDEX "page_talk_title" ON "page" ' .
330 'USING "btree" ("page_title" "text_pattern_ops") ' .
331 'WHERE ("page_namespace" = 1)' ],
332 [ 'checkIndex', 'page_user_title', [
333 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
334 ],
335 'CREATE INDEX "page_user_title" ON "page" ' .
336 'USING "btree" ("page_title" "text_pattern_ops") WHERE ' .
337 '("page_namespace" = 2)' ],
338 [ 'checkIndex', 'page_utalk_title', [
339 [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
340 ],
341 'CREATE INDEX "page_utalk_title" ON "page" ' .
342 'USING "btree" ("page_title" "text_pattern_ops") ' .
343 'WHERE ("page_namespace" = 3)' ],
344 [ 'checkIndex', 'ts2_page_text', [
345 [ 'textvector', 'tsvector_ops', 'gist', 0 ],
346 ],
347 'CREATE INDEX "ts2_page_text" ON "pagecontent" USING "gist" ("textvector")' ],
348 [ 'checkIndex', 'ts2_page_title', [
349 [ 'titlevector', 'tsvector_ops', 'gist', 0 ],
350 ],
351 'CREATE INDEX "ts2_page_title" ON "page" USING "gist" ("titlevector")' ],
352
353 [ 'checkOiNameConstraint' ],
354 [ 'checkPageDeletedTrigger' ],
355 [ 'checkRevUserFkey' ],
356 [ 'dropIndex', 'ipblocks', 'ipb_address' ],
357 [ 'checkIndex', 'ipb_address_unique', [
358 [ 'ipb_address', 'text_ops', 'btree', 0 ],
359 [ 'ipb_user', 'int4_ops', 'btree', 0 ],
360 [ 'ipb_auto', 'int2_ops', 'btree', 0 ],
361 [ 'ipb_anon_only', 'int2_ops', 'btree', 0 ],
362 ],
363 'CREATE UNIQUE INDEX ipb_address_unique ' .
364 'ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only)' ],
365
366 [ 'checkIwlPrefix' ],
367
368 # All FK columns should be deferred
369 [ 'changeFkeyDeferrable', 'archive', 'ar_user', 'mwuser(user_id) ON DELETE SET NULL' ],
370 [ 'changeFkeyDeferrable', 'categorylinks', 'cl_from', 'page(page_id) ON DELETE CASCADE' ],
371 [ 'changeFkeyDeferrable', 'externallinks', 'el_from', 'page(page_id) ON DELETE CASCADE' ],
372 [ 'changeFkeyDeferrable', 'filearchive', 'fa_deleted_user',
373 'mwuser(user_id) ON DELETE SET NULL' ],
374 [ 'changeFkeyDeferrable', 'filearchive', 'fa_user', 'mwuser(user_id) ON DELETE SET NULL' ],
375 [ 'changeFkeyDeferrable', 'image', 'img_user', 'mwuser(user_id) ON DELETE SET NULL' ],
376 [ 'changeFkeyDeferrable', 'imagelinks', 'il_from', 'page(page_id) ON DELETE CASCADE' ],
377 [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_by', 'mwuser(user_id) ON DELETE CASCADE' ],
378 [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_user', 'mwuser(user_id) ON DELETE SET NULL' ],
379 [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_parent_block_id',
380 'ipblocks(ipb_id) ON DELETE SET NULL' ],
381 [ 'changeFkeyDeferrable', 'langlinks', 'll_from', 'page(page_id) ON DELETE CASCADE' ],
382 [ 'changeFkeyDeferrable', 'logging', 'log_user', 'mwuser(user_id) ON DELETE SET NULL' ],
383 [ 'changeFkeyDeferrable', 'oldimage', 'oi_name',
384 'image(img_name) ON DELETE CASCADE ON UPDATE CASCADE' ],
385 [ 'changeFkeyDeferrable', 'oldimage', 'oi_user', 'mwuser(user_id) ON DELETE SET NULL' ],
386 [ 'changeFkeyDeferrable', 'pagelinks', 'pl_from', 'page(page_id) ON DELETE CASCADE' ],
387 [ 'changeFkeyDeferrable', 'page_props', 'pp_page', 'page (page_id) ON DELETE CASCADE' ],
388 [ 'changeFkeyDeferrable', 'page_restrictions', 'pr_page',
389 'page(page_id) ON DELETE CASCADE' ],
390 [ 'changeFkeyDeferrable', 'protected_titles', 'pt_user',
391 'mwuser(user_id) ON DELETE SET NULL' ],
392 [ 'changeFkeyDeferrable', 'recentchanges', 'rc_user',
393 'mwuser(user_id) ON DELETE SET NULL' ],
394 [ 'changeFkeyDeferrable', 'redirect', 'rd_from', 'page(page_id) ON DELETE CASCADE' ],
395 [ 'changeFkeyDeferrable', 'revision', 'rev_page', 'page (page_id) ON DELETE CASCADE' ],
396 [ 'changeFkeyDeferrable', 'revision', 'rev_user', 'mwuser(user_id) ON DELETE RESTRICT' ],
397 [ 'changeFkeyDeferrable', 'templatelinks', 'tl_from', 'page(page_id) ON DELETE CASCADE' ],
398 [ 'changeFkeyDeferrable', 'user_groups', 'ug_user', 'mwuser(user_id) ON DELETE CASCADE' ],
399 [ 'changeFkeyDeferrable', 'user_newtalk', 'user_id', 'mwuser(user_id) ON DELETE CASCADE' ],
400 [ 'changeFkeyDeferrable', 'user_properties', 'up_user',
401 'mwuser(user_id) ON DELETE CASCADE' ],
402 [ 'changeFkeyDeferrable', 'watchlist', 'wl_user', 'mwuser(user_id) ON DELETE CASCADE' ],
403
404 # r81574
405 [ 'addInterwikiType' ],
406 # end
407 [ 'tsearchFixes' ],
408
409 // 1.23
410 [ 'addPgField', 'recentchanges', 'rc_source', "TEXT NOT NULL DEFAULT ''" ],
411 [ 'addPgField', 'page', 'page_links_updated', "TIMESTAMPTZ NULL" ],
412 [ 'addPgField', 'mwuser', 'user_password_expires', 'TIMESTAMPTZ NULL' ],
413 [ 'changeFieldPurgeTable', 'l10n_cache', 'lc_value', 'bytea',
414 "replace(lc_value,'\','\\\\')::bytea" ],
415 // 1.23.9
416 [ 'rebuildTextSearch' ],
417
418 // 1.24
419 [ 'addPgField', 'page_props', 'pp_sortkey', 'float NULL' ],
420 [ 'addPgIndex', 'page_props', 'pp_propname_sortkey_page',
421 '( pp_propname, pp_sortkey, pp_page ) WHERE ( pp_sortkey IS NOT NULL )' ],
422 [ 'addPgField', 'page', 'page_lang', 'TEXT default NULL' ],
423 [ 'addPgField', 'pagelinks', 'pl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
424 [ 'addPgField', 'templatelinks', 'tl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
425 [ 'addPgField', 'imagelinks', 'il_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
426
427 // 1.25
428 [ 'dropTable', 'hitcounter' ],
429 [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
430 [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
431 [ 'dropFkey', 'recentchanges', 'rc_cur_id' ],
432
433 // 1.27
434 [ 'dropTable', 'msg_resource_links' ],
435 [ 'dropTable', 'msg_resource' ],
436 [
437 'addPgField', 'watchlist', 'wl_id',
438 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('watchlist_wl_id_seq')"
439 ],
440
441 // 1.28
442 [ 'addPgIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
443 '( rc_namespace, rc_type, rc_patrolled, rc_timestamp )' ],
444 [ 'addPgField', 'change_tag', 'ct_id',
445 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('change_tag_ct_id_seq')" ],
446 [ 'addPgField', 'tag_summary', 'ts_id',
447 "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('tag_summary_ts_id_seq')" ],
448
449 // 1.29
450 [ 'addPgField', 'externallinks', 'el_index_60', "BYTEA NOT NULL DEFAULT ''" ],
451 [ 'addPgIndex', 'externallinks', 'el_index_60', '( el_index_60, el_id )' ],
452 [ 'addPgIndex', 'externallinks', 'el_from_index_60', '( el_from, el_index_60, el_id )' ],
453 [ 'addPgField', 'user_groups', 'ug_expiry', "TIMESTAMPTZ NULL" ],
454 [ 'addPgIndex', 'user_groups', 'user_groups_expiry', '( ug_expiry )' ],
455
456 // 1.30
457 [ 'addPgEnumValue', 'media_type', '3D' ],
458 [ 'setDefault', 'revision', 'rev_comment', '' ],
459 [ 'changeNullableField', 'revision', 'rev_comment', 'NOT NULL', true ],
460 [ 'setDefault', 'archive', 'ar_comment', '' ],
461 [ 'changeNullableField', 'archive', 'ar_comment', 'NOT NULL', true ],
462 [ 'addPgField', 'archive', 'ar_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
463 [ 'setDefault', 'ipblocks', 'ipb_reason', '' ],
464 [ 'addPgField', 'ipblocks', 'ipb_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
465 [ 'setDefault', 'image', 'img_description', '' ],
466 [ 'setDefault', 'oldimage', 'oi_description', '' ],
467 [ 'changeNullableField', 'oldimage', 'oi_description', 'NOT NULL', true ],
468 [ 'addPgField', 'oldimage', 'oi_description_id', 'INTEGER NOT NULL DEFAULT 0' ],
469 [ 'setDefault', 'filearchive', 'fa_deleted_reason', '' ],
470 [ 'changeNullableField', 'filearchive', 'fa_deleted_reason', 'NOT NULL', true ],
471 [ 'addPgField', 'filearchive', 'fa_deleted_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
472 [ 'setDefault', 'filearchive', 'fa_description', '' ],
473 [ 'addPgField', 'filearchive', 'fa_description_id', 'INTEGER NOT NULL DEFAULT 0' ],
474 [ 'setDefault', 'recentchanges', 'rc_comment', '' ],
475 [ 'changeNullableField', 'recentchanges', 'rc_comment', 'NOT NULL', true ],
476 [ 'addPgField', 'recentchanges', 'rc_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
477 [ 'setDefault', 'logging', 'log_comment', '' ],
478 [ 'changeNullableField', 'logging', 'log_comment', 'NOT NULL', true ],
479 [ 'addPgField', 'logging', 'log_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
480 [ 'setDefault', 'protected_titles', 'pt_reason', '' ],
481 [ 'changeNullableField', 'protected_titles', 'pt_reason', 'NOT NULL', true ],
482 [ 'addPgField', 'protected_titles', 'pt_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
483 [ 'addTable', 'comment', 'patch-comment-table.sql' ],
484 [ 'addIndex', 'site_stats', 'site_stats_pkey', 'patch-site_stats-pk.sql' ],
485 [ 'addTable', 'ip_changes', 'patch-ip_changes.sql' ],
486 ];
487 }
488
489 protected function getOldGlobalUpdates() {
490 global $wgExtNewTables, $wgExtPGNewFields, $wgExtPGAlteredFields, $wgExtNewIndexes;
491
492 $updates = [];
493
494 # Add missing extension tables
495 foreach ( $wgExtNewTables as $tableRecord ) {
496 $updates[] = [
497 'addTable', $tableRecord[0], $tableRecord[1], true
498 ];
499 }
500
501 # Add missing extension fields
502 foreach ( $wgExtPGNewFields as $fieldRecord ) {
503 $updates[] = [
504 'addPgField', $fieldRecord[0], $fieldRecord[1],
505 $fieldRecord[2]
506 ];
507 }
508
509 # Change altered columns
510 foreach ( $wgExtPGAlteredFields as $fieldRecord ) {
511 $updates[] = [
512 'changeField', $fieldRecord[0], $fieldRecord[1],
513 $fieldRecord[2]
514 ];
515 }
516
517 # Add missing extension indexes
518 foreach ( $wgExtNewIndexes as $fieldRecord ) {
519 $updates[] = [
520 'addPgExtIndex', $fieldRecord[0], $fieldRecord[1],
521 $fieldRecord[2]
522 ];
523 }
524
525 return $updates;
526 }
527
528 protected function describeTable( $table ) {
529 $q = <<<END
530SELECT attname, attnum FROM pg_namespace, pg_class, pg_attribute
531 WHERE pg_class.relnamespace = pg_namespace.oid
532 AND attrelid=pg_class.oid AND attnum > 0
533 AND relname=%s AND nspname=%s
534END;
535 $res = $this->db->query( sprintf( $q,
536 $this->db->addQuotes( $table ),
537 $this->db->addQuotes( $this->db->getCoreSchema() ) ) );
538 if ( !$res ) {
539 return null;
540 }
541
542 $cols = [];
543 foreach ( $res as $r ) {
544 $cols[] = [
545 "name" => $r[0],
546 "ord" => $r[1],
547 ];
548 }
549
550 return $cols;
551 }
552
553 function describeIndex( $idx ) {
554 // first fetch the key (which is a list of columns ords) and
555 // the table the index applies to (an oid)
556 $q = <<<END
557SELECT indkey, indrelid FROM pg_namespace, pg_class, pg_index
558 WHERE nspname=%s
559 AND pg_class.relnamespace = pg_namespace.oid
560 AND relname=%s
561 AND indexrelid=pg_class.oid
562END;
563 $res = $this->db->query(
564 sprintf(
565 $q,
566 $this->db->addQuotes( $this->db->getCoreSchema() ),
567 $this->db->addQuotes( $idx )
568 )
569 );
570 if ( !$res ) {
571 return null;
572 }
573 $r = $this->db->fetchRow( $res );
574 if ( !$r ) {
575 return null;
576 }
577
578 $indkey = $r[0];
579 $relid = intval( $r[1] );
580 $indkeys = explode( ' ', $indkey );
581
582 $colnames = [];
583 foreach ( $indkeys as $rid ) {
584 $query = <<<END
585SELECT attname FROM pg_class, pg_attribute
586 WHERE attrelid=$relid
587 AND attnum=%d
588 AND attrelid=pg_class.oid
589END;
590 $r2 = $this->db->query( sprintf( $query, $rid ) );
591 if ( !$r2 ) {
592 return null;
593 }
594 $row2 = $this->db->fetchRow( $r2 );
595 if ( !$row2 ) {
596 return null;
597 }
598 $colnames[] = $row2[0];
599 }
600
601 return $colnames;
602 }
603
604 function fkeyDeltype( $fkey ) {
605 $q = <<<END
606SELECT confdeltype FROM pg_constraint, pg_namespace
607 WHERE connamespace=pg_namespace.oid
608 AND nspname=%s
609 AND conname=%s;
610END;
611 $r = $this->db->query(
612 sprintf(
613 $q,
614 $this->db->addQuotes( $this->db->getCoreSchema() ),
615 $this->db->addQuotes( $fkey )
616 )
617 );
618 $row = $this->db->fetchRow( $r );
619 if ( !$row ) {
620 return null;
621 }
622
623 return $row[0];
624 }
625
626 function ruleDef( $table, $rule ) {
627 $q = <<<END
628SELECT definition FROM pg_rules
629 WHERE schemaname = %s
630 AND tablename = %s
631 AND rulename = %s
632END;
633 $r = $this->db->query(
634 sprintf(
635 $q,
636 $this->db->addQuotes( $this->db->getCoreSchema() ),
637 $this->db->addQuotes( $table ),
638 $this->db->addQuotes( $rule )
639 )
640 );
641 $row = $this->db->fetchRow( $r );
642 if ( !$row ) {
643 return null;
644 }
645 $d = $row[0];
646
647 return $d;
648 }
649
650 protected function addSequence( $table, $pkey, $ns ) {
651 if ( !$this->db->sequenceExists( $ns ) ) {
652 $this->output( "Creating sequence $ns\n" );
653 $this->db->query( "CREATE SEQUENCE $ns" );
654 if ( $pkey !== false ) {
655 $this->setDefault( $table, $pkey, '"nextval"(\'"' . $ns . '"\'::"regclass")' );
656 }
657 }
658 }
659
660 protected function renameSequence( $old, $new ) {
661 if ( $this->db->sequenceExists( $new ) ) {
662 $this->output( "...sequence $new already exists.\n" );
663
664 return;
665 }
666 if ( $this->db->sequenceExists( $old ) ) {
667 $this->output( "Renaming sequence $old to $new\n" );
668 $this->db->query( "ALTER SEQUENCE $old RENAME TO $new" );
669 }
670 }
671
672 protected function renameTable( $old, $new, $patch = false ) {
673 if ( $this->db->tableExists( $old ) ) {
674 $this->output( "Renaming table $old to $new\n" );
675 $old = $this->db->realTableName( $old, "quoted" );
676 $new = $this->db->realTableName( $new, "quoted" );
677 $this->db->query( "ALTER TABLE $old RENAME TO $new" );
678 if ( $patch !== false ) {
679 $this->applyPatch( $patch );
680 }
681 }
682 }
683
684 protected function renameIndex(
685 $table, $old, $new, $skipBothIndexExistWarning = false, $a = false, $b = false
686 ) {
687 // First requirement: the table must exist
688 if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
689 $this->output( "...skipping: '$table' table doesn't exist yet.\n" );
690
691 return;
692 }
693
694 // Second requirement: the new index must be missing
695 if ( $this->db->indexExists( $table, $new, __METHOD__ ) ) {
696 $this->output( "...index $new already set on $table table.\n" );
697 if ( !$skipBothIndexExistWarning
698 && $this->db->indexExists( $table, $old, __METHOD__ )
699 ) {
700 $this->output( "...WARNING: $old still exists, despite it has been " .
701 "renamed into $new (which also exists).\n" .
702 " $old should be manually removed if not needed anymore.\n" );
703 }
704
705 return;
706 }
707
708 // Third requirement: the old index must exist
709 if ( !$this->db->indexExists( $table, $old, __METHOD__ ) ) {
710 $this->output( "...skipping: index $old doesn't exist.\n" );
711
712 return;
713 }
714
715 $this->db->query( "ALTER INDEX $old RENAME TO $new" );
716 }
717
718 protected function addPgField( $table, $field, $type ) {
719 $fi = $this->db->fieldInfo( $table, $field );
720 if ( !is_null( $fi ) ) {
721 $this->output( "...column '$table.$field' already exists\n" );
722
723 return;
724 } else {
725 $this->output( "Adding column '$table.$field'\n" );
726 $this->db->query( "ALTER TABLE $table ADD $field $type" );
727 }
728 }
729
730 protected function changeField( $table, $field, $newtype, $default ) {
731 $fi = $this->db->fieldInfo( $table, $field );
732 if ( is_null( $fi ) ) {
733 $this->output( "...ERROR: expected column $table.$field to exist\n" );
734 exit( 1 );
735 }
736
737 if ( $fi->type() === $newtype ) {
738 $this->output( "...column '$table.$field' is already of type '$newtype'\n" );
739 } else {
740 $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" );
741 $sql = "ALTER TABLE $table ALTER $field TYPE $newtype";
742 if ( strlen( $default ) ) {
743 $res = [];
744 if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) {
745 $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]";
746 $this->db->query( $sqldef );
747 $default = preg_replace( '/\s*DEFAULT .+/', '', $default );
748 }
749 $sql .= " USING $default";
750 }
751 $this->db->query( $sql );
752 }
753 }
754
755 protected function changeFieldPurgeTable( $table, $field, $newtype, $default ) {
756 # # For a cache table, empty it if the field needs to be changed, because the old contents
757 # # may be corrupted. If the column is already the desired type, refrain from purging.
758 $fi = $this->db->fieldInfo( $table, $field );
759 if ( is_null( $fi ) ) {
760 $this->output( "...ERROR: expected column $table.$field to exist\n" );
761 exit( 1 );
762 }
763
764 if ( $fi->type() === $newtype ) {
765 $this->output( "...column '$table.$field' is already of type '$newtype'\n" );
766 } else {
767 $this->output( "Purging data from cache table '$table'\n" );
768 $this->db->query( "DELETE from $table" );
769 $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" );
770 $sql = "ALTER TABLE $table ALTER $field TYPE $newtype";
771 if ( strlen( $default ) ) {
772 $res = [];
773 if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) {
774 $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]";
775 $this->db->query( $sqldef );
776 $default = preg_replace( '/\s*DEFAULT .+/', '', $default );
777 }
778 $sql .= " USING $default";
779 }
780 $this->db->query( $sql );
781 }
782 }
783
784 protected function setDefault( $table, $field, $default ) {
785 $info = $this->db->fieldInfo( $table, $field );
786 if ( $info->defaultValue() !== $default ) {
787 $this->output( "Changing '$table.$field' default value\n" );
788 $this->db->query( "ALTER TABLE $table ALTER $field SET DEFAULT "
789 . $this->db->addQuotes( $default ) );
790 }
791 }
792
793 protected function changeNullableField( $table, $field, $null, $update = false ) {
794 $fi = $this->db->fieldInfo( $table, $field );
795 if ( is_null( $fi ) ) {
796 $this->output( "...ERROR: expected column $table.$field to exist\n" );
797 exit( 1 );
798 }
799 if ( $fi->isNullable() ) {
800 # # It's NULL - does it need to be NOT NULL?
801 if ( 'NOT NULL' === $null ) {
802 $this->output( "Changing '$table.$field' to not allow NULLs\n" );
803 if ( $update ) {
804 $this->db->query( "UPDATE $table SET $field = DEFAULT WHERE $field IS NULL" );
805 }
806 $this->db->query( "ALTER TABLE $table ALTER $field SET NOT NULL" );
807 } else {
808 $this->output( "...column '$table.$field' is already set as NULL\n" );
809 }
810 } else {
811 # # It's NOT NULL - does it need to be NULL?
812 if ( 'NULL' === $null ) {
813 $this->output( "Changing '$table.$field' to allow NULLs\n" );
814 $this->db->query( "ALTER TABLE $table ALTER $field DROP NOT NULL" );
815 } else {
816 $this->output( "...column '$table.$field' is already set as NOT NULL\n" );
817 }
818 }
819 }
820
821 public function addPgIndex( $table, $index, $type ) {
822 if ( $this->db->indexExists( $table, $index ) ) {
823 $this->output( "...index '$index' on table '$table' already exists\n" );
824 } else {
825 $this->output( "Creating index '$index' on table '$table' $type\n" );
826 $this->db->query( "CREATE INDEX $index ON $table $type" );
827 }
828 }
829
830 public function addPgExtIndex( $table, $index, $type ) {
831 if ( $this->db->indexExists( $table, $index ) ) {
832 $this->output( "...index '$index' on table '$table' already exists\n" );
833 } else {
834 if ( preg_match( '/^\‍(/', $type ) ) {
835 $this->output( "Creating index '$index' on table '$table'\n" );
836 $this->db->query( "CREATE INDEX $index ON $table $type" );
837 } else {
838 $this->applyPatch( $type, true, "Creating index '$index' on table '$table'" );
839 }
840 }
841 }
842
849 public function addPgEnumValue( $type, $value ) {
850 $row = $this->db->selectRow(
851 [
852 't' => 'pg_catalog.pg_type',
853 'n' => 'pg_catalog.pg_namespace',
854 'e' => 'pg_catalog.pg_enum',
855 ],
856 [ 't.typname', 't.typtype', 'e.enumlabel' ],
857 [
858 't.typname' => $type,
859 'n.nspname' => $this->db->getCoreSchema(),
860 ],
861 __METHOD__,
862 [],
863 [
864 'n' => [ 'JOIN', 't.typnamespace = n.oid' ],
865 'e' => [ 'LEFT JOIN', [ 'e.enumtypid = t.oid', 'e.enumlabel' => $value ] ],
866 ]
867 );
868
869 if ( !$row ) {
870 $this->output( "...Type $type does not exist, skipping modify enum.\n" );
871 } elseif ( $row->typtype !== 'e' ) {
872 $this->output( "...Type $type does not seem to be an enum, skipping modify enum.\n" );
873 } elseif ( $row->enumlabel === $value ) {
874 $this->output( "...Enum type $type already contains value '$value'.\n" );
875 } else {
876 $this->output( "...Adding value '$value' to enum type $type.\n" );
877 $etype = $this->db->addIdentifierQuotes( $type );
878 $evalue = $this->db->addQuotes( $value );
879 $this->db->query( "ALTER TYPE $etype ADD VALUE $evalue" );
880 }
881 }
882
883 protected function dropFkey( $table, $field ) {
884 $fi = $this->db->fieldInfo( $table, $field );
885 if ( is_null( $fi ) ) {
886 $this->output( "WARNING! Column '$table.$field' does not exist but it should! " .
887 "Please report this.\n" );
888 return;
889 }
890 $conname = $fi->conname();
891 if ( $fi->conname() ) {
892 $this->output( "Dropping foreign key constraint on '$table.$field'\n" );
893 $conclause = "CONSTRAINT \"$conname\"";
894 $command = "ALTER TABLE $table DROP CONSTRAINT $conname";
895 $this->db->query( $command );
896 } else {
897 $this->output( "...foreign key constraint on '$table.$field' already does not exist\n" );
898 };
899 }
900
901 protected function changeFkeyDeferrable( $table, $field, $clause ) {
902 $fi = $this->db->fieldInfo( $table, $field );
903 if ( is_null( $fi ) ) {
904 $this->output( "WARNING! Column '$table.$field' does not exist but it should! " .
905 "Please report this.\n" );
906
907 return;
908 }
909 if ( $fi->is_deferred() && $fi->is_deferrable() ) {
910 return;
911 }
912 $this->output( "Altering column '$table.$field' to be DEFERRABLE INITIALLY DEFERRED\n" );
913 $conname = $fi->conname();
914 if ( $fi->conname() ) {
915 $conclause = "CONSTRAINT \"$conname\"";
916 $command = "ALTER TABLE $table DROP CONSTRAINT $conname";
917 $this->db->query( $command );
918 } else {
919 $this->output( "Column '$table.$field' does not have a foreign key " .
920 "constraint, will be added\n" );
921 $conclause = "";
922 }
923 $command =
924 "ALTER TABLE $table ADD $conclause " .
925 "FOREIGN KEY ($field) REFERENCES $clause DEFERRABLE INITIALLY DEFERRED";
926 $this->db->query( $command );
927 }
928
929 protected function convertArchive2() {
930 if ( $this->db->tableExists( "archive2" ) ) {
931 if ( $this->db->ruleExists( 'archive', 'archive_insert' ) ) {
932 $this->output( "Dropping rule 'archive_insert'\n" );
933 $this->db->query( 'DROP RULE archive_insert ON archive' );
934 }
935 if ( $this->db->ruleExists( 'archive', 'archive_delete' ) ) {
936 $this->output( "Dropping rule 'archive_delete'\n" );
937 $this->db->query( 'DROP RULE archive_delete ON archive' );
938 }
939 $this->applyPatch(
940 'patch-remove-archive2.sql',
941 false,
942 "Converting 'archive2' back to normal archive table"
943 );
944 } else {
945 $this->output( "...obsolete table 'archive2' does not exist\n" );
946 }
947 }
948
949 protected function checkOiDeleted() {
950 if ( $this->db->fieldInfo( 'oldimage', 'oi_deleted' )->type() !== 'smallint' ) {
951 $this->output( "Changing 'oldimage.oi_deleted' to type 'smallint'\n" );
952 $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted DROP DEFAULT" );
953 $this->db->query(
954 "ALTER TABLE oldimage ALTER oi_deleted TYPE SMALLINT USING (oi_deleted::smallint)" );
955 $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted SET DEFAULT 0" );
956 } else {
957 $this->output( "...column 'oldimage.oi_deleted' is already of type 'smallint'\n" );
958 }
959 }
960
961 protected function checkOiNameConstraint() {
962 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascaded" ) ) {
963 $this->output( "...table 'oldimage' has correct cascading delete/update " .
964 "foreign key to image\n" );
965 } else {
966 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey" ) ) {
967 $this->db->query(
968 "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey" );
969 }
970 if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascade" ) ) {
971 $this->db->query(
972 "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey_cascade" );
973 }
974 $this->output( "Making foreign key on table 'oldimage' (to image) a cascade delete/update\n" );
975 $this->db->query(
976 "ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascaded " .
977 "FOREIGN KEY (oi_name) REFERENCES image(img_name) " .
978 "ON DELETE CASCADE ON UPDATE CASCADE" );
979 }
980 }
981
982 protected function checkPageDeletedTrigger() {
983 if ( !$this->db->triggerExists( 'page', 'page_deleted' ) ) {
984 $this->applyPatch(
985 'patch-page_deleted.sql',
986 false,
987 "Adding function and trigger 'page_deleted' to table 'page'"
988 );
989 } else {
990 $this->output( "...table 'page' has 'page_deleted' trigger\n" );
991 }
992 }
993
994 protected function dropIndex( $table, $index, $patch = '', $fullpath = false ) {
995 if ( $this->db->indexExists( $table, $index ) ) {
996 $this->output( "Dropping obsolete index '$index'\n" );
997 $this->db->query( "DROP INDEX \"" . $index . "\"" );
998 }
999 }
1000
1001 protected function checkIndex( $index, $should_be, $good_def ) {
1002 $pu = $this->db->indexAttributes( $index );
1003 if ( !empty( $pu ) && $pu != $should_be ) {
1004 $this->output( "Dropping obsolete version of index '$index'\n" );
1005 $this->db->query( "DROP INDEX \"" . $index . "\"" );
1006 $pu = [];
1007 } else {
1008 $this->output( "...no need to drop index '$index'\n" );
1009 }
1010
1011 if ( empty( $pu ) ) {
1012 $this->output( "Creating index '$index'\n" );
1013 $this->db->query( $good_def );
1014 } else {
1015 $this->output( "...index '$index' exists\n" );
1016 }
1017 }
1018
1019 protected function checkRevUserFkey() {
1020 if ( $this->fkeyDeltype( 'revision_rev_user_fkey' ) == 'r' ) {
1021 $this->output( "...constraint 'revision_rev_user_fkey' is ON DELETE RESTRICT\n" );
1022 } else {
1023 $this->applyPatch(
1024 'patch-revision_rev_user_fkey.sql',
1025 false,
1026 "Changing constraint 'revision_rev_user_fkey' to ON DELETE RESTRICT"
1027 );
1028 }
1029 }
1030
1031 protected function checkIwlPrefix() {
1032 if ( $this->db->indexExists( 'iwlinks', 'iwl_prefix' ) ) {
1033 $this->applyPatch(
1034 'patch-rename-iwl_prefix.sql',
1035 false,
1036 "Replacing index 'iwl_prefix' with 'iwl_prefix_title_from'"
1037 );
1038 }
1039 }
1040
1041 protected function addInterwikiType() {
1042 $this->applyPatch( 'patch-add_interwiki.sql', false, "Refreshing add_interwiki()" );
1043 }
1044
1045 protected function tsearchFixes() {
1046 # Tweak the page_title tsearch2 trigger to filter out slashes
1047 # This is create or replace, so harmless to call if not needed
1048 $this->applyPatch( 'patch-ts2pagetitle.sql', false, "Refreshing ts2_page_title()" );
1049
1050 # If the server is 8.3 or higher, rewrite the tsearch2 triggers
1051 # in case they have the old 'default' versions
1052 # Gather version numbers in case we need them
1053 if ( $this->db->getServerVersion() >= 8.3 ) {
1054 $this->applyPatch( 'patch-tsearch2funcs.sql', false, "Rewriting tsearch2 triggers" );
1055 }
1056 }
1057
1058 protected function rebuildTextSearch() {
1059 if ( $this->updateRowExists( 'patch-textsearch_bug66650.sql' ) ) {
1060 $this->output( "...T68650 already fixed or not applicable.\n" );
1061 return;
1062 };
1063 $this->applyPatch( 'patch-textsearch_bug66650.sql', false,
1064 'Rebuilding text search for T68650' );
1065 }
1066}
definition
Apache License January AND DISTRIBUTION Definitions License shall mean the terms and conditions for and distribution as defined by Sections through of this document Licensor shall mean the copyright owner or entity authorized by the copyright owner that is granting the License Legal Entity shall mean the union of the acting entity and all other entities that control are controlled by or are under common control with that entity For the purposes of this definition control direct or to cause the direction or management of such whether by contract or including but not limited to software source documentation and configuration files Object form shall mean any form resulting from mechanical transformation or translation of a Source including but not limited to compiled object generated and conversions to other media types Work shall mean the work of whether in Source or Object made available under the as indicated by a copyright notice that is included in or attached to the whether in Source or Object that is based or other modifications as a an original work of authorship For the purposes of this Derivative Works shall not include works that remain separable or merely the Work and Derivative Works thereof Contribution shall mean any work of including the original version of the Work and any modifications or additions to that Work or Derivative Works that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner For the purposes of this definition
Definition APACHE-LICENSE-2.0.txt:54
use
Apache License January AND DISTRIBUTION Definitions License shall mean the terms and conditions for use
Definition APACHE-LICENSE-2.0.txt:10
$command
$command
Definition cdb.php:64
DatabaseUpdater
Class for handling database updates.
Definition DatabaseUpdater.php:36
DatabaseUpdater\$updates
array $updates
Array of updates to perform on the database.
Definition DatabaseUpdater.php:42
DatabaseUpdater\updateRowExists
updateRowExists( $key)
Helper function: check if the given key is present in the updatelog table.
Definition DatabaseUpdater.php:492
DatabaseUpdater\applyPatch
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Definition DatabaseUpdater.php:655
PostgresUpdater
Class for handling updates to Postgres databases.
Definition PostgresUpdater.php:32
PostgresUpdater\changeNullableField
changeNullableField( $table, $field, $null, $update=false)
Definition PostgresUpdater.php:793
PostgresUpdater\changeField
changeField( $table, $field, $newtype, $default)
Definition PostgresUpdater.php:730
PostgresUpdater\renameTable
renameTable( $old, $new, $patch=false)
Definition PostgresUpdater.php:672
PostgresUpdater\renameIndex
renameIndex( $table, $old, $new, $skipBothIndexExistWarning=false, $a=false, $b=false)
Rename an index from an existing table.
Definition PostgresUpdater.php:684
PostgresUpdater\ruleDef
ruleDef( $table, $rule)
Definition PostgresUpdater.php:626
PostgresUpdater\addPgExtIndex
addPgExtIndex( $table, $index, $type)
Definition PostgresUpdater.php:830
PostgresUpdater\addSequence
addSequence( $table, $pkey, $ns)
Definition PostgresUpdater.php:650
PostgresUpdater\addPgEnumValue
addPgEnumValue( $type, $value)
Add a value to an existing PostgreSQL enum type.
Definition PostgresUpdater.php:849
PostgresUpdater\getOldGlobalUpdates
getOldGlobalUpdates()
Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes.
Definition PostgresUpdater.php:489
PostgresUpdater\renameSequence
renameSequence( $old, $new)
Definition PostgresUpdater.php:660
PostgresUpdater\setDefault
setDefault( $table, $field, $default)
Definition PostgresUpdater.php:784
PostgresUpdater\$db
DatabasePostgres $db
Definition PostgresUpdater.php:37
PostgresUpdater\addPgField
addPgField( $table, $field, $type)
Definition PostgresUpdater.php:718
PostgresUpdater\dropIndex
dropIndex( $table, $index, $patch='', $fullpath=false)
Drop an index from an existing table.
Definition PostgresUpdater.php:994
PostgresUpdater\dropFkey
dropFkey( $table, $field)
Definition PostgresUpdater.php:883
PostgresUpdater\changeFkeyDeferrable
changeFkeyDeferrable( $table, $field, $clause)
Definition PostgresUpdater.php:901
PostgresUpdater\checkIndex
checkIndex( $index, $should_be, $good_def)
Definition PostgresUpdater.php:1001
PostgresUpdater\changeFieldPurgeTable
changeFieldPurgeTable( $table, $field, $newtype, $default)
Definition PostgresUpdater.php:755
PostgresUpdater\addPgIndex
addPgIndex( $table, $index, $type)
Definition PostgresUpdater.php:821
$res
$res
Definition database.txt:21
output
design txt This is a brief overview of the new design More thorough and up to date information is available on the documentation wiki at etc Handles the details of getting and saving to the user table of the and dealing with sessions and cookies OutputPage Encapsulates the entire HTML page that will be sent in response to any server request It is used by calling its functions to add in any and then calling output() to send it all. It could be easily changed to send incrementally if that becomes useful
global
when a variable name is used in a it is silently declared as a new local masking the global
Definition design.txt:95
as
This document is intended to provide useful advice for parties seeking to redistribute MediaWiki to end users It s targeted particularly at maintainers for Linux since it s been observed that distribution packages of MediaWiki often break We ve consistently had to recommend that users seeking support use official tarballs instead of their distribution s and this often solves whatever problem the user is having It would be nice if this could such as
Definition distributors.txt:22
true
null means default in associative array with keys and values unescaped Should be merged with default with a value of false meaning to suppress the attribute in associative array with keys and values unescaped noclasses just before the function returns a value If you return true
Definition hooks.txt:1976
$query
null for the local wiki Added should default to null in handler for backwards compatibility add a value to it if you want to add a cookie that have to vary cache options can modify $query
Definition hooks.txt:1610
FROM
as see the revision history and available at free of to any person obtaining a copy of this software and associated documentation to deal in the Software without including without limitation the rights to and or sell copies of the and to permit persons to whom the Software is furnished to do subject to the following WITHOUT WARRANTY OF ANY EXPRESS OR INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY DAMAGES OR OTHER WHETHER IN AN ACTION OF TORT OR ARISING FROM
Definition LICENSE.txt:24
php
injection txt This is an overview of how MediaWiki makes use of dependency injection The design described here grew from the discussion of RFC T384 The term dependency this means that anything an object needs to operate should be injected from the the object itself should only know narrow no concrete implementation of the logic it relies on The requirement to inject everything typically results in an architecture that based on two main types of and essentially stateless service objects that use other service objects to operate on the value objects As of the beginning MediaWiki is only starting to use the DI approach Much of the code still relies on global state or direct resulting in a highly cyclical dependency which acts as the top level factory for services in MediaWiki which can be used to gain access to default instances of various services MediaWikiServices however also allows new services to be defined and default services to be redefined Services are defined or redefined by providing a callback the instantiator that will return a new instance of the service When it will create an instance of MediaWikiServices and populate it with the services defined in the files listed by thereby bootstrapping the DI framework Per $wgServiceWiringFiles lists includes ServiceWiring php
Definition injection.txt:37