手册:IP封禁表

This page is a translated version of the page Manual:Ipblocks table and the translation is 95% complete.
手册:索引 MediaWiki数据库布局 ipblocks表
MediaWiki版本:
1.42

ipblocks表存储被阻止编辑的IP地址和用户的详细信息。 名称“ipblocks”是一个传统名称,因为现在用户帐户封禁也存储在此表中。 有关之前的封禁,请参阅手册:logging表 Starting from MediaWiki 1.42 this table will be replaced with the new block and block_target tables.

字段

ipb_id

MediaWiki版本:
1.2

主要密钥,为隐私而引入。

ipb_address

被阻止的四分点形式的IP地址或用户名。

ipb_user

被封禁的用户ID或0表示IP。

ipb_by

MediaWiki版本:
1.33

实施封禁的管理员的用户ID。

(已弃用); Deprecated in favor of ipb_by_actor.

ipb_by_text

MediaWiki版本:
1.13 – 1.33

实施封禁的管理员的用户名文本。

(在1.31版本中已弃用); 已弃用,被ipb_by_actor替换。

ipb_by_actor

MediaWiki版本:
1.31
Gerrit change 380669

这是actor 表中actor_id 的外键。

ipb_reason

MediaWiki版本:
1.32

管理员提供的封禁的原因。

(已弃用) ipb_reason_idcomment表应改为!

ipb_reason_id

MediaWiki版本:
1.30

这是comment 表中comment_id 的外键。

ipb_timestamp

标准年月日时分秒格式的创建(或刷新)日期。

ipb_auto

指示该IP地址被阻止,因为被阻止的用户通过它访问页面。 如果这是1,ipb_address将会隐藏。

ipb_anon_only

MediaWiki版本:
1.8

如果设置为1,则阻止仅适用于已注销的用户。

ipb_create_account

如果设置为1,则阻止帐户创建与IP地址匹配。

ipb_enable_autoblock

MediaWiki版本:
1.9

如果设置为1,则允许从封禁创建自动封禁。

ipb_expiry

MediaWiki版本:
1.2

由管理员在阻止时设置的过期时间。 标准时间戳或字符串‘infinity(仅允许管理员手动解封)’。

ipb_range_start

MediaWiki版本:
1.6

IP段封中的第一个IP。

ipb_range_end

IP段封中的最后一个IP。

ipb_deleted

MediaWiki版本:
1.10

允许标记条目,对用户和sysop隐藏该条目。

ipb_block_email

MediaWiki版本:
1.11

如果设置为1,则阻止用户访问Special:Emailuser。

ipb_allow_usertalk

MediaWiki版本:
1.14

指示是否阻止被阻止的用户编辑其对话页面。 值为1表示允许用户编辑其用户对话页面。

ipb_parent_block_id

MediaWiki版本:
1.20

导致此封禁存在的封禁的ID。 自动块将其设置为原始封禁,以便被删除的原始块也会删除自动封禁。

ipb_sitewide

MediaWiki版本:
1.32

指示封禁是站点范围还是部分封禁。 值为0表示封禁是部分的。 部分封禁可以阻止用户访问特定页面、命名空间或操作。 如果部分封禁阻止用户访问任何页面或名称空间,则这些页面或名称空间将存储在ipblocks_restrictions 表中。

架构摘要

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

索引

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

参见