Manual:ipblocks table
| ↑ Manual:Contents | MediaWiki database layout | ipblocks table |
| MediaWiki version: | ≤ 1.42 |
The ipblocks table stores details of IP addresses and users who are blocked from editing.
The name "ipblocks" is a legacy name, as now user account blocks are also stored in this table.
For previous blocks, see Manual:Logging table.
Starting from MediaWiki 1.42 this table will be replaced with the new block and block_target tables.
Fields
[edit]ipb_id
[edit]| MediaWiki version: | ≥ 1.2 |
Primary key, introduced for privacy.
ipb_address
[edit]Blocked IP address in dotted-quad form or user name.
ipb_user
[edit]Blocked user ID or 0 for IP blocks.
ipb_by
[edit]| MediaWiki version: | ≤ 1.33 |
User ID of the administrator who made the block.
(deprecated); Deprecated in favor of ipb_by_actor.
ipb_by_text
[edit]| MediaWiki versions: | 1.13 – 1.33 |
Text username of the administrator who made the block.
(deprecated in 1.31); Deprecated in favor of ipb_by_actor.
ipb_by_actor
[edit]| MediaWiki version: | ≥ 1.31 Gerrit change 380669 |
This is a foreign key to actor_id in the actor table.
ipb_reason
[edit]| MediaWiki version: | ≤ 1.32 |
Reason for the block given by the administrator.
(deprecated)
ipb_reason_id and the comment table should be used instead!
ipb_reason_id
[edit]| MediaWiki version: | ≥ 1.30 |
This is a foreign key to comment_id in the comment table.
ipb_timestamp
[edit]Creation (or refresh) date in standard YMDHMS form.
ipb_auto
[edit]Indicates that the IP address was blocked because a blocked user accessed a page through it.
If this is 1, ipb_address will be hidden.
ipb_anon_only
[edit]| MediaWiki version: | ≥ 1.8 |
If set to 1, the block only applies to logged out users.
ipb_create_account
[edit]If set to 1, prevents account creation from matching IP addresses.
ipb_enable_autoblock
[edit]| MediaWiki version: | ≥ 1.9 |
If set to 1, enables autoblocks to be created from the block.
ipb_expiry
[edit]| MediaWiki version: | ≥ 1.2 |
Expiry time set by the administrator at the time of the block. A standard timestamp or the string 'infinity'.
ipb_range_start
[edit]| MediaWiki version: | ≥ 1.6 |
The first IP in an IP range block.
ipb_range_end
[edit]The last IP in an IP range block.
ipb_deleted
[edit]| MediaWiki version: | ≥ 1.10 |
Allows the entry to be flagged, hiding it from users and sysops.
ipb_block_email
[edit]| MediaWiki version: | ≥ 1.11 |
If set to 1, prevents the user from accessing Special:Emailuser.
ipb_allow_usertalk
[edit]| MediaWiki version: | ≥ 1.14 |
Indicates whether the blocked user is blocked from editing their talk page. A value of 1 means that the user is allowed to edit their user talk page.
ipb_parent_block_id
[edit]| MediaWiki version: | ≥ 1.20 |
ID of the block that caused this block to exist. Autoblocks set this to the original block so that the original block being deleted also deletes the autoblocks.
ipb_sitewide
[edit]| MediaWiki version: | ≥ 1.32 |
Indicates whether the block is sitewide or partial. A value of 0 indicates that the block is partial. A partial block can block a user from specific pages, namespaces or actions. If a partial block blocks a user from any pages or namespaces, these are stored in the ipblocks_restrictions table.
Schema summary
[edit]| MediaWiki versions: | 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 versions: | 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 versions: | 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 version: | 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 version: | 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 version: | 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 version: | 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 versions: | 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 versions: | 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 versions: | 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 version: | 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 versions: | 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 version: | 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 version: | 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 version: | 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 version: | 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 versions: | 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 versions: | 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 version: | 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 | | +--------------------+--------------------+------+-----+---------+----------------+
Indexes
[edit]| MediaWiki versions: | 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 | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+