(If you don't work with the imagelinks or categorylinks tables, you can ignore this message)

Hello,

Here is an update on the ongoing normalization of the MediaWiki link tables.

Starting 1 March, the cl_to and il_to columns in the categorylinks and imagelinks tables will be removed. You will need to use cl_target_id and il_target_id, respectively, and join against the linktarget table instead. This is analogous to the templatelinks normalization done a few years ago.

Additionally, the cl_collation column in the categorylinks table will be removed. Please use cl_collation_id joined with the collation table instead.

If your tools or queries access these tables directly, please update them to use the new schema before 1 March.

Progress is tracked at: https://phabricator.wikimedia.org/T300222 Background/rationale: https://phabricator.wikimedia.org/T222224

Thank you, Alexander Vorwerk — IRC: Zabe