Manuel:table linkscc
↑ Manuel:Contenu | Schéma de base de données MédiaWiki | table linkscc |
Version de MediaWiki : | ≤ 1.4 |
La table linkscc met en cache les données des liens pour le rendu.
Résumé du schéma
Versions de MediaWiki : | 1.3 – 1.4 |
DESCRIBE linkscc;
+--------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+-------+ | lcc_pageid | int(10) unsigned | NO | PRI | NULL | | | lcc_cacheobj | mediumblob | NO | | NULL | | +--------------+------------------+------+-----+---------+-------+
Versions de MediaWiki : | 1.1 – 1.2 |
DESCRIBE linkscc;
+--------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------------+------+-----+---------+-------+ | lcc_pageid | int(10) unsigned | NO | PRI | NULL | | | lcc_title | varchar(255) | NO | UNI | NULL | | | lcc_cacheobj | mediumblob | NO | | NULL | | +--------------+------------------+------+-----+---------+-------+
Les index
Versions de MediaWiki : | 1.3 – 1.4 |
SHOW INDEX IN linkscc;
+---------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | linkscc | 0 | lcc_pageid | 1 | lcc_pageid | A | 0 | NULL | NULL | | BTREE | | | +---------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+