Manuel:table ipblocks

From mediawiki.org
This page is a translated version of the page Manual:Ipblocks table and the translation is 100% complete.
Manuel:Contenu Schéma de base de données MédiaWiki table ipblocks

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 .

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 ipb_reason_id et 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

Version de MediaWiki :
1.39

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

Version de MediaWiki :
1.35

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

Voir aussi