Manual:Ipblocks restrictions table/ru

This page is a translated version of the page Manual:Ipblocks restrictions table and the translation is 8% complete.
Manual:Содержание MediaWiki database layout ipblocks_restrictions таблица

The ipblocks_restrictions table stores restrictions related to Blocks .

Fields

ir_ipb_id

Версия MediaWiki:
1.32

The ipb_id of the block this restriction relates to.

ir_type

Версия MediaWiki:
1.32

The Type of the Block.

  • 1 = Page
  • 2 = Namespace

ir_value

Версия MediaWiki:
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:
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:
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:
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:
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:
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      |         |               |
+-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

См. также