Podręcznik:Tabela imagelinks

↑ Podręcznik:Spis treści

Opis i struktura bazy danych MediaWiki

Tabela imagelinks

Tabela imagelinks przechowuje dane dotyczące umieszczania plików w artykułach. Jest to przydatne dla takich funkcji jak "Linkujące". Note that some images may be on a foreign file repository.

Pola

il_from

page_id strony na której umieszczony jest link do pliku.

il_from_namespace

Wersja MediaWiki:

≥ 1.24

page_namespace of the page containing the link.

il_to

tytuł linkowanego pliku.

Podsumowanie struktury

Wersja MediaWiki:

≥ 1.36

DESCRIBE imagelinks;

+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| il_from           | int(10) unsigned | NO   | PRI | 0       |       |
| il_to             | varbinary(255)   | NO   | PRI |         |       |
| il_from_namespace | int(11)          | NO   | MUL | 0       |       |
+-------------------+------------------+------+-----+---------+-------+

Wersje MediaWiki:

1.26 – 1.35

DESCRIBE imagelinks;

+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| il_from           | int(10) unsigned | NO   | PRI | 0       |       |
| il_from_namespace | int(11)          | NO   | MUL | 0       |       |
| il_to             | varbinary(255)   | NO   | PRI |         |       |
+-------------------+------------------+------+-----+---------+-------+

Wersje MediaWiki:

1.24 – 1.25

DESCRIBE imagelinks;

+-------------------+------------------+------+-----+---------+-------+
| Field             | Type             | Null | Key | Default | Extra |
+-------------------+------------------+------+-----+---------+-------+
| il_from           | int(10) unsigned | NO   | PRI | 0       |       |
| il_from_namespace | int(11)          | NO   |     | 0       |       |
| il_to             | varbinary(255)   | NO   | PRI |         |       |
+-------------------+------------------+------+-----+---------+-------+

Wersje MediaWiki:

1.10 – 1.23

DESCRIBE imagelinks;

+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | int(10) unsigned    | NO   | PRI | 0       |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+

Wersje MediaWiki:

1.3 – 1.9

DESCRIBE imagelinks;

+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | int(8) unsigned     | NO   | PRI | 0       |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+

Wersje MediaWiki:

1.1 – 1.2

DESCRIBE imagelinks;

+---------+---------------------+------+-----+---------+-------+
| Field   | Type                | Null | Key | Default | Extra |
+---------+---------------------+------+-----+---------+-------+
| il_from | varchar(255) binary | NO   | PRI | NULL    |       |
| il_to   | varchar(255) binary | NO   | PRI | NULL    |       |
+---------+---------------------+------+-----+---------+-------+