Manual:ipblocks/fr table
From Linux Web Expert
| ↑ Manuel:Contenu | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>ipblocks/fr</tvar> table</translate> |
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 : | <translate> ≥</translate> 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
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.33
| <translate> MediaWiki version:</translate> |
ID utilisateur de l'administrateur qui a fait le blocage.
<translate> (deprecated)</translate>; Obsolète et remplacé par ipb_by_actor.
ipb_by_text
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>"> 1.13 – 1.33
| <translate> MediaWiki versions:</translate> |
Nom d'utilisateur (sous forme textuelle) de l'administrateur qui a fait le blocage.
<translate> (deprecated in <tvar name=2>1.31</tvar>)</translate>; remplacé par ipb_by_actor.
ipb_by_actor
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.31
Gerrit change 380669| <translate> MediaWiki version:</translate> |
Ceci est une clé externe vers actor_id dans la table actor .
ipb_reason
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>"><translate> ≤</translate> 1.32
| <translate> MediaWiki version:</translate> |
Motif de blocage tel que donné par l'administrateur.
<translate> (deprecated)</translate>
Remplacé par les tables ipb_reason_id et comment .
ipb_reason_id
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.30
| <translate> MediaWiki version:</translate> |
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 : | <translate> ≥</translate> 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 : | <translate> ≥</translate> 1.9 |
S'il vaut 1, il active les autoblocages sur le bloc d'adresses.
ipb_expiry
| Version de MediaWiki : | <translate> ≥</translate> 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 : | <translate> ≥</translate> 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 : | <translate> ≥</translate> 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 : | <translate> ≥</translate> 1.11 |
S'il vaut 1, il empêche l'utilisateur d'accèder à Special:Emailuser.
ipb_allow_usertalk
| Version de MediaWiki : | <translate> ≥</translate> 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 : | <translate> ≥</translate> 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
<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> |
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
<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/fr;
+----------------------+---------------------+------+-----+---------+----------------+ | 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 | | +----------------------+---------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.38</tvar> is unsupported version</translate>">
1.36 – 1.38
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+---------+----------------+ | 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 | | +----------------------+---------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.35</tvar> is unsupported version</translate>">
1.34 – 1.35
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+---------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.33</tvar> is unsupported version</translate>">
1.33
| <translate> MediaWiki version:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+---------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">
1.32
| <translate> MediaWiki version:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+---------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.31</tvar> is unsupported version</translate>">
1.31
| <translate> MediaWiki version:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+---------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.30</tvar> is unsupported version</translate>">
1.30
| <translate> MediaWiki version:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+---------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">
1.25 – 1.29
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+------------------+------+-----+----------------+----------------+ | 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 | | +----------------------+------------------+------+-----+----------------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.24</tvar> is unsupported version</translate>">
1.20 – 1.24
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+---------+----------------+ | 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 | | +----------------------+---------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.19</tvar> is unsupported version</translate>">
1.14 – 1.19
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+---------+----------------+ | 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 | | +----------------------+---------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.13</tvar> is unsupported version</translate>">
1.13
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+----------------------+---------------------+------+-----+---------+----------------+ | 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 | | +----------------------+---------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.12</tvar> is unsupported version</translate>">
1.11 – 1.12
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+----------------------+--------------------+------+-----+---------+----------------+ | 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 | | +----------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.11</tvar> is unsupported version</translate>">
1.11
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+----------------------+--------------------+------+-----+---------+----------------+ | 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 | | +----------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.10</tvar> is unsupported version</translate>">
1.10
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+----------------------+--------------------+------+-----+---------+----------------+ | 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 | | +----------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.9</tvar> is unsupported version</translate>">
1.9
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+----------------------+--------------------+------+-----+---------+----------------+ | 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 | | +----------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>">
1.8
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+--------------------+--------------------+------+-----+---------+----------------+ | 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 | | +--------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.7</tvar> is unsupported version</translate>">
1.6 – 1.7
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+--------------------+--------------------+------+-----+---------+----------------+ | 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 | | +--------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.5</tvar> is unsupported version</translate>">
1.2 – 1.5
| <translate> MediaWiki versions:</translate> |
DESCRIBE ipblocks/fr;
+--------------------+--------------------+------+-----+---------+----------------+ | 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 | | +--------------------+--------------------+------+-----+---------+----------------+<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.1</tvar> is unsupported version</translate>">
1.1
| Version de MediaWiki : |
DESCRIBE ipblocks/fr;
+--------------------+--------------------+------+-----+---------+----------------+ | 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
<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>"><translate> ≥</translate> 1.35
| <translate> MediaWiki version:</translate> |
SHOW INDEX IN ipblocks/fr;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
