Manual:Ipblocks table

The ipblocks table stores details of IP addresses and users who have been blocked from editing. The name "ipblocks" is a legacy name, as now user account blocks are also stored in this table.

ipb_id
Primary key, introduced for privacy.

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

ipb_user
Blocked user ID or 0 for IP blocks.

ipb_by
User ID of the administrator who made the block.

ipb_by_text
Text username of the administrator who made the block.

ipb_reason
Reason for the block given by the administrator.

ipb_timestamp
Creation (or refresh) date in standard YMDHMS form.

ipb_auto
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
If set to 1, the block only applies to logged out users.

ipb_create_account
Prevents account creation from matching IP addresses.

ipb_enable_autoblock
Enables autoblock on the block.

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

ipb_range_start
The first IP in an IP range block.

ipb_range_end
The last IP in an IP range block.

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

ipb_block_email
Prevents the user from accessing Special:Emailuser

ipb_allow_usertalk
Prevents a blocked user from editing their talk page. A value of 1 means that the user is not allowed to edit his user talk page. (Thus, a less confusing name would have been ipb_block_usertalk).

ipb_parent_block_id
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.

Current version
mysql> describe ipblocks; +--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++ 18 rows in set (0.00 sec)
 * 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          | tinyblob         | 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           |                |

Previous Versions
+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * Field               | Type             | Null | Key | Default        | Extra          |
 * ipb_id              | int(11)          | NO   | PRI |                | auto_increment |
 * ipb_address         | tinyblob         | NO   |     |                |                |
 * ipb_user            | int(10) unsigned | NO   | MUL | 0              |                |
 * ipb_by              | int(10) unsigned | NO   |     | 0              |                |
 * ipb_by_text         | varbinary(255)   | NO   |     |                |                |
 * ipb_reason          | tinyblob         | NO   |     |                |                |
 * ipb_timestamp       | binary(14)       | NO   | MUL |                |                |
 * 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 |                |                |
 * 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              |                |

+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * 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         | varchar(255)     | NO   |     |                |                |
 * ipb_reason          | tinyblob         | NO   |     | NULL           |                |
 * ipb_timestamp       | binary(14)       | NO   | MUL |                |                |
 * 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 |                |                |
 * ipb_range_start     | tinyblob         | NO   | MUL | NULL           |                |
 * ipb_range_end       | tinyblob         | NO   |     | NULL           |                |
 * ipb_deleted         | bool             | NO   |     | 0              |                |
 * ipb_block_email     | bool             | NO   |     | 0              |                |

+--+--+--+-+++ +--+--+--+-+++ +--+--+--+-+++
 * 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         | varchar(255)     | NO   |     |                |                |
 * ipb_reason          | tinyblob         | NO   |     | NULL           |                |
 * ipb_timestamp       | binary(14)       | NO   | MUL |                |                |
 * 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 |                |                |
 * ipb_range_start     | tinyblob         | NO   | MUL | NULL           |                |
 * ipb_range_end       | tinyblob         | NO   |     | NULL           |                |
 * ipb_deleted         | bool             | NO   |     | 0              |                |

+--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++
 * 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)        | 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)        | NO   | MUL | NULL    |                |
 * ipb_range_start     | tinyblob        | NO   | MUL | NULL    |                |
 * ipb_range_end       | tinyblob        | NO   |     | NULL    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * 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)        | NO   | MUL | NULL    |                |
 * ipb_auto          | bool            | NO   |     | 0       |                |
 * ipb_anon_only     | bool            | NO   |     | 0       |                |
 * ipb_create_account | bool           | NO   |     | 1       |                |
 * ipb_expiry        | char(14)        | NO   | MUL | NULL    |                |
 * ipb_range_start   | tinyblob        | NO   | MUL | NULL    |                |
 * ipb_range_end     | tinyblob        | NO   |     | NULL    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * 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)        | NO   | MUL | NULL    |                |
 * ipb_auto          | tinyint(1)      | NO   |     | 0       |                |
 * ipb_expiry        | char(14)        | NO   | MUL | NULL    |                |
 * ipb_range_start   | tinyblob        | NO   | MUL | NULL    |                |
 * ipb_range_end     | tinyblob        | NO   |     | NULL    |                |

++-+--+-+-++ ++-+--+-+-++ ++-+--+-+-++
 * 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)        | NO   | MUL | NULL    |                |
 * ipb_auto          | tinyint(1)      | NO   |     | 0       |                |
 * ipb_expiry        | char(14)        | NO   | MUL | NULL    |                |