Manual:ipblocks_old/fi table
From Linux Web Expert
| ↑ Manual:Sisällöt | <translate> MediaWiki database layout</translate> | <translate> <tvar name=1>ipblocks_old/fi</tvar> table</translate> |
1.8
| MediaWiki version: |
This table was added in r15482.
Schema summary
1.8
| MediaWiki version: |
DESCRIBE ipblocks_old/fi;
+-----------------+-----------------+------+-----+---------+----------------+ | 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 | | +-----------------+-----------------+------+-----+---------+----------------+
Indeksit
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>"> 1.8
| MediaWiki version: |
SHOW INDEX IN ipblocks_old/fi;
+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | 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 | | | +--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
