- ALTERs to run: https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/GlobalBlocking/+/bdfa4a01272c793e190cbbf0169104a1f9a385e8/sql/mysql/patch-add-gbw_target_central_id.sql
- Where to run those changes: All (excluding the centralauth DB)
- 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 update.php
- 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 global_block_whitelist; from betawikis
MariaDB [enwiki]> describe global_block_whitelist; +-----------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+------------------+------+-----+---------+-------+ | gbw_id | int(11) | NO | PRI | NULL | | | gbw_address | varbinary(255) | NO | | NULL | | | gbw_by | int(11) | NO | MUL | NULL | | | gbw_by_text | varbinary(255) | NO | | NULL | | | gbw_reason | varbinary(767) | NO | | NULL | | | gbw_expiry | binary(14) | NO | | NULL | | | gbw_target_central_id | int(10) unsigned | NO | | 0 | | +-----------------------+------------------+------+-----+---------+-------+ 7 rows in set (0.002 sec)
Progress
- s1
- s2
- s3
- s4
- s5
- s6
- s7
- s8
- labtestwiki