Manual:ipblocks_restrictions/ru table

<translate> MediaWiki database layout</translate>

<translate> <tvar name=1>ipblocks_restrictions/ru</tvar> table</translate>

The ipblocks_restrictions table stores restrictions related to Blocks .

Fields

ir_ipb_id

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.32

<translate> MediaWiki version:</translate>

The ipb_id of the block this restriction relates to.

ir_type

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.32

<translate> MediaWiki version:</translate>

The Type of the Block.

1 = Page
2 = Namespace

ir_value

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.32

<translate> MediaWiki version:</translate>

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

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.39

<translate> MediaWiki version:</translate>

DESCRIBE ipblocks_restrictions/ru;

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

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.38</tvar> is unsupported version</translate>">

1.38

<translate> MediaWiki version:</translate>

DESCRIBE ipblocks_restrictions/ru;

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

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.37</tvar> is unsupported version</translate>">

1.36 – 1.37

<translate> MediaWiki versions:</translate>

DESCRIBE ipblocks_restrictions/ru;

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

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">

1.32 – 1.35

<translate> MediaWiki versions:</translate>

DESCRIBE ipblocks_restrictions/ru;

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

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.32

<translate> MediaWiki version:</translate>

SHOW INDEX IN ipblocks_restrictions/ru;

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

См. также