Manual:ipblocks old table

From MediaWiki.org
Jump to navigation Jump to search
Other languages:
English • ‎日本語
Manual:Contents MediaWiki database layout ipblocks old table


This table was added in r15482.

Schema summary[edit]

MediaWiki version: 1.6

DESCRIBE ipblocks_old;

+-----------------+-----------------+------+-----+---------+----------------+
| Field           | Type            | Null | Key | Default | Extra          |
+-----------------+-----------------+------+-----+---------+----------------+
| ipb_id          | int(8)          | NO   | PRI | NULL    | auto_increment |
| ipb_address     | varchar(40)     | NO   | MUL |         |                |
| 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   |     |         |                |
| ipb_auto        | tinyint(1)      | NO   |     | 0       |                |
| ipb_expiry      | char(14)        | NO   |     |         |                |
| ipb_range_start | varchar(32)     | NO   | MUL |         |                |
| ipb_range_end   | varchar(32)     | NO   |     |         |                |
+-----------------+-----------------+------+-----+---------+----------------+