Manual:ipblocks_old/ja table

From Linux Web Expert


Manual:コンテンツ <translate> MediaWiki database layout</translate> <translate> <tvar name=1>ipblocks_old/ja</tvar> table</translate>
<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>">
1.8
MediaWiki バージョン:

このテーブルは r15482 で導入されました。

スキーマの要約

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>">
1.8
MediaWiki バージョン:

DESCRIBE ipblocks_old/ja;

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

インデックス

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.8</tvar> is unsupported version</translate>">
1.8
MediaWiki バージョン:

SHOW INDEX IN ipblocks_old/ja;

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