Extension:EImage/ei pages table
| â 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 | | | +----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+