Manuel:table ipblocks
↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table ipblocks |
Version de MediaWiki : | ≤ 1.42 |
La table ipblocks enregistre les détails des adresses IP et des utilisateurs qui ont été bloqués en modification.
Le nom « ipblocks
» est un nom ancien, car maintenant les comptes des utilisateurs bloqués sont aussi enregistrés dans cette table.
Pour les blocages précédents, voir Table du journal .
À partir de MediaWiki 1.42 cette table est remplacée par les nouvelles tables block et block_target .
Champs
ipb_id
Version de MediaWiki : | ≥ 1.2 |
Clé primaire, ajoutée pour la confidentialité.
ipb_address
Adresse IP bloquée exprimée sous forme de quadruplet avec des points pour séparateurs, ou nom d'utilisateur.
ipb_user
ID de l'utilisateur bloqué ou 0 pour les blocages d'adresses IP.
ipb_by
Version de MediaWiki : | ≤ 1.33 |
ID utilisateur de l'administrateur qui a fait le blocage.
(obsolète); Obsolète et remplacé par ipb_by_actor.
ipb_by_text
Versions de MediaWiki : | 1.13 – 1.33 |
Nom d'utilisateur (sous forme textuelle) de l'administrateur qui a fait le blocage.
(obsolète depuis v. 1.31); remplacé par ipb_by_actor.
ipb_by_actor
Version de MediaWiki : | ≥ 1.31 Gerrit change 380669 |
Ceci est une clé externe vers actor_id dans la table actor .
ipb_reason
Version de MediaWiki : | ≤ 1.32 |
Motif de blocage tel que donné par l'administrateur.
(obsolète)
Remplacé par les tables
et ipb_reason_id
.
comment
ipb_reason_id
Version de MediaWiki : | ≥ 1.30 |
Ceci est une clé externe vers comment_id dans la table comment .
ipb_timestamp
Création (ou remise à jour) de la date dans le format standard AMJHMS.
ipb_auto
Indique que l'adresse IP a été bloquée parce qu'un utilisateur bloqué s'en est servi pour accéder à une page.
S'il vaut 1
, ipb_address
sera masqué.
ipb_anon_only
Version de MediaWiki : | ≥ 1.8 |
S'il vaut 1
, le blocage ne s'applique qu'aux utilisateurs qui ne sont pas connectés.
ipb_create_account
S'il vaut 1
, il empêche la création de compte à partir des adresses IP correspondantes.
ipb_enable_autoblock
Version de MediaWiki : | ≥ 1.9 |
S'il vaut 1
, il active les autoblocages sur le bloc d'adresses.
ipb_expiry
Version de MediaWiki : | ≥ 1.2 |
Délai initialisé par l'administrateur au moment du blocage. Un horodatage standard ou la chaîne 'infinity'.
ipb_range_start
Version de MediaWiki : | ≥ 1.6 |
Première adresse IP dans un bloc d'adresses IP.
ipb_range_end
Dernière adresse IP dans un bloc d'adresses IP.
ipb_deleted
Version de MediaWiki : | ≥ 1.10 |
Autorise que l'entrée puisse être marquée, ce qui la masque au utilisateurs et aux administrateurs (sysops).
ipb_block_email
Version de MediaWiki : | ≥ 1.11 |
S'il vaut 1
, il empêche l'utilisateur d'accèder à Special:Emailuser.
ipb_allow_usertalk
Version de MediaWiki : | ≥ 1.14 |
Indique si l'utilisateur bloqué n'a pas le droit de modifier sa page de discussion.
La valeur 1
signifie que l'utilisateur est autorisé à modifier sa page de discussion.
ipb_parent_block_id
Version de MediaWiki : | ≥ 1.20 |
ID de l'utilisateur qui a fait le blocage. Les autoblocages initialisent ceci avec le blocage initial, ce qui signifie que si celui-ci est supprimé, les auto-blocages le sont aussi.
ipb_sitewide
Version de MediaWiki : | ≥ 1.32 |
Indique si le blocage est général à tout le site ou s'il est partiel.
La valeur 0
indique que le blocage est partiel.
Un blocage partiel peut empêcher un utilisateur d'accéder à des pages, à des espaces de noms, ou de faire des actions spécifiques,
Si un blocage partiel bloque un utilisateur sur toutes les pages ou tous les espaces de noms, ceux-ci sont enregistrés dans la table ipblocks_restrictions .
Résumé du schéma
Versions de MediaWiki : | 1.39 – 1.42 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | ipb_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by_actor | bigint(20) unsigned | NO | | NULL | | | ipb_reason_id | bigint(20) unsigned | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(10) unsigned | YES | MUL | NULL | | | ipb_sitewide | tinyint(1) | NO | | 1 | | +----------------------+---------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.36 – 1.38 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by_actor | bigint(20) unsigned | NO | | NULL | | | ipb_reason_id | bigint(20) unsigned | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | | ipb_sitewide | tinyint(1) | NO | | 1 | | +----------------------+---------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.34 – 1.35 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by_actor | bigint(20) unsigned | NO | | NULL | | | ipb_reason_id | bigint(20) unsigned | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | | ipb_sitewide | tinyint(1) | NO | | 1 | | +----------------------+---------------------+------+-----+----------------+----------------+
Version de MediaWiki : | 1.33 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by | int(10) unsigned | NO | | 0 | | | ipb_by_text | varbinary(255) | NO | | | | | ipb_by_actor | bigint(20) unsigned | NO | | 0 | | | ipb_reason_id | bigint(20) unsigned | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | | ipb_sitewide | tinyint(1) | NO | | 1 | | +----------------------+---------------------+------+-----+----------------+----------------+
Version de MediaWiki : | 1.32 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by | int(10) unsigned | NO | | 0 | | | ipb_by_text | varbinary(255) | NO | | | | | ipb_by_actor | bigint(20) unsigned | NO | | 0 | | | ipb_reason | varbinary(767) | NO | | | | | ipb_reason_id | bigint(20) unsigned | NO | | 0 | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | | ipb_sitewide | tinyint(1) | NO | | 1 | | +----------------------+---------------------+------+-----+----------------+----------------+
Version de MediaWiki : | 1.31 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by | int(10) unsigned | NO | | 0 | | | ipb_by_text | varbinary(255) | NO | | | | | ipb_by_actor | bigint(20) unsigned | NO | | 0 | | | ipb_reason | varbinary(767) | NO | | | | | ipb_reason_id | bigint(20) unsigned | NO | | 0 | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | +----------------------+---------------------+------+-----+----------------+----------------+
Version de MediaWiki : | 1.30 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by | int(10) unsigned | NO | | 0 | | | ipb_by_text | varbinary(255) | NO | | | | | ipb_reason | varbinary(767) | NO | | | | | ipb_reason_id | bigint(20) unsigned | NO | | 0 | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | +----------------------+---------------------+------+-----+----------------+----------------+
Versions de MediaWiki : | 1.25 – 1.29 |
DESCRIBE ipblocks;
+----------------------+------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+------------------+------+-----+----------------+----------------+ | ipb_id | int(11) | NO | PRI | NULL | auto_increment | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(10) unsigned | NO | MUL | 0 | | | ipb_by | int(10) unsigned | NO | | 0 | | | ipb_by_text | varbinary(255) | NO | | | | | ipb_reason | varbinary(767) | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_anon_only | tinyint(1) | NO | | 0 | | | ipb_create_account | tinyint(1) | NO | | 1 | | | ipb_enable_autoblock | tinyint(1) | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | tinyint(1) | NO | | 0 | | | ipb_block_email | tinyint(1) | NO | | 0 | | | ipb_allow_usertalk | tinyint(1) | NO | | 0 | | | ipb_parent_block_id | int(11) | YES | MUL | NULL | | +----------------------+------------------+------+-----+----------------+----------------+
Versions de MediaWiki : | 1.20 – 1.24 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_by_text | varchar(255) binary | NO | | NULL | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | | ipb_block_email | bool | NO | | 0 | | | ipb_allow_usertalk | bool | NO | | 0 | | | ipb_parent_block_id | int(10) | YES | MUL | NULL | | +----------------------+---------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.14 – 1.19 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_by_text | varchar(255) binary | NO | | NULL | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | | ipb_block_email | bool | NO | | 0 | | | ipb_allow_usertalk | bool | NO | | 0 | | +----------------------+---------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.13 |
DESCRIBE ipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+---------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_by_text | varchar(255) binary | NO | | NULL | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | | ipb_block_email | bool | NO | | 0 | | +----------------------+---------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.11 – 1.12 |
DESCRIBE ipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | | ipb_block_email | bool | NO | | 0 | | +----------------------+--------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.11 |
DESCRIBE ipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | | ipb_block_email | bool | NO | | 0 | | +----------------------+--------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.10 |
DESCRIBE ipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | binary(14) | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | varbinary(14) | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | | ipb_deleted | bool | NO | | 0 | | +----------------------+--------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.9 |
DESCRIBE ipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) binary | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_enable_autoblock | bool | NO | | 1 | | | ipb_expiry | char(14) binary | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | +----------------------+--------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.8 |
DESCRIBE ipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | tinyblob | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) binary | NO | MUL | NULL | | | ipb_auto | bool | NO | | 0 | | | ipb_anon_only | bool | NO | | 0 | | | ipb_create_account | bool | NO | | 1 | | | ipb_expiry | char(14) binary | NO | MUL | NULL | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | +--------------------+--------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.6 – 1.7 |
DESCRIBE ipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | varchar(40) binary | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) binary | NO | | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_expiry | char(14) binary | NO | | NULL | | | ipb_range_start | varchar(32) | NO | MUL | NULL | | | ipb_range_end | varchar(32) | NO | | NULL | | +--------------------+--------------------+------+-----+---------+----------------+
Versions de MediaWiki : | 1.2 – 1.5 |
DESCRIBE ipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | varchar(40) binary | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) binary | NO | | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_expiry | char(14) binary | NO | | NULL | | +--------------------+--------------------+------+-----+---------+----------------+
Version de MediaWiki : | 1.1 |
DESCRIBE ipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------------+------+-----+---------+----------------+ | ipb_id | int(8) | NO | PRI | NULL | AUTO_INCREMENT | | ipb_address | varchar(40) binary | NO | MUL | NULL | | | ipb_user | int(8) unsigned | NO | MUL | 0 | | | ipb_by | int(8) unsigned | NO | | 0 | | | ipb_reason | tinyblob | NO | | NULL | | | ipb_timestamp | char(14) binary | NO | | NULL | | | ipb_auto | tinyint(1) | NO | | 0 | | +--------------------+--------------------+------+-----+---------+----------------+
Index
Versions de MediaWiki : | 1.35 – 1.42 |
SHOW INDEX IN ipblocks;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks | 0 | PRIMARY | 1 | ipb_id | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 1 | ipb_address | A | 0 | 255 | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 2 | ipb_user | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 0 | ipb_address_unique | 3 | ipb_auto | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_user | 1 | ipb_user | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 1 | ipb_range_start | A | 0 | 8 | NULL | | BTREE | | | | ipblocks | 1 | ipb_range | 2 | ipb_range_end | A | 0 | 8 | NULL | | BTREE | | | | ipblocks | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_expiry | 1 | ipb_expiry | A | 0 | NULL | NULL | | BTREE | | | | ipblocks | 1 | ipb_parent_block_id | 1 | ipb_parent_block_id | A | 0 | NULL | NULL | YES | BTREE | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+