Jump to content

Extension:EImage/ei pages table

From mediawiki.org


Manual:Contents MediaWiki database layout eimage table

The ei_pages table was introduced since version 3.4; Used by Special:EImagePages page.

Fields

[edit]

ei_page

[edit]

Numeric id pages (curid) where is the clip used.

ei_image

[edit]

Sha1 checksum of the clip content, which is storage in cache. It's base string for clip and thumbnail name, and same value as use 'ei_file' field from 'ei_cache' table.

Schema summary

[edit]

DESCRIBE ei_pages;

+----------+------------------+------+-----+---------+-------+
| Field    | Type             | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+-------+
| ei_page  | int(10) unsigned | NO   | PRI | NULL    |       |
| ei_image | varbinary(40)    | NO   | PRI | NULL    |       |
+----------+------------------+------+-----+---------+-------+

Indexes

[edit]

SHOW INDEX IN ei_pages;

+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| ei_pages |          0 | ei_page_image |            1 | ei_page     | A         |           5 |     NULL | NULL   |      | BTREE      |         |               |
| ei_pages |          0 | ei_page_image |            2 | ei_image    | A         |          11 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+