Manual:Ipblocks old table/fr

Cette table a été introduite en.

Résumé du schéma
+-+-+--+-+-++ +-+-+--+-+-++ +-+-+--+-+-++
 * 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    |                |

Les index
 +--+++--+-+---+-+--++--++-+---+ +--+++--+-+---+-+--++--++-+---+ +--+++--+-+---+-+--++--++-+---+
 * 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      |         |               |