The ipblocks table stores details of IP addresses and users who have been blocked from editing.
+----------------------+------------------+------+-----+----------------+----------------+
| 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 | |
+----------------------+------------------+------+-----+----------------+----------------+
[edit] Fields
- 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 banned because a banned 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.
Related pages: range blocks, admininstrator's guide to blocking, bans, bans and blocks.
[edit] Previous Versions
+----------------------+------------------+------+-----+----------------+----------------+
| 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 | |
+--------------------+-----------------+------+-----+---------+----------------+
| MediaWiki version: |
1.5 |
and previous version |
+--------------------+-----------------+------+-----+---------+----------------+
| 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 | |
+--------------------+-----------------+------+-----+---------+----------------+
