Movatterモバイル変換


[0]ホーム

URL:


Jump to content
MediaWiki
Search

Manual:ipblocks_old table

From mediawiki.org
Translate this page
Languages:
Manual:Contents
MediaWiki database layout
ipblocks_old table
MediaWiki version:
1.8

This table was added inr15482.

Schema summary

[edit]
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    |                |+-----------------+-----------------+------+-----+---------+----------------+

Indexes

[edit]
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      |         |               |+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Engines
Current
Former
Technical documentation
Configuration
Development
Core tables
Current
Former
Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Ipblocks_old_table&oldid=5065740"

[8]ページ先頭

©2009-2025 Movatter.jp