Příručka:Databázová tabulka ipblocks_old

From mediawiki.org

This page is a translated version of the page Manual:Ipblocks old table and the translation is 100% complete.

Tato tabulka byla přidána na r15482 .

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

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

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Ipblocks_old_table/cs&oldid=6550616"