| MediaWiki version: | 1.8 |
This table was added inr15482.
| MediaWiki version: | 1.8 |
DESCRIBEipblocks_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 | |+-----------------+-----------------+------+-----+---------+----------------+
| MediaWiki version: | 1.8 |
SHOWINDEXINipblocks_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 | | |+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+