Manual:Ipblocks restrictions table
| ↑ Manual:Contents | MediaWiki database layout | ipblocks_restrictions table |
The ipblocks_restrictions table stores restrictions related to Blocks.
Fields
ir_ipb_id
| MediaWiki version: | ≥ 1.32 |
The ipb_id of the block this restriction relates to.
ir_type
| MediaWiki version: | ≥ 1.32 |
The Type of the Block.
- 1 = Page
- 2 = Namespace
ir_value
| MediaWiki version: | ≥ 1.32 |
The value of the block restriction. For pages this is a page_id for Namespaces, this is a namespace id found in config.
Schema summary
| MediaWiki version: | ≥ 1.39 |
DESCRIBE ipblocks_restrictions;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | ir_ipb_id | int(10) unsigned | NO | PRI | NULL | | | ir_type | tinyint(4) | NO | PRI | NULL | | | ir_value | int(10) unsigned | NO | PRI | NULL | | +-----------+------------------+------+-----+---------+-------+
| MediaWiki version: | 1.38 |
DESCRIBE ipblocks_restrictions;
+-----------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+-------+ | ir_ipb_id | int(11) | NO | PRI | NULL | | | ir_type | tinyint(4) | NO | PRI | NULL | | | ir_value | int(10) unsigned | NO | PRI | NULL | | +-----------+------------------+------+-----+---------+-------+
| MediaWiki versions: | 1.36 – 1.37 |
DESCRIBE ipblocks_restrictions;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | ir_ipb_id | int(11) | NO | PRI | NULL | | | ir_type | tinyint(4) | NO | PRI | NULL | | | ir_value | int(11) | NO | PRI | NULL | | +-----------+------------+------+-----+---------+-------+
| MediaWiki versions: | 1.32 – 1.35 |
DESCRIBE ipblocks_restrictions;
+-----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------+------+-----+---------+-------+ | ir_ipb_id | int(11) | NO | PRI | NULL | | | ir_type | tinyint(1) | NO | PRI | NULL | | | ir_value | int(11) | NO | PRI | NULL | | +-----------+------------+------+-----+---------+-------+
Indexes
| MediaWiki version: | ≥ 1.32 |
SHOW INDEX IN ipblocks_restrictions;
+-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks_restrictions | 0 | PRIMARY | 1 | ir_ipb_id | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_restrictions | 0 | PRIMARY | 2 | ir_type | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_restrictions | 0 | PRIMARY | 3 | ir_value | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_restrictions | 1 | ir_type_value | 1 | ir_type | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_restrictions | 1 | ir_type_value | 2 | ir_value | A | 0 | NULL | NULL | | BTREE | | | +-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+