MediaWiki  1.33.1
PostgresUpdater.php
Go to the documentation of this file.
1 <?php
24 use Wikimedia\Rdbms\DatabasePostgres;
25 
32 class 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 
75  # new tables
76  [ 'addTable', 'category', 'patch-category.sql' ],
77  [ 'addTable', 'page', 'patch-page.sql' ],
78  [ 'addTable', 'querycachetwo', 'patch-querycachetwo.sql' ],
79  [ 'addTable', 'page_props', 'patch-page_props.sql' ],
80  [ 'addTable', 'page_restrictions', 'patch-page_restrictions.sql' ],
81  [ 'addTable', 'profiling', 'patch-profiling.sql' ],
82  [ 'addTable', 'protected_titles', 'patch-protected_titles.sql' ],
83  [ 'addTable', 'redirect', 'patch-redirect.sql' ],
84  [ 'addTable', 'updatelog', 'patch-updatelog.sql' ],
85  [ 'addTable', 'change_tag', 'patch-change_tag.sql' ],
86  [ 'addTable', 'user_properties', 'patch-user_properties.sql' ],
87  [ 'addTable', 'log_search', 'patch-log_search.sql' ],
88  [ 'addTable', 'l10n_cache', 'patch-l10n_cache.sql' ],
89  [ 'addTable', 'iwlinks', 'patch-iwlinks.sql' ],
90  [ 'addTable', 'module_deps', 'patch-module_deps.sql' ],
91  [ 'addTable', 'uploadstash', 'patch-uploadstash.sql' ],
92  [ 'addTable', 'user_former_groups', 'patch-user_former_groups.sql' ],
93  [ 'addTable', 'sites', 'patch-sites.sql' ],
94  [ 'addTable', 'bot_passwords', 'patch-bot_passwords.sql' ],
95 
96  # Needed before new field
97  [ 'convertArchive2' ],
98 
99  # new fields
100  [ 'addPgField', 'updatelog', 'ul_value', 'TEXT' ],
101  [ 'addPgField', 'archive', 'ar_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
102  [ 'addPgField', 'archive', 'ar_len', 'INTEGER' ],
103  [ 'addPgField', 'archive', 'ar_page_id', 'INTEGER' ],
104  [ 'addPgField', 'archive', 'ar_parent_id', 'INTEGER' ],
105  [ 'addPgField', 'archive', 'ar_content_model', 'TEXT' ],
106  [ 'addPgField', 'archive', 'ar_content_format', 'TEXT' ],
107  [ 'addPgField', 'categorylinks', 'cl_sortkey_prefix', "TEXT NOT NULL DEFAULT ''" ],
108  [ 'addPgField', 'categorylinks', 'cl_collation', "TEXT NOT NULL DEFAULT 0" ],
109  [ 'addPgField', 'categorylinks', 'cl_type', "TEXT NOT NULL DEFAULT 'page'" ],
110  [ 'addPgField', 'image', 'img_sha1', "TEXT NOT NULL DEFAULT ''" ],
111  [ 'addPgField', 'ipblocks', 'ipb_allow_usertalk', 'SMALLINT NOT NULL DEFAULT 0' ],
112  [ 'addPgField', 'ipblocks', 'ipb_anon_only', 'SMALLINT NOT NULL DEFAULT 0' ],
113  [ 'addPgField', 'ipblocks', 'ipb_by_text', "TEXT NOT NULL DEFAULT ''" ],
114  [ 'addPgField', 'ipblocks', 'ipb_block_email', 'SMALLINT NOT NULL DEFAULT 0' ],
115  [ 'addPgField', 'ipblocks', 'ipb_create_account', 'SMALLINT NOT NULL DEFAULT 1' ],
116  [ 'addPgField', 'ipblocks', 'ipb_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
117  [ 'addPgField', 'ipblocks', 'ipb_enable_autoblock', 'SMALLINT NOT NULL DEFAULT 1' ],
118  [ 'addPgField', 'ipblocks', 'ipb_parent_block_id',
119  'INTEGER DEFAULT NULL REFERENCES ipblocks(ipb_id) ' .
120  'ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED' ],
121  [ 'addPgField', 'filearchive', 'fa_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
122  [ 'addPgField', 'filearchive', 'fa_sha1', "TEXT NOT NULL DEFAULT ''" ],
123  [ 'addPgField', 'logging', 'log_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
124  [ 'addPgField', 'logging', 'log_id',
125  "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('logging_log_id_seq')" ],
126  [ 'addPgField', 'logging', 'log_params', 'TEXT' ],
127  [ 'addPgField', 'mwuser', 'user_editcount', 'INTEGER' ],
128  [ 'addPgField', 'mwuser', 'user_newpass_time', 'TIMESTAMPTZ' ],
129  [ 'addPgField', 'oldimage', 'oi_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
130  [ 'addPgField', 'oldimage', 'oi_major_mime', "TEXT NOT NULL DEFAULT 'unknown'" ],
131  [ 'addPgField', 'oldimage', 'oi_media_type', 'TEXT' ],
132  [ 'addPgField', 'oldimage', 'oi_metadata', "BYTEA NOT NULL DEFAULT ''" ],
133  [ 'addPgField', 'oldimage', 'oi_minor_mime', "TEXT NOT NULL DEFAULT 'unknown'" ],
134  [ 'addPgField', 'oldimage', 'oi_sha1', "TEXT NOT NULL DEFAULT ''" ],
135  [ 'addPgField', 'page', 'page_content_model', 'TEXT' ],
136  [ 'addPgField', 'page_restrictions', 'pr_id',
137  "INTEGER NOT NULL UNIQUE DEFAULT nextval('page_restrictions_pr_id_seq')" ],
138  [ 'addPgField', 'profiling', 'pf_memory', 'NUMERIC(18,10) NOT NULL DEFAULT 0' ],
139  [ 'addPgField', 'recentchanges', 'rc_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
140  [ 'addPgField', 'recentchanges', 'rc_log_action', 'TEXT' ],
141  [ 'addPgField', 'recentchanges', 'rc_log_type', 'TEXT' ],
142  [ 'addPgField', 'recentchanges', 'rc_logid', 'INTEGER NOT NULL DEFAULT 0' ],
143  [ 'addPgField', 'recentchanges', 'rc_new_len', 'INTEGER' ],
144  [ 'addPgField', 'recentchanges', 'rc_old_len', 'INTEGER' ],
145  [ 'addPgField', 'recentchanges', 'rc_params', 'TEXT' ],
146  [ 'addPgField', 'redirect', 'rd_interwiki', 'TEXT NULL' ],
147  [ 'addPgField', 'redirect', 'rd_fragment', 'TEXT NULL' ],
148  [ 'addPgField', 'revision', 'rev_deleted', 'SMALLINT NOT NULL DEFAULT 0' ],
149  [ 'addPgField', 'revision', 'rev_len', 'INTEGER' ],
150  [ 'addPgField', 'revision', 'rev_parent_id', 'INTEGER DEFAULT NULL' ],
151  [ 'addPgField', 'revision', 'rev_content_model', 'TEXT' ],
152  [ 'addPgField', 'revision', 'rev_content_format', 'TEXT' ],
153  [ 'addPgField', 'site_stats', 'ss_active_users', "INTEGER DEFAULT '-1'" ],
154  [ 'addPgField', 'user_newtalk', 'user_last_timestamp', 'TIMESTAMPTZ' ],
155  [ 'addPgField', 'logging', 'log_user_text', "TEXT NOT NULL DEFAULT ''" ],
156  [ 'addPgField', 'logging', 'log_page', 'INTEGER' ],
157  [ 'addPgField', 'interwiki', 'iw_api', "TEXT NOT NULL DEFAULT ''" ],
158  [ 'addPgField', 'interwiki', 'iw_wikiid', "TEXT NOT NULL DEFAULT ''" ],
159  [ 'addPgField', 'revision', 'rev_sha1', "TEXT NOT NULL DEFAULT ''" ],
160  [ 'addPgField', 'archive', 'ar_sha1', "TEXT NOT NULL DEFAULT ''" ],
161  [ 'addPgField', 'uploadstash', 'us_chunk_inx', "INTEGER NULL" ],
162  [ 'addPgField', 'job', 'job_timestamp', "TIMESTAMPTZ" ],
163  [ 'addPgField', 'job', 'job_random', "INTEGER NOT NULL DEFAULT 0" ],
164  [ 'addPgField', 'job', 'job_attempts', "INTEGER NOT NULL DEFAULT 0" ],
165  [ 'addPgField', 'job', 'job_token', "TEXT NOT NULL DEFAULT ''" ],
166  [ 'addPgField', 'job', 'job_token_timestamp', "TIMESTAMPTZ" ],
167  [ 'addPgField', 'job', 'job_sha1', "TEXT NOT NULL DEFAULT ''" ],
168  [ 'addPgField', 'archive', 'ar_id',
169  "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('archive_ar_id_seq')" ],
170  [ 'addPgField', 'externallinks', 'el_id',
171  "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('externallinks_el_id_seq')" ],
172  [ 'addPgField', 'uploadstash', 'us_props', "BYTEA" ],
173 
174  # type changes
175  [ 'changeField', 'archive', 'ar_deleted', 'smallint', '' ],
176  [ 'changeField', 'archive', 'ar_minor_edit', 'smallint',
177  'ar_minor_edit::smallint DEFAULT 0' ],
178  [ 'changeField', 'filearchive', 'fa_deleted', 'smallint', '' ],
179  [ 'changeField', 'filearchive', 'fa_height', 'integer', '' ],
180  [ 'changeField', 'filearchive', 'fa_metadata', 'bytea', "decode(fa_metadata,'escape')" ],
181  [ 'changeField', 'filearchive', 'fa_size', 'integer', '' ],
182  [ 'changeField', 'filearchive', 'fa_width', 'integer', '' ],
183  [ 'changeField', 'filearchive', 'fa_storage_group', 'text', '' ],
184  [ 'changeField', 'filearchive', 'fa_storage_key', 'text', '' ],
185  [ 'changeField', 'image', 'img_metadata', 'bytea', "decode(img_metadata,'escape')" ],
186  [ 'changeField', 'image', 'img_size', 'integer', '' ],
187  [ 'changeField', 'image', 'img_width', 'integer', '' ],
188  [ 'changeField', 'image', 'img_height', 'integer', '' ],
189  [ 'changeField', 'interwiki', 'iw_local', 'smallint', 'iw_local::smallint' ],
190  [ 'changeField', 'interwiki', 'iw_trans', 'smallint', 'iw_trans::smallint DEFAULT 0' ],
191  [ 'changeField', 'ipblocks', 'ipb_auto', 'smallint', 'ipb_auto::smallint DEFAULT 0' ],
192  [ 'changeField', 'ipblocks', 'ipb_anon_only', 'smallint',
193  "CASE WHEN ipb_anon_only=' ' THEN 0 ELSE ipb_anon_only::smallint END DEFAULT 0" ],
194  [ 'changeField', 'ipblocks', 'ipb_create_account', 'smallint',
195  "CASE WHEN ipb_create_account=' ' THEN 0 ELSE ipb_create_account::smallint END DEFAULT 1" ],
196  [ 'changeField', 'ipblocks', 'ipb_enable_autoblock', 'smallint',
197  "CASE WHEN ipb_enable_autoblock=' ' THEN 0 ELSE ipb_enable_autoblock::smallint END DEFAULT 1" ],
198  [ 'changeField', 'ipblocks', 'ipb_block_email', 'smallint',
199  "CASE WHEN ipb_block_email=' ' THEN 0 ELSE ipb_block_email::smallint END DEFAULT 0" ],
200  [ 'changeField', 'ipblocks', 'ipb_address', 'text', 'ipb_address::text' ],
201  [ 'changeField', 'ipblocks', 'ipb_deleted', 'smallint', 'ipb_deleted::smallint DEFAULT 0' ],
202  [ 'changeField', 'mwuser', 'user_token', 'text', '' ],
203  [ 'changeField', 'mwuser', 'user_email_token', 'text', '' ],
204  [ 'changeField', 'objectcache', 'keyname', 'text', '' ],
205  [ 'changeField', 'oldimage', 'oi_height', 'integer', '' ],
206  [ 'changeField', 'oldimage', 'oi_metadata', 'bytea', "decode(img_metadata,'escape')" ],
207  [ 'changeField', 'oldimage', 'oi_size', 'integer', '' ],
208  [ 'changeField', 'oldimage', 'oi_width', 'integer', '' ],
209  [ 'changeField', 'page', 'page_is_redirect', 'smallint',
210  'page_is_redirect::smallint DEFAULT 0' ],
211  [ 'changeField', 'page', 'page_is_new', 'smallint', 'page_is_new::smallint DEFAULT 0' ],
212  [ 'changeField', 'querycache', 'qc_value', 'integer', '' ],
213  [ 'changeField', 'querycachetwo', 'qcc_value', 'integer', '' ],
214  [ 'changeField', 'recentchanges', 'rc_bot', 'smallint', 'rc_bot::smallint DEFAULT 0' ],
215  [ 'changeField', 'recentchanges', 'rc_deleted', 'smallint', '' ],
216  [ 'changeField', 'recentchanges', 'rc_minor', 'smallint', 'rc_minor::smallint DEFAULT 0' ],
217  [ 'changeField', 'recentchanges', 'rc_new', 'smallint', 'rc_new::smallint DEFAULT 0' ],
218  [ 'changeField', 'recentchanges', 'rc_type', 'smallint', 'rc_type::smallint DEFAULT 0' ],
219  [ 'changeField', 'recentchanges', 'rc_patrolled', 'smallint',
220  'rc_patrolled::smallint DEFAULT 0' ],
221  [ 'changeField', 'revision', 'rev_deleted', 'smallint', 'rev_deleted::smallint DEFAULT 0' ],
222  [ 'changeField', 'revision', 'rev_minor_edit', 'smallint',
223  'rev_minor_edit::smallint DEFAULT 0' ],
224  [ 'changeField', 'templatelinks', 'tl_namespace', 'smallint', 'tl_namespace::smallint' ],
225  [ 'changeField', 'user_newtalk', 'user_ip', 'text', 'host(user_ip)' ],
226  [ 'changeField', 'uploadstash', 'us_image_bits', 'smallint', '' ],
227  [ 'changeField', 'profiling', 'pf_time', 'float', '' ],
228  [ 'changeField', 'profiling', 'pf_memory', 'float', '' ],
229 
230  # null changes
231  [ 'changeNullableField', 'oldimage', 'oi_bits', 'NULL' ],
232  [ 'changeNullableField', 'oldimage', 'oi_timestamp', 'NULL' ],
233  [ 'changeNullableField', 'oldimage', 'oi_major_mime', 'NULL' ],
234  [ 'changeNullableField', 'oldimage', 'oi_minor_mime', 'NULL' ],
235  [ 'changeNullableField', 'image', 'img_metadata', 'NOT NULL' ],
236  [ 'changeNullableField', 'filearchive', 'fa_metadata', 'NOT NULL' ],
237  [ 'changeNullableField', 'recentchanges', 'rc_cur_id', 'NULL' ],
238  [ 'changeNullableField', 'recentchanges', 'rc_cur_time', 'NULL' ],
239 
240  [ 'checkOiDeleted' ],
241 
242  # New indexes
243  [ 'addPgIndex', 'archive', 'archive_user_text', '(ar_user_text)' ],
244  [ 'addPgIndex', 'image', 'img_sha1', '(img_sha1)' ],
245  [ 'addPgIndex', 'ipblocks', 'ipb_parent_block_id', '(ipb_parent_block_id)' ],
246  [ 'addPgIndex', 'oldimage', 'oi_sha1', '(oi_sha1)' ],
247  [ 'addPgIndex', 'page', 'page_mediawiki_title', '(page_title) WHERE page_namespace = 8' ],
248  [ 'addPgIndex', 'pagelinks', 'pagelinks_title', '(pl_title)' ],
249  [ 'addPgIndex', 'page_props', 'pp_propname_page', '(pp_propname, pp_page)' ],
250  [ 'addPgIndex', 'revision', 'rev_text_id_idx', '(rev_text_id)' ],
251  [ 'addPgIndex', 'recentchanges', 'rc_timestamp_bot', '(rc_timestamp) WHERE rc_bot = 0' ],
252  [ 'addPgIndex', 'templatelinks', 'templatelinks_from', '(tl_from)' ],
253  [ 'addPgIndex', 'watchlist', 'wl_user', '(wl_user)' ],
254  [ 'addPgIndex', 'watchlist', 'wl_user_notificationtimestamp',
255  '(wl_user, wl_notificationtimestamp)' ],
256  [ 'addPgIndex', 'logging', 'logging_user_type_time',
257  '(log_user, log_type, log_timestamp)' ],
258  [ 'addPgIndex', 'logging', 'logging_page_id_time', '(log_page,log_timestamp)' ],
259  [ 'addPgIndex', 'iwlinks', 'iwl_prefix_from_title', '(iwl_prefix, iwl_from, iwl_title)' ],
260  [ 'addPgIndex', 'iwlinks', 'iwl_prefix_title_from', '(iwl_prefix, iwl_title, iwl_from)' ],
261  [ 'addPgIndex', 'job', 'job_timestamp_idx', '(job_timestamp)' ],
262  [ 'addPgIndex', 'job', 'job_sha1', '(job_sha1)' ],
263  [ 'addPgIndex', 'job', 'job_cmd_token', '(job_cmd, job_token, job_random)' ],
264  [ 'addPgIndex', 'job', 'job_cmd_token_id', '(job_cmd, job_token, job_id)' ],
265  [ 'addPgIndex', 'filearchive', 'fa_sha1', '(fa_sha1)' ],
266  [ 'addPgIndex', 'logging', 'logging_user_text_type_time',
267  '(log_user_text, log_type, log_timestamp)' ],
268  [ 'addPgIndex', 'logging', 'logging_user_text_time', '(log_user_text, log_timestamp)' ],
269 
270  [ 'checkIndex', 'pagelink_unique', [
271  [ 'pl_from', 'int4_ops', 'btree', 0 ],
272  [ 'pl_namespace', 'int2_ops', 'btree', 0 ],
273  [ 'pl_title', 'text_ops', 'btree', 0 ],
274  ],
275  'CREATE UNIQUE INDEX pagelink_unique ON pagelinks (pl_from,pl_namespace,pl_title)' ],
276  [ 'checkIndex', 'cl_sortkey', [
277  [ 'cl_to', 'text_ops', 'btree', 0 ],
278  [ 'cl_sortkey', 'text_ops', 'btree', 0 ],
279  [ 'cl_from', 'int4_ops', 'btree', 0 ],
280  ],
281  'CREATE INDEX cl_sortkey ON "categorylinks" ' .
282  'USING "btree" ("cl_to", "cl_sortkey", "cl_from")' ],
283  [ 'checkIndex', 'iwl_prefix_title_from', [
284  [ 'iwl_prefix', 'text_ops', 'btree', 0 ],
285  [ 'iwl_title', 'text_ops', 'btree', 0 ],
286  [ 'iwl_from', 'int4_ops', 'btree', 0 ],
287  ],
288  'CREATE INDEX iwl_prefix_title_from ON "iwlinks" ' .
289  'USING "btree" ("iwl_prefix", "iwl_title", "iwl_from")' ],
290  [ 'checkIndex', 'logging_times', [
291  [ 'log_timestamp', 'timestamptz_ops', 'btree', 0 ],
292  ],
293  'CREATE INDEX "logging_times" ON "logging" USING "btree" ("log_timestamp")' ],
294  [ 'dropPgIndex', 'oldimage', 'oi_name' ],
295  [ 'checkIndex', 'oi_name_archive_name', [
296  [ 'oi_name', 'text_ops', 'btree', 0 ],
297  [ 'oi_archive_name', 'text_ops', 'btree', 0 ],
298  ],
299  'CREATE INDEX "oi_name_archive_name" ON "oldimage" ' .
300  'USING "btree" ("oi_name", "oi_archive_name")' ],
301  [ 'checkIndex', 'oi_name_timestamp', [
302  [ 'oi_name', 'text_ops', 'btree', 0 ],
303  [ 'oi_timestamp', 'timestamptz_ops', 'btree', 0 ],
304  ],
305  'CREATE INDEX "oi_name_timestamp" ON "oldimage" ' .
306  'USING "btree" ("oi_name", "oi_timestamp")' ],
307  [ 'checkIndex', 'page_main_title', [
308  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
309  ],
310  'CREATE INDEX "page_main_title" ON "page" ' .
311  'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 0)' ],
312  [ 'checkIndex', 'page_mediawiki_title', [
313  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
314  ],
315  'CREATE INDEX "page_mediawiki_title" ON "page" ' .
316  'USING "btree" ("page_title" "text_pattern_ops") WHERE ("page_namespace" = 8)' ],
317  [ 'checkIndex', 'page_project_title', [
318  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
319  ],
320  'CREATE INDEX "page_project_title" ON "page" ' .
321  'USING "btree" ("page_title" "text_pattern_ops") ' .
322  'WHERE ("page_namespace" = 4)' ],
323  [ 'checkIndex', 'page_talk_title', [
324  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
325  ],
326  'CREATE INDEX "page_talk_title" ON "page" ' .
327  'USING "btree" ("page_title" "text_pattern_ops") ' .
328  'WHERE ("page_namespace" = 1)' ],
329  [ 'checkIndex', 'page_user_title', [
330  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
331  ],
332  'CREATE INDEX "page_user_title" ON "page" ' .
333  'USING "btree" ("page_title" "text_pattern_ops") WHERE ' .
334  '("page_namespace" = 2)' ],
335  [ 'checkIndex', 'page_utalk_title', [
336  [ 'page_title', 'text_pattern_ops', 'btree', 0 ],
337  ],
338  'CREATE INDEX "page_utalk_title" ON "page" ' .
339  'USING "btree" ("page_title" "text_pattern_ops") ' .
340  'WHERE ("page_namespace" = 3)' ],
341  [ 'checkIndex', 'ts2_page_text', [
342  [ 'textvector', 'tsvector_ops', 'gist', 0 ],
343  ],
344  'CREATE INDEX "ts2_page_text" ON "pagecontent" USING "gist" ("textvector")' ],
345  [ 'checkIndex', 'ts2_page_title', [
346  [ 'titlevector', 'tsvector_ops', 'gist', 0 ],
347  ],
348  'CREATE INDEX "ts2_page_title" ON "page" USING "gist" ("titlevector")' ],
349 
350  [ 'checkOiNameConstraint' ],
351  [ 'checkPageDeletedTrigger' ],
352  [ 'checkRevUserFkey' ],
353  [ 'dropPgIndex', 'ipblocks', 'ipb_address' ],
354  [ 'checkIndex', 'ipb_address_unique', [
355  [ 'ipb_address', 'text_ops', 'btree', 0 ],
356  [ 'ipb_user', 'int4_ops', 'btree', 0 ],
357  [ 'ipb_auto', 'int2_ops', 'btree', 0 ],
358  [ 'ipb_anon_only', 'int2_ops', 'btree', 0 ],
359  ],
360  'CREATE UNIQUE INDEX ipb_address_unique ' .
361  'ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only)' ],
362 
363  [ 'checkIwlPrefix' ],
364 
365  # All FK columns should be deferred
366  [ 'changeFkeyDeferrable', 'archive', 'ar_user', 'mwuser(user_id) ON DELETE SET NULL' ],
367  [ 'changeFkeyDeferrable', 'categorylinks', 'cl_from', 'page(page_id) ON DELETE CASCADE' ],
368  [ 'changeFkeyDeferrable', 'externallinks', 'el_from', 'page(page_id) ON DELETE CASCADE' ],
369  [ 'changeFkeyDeferrable', 'filearchive', 'fa_deleted_user',
370  'mwuser(user_id) ON DELETE SET NULL' ],
371  [ 'changeFkeyDeferrable', 'filearchive', 'fa_user', 'mwuser(user_id) ON DELETE SET NULL' ],
372  [ 'changeFkeyDeferrable', 'image', 'img_user', 'mwuser(user_id) ON DELETE SET NULL' ],
373  [ 'changeFkeyDeferrable', 'imagelinks', 'il_from', 'page(page_id) ON DELETE CASCADE' ],
374  [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_by', 'mwuser(user_id) ON DELETE CASCADE' ],
375  [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_user', 'mwuser(user_id) ON DELETE SET NULL' ],
376  [ 'changeFkeyDeferrable', 'ipblocks', 'ipb_parent_block_id',
377  'ipblocks(ipb_id) ON DELETE SET NULL' ],
378  [ 'changeFkeyDeferrable', 'langlinks', 'll_from', 'page(page_id) ON DELETE CASCADE' ],
379  [ 'changeFkeyDeferrable', 'logging', 'log_user', 'mwuser(user_id) ON DELETE SET NULL' ],
380  [ 'changeFkeyDeferrable', 'oldimage', 'oi_name',
381  'image(img_name) ON DELETE CASCADE ON UPDATE CASCADE' ],
382  [ 'changeFkeyDeferrable', 'oldimage', 'oi_user', 'mwuser(user_id) ON DELETE SET NULL' ],
383  [ 'changeFkeyDeferrable', 'pagelinks', 'pl_from', 'page(page_id) ON DELETE CASCADE' ],
384  [ 'changeFkeyDeferrable', 'page_props', 'pp_page', 'page (page_id) ON DELETE CASCADE' ],
385  [ 'changeFkeyDeferrable', 'page_restrictions', 'pr_page',
386  'page(page_id) ON DELETE CASCADE' ],
387  [ 'changeFkeyDeferrable', 'protected_titles', 'pt_user',
388  'mwuser(user_id) ON DELETE SET NULL' ],
389  [ 'changeFkeyDeferrable', 'recentchanges', 'rc_user',
390  'mwuser(user_id) ON DELETE SET NULL' ],
391  [ 'changeFkeyDeferrable', 'redirect', 'rd_from', 'page(page_id) ON DELETE CASCADE' ],
392  [ 'changeFkeyDeferrable', 'revision', 'rev_page', 'page (page_id) ON DELETE CASCADE' ],
393  [ 'changeFkeyDeferrable', 'revision', 'rev_user', 'mwuser(user_id) ON DELETE RESTRICT' ],
394  [ 'changeFkeyDeferrable', 'templatelinks', 'tl_from', 'page(page_id) ON DELETE CASCADE' ],
395  [ 'changeFkeyDeferrable', 'user_groups', 'ug_user', 'mwuser(user_id) ON DELETE CASCADE' ],
396  [ 'changeFkeyDeferrable', 'user_newtalk', 'user_id', 'mwuser(user_id) ON DELETE CASCADE' ],
397  [ 'changeFkeyDeferrable', 'user_properties', 'up_user',
398  'mwuser(user_id) ON DELETE CASCADE' ],
399  [ 'changeFkeyDeferrable', 'watchlist', 'wl_user', 'mwuser(user_id) ON DELETE CASCADE' ],
400 
401  # r81574
402  [ 'addInterwikiType' ],
403  # end
404  [ 'tsearchFixes' ],
405 
406  // 1.23
407  [ 'addPgField', 'recentchanges', 'rc_source', "TEXT NOT NULL DEFAULT ''" ],
408  [ 'addPgField', 'page', 'page_links_updated', "TIMESTAMPTZ NULL" ],
409  [ 'addPgField', 'mwuser', 'user_password_expires', 'TIMESTAMPTZ NULL' ],
410  [ 'changeFieldPurgeTable', 'l10n_cache', 'lc_value', 'bytea',
411  "replace(lc_value,'\','\\\\')::bytea" ],
412  // 1.23.9
413  [ 'rebuildTextSearch' ],
414 
415  // 1.24
416  [ 'addPgField', 'page_props', 'pp_sortkey', 'float NULL' ],
417  [ 'addPgIndex', 'page_props', 'pp_propname_sortkey_page',
418  '( pp_propname, pp_sortkey, pp_page ) WHERE ( pp_sortkey IS NOT NULL )' ],
419  [ 'addPgField', 'page', 'page_lang', 'TEXT default NULL' ],
420  [ 'addPgField', 'pagelinks', 'pl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
421  [ 'addPgField', 'templatelinks', 'tl_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
422  [ 'addPgField', 'imagelinks', 'il_from_namespace', 'INTEGER NOT NULL DEFAULT 0' ],
423 
424  // 1.25
425  [ 'dropTable', 'hitcounter' ],
426  [ 'dropField', 'site_stats', 'ss_total_views', 'patch-drop-ss_total_views.sql' ],
427  [ 'dropField', 'page', 'page_counter', 'patch-drop-page_counter.sql' ],
428  [ 'dropFkey', 'recentchanges', 'rc_cur_id' ],
429 
430  // 1.27
431  [ 'dropTable', 'msg_resource_links' ],
432  [ 'dropTable', 'msg_resource' ],
433  [
434  'addPgField', 'watchlist', 'wl_id',
435  "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('watchlist_wl_id_seq')"
436  ],
437 
438  // 1.28
439  [ 'addPgIndex', 'recentchanges', 'rc_name_type_patrolled_timestamp',
440  '( rc_namespace, rc_type, rc_patrolled, rc_timestamp )' ],
441  [ 'addPgField', 'change_tag', 'ct_id',
442  "INTEGER NOT NULL PRIMARY KEY DEFAULT nextval('change_tag_ct_id_seq')" ],
443 
444  // 1.29
445  [ 'addPgField', 'externallinks', 'el_index_60', "BYTEA NOT NULL DEFAULT ''" ],
446  [ 'addPgIndex', 'externallinks', 'el_index_60', '( el_index_60, el_id )' ],
447  [ 'addPgIndex', 'externallinks', 'el_from_index_60', '( el_from, el_index_60, el_id )' ],
448  [ 'addPgField', 'user_groups', 'ug_expiry', "TIMESTAMPTZ NULL" ],
449  [ 'addPgIndex', 'user_groups', 'user_groups_expiry', '( ug_expiry )' ],
450 
451  // 1.30
452  [ 'addPgEnumValue', 'media_type', '3D' ],
453  [ 'setDefault', 'revision', 'rev_comment', '' ],
454  [ 'changeNullableField', 'revision', 'rev_comment', 'NOT NULL', true ],
455  [ 'setDefault', 'archive', 'ar_comment', '' ],
456  [ 'changeNullableField', 'archive', 'ar_comment', 'NOT NULL', true ],
457  [ 'addPgField', 'archive', 'ar_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
458  [ 'setDefault', 'ipblocks', 'ipb_reason', '' ],
459  [ 'addPgField', 'ipblocks', 'ipb_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
460  [ 'setDefault', 'image', 'img_description', '' ],
461  [ 'setDefault', 'oldimage', 'oi_description', '' ],
462  [ 'changeNullableField', 'oldimage', 'oi_description', 'NOT NULL', true ],
463  [ 'addPgField', 'oldimage', 'oi_description_id', 'INTEGER NOT NULL DEFAULT 0' ],
464  [ 'setDefault', 'filearchive', 'fa_deleted_reason', '' ],
465  [ 'changeNullableField', 'filearchive', 'fa_deleted_reason', 'NOT NULL', true ],
466  [ 'addPgField', 'filearchive', 'fa_deleted_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
467  [ 'setDefault', 'filearchive', 'fa_description', '' ],
468  [ 'addPgField', 'filearchive', 'fa_description_id', 'INTEGER NOT NULL DEFAULT 0' ],
469  [ 'setDefault', 'recentchanges', 'rc_comment', '' ],
470  [ 'changeNullableField', 'recentchanges', 'rc_comment', 'NOT NULL', true ],
471  [ 'addPgField', 'recentchanges', 'rc_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
472  [ 'setDefault', 'logging', 'log_comment', '' ],
473  [ 'changeNullableField', 'logging', 'log_comment', 'NOT NULL', true ],
474  [ 'addPgField', 'logging', 'log_comment_id', 'INTEGER NOT NULL DEFAULT 0' ],
475  [ 'setDefault', 'protected_titles', 'pt_reason', '' ],
476  [ 'changeNullableField', 'protected_titles', 'pt_reason', 'NOT NULL', true ],
477  [ 'addPgField', 'protected_titles', 'pt_reason_id', 'INTEGER NOT NULL DEFAULT 0' ],
478  [ 'addTable', 'comment', 'patch-comment-table.sql' ],
479  [ 'addTable', 'revision_comment_temp', 'patch-revision_comment_temp-table.sql' ],
480  // image_comment_temp is no longer needed when upgrading to MW 1.31 or newer,
481  // as it is dropped later in the update process as part of 'migrateImageCommentTemp'.
482  // File kept on disk and the updater entry here for historical purposes.
483  // [ 'addTable', 'image_comment_temp', 'patch-image_comment_temp-table.sql' ],
484 
485  // This field was added in 1.31, but is put here so it can be used by 'migrateComments'
486  [ 'addPgField', 'image', 'img_description_id', 'INTEGER NOT NULL DEFAULT 0' ],
487 
488  [ 'migrateComments' ],
489  [ 'addIndex', 'site_stats', 'site_stats_pkey', 'patch-site_stats-pk.sql' ],
490  [ 'addTable', 'ip_changes', 'patch-ip_changes.sql' ],
491 
492  // 1.31
493  [ 'addTable', 'slots', 'patch-slots-table.sql' ],
494  [ 'dropPgIndex', 'slots', 'slot_role_inherited' ],
495  [ 'dropPgField', 'slots', 'slot_inherited' ],
496  [ 'addPgField', 'slots', 'slot_origin', 'INTEGER NOT NULL' ],
497  [
498  'addPgIndex',
499  'slots',
500  'slot_revision_origin_role',
501  '( slot_revision_id, slot_origin, slot_role_id )',
502  ],
503  [ 'addTable', 'content', 'patch-content-table.sql' ],
504  [ 'addTable', 'content_models', 'patch-content_models-table.sql' ],
505  [ 'addTable', 'slot_roles', 'patch-slot_roles-table.sql' ],
506  [ 'migrateArchiveText' ],
507  [ 'addTable', 'actor', 'patch-actor-table.sql' ],
508  [ 'addTable', 'revision_actor_temp', 'patch-revision_actor_temp-table.sql' ],
509  [ 'setDefault', 'revision', 'rev_user', 0 ],
510  [ 'setDefault', 'revision', 'rev_user_text', '' ],
511  [ 'setDefault', 'archive', 'ar_user', 0 ],
512  [ 'changeNullableField', 'archive', 'ar_user', 'NOT NULL', true ],
513  [ 'setDefault', 'archive', 'ar_user_text', '' ],
514  [ 'addPgField', 'archive', 'ar_actor', 'INTEGER NOT NULL DEFAULT 0' ],
515  [ 'addPgIndex', 'archive', 'archive_actor', '( ar_actor )' ],
516  [ 'setDefault', 'ipblocks', 'ipb_by', 0 ],
517  [ 'addPgField', 'ipblocks', 'ipb_by_actor', 'INTEGER NOT NULL DEFAULT 0' ],
518  [ 'setDefault', 'image', 'img_user', 0 ],
519  [ 'changeNullableField', 'image', 'img_user', 'NOT NULL', true ],
520  [ 'setDefault', 'image', 'img_user_text', '' ],
521  [ 'addPgField', 'image', 'img_actor', 'INTEGER NOT NULL DEFAULT 0' ],
522  [ 'setDefault', 'oldimage', 'oi_user', 0 ],
523  [ 'changeNullableField', 'oldimage', 'oi_user', 'NOT NULL', true ],
524  [ 'setDefault', 'oldimage', 'oi_user_text', '' ],
525  [ 'addPgField', 'oldimage', 'oi_actor', 'INTEGER NOT NULL DEFAULT 0' ],
526  [ 'setDefault', 'filearchive', 'fa_user', 0 ],
527  [ 'changeNullableField', 'filearchive', 'fa_user', 'NOT NULL', true ],
528  [ 'setDefault', 'filearchive', 'fa_user_text', '' ],
529  [ 'addPgField', 'filearchive', 'fa_actor', 'INTEGER NOT NULL DEFAULT 0' ],
530  [ 'setDefault', 'recentchanges', 'rc_user', 0 ],
531  [ 'changeNullableField', 'recentchanges', 'rc_user', 'NOT NULL', true ],
532  [ 'setDefault', 'recentchanges', 'rc_user_text', '' ],
533  [ 'addPgField', 'recentchanges', 'rc_actor', 'INTEGER NOT NULL DEFAULT 0' ],
534  [ 'setDefault', 'logging', 'log_user', 0 ],
535  [ 'changeNullableField', 'logging', 'log_user', 'NOT NULL', true ],
536  [ 'addPgField', 'logging', 'log_actor', 'INTEGER NOT NULL DEFAULT 0' ],
537  [ 'addPgIndex', 'logging', 'logging_actor_time_backwards', '( log_timestamp, log_actor )' ],
538  [ 'addPgIndex', 'logging', 'logging_actor_type_time', '( log_actor, log_type, log_timestamp )' ],
539  [ 'addPgIndex', 'logging', 'logging_actor_time', '( log_actor, log_timestamp )' ],
540  [ 'migrateActors' ],
541  [ 'modifyTable', 'site_stats', 'patch-site_stats-modify.sql' ],
542  [ 'populateArchiveRevId' ],
543  [ 'dropPgIndex', 'recentchanges', 'rc_namespace_title' ],
544  [
545  'addPgIndex',
546  'recentchanges',
547  'rc_namespace_title_timestamp', '( rc_namespace, rc_title, rc_timestamp )'
548  ],
549  [ 'setSequenceOwner', 'mwuser', 'user_id', 'user_user_id_seq' ],
550  [ 'setSequenceOwner', 'actor', 'actor_id', 'actor_actor_id_seq' ],
551  [ 'setSequenceOwner', 'page', 'page_id', 'page_page_id_seq' ],
552  [ 'setSequenceOwner', 'revision', 'rev_id', 'revision_rev_id_seq' ],
553  [ 'setSequenceOwner', 'ip_changes', 'ipc_rev_id', 'ip_changes_ipc_rev_id_seq' ],
554  [ 'setSequenceOwner', 'pagecontent', 'old_id', 'text_old_id_seq' ],
555  [ 'setSequenceOwner', 'comment', 'comment_id', 'comment_comment_id_seq' ],
556  [ 'setSequenceOwner', 'page_restrictions', 'pr_id', 'page_restrictions_pr_id_seq' ],
557  [ 'setSequenceOwner', 'archive', 'ar_id', 'archive_ar_id_seq' ],
558  [ 'setSequenceOwner', 'content', 'content_id', 'content_content_id_seq' ],
559  [ 'setSequenceOwner', 'slot_roles', 'role_id', 'slot_roles_role_id_seq' ],
560  [ 'setSequenceOwner', 'content_models', 'model_id', 'content_models_model_id_seq' ],
561  [ 'setSequenceOwner', 'externallinks', 'el_id', 'externallinks_el_id_seq' ],
562  [ 'setSequenceOwner', 'ipblocks', 'ipb_id', 'ipblocks_ipb_id_seq' ],
563  [ 'setSequenceOwner', 'filearchive', 'fa_id', 'filearchive_fa_id_seq' ],
564  [ 'setSequenceOwner', 'uploadstash', 'us_id', 'uploadstash_us_id_seq' ],
565  [ 'setSequenceOwner', 'recentchanges', 'rc_id', 'recentchanges_rc_id_seq' ],
566  [ 'setSequenceOwner', 'watchlist', 'wl_id', 'watchlist_wl_id_seq' ],
567  [ 'setSequenceOwner', 'logging', 'log_id', 'logging_log_id_seq' ],
568  [ 'setSequenceOwner', 'job', 'job_id', 'job_job_id_seq' ],
569  [ 'setSequenceOwner', 'category', 'cat_id', 'category_cat_id_seq' ],
570  [ 'setSequenceOwner', 'change_tag', 'ct_id', 'change_tag_ct_id_seq' ],
571  [ 'setSequenceOwner', 'sites', 'site_id', 'sites_site_id_seq' ],
572 
573  // 1.32
574  [ 'addTable', 'change_tag_def', 'patch-change_tag_def.sql' ],
575  [ 'populateExternallinksIndex60' ],
576  [ 'dropDefault', 'externallinks', 'el_index_60' ],
577  [ 'runMaintenance', DeduplicateArchiveRevId::class, 'maintenance/deduplicateArchiveRevId.php' ],
578  [ 'addPgField', 'change_tag', 'ct_tag_id', 'INTEGER NULL' ],
579  [
580  'addPgIndex',
581  'change_tag',
582  'change_tag_tag_id_id',
583  '( ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id )'
584  ],
585  [ 'addPgIndex', 'archive', 'ar_revid_uniq', '(ar_rev_id)', 'unique' ],
586  [ 'dropPgIndex', 'archive', 'ar_revid' ], // Probably doesn't exist, but do it anyway.
587  [ 'populateContentTables' ],
588  [ 'addPgIndex', 'logging', 'log_type_action', '( log_type, log_action, log_timestamp )' ],
589  [ 'dropPgIndex', 'page_props', 'page_props_propname' ],
590  [ 'addIndex', 'interwiki', 'interwiki_pkey', 'patch-interwiki-pk.sql' ],
591  [ 'addIndex', 'protected_titles', 'protected_titles_pkey', 'patch-protected_titles-pk.sql' ],
592  [ 'addIndex', 'site_identifiers', 'site_identifiers_pkey', 'patch-site_identifiers-pk.sql' ],
593  [ 'addPgIndex', 'recentchanges', 'rc_this_oldid', '(rc_this_oldid)' ],
594  [ 'dropTable', 'transcache' ],
595  [ 'runMaintenance', PopulateChangeTagDef::class, 'maintenance/populateChangeTagDef.php' ],
596  [ 'addIndex', 'change_tag', 'change_tag_rc_tag_id',
597  'patch-change_tag-change_tag_rc_tag_id.sql' ],
598  [ 'addPgField', 'ipblocks', 'ipb_sitewide', 'SMALLINT NOT NULL DEFAULT 1' ],
599  [ 'addTable', 'ipblocks_restrictions', 'patch-ipblocks_restrictions-table.sql' ],
600  [ 'migrateImageCommentTemp' ],
601  [ 'dropPgField', 'category', 'cat_hidden' ],
602  [ 'dropPgField', 'site_stats', 'ss_admins' ],
603  [ 'dropPgField', 'recentchanges', 'rc_cur_time' ],
604 
605  // 1.33
606  [ 'dropField', 'change_tag', 'ct_tag', 'patch-drop-ct_tag.sql' ],
607  [ 'dropTable', 'valid_tag' ],
608  [ 'dropTable', 'tag_summary' ],
609  [ 'dropPgField', 'archive', 'ar_comment' ],
610  [ 'dropDefault', 'archive', 'ar_comment_id' ],
611  [ 'dropPgField', 'ipblocks', 'ipb_reason' ],
612  [ 'dropDefault', 'ipblocks', 'ipb_reason_id' ],
613  [ 'dropPgField', 'image', 'img_description' ],
614  [ 'dropDefault', 'image', 'img_description_id' ],
615  [ 'dropPgField', 'oldimage', 'oi_description' ],
616  [ 'dropDefault', 'oldimage', 'oi_description_id' ],
617  [ 'dropPgField', 'filearchive', 'fa_deleted_reason' ],
618  [ 'dropDefault', 'filearchive', 'fa_deleted_reason_id' ],
619  [ 'dropPgField', 'filearchive', 'fa_description' ],
620  [ 'dropDefault', 'filearchive', 'fa_description_id' ],
621  [ 'dropPgField', 'recentchanges', 'rc_comment' ],
622  [ 'dropDefault', 'recentchanges', 'rc_comment_id' ],
623  [ 'dropPgField', 'logging', 'log_comment' ],
624  [ 'dropDefault', 'logging', 'log_comment_id' ],
625  [ 'dropPgField', 'protected_titles', 'pt_reason' ],
626  [ 'dropDefault', 'protected_titles', 'pt_reason_id' ],
627  ];
628  }
629 
630  protected function getOldGlobalUpdates() {
631  global $wgExtNewTables, $wgExtPGNewFields, $wgExtPGAlteredFields, $wgExtNewIndexes;
632 
633  $updates = [];
634 
635  # Add missing extension tables
636  foreach ( $wgExtNewTables as $tableRecord ) {
637  $updates[] = [
638  'addTable', $tableRecord[0], $tableRecord[1], true
639  ];
640  }
641 
642  # Add missing extension fields
643  foreach ( $wgExtPGNewFields as $fieldRecord ) {
644  $updates[] = [
645  'addPgField', $fieldRecord[0], $fieldRecord[1],
646  $fieldRecord[2]
647  ];
648  }
649 
650  # Change altered columns
651  foreach ( $wgExtPGAlteredFields as $fieldRecord ) {
652  $updates[] = [
653  'changeField', $fieldRecord[0], $fieldRecord[1],
654  $fieldRecord[2]
655  ];
656  }
657 
658  # Add missing extension indexes
659  foreach ( $wgExtNewIndexes as $fieldRecord ) {
660  $updates[] = [
661  'addPgExtIndex', $fieldRecord[0], $fieldRecord[1],
662  $fieldRecord[2]
663  ];
664  }
665 
666  return $updates;
667  }
668 
669  protected function describeTable( $table ) {
670  $q = <<<END
671 SELECT attname, attnum FROM pg_namespace, pg_class, pg_attribute
672  WHERE pg_class.relnamespace = pg_namespace.oid
673  AND attrelid=pg_class.oid AND attnum > 0
674  AND relname=%s AND nspname=%s
675 END;
676  $res = $this->db->query( sprintf( $q,
677  $this->db->addQuotes( $table ),
678  $this->db->addQuotes( $this->db->getCoreSchema() ) ) );
679  if ( !$res ) {
680  return null;
681  }
682 
683  $cols = [];
684  foreach ( $res as $r ) {
685  $cols[] = [
686  "name" => $r[0],
687  "ord" => $r[1],
688  ];
689  }
690 
691  return $cols;
692  }
693 
694  function describeIndex( $idx ) {
695  // first fetch the key (which is a list of columns ords) and
696  // the table the index applies to (an oid)
697  $q = <<<END
698 SELECT indkey, indrelid FROM pg_namespace, pg_class, pg_index
699  WHERE nspname=%s
700  AND pg_class.relnamespace = pg_namespace.oid
701  AND relname=%s
702  AND indexrelid=pg_class.oid
703 END;
704  $res = $this->db->query(
705  sprintf(
706  $q,
707  $this->db->addQuotes( $this->db->getCoreSchema() ),
708  $this->db->addQuotes( $idx )
709  )
710  );
711  if ( !$res ) {
712  return null;
713  }
714  $r = $this->db->fetchRow( $res );
715  if ( !$r ) {
716  return null;
717  }
718 
719  $indkey = $r[0];
720  $relid = intval( $r[1] );
721  $indkeys = explode( ' ', $indkey );
722 
723  $colnames = [];
724  foreach ( $indkeys as $rid ) {
725  $query = <<<END
726 SELECT attname FROM pg_class, pg_attribute
727  WHERE attrelid=$relid
728  AND attnum=%d
729  AND attrelid=pg_class.oid
730 END;
731  $r2 = $this->db->query( sprintf( $query, $rid ) );
732  if ( !$r2 ) {
733  return null;
734  }
735  $row2 = $this->db->fetchRow( $r2 );
736  if ( !$row2 ) {
737  return null;
738  }
739  $colnames[] = $row2[0];
740  }
741 
742  return $colnames;
743  }
744 
745  function fkeyDeltype( $fkey ) {
746  $q = <<<END
747 SELECT confdeltype FROM pg_constraint, pg_namespace
748  WHERE connamespace=pg_namespace.oid
749  AND nspname=%s
750  AND conname=%s;
751 END;
752  $r = $this->db->query(
753  sprintf(
754  $q,
755  $this->db->addQuotes( $this->db->getCoreSchema() ),
756  $this->db->addQuotes( $fkey )
757  )
758  );
759  $row = $this->db->fetchRow( $r );
760  if ( !$row ) {
761  return null;
762  }
763 
764  return $row[0];
765  }
766 
767  function ruleDef( $table, $rule ) {
768  $q = <<<END
769 SELECT definition FROM pg_rules
770  WHERE schemaname = %s
771  AND tablename = %s
772  AND rulename = %s
773 END;
774  $r = $this->db->query(
775  sprintf(
776  $q,
777  $this->db->addQuotes( $this->db->getCoreSchema() ),
778  $this->db->addQuotes( $table ),
779  $this->db->addQuotes( $rule )
780  )
781  );
782  $row = $this->db->fetchRow( $r );
783  if ( !$row ) {
784  return null;
785  }
786  $d = $row[0];
787 
788  return $d;
789  }
790 
791  protected function addSequence( $table, $pkey, $ns ) {
792  if ( !$this->db->sequenceExists( $ns ) ) {
793  $this->output( "Creating sequence $ns\n" );
794  if ( $pkey !== false ) {
795  $this->db->query( "CREATE SEQUENCE $ns OWNED BY $table.$pkey" );
796  $this->setDefault( $table, $pkey, '"nextval"(\'"' . $ns . '"\'::"regclass")' );
797  } else {
798  $this->db->query( "CREATE SEQUENCE $ns" );
799  }
800  }
801  }
802 
803  protected function dropSequence( $table, $ns ) {
804  if ( $this->db->sequenceExists( $ns ) ) {
805  $this->output( "Dropping sequence $ns\n" );
806  $this->db->query( "DROP SEQUENCE $ns CASCADE" );
807  }
808  }
809 
810  protected function renameSequence( $old, $new ) {
811  if ( $this->db->sequenceExists( $new ) ) {
812  $this->output( "...sequence $new already exists.\n" );
813 
814  return;
815  }
816  if ( $this->db->sequenceExists( $old ) ) {
817  $this->output( "Renaming sequence $old to $new\n" );
818  $this->db->query( "ALTER SEQUENCE $old RENAME TO $new" );
819  }
820  }
821 
822  protected function setSequenceOwner( $table, $pkey, $seq ) {
823  if ( $this->db->sequenceExists( $seq ) ) {
824  $this->output( "Setting sequence $seq owner to $table.$pkey\n" );
825  $this->db->query( "ALTER SEQUENCE $seq OWNED BY $table.$pkey" );
826  }
827  }
828 
829  protected function renameTable( $old, $new, $patch = false ) {
830  if ( $this->db->tableExists( $old ) ) {
831  $this->output( "Renaming table $old to $new\n" );
832  $old = $this->db->realTableName( $old, "quoted" );
833  $new = $this->db->realTableName( $new, "quoted" );
834  $this->db->query( "ALTER TABLE $old RENAME TO $new" );
835  if ( $patch !== false ) {
836  $this->applyPatch( $patch );
837  }
838  }
839  }
840 
841  protected function renameIndex(
842  $table, $old, $new, $skipBothIndexExistWarning = false, $a = false, $b = false
843  ) {
844  // First requirement: the table must exist
845  if ( !$this->db->tableExists( $table, __METHOD__ ) ) {
846  $this->output( "...skipping: '$table' table doesn't exist yet.\n" );
847 
848  return true;
849  }
850 
851  // Second requirement: the new index must be missing
852  if ( $this->db->indexExists( $table, $new, __METHOD__ ) ) {
853  $this->output( "...index $new already set on $table table.\n" );
854  if ( !$skipBothIndexExistWarning
855  && $this->db->indexExists( $table, $old, __METHOD__ )
856  ) {
857  $this->output( "...WARNING: $old still exists, despite it has been " .
858  "renamed into $new (which also exists).\n" .
859  " $old should be manually removed if not needed anymore.\n" );
860  }
861 
862  return true;
863  }
864 
865  // Third requirement: the old index must exist
866  if ( !$this->db->indexExists( $table, $old, __METHOD__ ) ) {
867  $this->output( "...skipping: index $old doesn't exist.\n" );
868 
869  return true;
870  }
871 
872  $this->db->query( "ALTER INDEX $old RENAME TO $new" );
873  return true;
874  }
875 
876  protected function dropPgField( $table, $field ) {
877  $fi = $this->db->fieldInfo( $table, $field );
878  if ( is_null( $fi ) ) {
879  $this->output( "...$table table does not contain $field field.\n" );
880 
881  return;
882  } else {
883  $this->output( "Dropping column '$table.$field'\n" );
884  $this->db->query( "ALTER TABLE $table DROP COLUMN $field" );
885  }
886  }
887 
888  protected function addPgField( $table, $field, $type ) {
889  $fi = $this->db->fieldInfo( $table, $field );
890  if ( !is_null( $fi ) ) {
891  $this->output( "...column '$table.$field' already exists\n" );
892 
893  return;
894  } else {
895  $this->output( "Adding column '$table.$field'\n" );
896  $this->db->query( "ALTER TABLE $table ADD $field $type" );
897  }
898  }
899 
900  protected function changeField( $table, $field, $newtype, $default ) {
901  $fi = $this->db->fieldInfo( $table, $field );
902  if ( is_null( $fi ) ) {
903  $this->output( "...ERROR: expected column $table.$field to exist\n" );
904  exit( 1 );
905  }
906 
907  if ( $fi->type() === $newtype ) {
908  $this->output( "...column '$table.$field' is already of type '$newtype'\n" );
909  } else {
910  $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" );
911  $sql = "ALTER TABLE $table ALTER $field TYPE $newtype";
912  if ( strlen( $default ) ) {
913  $res = [];
914  if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) {
915  $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]";
916  $this->db->query( $sqldef );
917  $default = preg_replace( '/\s*DEFAULT .+/', '', $default );
918  }
919  $sql .= " USING $default";
920  }
921  $this->db->query( $sql );
922  }
923  }
924 
925  protected function changeFieldPurgeTable( $table, $field, $newtype, $default ) {
926  # # For a cache table, empty it if the field needs to be changed, because the old contents
927  # # may be corrupted. If the column is already the desired type, refrain from purging.
928  $fi = $this->db->fieldInfo( $table, $field );
929  if ( is_null( $fi ) ) {
930  $this->output( "...ERROR: expected column $table.$field to exist\n" );
931  exit( 1 );
932  }
933 
934  if ( $fi->type() === $newtype ) {
935  $this->output( "...column '$table.$field' is already of type '$newtype'\n" );
936  } else {
937  $this->output( "Purging data from cache table '$table'\n" );
938  $this->db->query( "DELETE from $table" );
939  $this->output( "Changing column type of '$table.$field' from '{$fi->type()}' to '$newtype'\n" );
940  $sql = "ALTER TABLE $table ALTER $field TYPE $newtype";
941  if ( strlen( $default ) ) {
942  $res = [];
943  if ( preg_match( '/DEFAULT (.+)/', $default, $res ) ) {
944  $sqldef = "ALTER TABLE $table ALTER $field SET DEFAULT $res[1]";
945  $this->db->query( $sqldef );
946  $default = preg_replace( '/\s*DEFAULT .+/', '', $default );
947  }
948  $sql .= " USING $default";
949  }
950  $this->db->query( $sql );
951  }
952  }
953 
954  protected function setDefault( $table, $field, $default ) {
955  $info = $this->db->fieldInfo( $table, $field );
956  if ( $info && $info->defaultValue() !== $default ) {
957  $this->output( "Changing '$table.$field' default value\n" );
958  $this->db->query( "ALTER TABLE $table ALTER $field SET DEFAULT "
959  . $this->db->addQuotes( $default ) );
960  }
961  }
962 
969  protected function dropDefault( $table, $field ) {
970  $info = $this->db->fieldInfo( $table, $field );
971  if ( $info->defaultValue() !== false ) {
972  $this->output( "Removing '$table.$field' default value\n" );
973  $this->db->query( "ALTER TABLE $table ALTER $field DROP DEFAULT" );
974  }
975  }
976 
977  protected function changeNullableField( $table, $field, $null, $update = false ) {
978  $fi = $this->db->fieldInfo( $table, $field );
979  if ( is_null( $fi ) ) {
980  return;
981  }
982  if ( $fi->isNullable() ) {
983  # # It's NULL - does it need to be NOT NULL?
984  if ( $null === 'NOT NULL' ) {
985  $this->output( "Changing '$table.$field' to not allow NULLs\n" );
986  if ( $update ) {
987  $this->db->query( "UPDATE $table SET $field = DEFAULT WHERE $field IS NULL" );
988  }
989  $this->db->query( "ALTER TABLE $table ALTER $field SET NOT NULL" );
990  } else {
991  $this->output( "...column '$table.$field' is already set as NULL\n" );
992  }
993  } else {
994  # # It's NOT NULL - does it need to be NULL?
995  if ( $null === 'NULL' ) {
996  $this->output( "Changing '$table.$field' to allow NULLs\n" );
997  $this->db->query( "ALTER TABLE $table ALTER $field DROP NOT NULL" );
998  } else {
999  $this->output( "...column '$table.$field' is already set as NOT NULL\n" );
1000  }
1001  }
1002  }
1003 
1004  public function addPgIndex( $table, $index, $type, $unique = false ) {
1005  if ( $this->db->indexExists( $table, $index ) ) {
1006  $this->output( "...index '$index' on table '$table' already exists\n" );
1007  } else {
1008  $this->output( "Creating index '$index' on table '$table' $type\n" );
1009  $unique = $unique ? 'UNIQUE' : '';
1010  $this->db->query( "CREATE $unique INDEX $index ON $table $type" );
1011  }
1012  }
1013 
1014  public function addPgExtIndex( $table, $index, $type ) {
1015  if ( $this->db->indexExists( $table, $index ) ) {
1016  $this->output( "...index '$index' on table '$table' already exists\n" );
1017  } elseif ( preg_match( '/^\(/', $type ) ) {
1018  $this->output( "Creating index '$index' on table '$table'\n" );
1019  $this->db->query( "CREATE INDEX $index ON $table $type" );
1020  } else {
1021  $this->applyPatch( $type, true, "Creating index '$index' on table '$table'" );
1022  }
1023  }
1024 
1031  public function addPgEnumValue( $type, $value ) {
1032  $row = $this->db->selectRow(
1033  [
1034  't' => 'pg_catalog.pg_type',
1035  'n' => 'pg_catalog.pg_namespace',
1036  'e' => 'pg_catalog.pg_enum',
1037  ],
1038  [ 't.typname', 't.typtype', 'e.enumlabel' ],
1039  [
1040  't.typname' => $type,
1041  'n.nspname' => $this->db->getCoreSchema(),
1042  ],
1043  __METHOD__,
1044  [],
1045  [
1046  'n' => [ 'JOIN', 't.typnamespace = n.oid' ],
1047  'e' => [ 'LEFT JOIN', [ 'e.enumtypid = t.oid', 'e.enumlabel' => $value ] ],
1048  ]
1049  );
1050 
1051  if ( !$row ) {
1052  $this->output( "...Type $type does not exist, skipping modify enum.\n" );
1053  } elseif ( $row->typtype !== 'e' ) {
1054  $this->output( "...Type $type does not seem to be an enum, skipping modify enum.\n" );
1055  } elseif ( $row->enumlabel === $value ) {
1056  $this->output( "...Enum type $type already contains value '$value'.\n" );
1057  } else {
1058  $this->output( "...Adding value '$value' to enum type $type.\n" );
1059  $etype = $this->db->addIdentifierQuotes( $type );
1060  $evalue = $this->db->addQuotes( $value );
1061  $this->db->query( "ALTER TYPE $etype ADD VALUE $evalue" );
1062  }
1063  }
1064 
1065  protected function dropFkey( $table, $field ) {
1066  $fi = $this->db->fieldInfo( $table, $field );
1067  if ( is_null( $fi ) ) {
1068  $this->output( "WARNING! Column '$table.$field' does not exist but it should! " .
1069  "Please report this.\n" );
1070  return;
1071  }
1072  $conname = $fi->conname();
1073  if ( $fi->conname() ) {
1074  $this->output( "Dropping foreign key constraint on '$table.$field'\n" );
1075  $conclause = "CONSTRAINT \"$conname\"";
1076  $command = "ALTER TABLE $table DROP CONSTRAINT $conname";
1077  $this->db->query( $command );
1078  } else {
1079  $this->output( "...foreign key constraint on '$table.$field' already does not exist\n" );
1080  };
1081  }
1082 
1083  protected function changeFkeyDeferrable( $table, $field, $clause ) {
1084  $fi = $this->db->fieldInfo( $table, $field );
1085  if ( is_null( $fi ) ) {
1086  $this->output( "WARNING! Column '$table.$field' does not exist but it should! " .
1087  "Please report this.\n" );
1088 
1089  return;
1090  }
1091  if ( $fi->is_deferred() && $fi->is_deferrable() ) {
1092  return;
1093  }
1094  $this->output( "Altering column '$table.$field' to be DEFERRABLE INITIALLY DEFERRED\n" );
1095  $conname = $fi->conname();
1096  if ( $fi->conname() ) {
1097  $conclause = "CONSTRAINT \"$conname\"";
1098  $command = "ALTER TABLE $table DROP CONSTRAINT $conname";
1099  $this->db->query( $command );
1100  } else {
1101  $this->output( "Column '$table.$field' does not have a foreign key " .
1102  "constraint, will be added\n" );
1103  $conclause = "";
1104  }
1105  $command =
1106  "ALTER TABLE $table ADD $conclause " .
1107  "FOREIGN KEY ($field) REFERENCES $clause DEFERRABLE INITIALLY DEFERRED";
1108  $this->db->query( $command );
1109  }
1110 
1111  protected function convertArchive2() {
1112  if ( $this->db->tableExists( "archive2" ) ) {
1113  if ( $this->db->ruleExists( 'archive', 'archive_insert' ) ) {
1114  $this->output( "Dropping rule 'archive_insert'\n" );
1115  $this->db->query( 'DROP RULE archive_insert ON archive' );
1116  }
1117  if ( $this->db->ruleExists( 'archive', 'archive_delete' ) ) {
1118  $this->output( "Dropping rule 'archive_delete'\n" );
1119  $this->db->query( 'DROP RULE archive_delete ON archive' );
1120  }
1121  $this->applyPatch(
1122  'patch-remove-archive2.sql',
1123  false,
1124  "Converting 'archive2' back to normal archive table"
1125  );
1126  } else {
1127  $this->output( "...obsolete table 'archive2' does not exist\n" );
1128  }
1129  }
1130 
1131  protected function checkOiDeleted() {
1132  if ( $this->db->fieldInfo( 'oldimage', 'oi_deleted' )->type() !== 'smallint' ) {
1133  $this->output( "Changing 'oldimage.oi_deleted' to type 'smallint'\n" );
1134  $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted DROP DEFAULT" );
1135  $this->db->query(
1136  "ALTER TABLE oldimage ALTER oi_deleted TYPE SMALLINT USING (oi_deleted::smallint)" );
1137  $this->db->query( "ALTER TABLE oldimage ALTER oi_deleted SET DEFAULT 0" );
1138  } else {
1139  $this->output( "...column 'oldimage.oi_deleted' is already of type 'smallint'\n" );
1140  }
1141  }
1142 
1143  protected function checkOiNameConstraint() {
1144  if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascaded" ) ) {
1145  $this->output( "...table 'oldimage' has correct cascading delete/update " .
1146  "foreign key to image\n" );
1147  } else {
1148  if ( $this->db->hasConstraint( "oldimage_oi_name_fkey" ) ) {
1149  $this->db->query(
1150  "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey" );
1151  }
1152  if ( $this->db->hasConstraint( "oldimage_oi_name_fkey_cascade" ) ) {
1153  $this->db->query(
1154  "ALTER TABLE oldimage DROP CONSTRAINT oldimage_oi_name_fkey_cascade" );
1155  }
1156  $this->output( "Making foreign key on table 'oldimage' (to image) a cascade delete/update\n" );
1157  $this->db->query(
1158  "ALTER TABLE oldimage ADD CONSTRAINT oldimage_oi_name_fkey_cascaded " .
1159  "FOREIGN KEY (oi_name) REFERENCES image(img_name) " .
1160  "ON DELETE CASCADE ON UPDATE CASCADE" );
1161  }
1162  }
1163 
1164  protected function checkPageDeletedTrigger() {
1165  if ( !$this->db->triggerExists( 'page', 'page_deleted' ) ) {
1166  $this->applyPatch(
1167  'patch-page_deleted.sql',
1168  false,
1169  "Adding function and trigger 'page_deleted' to table 'page'"
1170  );
1171  } else {
1172  $this->output( "...table 'page' has 'page_deleted' trigger\n" );
1173  }
1174  }
1175 
1176  protected function dropPgIndex( $table, $index ) {
1177  if ( $this->db->indexExists( $table, $index ) ) {
1178  $this->output( "Dropping obsolete index '$index'\n" );
1179  $this->db->query( "DROP INDEX \"" . $index . "\"" );
1180  }
1181  }
1182 
1183  protected function checkIndex( $index, $should_be, $good_def ) {
1184  $pu = $this->db->indexAttributes( $index );
1185  if ( !empty( $pu ) && $pu != $should_be ) {
1186  $this->output( "Dropping obsolete version of index '$index'\n" );
1187  $this->db->query( "DROP INDEX \"" . $index . "\"" );
1188  $pu = [];
1189  } else {
1190  $this->output( "...no need to drop index '$index'\n" );
1191  }
1192 
1193  if ( empty( $pu ) ) {
1194  $this->output( "Creating index '$index'\n" );
1195  $this->db->query( $good_def );
1196  } else {
1197  $this->output( "...index '$index' exists\n" );
1198  }
1199  }
1200 
1201  protected function checkRevUserFkey() {
1202  if ( $this->fkeyDeltype( 'revision_rev_user_fkey' ) == 'r' ) {
1203  $this->output( "...constraint 'revision_rev_user_fkey' is ON DELETE RESTRICT\n" );
1204  } else {
1205  $this->applyPatch(
1206  'patch-revision_rev_user_fkey.sql',
1207  false,
1208  "Changing constraint 'revision_rev_user_fkey' to ON DELETE RESTRICT"
1209  );
1210  }
1211  }
1212 
1213  protected function checkIwlPrefix() {
1214  if ( $this->db->indexExists( 'iwlinks', 'iwl_prefix' ) ) {
1215  $this->applyPatch(
1216  'patch-rename-iwl_prefix.sql',
1217  false,
1218  "Replacing index 'iwl_prefix' with 'iwl_prefix_title_from'"
1219  );
1220  }
1221  }
1222 
1223  protected function addInterwikiType() {
1224  $this->applyPatch( 'patch-add_interwiki.sql', false, "Refreshing add_interwiki()" );
1225  }
1226 
1227  protected function tsearchFixes() {
1228  # Tweak the page_title tsearch2 trigger to filter out slashes
1229  # This is create or replace, so harmless to call if not needed
1230  $this->applyPatch( 'patch-ts2pagetitle.sql', false, "Refreshing ts2_page_title()" );
1231 
1232  # If the server is 8.3 or higher, rewrite the tsearch2 triggers
1233  # in case they have the old 'default' versions
1234  # Gather version numbers in case we need them
1235  if ( $this->db->getServerVersion() >= 8.3 ) {
1236  $this->applyPatch( 'patch-tsearch2funcs.sql', false, "Rewriting tsearch2 triggers" );
1237  }
1238  }
1239 
1240  protected function rebuildTextSearch() {
1241  if ( $this->updateRowExists( 'patch-textsearch_bug66650.sql' ) ) {
1242  $this->output( "...T68650 already fixed or not applicable.\n" );
1243  return;
1244  };
1245  $this->applyPatch( 'patch-textsearch_bug66650.sql', false,
1246  'Rebuilding text search for T68650' );
1247  }
1248 }
DatabaseUpdater\output
output( $str)
Output some text.
Definition: DatabaseUpdater.php:221
PostgresUpdater\rebuildTextSearch
rebuildTextSearch()
Definition: PostgresUpdater.php:1240
PostgresUpdater\renameIndex
renameIndex( $table, $old, $new, $skipBothIndexExistWarning=false, $a=false, $b=false)
Rename an index from an existing table.
Definition: PostgresUpdater.php:841
PostgresUpdater\checkOiNameConstraint
checkOiNameConstraint()
Definition: PostgresUpdater.php:1143
PostgresUpdater\changeNullableField
changeNullableField( $table, $field, $null, $update=false)
Definition: PostgresUpdater.php:977
PostgresUpdater\getCoreUpdateList
getCoreUpdateList()
Definition: PostgresUpdater.php:44
PostgresUpdater\setDefault
setDefault( $table, $field, $default)
Definition: PostgresUpdater.php:954
PostgresUpdater\addPgEnumValue
addPgEnumValue( $type, $value)
Add a value to an existing PostgreSQL enum type.
Definition: PostgresUpdater.php:1031
DatabaseUpdater\applyPatch
applyPatch( $path, $isFullPath=false, $msg=null)
Applies a SQL patch.
Definition: DatabaseUpdater.php:672
false
processing should stop and the error should be shown to the user * false
Definition: hooks.txt:187
DatabaseUpdater
Class for handling database updates.
Definition: DatabaseUpdater.php:36
PostgresUpdater\convertArchive2
convertArchive2()
Definition: PostgresUpdater.php:1111
PostgresUpdater\dropFkey
dropFkey( $table, $field)
Definition: PostgresUpdater.php:1065
PostgresUpdater\checkPageDeletedTrigger
checkPageDeletedTrigger()
Definition: PostgresUpdater.php:1164
PostgresUpdater\describeIndex
describeIndex( $idx)
Definition: PostgresUpdater.php:694
PostgresUpdater\$db
DatabasePostgres $db
Definition: PostgresUpdater.php:37
PostgresUpdater\renameTable
renameTable( $old, $new, $patch=false)
Definition: PostgresUpdater.php:829
PostgresUpdater\fkeyDeltype
fkeyDeltype( $fkey)
Definition: PostgresUpdater.php:745
Wikimedia\Rdbms\DatabasePostgres
Definition: DatabasePostgres.php:33
$res
$res
Definition: database.txt:21
PostgresUpdater\checkIwlPrefix
checkIwlPrefix()
Definition: PostgresUpdater.php:1213
PostgresUpdater\changeField
changeField( $table, $field, $newtype, $default)
Definition: PostgresUpdater.php:900
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:35
DatabaseUpdater\$updates
array $updates
Array of updates to perform on the database.
Definition: DatabaseUpdater.php:44
PostgresUpdater\changeFieldPurgeTable
changeFieldPurgeTable( $table, $field, $newtype, $default)
Definition: PostgresUpdater.php:925
PostgresUpdater\addPgExtIndex
addPgExtIndex( $table, $index, $type)
Definition: PostgresUpdater.php:1014
$query
null for the 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:1588
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: MIT-LICENSE.txt:10
PostgresUpdater\describeTable
describeTable( $table)
Definition: PostgresUpdater.php:669
PostgresUpdater\ruleDef
ruleDef( $table, $rule)
Definition: PostgresUpdater.php:767
PostgresUpdater\addPgIndex
addPgIndex( $table, $index, $type, $unique=false)
Definition: PostgresUpdater.php:1004
use
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 use
Definition: MIT-LICENSE.txt:10
PostgresUpdater\checkRevUserFkey
checkRevUserFkey()
Definition: PostgresUpdater.php:1201
DatabaseUpdater\updateRowExists
updateRowExists( $key)
Helper function: check if the given key is present in the updatelog table.
Definition: DatabaseUpdater.php:509
$command
$command
Definition: cdb.php:65
$value
$value
Definition: styleTest.css.php:49
PostgresUpdater
Class for handling updates to Postgres databases.
Definition: PostgresUpdater.php:32
PostgresUpdater\checkIndex
checkIndex( $index, $should_be, $good_def)
Definition: PostgresUpdater.php:1183
PostgresUpdater\changeFkeyDeferrable
changeFkeyDeferrable( $table, $field, $clause)
Definition: PostgresUpdater.php:1083
PostgresUpdater\renameSequence
renameSequence( $old, $new)
Definition: PostgresUpdater.php:810
PostgresUpdater\dropDefault
dropDefault( $table, $field)
Drop a default value from a field.
Definition: PostgresUpdater.php:969
PostgresUpdater\setSequenceOwner
setSequenceOwner( $table, $pkey, $seq)
Definition: PostgresUpdater.php:822
PostgresUpdater\addInterwikiType
addInterwikiType()
Definition: PostgresUpdater.php:1223
PostgresUpdater\dropSequence
dropSequence( $table, $ns)
Definition: PostgresUpdater.php:803
PostgresUpdater\addSequence
addSequence( $table, $pkey, $ns)
Definition: PostgresUpdater.php:791
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:9
PostgresUpdater\tsearchFixes
tsearchFixes()
Definition: PostgresUpdater.php:1227
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:1993
PostgresUpdater\addPgField
addPgField( $table, $field, $type)
Definition: PostgresUpdater.php:888
PostgresUpdater\dropPgField
dropPgField( $table, $field)
Definition: PostgresUpdater.php:876
class
you have access to all of the normal MediaWiki so you can get a DB use the etc For full docs on the Maintenance class
Definition: maintenance.txt:52
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:49
PostgresUpdater\checkOiDeleted
checkOiDeleted()
Definition: PostgresUpdater.php:1131
PostgresUpdater\getOldGlobalUpdates
getOldGlobalUpdates()
Before 1.17, we used to handle updates via stuff like $wgExtNewTables/Fields/Indexes.
Definition: PostgresUpdater.php:630
PostgresUpdater\dropPgIndex
dropPgIndex( $table, $index)
Definition: PostgresUpdater.php:1176
$type
$type
Definition: testCompression.php:48