Theipblocks 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, seeManual:Logging table.Starting from MediaWiki 1.42 this table will be replaced with the newblock andblock_target tables.

Primary key, introduced for privacy.

Blocked IP address in dotted-quad form or user name.

Blocked user ID or 0 for IP blocks.

User ID of the administrator who made the block.

(deprecated);Deprecated in favor ofipb_by_actor.

Text username of the administrator who made the block.

(deprecated in 1.31);Deprecated in favor ofipb_by_actor.

This is a foreign key toactor_id in theactor table.

Reason for the block given by the administrator.

(deprecated)ipb_reason_id and thecomment table should be used instead!

This is a foreign key tocomment_id in thecomment table.

Creation (or refresh) date in standard YMDHMS form.

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.

If set to 1, the block only applies to logged out users.

If set to 1, prevents account creation from matching IP addresses.

If set to 1, enables autoblocks to be created from the block.

Expiry time set by the administrator at the time of the block.A standard timestamp or the string 'infinity'.

The first IP in an IP range block.

The last IP in an IP range block.

Allows the entry to be flagged, hiding it from users and sysops.

If set to 1, prevents the user from accessing Special:Emailuser.

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.

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.

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 theipblocks_restrictions table.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• Help:Range blocks
• Manual:Block and unblock

• MediaWiki database tables