Manual:ipblocks_old table
| ↑ Manual:Contents | MediaWiki database layout | ipblocks_old table |
| MediaWiki version: | 1.8 |
This table was added in r15482.
Schema summary
[edit]| MediaWiki version: | 1.8 |
DESCRIBE ipblocks_old;
+-----------------+-----------------+------+-----+---------+----------------+ | 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 | | | | ipb_auto | tinyint(1) | NO | | 0 | | | ipb_expiry | char(14) | NO | MUL | | | | ipb_range_start | tinyblob | NO | MUL | NULL | | | ipb_range_end | tinyblob | NO | | NULL | | +-----------------+-----------------+------+-----+---------+----------------+
Indexes
[edit]| MediaWiki version: | 1.8 |
SHOW INDEX IN ipblocks_old;
+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | ipblocks_old | 0 | PRIMARY | 1 | ipb_id | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_old | 0 | ipb_address_unique | 1 | ipb_address | A | 0 | 255 | NULL | | BTREE | | | | ipblocks_old | 0 | ipb_address_unique | 2 | ipb_user | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_old | 0 | ipb_address_unique | 3 | ipb_auto | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_old | 1 | ipb_user | 1 | ipb_user | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_old | 1 | ipb_range | 1 | ipb_range_start | A | 0 | 8 | NULL | | BTREE | | | | ipblocks_old | 1 | ipb_range | 2 | ipb_range_end | A | 0 | 8 | NULL | | BTREE | | | | ipblocks_old | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 0 | NULL | NULL | | BTREE | | | | ipblocks_old | 1 | ipb_expiry | 1 | ipb_expiry | A | 0 | NULL | NULL | | BTREE | | | +--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+