Extension:GlobalBlocking/global_block_whitelist table

The global_block_whitelist table stores information about global blocks that have been locally disabled on a wiki. The table exists per wiki and updates to this table can be applied using update.php .

Fields

gbw_id

Primary key. This is also a foreign key to the gb_id column in the globalblocks table .

gbw_address

The target of the block which has been locally disabled. One of an IP address, IP range, or account.

gbw_target_central_id

MediaWiki version:

≥ 1.42

The central ID for the target of the block that has been locally disabled. 0 if the target is an IP address or IP range.

gbw_by

The user ID of the user who disabled the block locally.

gbw_by_text

The username of the user who disabled the block locally.

gbw_reason

The reason given for disabling the global block locally.

gbw_expiry

The expiry timestamp for the global block. Blocks can have an infinite expiry.

Schema summary

MediaWiki version:

≥ 1.42

DESCRIBE global_block_whitelist;

+-----------------------+------------------+------+-----+---------+-------+
| Field                 | Type             | Null | Key | Default | Extra |
+-----------------------+------------------+------+-----+---------+-------+
| gbw_id                | int(11)          | NO   | PRI | NULL    |       |
| gbw_address           | varbinary(255)   | NO   |     | NULL    |       |
| gbw_central_id        | int(10) unsigned | YES  |     | NULL    |       |
| gbw_by                | int(11)          | NO   | MUL | NULL    |       |
| gbw_by_text           | varbinary(255)   | NO   |     | NULL    |       |
| gbw_reason            | varbinary(767)   | NO   |     | NULL    |       |
| gbw_expiry            | varbinary(14)    | NO   |     | NULL    |       |
| gbw_target_central_id | int(10) unsigned | NO   |     | 0       |       |
+-----------------------+------------------+------+-----+---------+-------+

MediaWiki versions:

1.39 – 1.41

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(255) | NO   |     | NULL    |       |
| gbw_expiry  | varbinary(14)  | NO   |     | NULL    |       |
+-------------+----------------+------+-----+---------+-------+

Indexes

SHOW INDEX IN global_block_whitelist;

+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table                  | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| global_block_whitelist |          0 | PRIMARY  |            1 | gbw_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| global_block_whitelist |          1 | gbw_by   |            1 | gbw_by      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+