Manual:Ipblocks restrictions table/es
| ↑ Manual: Contenidos de | MediaWiki database layout | ipblocks_restrictions table |
The ipblocks_restrictions table stores restrictions related to Blocks.
Campos
ir_ipb_id
| Versión de MediaWiki: | ≥ 1.32 |
The ipb_id of the block this restriction relates to.
ir_type
| Versión de MediaWiki: | ≥ 1.32 |
El tipo del Bloqueo.
- 1 = Página
- 2 = Espacio de nombres
ir_value
| Versión de 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.
Resumen del esquema
| Versión de 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 | | +-----------+------------------+------+-----+---------+-------+
| Versión de 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 | | +-----------+------------------+------+-----+---------+-------+
| Versiones de 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 | | +-----------+------------+------+-----+---------+-------+
| Versiones de 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
| Versión de 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 | | | +-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+