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.36

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    |       |
+-----------+------------+------+-----+---------+-------+

See also

• Help:Range blocks
• Manual:Administrators#Block and unblock