Manual:Ipblocks table

↑ Manual:Contents

MediaWiki database layout

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.

Fields

ipb_id

MediaWiki version:

≥ 1.2

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

MediaWiki version:

≥ 1.13

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

MediaWiki version:

≥ 1.6

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

MediaWiki version:

≥ 1.6

Enables autoblock on the block.

ipb_expiry

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

MediaWiki version:

≥ 1.6

The first IP in an IP range block.

ipb_range_end

The last IP in an IP range block.

ipb_deleted

MediaWiki version:

≥ 1.10

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

ipb_block_email

MediaWiki version:

≥ 1.11

Prevents the user from accessing Special:Emailuser

ipb_allow_usertalk

MediaWiki version:

≥ 1.14

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

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.

Current version

MediaWiki version:

≥ 1.21

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

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

MediaWiki version:

1.14

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

MediaWiki version:

1.13

MediaWiki version:

1.12

MediaWiki version:

1.11

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

MediaWiki version:

1.10

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

MediaWiki version:

1.9

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

MediaWiki version:

1.8

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

MediaWiki version:

1.7

MediaWiki version:

1.6

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

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist

See also

• Help:Range blocks
• Manual:Administrators#Block and unblock