Manuel:table ipblocks_restrictions
| ↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table ipblocks_restrictions |
La table ipblocks_restrictions enregistre les restrictions liées aux blocs.
Champs
ir_ipb_id
| Version de MediaWiki : | ≥ 1.32 |
Le ipb_id du blocage auquel cette restriction est liée.
ir_type
| Version de MediaWiki : | ≥ 1.32 |
Type du blocage.
- 1 = Page
- 2 = Espace de noms
ir_value
| Version de MediaWiki : | ≥ 1.32 |
La valeur de la restriction du bloc. Pour les pages ceci est un page_id pour les espaces de noms; c'est l'ID d'un espace de noms trouvé dans la configuration.
Résumé du schéma
| Version 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 | | +-----------+------------------+------+-----+---------+-------+
| Version 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 | | +-----------+------------------+------+-----+---------+-------+
| Versions 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 | | +-----------+------------+------+-----+---------+-------+
| Versions 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 | | +-----------+------------+------+-----+---------+-------+
Les index
| Version 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 | | | +-----------------------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+