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
]
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
]
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
]
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
]
If set to 1, enables autoblocks to be created from the block.
ipb_expiry
[
edit
]
Expiry time set by the administrator at the time of the block.
A standard timestamp or the string 'infinity'.
ipb_range_start
[
edit
]
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 | |
+----------------------+---------------------+------+-----+----------------+----------------+
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 | |
+----------------------+---------------------+------+-----+----------------+----------------+
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 | |
+----------------------+---------------------+------+-----+----------------+----------------+
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 | |
+----------------------+---------------------+------+-----+----------------+----------------+
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 | |
+----------------------+---------------------+------+-----+---------+----------------+
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 | |
+----------------------+--------------------+------+-----+---------+----------------+
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 | |
+----------------------+--------------------+------+-----+---------+----------------+
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 | |
+----------------------+--------------------+------+-----+---------+----------------+
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 | |
+----------------------+--------------------+------+-----+---------+----------------+
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 | |
+--------------------+--------------------+------+-----+---------+----------------+
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 | | |
+----------+------------+---------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
See also
[
edit
]
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|