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 or IP range.
gbw_target_central_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">| <translate> MediaWiki version:</translate> |
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
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">| <translate> MediaWiki version:</translate> |
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 | | +-----------------------+------------------+------+-----+---------+-------+
| <translate> MediaWiki versions:</translate> |
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 | +------------------------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
