Extension:EImage/ei pages table
The ei_pages table was introduced since version 3.4; Used by Special:EImagePages page.
Fields
ei_page
Numeric id pages (curid) where is the clip used.
ei_image
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
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
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 | | | +----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+