Jump to content

Manüel:Ip engelleme kısıtlamaları tablosu

From mediawiki.org
This page is a translated version of the page Manual:Ipblocks restrictions table and the translation is 92% complete.
Manual:İçindekiler MediaWiki veritabanı düzeni ipblocks_restrictions tablosu

ipblocks_restrictions tablosu, Engel ile ilgili kısıtlamaları saklar.

Alanlar

ir_ipb_id

MediaWiki sürümü:
1.32

Bu kısıtlamanın ilgili olduğu bloğun ipb_id 'dir.

ir_type

MediaWiki sürümü:
1.32

Bloğun Türü.

  • 1 = Sayfa
  • 2 = Ad alanı

ir_value

MediaWiki sürümü:
1.32

Blok kısıtlamasının değeri. Bu, Ad Alanları için page_id olan sayfalar için, yapım dosyasında bulunan bir ad alanı kimliğidir.

Şema özeti

MediaWiki sürümü:
1.39

DESCRIBE ipblocks_restrictions;

+-----------+------------------+------+-----+---------+-------+
| 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    |       |
+-----------+------------------+------+-----+---------+-------+
MediaWiki sürümü:
1.38

DESCRIBE ipblocks_restrictions;

+-----------+------------------+------+-----+---------+-------+
| 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    |       |
+-----------+------------------+------+-----+---------+-------+
MediaWiki sürümleri:
1.36 – 1.37

DESCRIBE ipblocks_restrictions;

+-----------+------------+------+-----+---------+-------+
| 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    |       |
+-----------+------------+------+-----+---------+-------+
MediaWiki sürümleri:
1.32 – 1.35

DESCRIBE ipblocks_restrictions;

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

Indexes

MediaWiki sürümü:
1.32

SHOW INDEX IN ipblocks_restrictions;

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

Ayrıca bakınız