Manual:ipblocks table
From mediawiki.org
Languages:
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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+------------------+------+-----+----------------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+---------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+----------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | 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
DESCRIBEipblocks;
+--------------------+--------------------+------+-----+---------+----------------+ | 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
SHOWINDEXINipblocks;
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+