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

↑ Manuál:Obsah

MediaWiki schéma databáze

Tabulka links

Verze MediaWiki:

1.1 – 1.3

Tabulka links byla zároveň s tabulkou brokenlinks sloučena do jedné tabulky pagelinks , která zaznamenává kombinaci jmenného prostoru + klíče názvu cílové stránky, místo jejího ID či názvu doplněného nějakým prefixem. Viz [1]

The links table stored all the links to existing articles. This was good for a variety of functions, from link caching in the output functions to the "what links here" page. It was the "good twin" of the brokenlinks table.

Od MediaWiki verze 1.5 se tahle tabulka nepoužívá, takže ji můžete bez problému z databáze odstranit. The contents have been migrated to the table pagelinks on update. Regenerating the pagelinks table always is possible using the rebuildall maintenance script.

Pole

l_from

l_from is the cur_id of the article that contains the link. (This is a change from 1.2, wherein the title of the article was stored. This was not very wise, and has now been fixed.)

l_to

l_to is the cur_id of the "target" article.

Přehled změn ve schématu tabulky

Verze MediaWiki:

1.3

+--------+-----------------+------+-----+---------+-------+
| Field  | Type            | Null | Key | Default | Extra |
+--------+-----------------+------+-----+---------+-------+
| l_from | int(8) unsigned | NO   | PRI | 0       |       |
| l_to   | int(8) unsigned | NO   | PRI | 0       |       |
+--------+-----------------+------+-----+---------+-------+

Verze MediaWiki:

1.2

+--------+-----------------+------+-----+---------+-------+
| Field  | Type            | Null | Key | Default | Extra |
+--------+-----------------+------+-----+---------+-------+
| l_from | varchar(255)    | NO   | PRI |         |       |
| l_to   | int(8) unsigned | NO   | PRI | 0       |       |
+--------+-----------------+------+-----+---------+-------+

Verze MediaWiki:

1.1

+--------+-----------------+------+-----+---------+-------+
| Field  | Type            | Null | Key | Default | Extra |
+--------+-----------------+------+-----+---------+-------+
| l_from | varchar(255)    | NO   |     |         |       |
| l_to   | int(8) unsigned | NO   |     | 0       |       |
+--------+-----------------+------+-----+---------+-------+

Indexy

Verze MediaWiki:

1.3

SHOW INDEX IN links;

+--------+-----------------+------+-----+---------+-------+
| Field  | Type            | Null | Key | Default | Extra |
+--------+-----------------+------+-----+---------+-------+
| l_from | int(8) unsigned | NO   | PRI | 0       |       |
| l_to   | int(8) unsigned | NO   | PRI | 0       |       |
+--------+-----------------+------+-----+---------+-------+