Manual:Ipblocks restrictions table/de

The ipblocks_restrictions table stores restrictions related to.

ir_ipb_id
The of the block this restriction relates to.

ir_type
The Type of the Block.


 * 1 = Page
 * 2 = Namespace

ir_value
The value of the block restriction. For pages this is a for Namespaces, this is a namespace id found in config.

Schematische Übersicht
+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type             | Null | Key | Default | Extra |
 * ir_ipb_id | int(10) unsigned | NO  | PRI | NULL    |       |
 * ir_type  | tinyint(4)       | NO   | PRI | NULL    |       |
 * ir_value | int(10) unsigned | NO   | PRI | NULL    |       |

+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field    | Type             | Null | Key | Default | Extra |
 * ir_ipb_id | int(11)         | NO   | PRI | NULL    |       |
 * ir_type  | tinyint(4)       | NO   | PRI | NULL    |       |
 * ir_value | int(10) unsigned | NO   | PRI | NULL    |       |

+---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * Field    | Type       | Null | Key | Default | Extra |
 * ir_ipb_id | int(11)   | NO   | PRI | NULL    |       |
 * ir_type  | tinyint(4) | NO   | PRI | NULL    |       |
 * ir_value | int(11)    | NO   | PRI | NULL    |       |

+---++--+-+-+---+ +---++--+-+-+---+ +---++--+-+-+---+
 * Field    | Type       | Null | Key | Default | Extra |
 * ir_ipb_id | int(11)   | NO   | PRI | NULL    |       |
 * ir_type  | tinyint(1) | NO   | PRI | NULL    |       |
 * ir_value | int(11)    | NO   | PRI | NULL    |       |

Indexe
 +---++---+--+-+---+-+--++--++-+---+ +---++---+--+-+---+-+--++--++-+---+ +---++---+--+-+---+-+--++--++-+---+
 * Table                | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * ipblocks_restrictions |         0 | PRIMARY       |            1 | ir_ipb_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * ipblocks_restrictions |         0 | PRIMARY       |            2 | ir_type     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * ipblocks_restrictions |         0 | PRIMARY       |            3 | ir_value    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * ipblocks_restrictions |         1 | ir_type_value |            1 | ir_type     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * ipblocks_restrictions |         1 | ir_type_value |            2 | ir_value    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |