- ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/bdfa4a01272c793e190cbbf0169104a1f9a385e8/sql/mysql/patch-add-gb_target_central_id.sql
- Where to run those changes: Per T230055, only centralauth
- When to run those changes: At any time
- If the schema change is backwards compatible: Yes.
- If the schema change has been tested already on some of the test/beta wikis: This change has been applied to the betawikis by myself manually (see paste below for details).
- If the data should be made available on the labs replicas and/or dumps: As far as I am aware this table is public and I see no reason for this column not to be on labs replicas and/or dumps.
The output of describe globalblocks; from betawikis
MariaDB [centralauth]> describe globalblocks; +----------------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+---------+----------------+ | gb_id | int(11) | NO | PRI | NULL | auto_increment | | gb_address | varchar(255) | NO | MUL | NULL | | | gb_by | varchar(255) | NO | | NULL | | | gb_by_wiki | varbinary(255) | NO | | NULL | | | gb_reason | varbinary(767) | NO | | NULL | | | gb_timestamp | binary(14) | NO | MUL | NULL | | | gb_anon_only | tinyint(1) | NO | | 0 | | | gb_expiry | varbinary(14) | NO | MUL | | | | gb_range_start | varbinary(32) | NO | MUL | NULL | | | gb_range_end | varbinary(32) | NO | | NULL | | | gb_by_central_id | int(10) unsigned | YES | | NULL | | | gb_target_central_id | int(10) unsigned | NO | MUL | 0 | | +----------------------+------------------+------+-----+---------+----------------+ 12 rows in set (0.003 sec)