手册:IP封禁表
↑ 手册:索引 | 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 |
ipb_reason
MediaWiki版本: | ≤ 1.32 |
管理员提供的封禁的原因。
(已弃用)
ipb_reason_id
和comment
表应改为!
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 | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+