Manual:collation table
| ↑ Manual:Contents | MediaWiki database layout | collation table |
| MediaWiki version: | ≥ 1.44 |
Normalization table for collation names.
Fields
[edit]collation_id
[edit]Primary key.
collation_name
[edit]Collation name.
Schema summary
[edit]| MediaWiki version: | ≥ 1.44 |
DESCRIBE collation;
+----------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+----------------------+------+-----+---------+----------------+ | collation_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment | | collation_name | varbinary(64) | NO | UNI | NULL | | +----------------+----------------------+------+-----+---------+----------------+
Indexes
[edit]| MediaWiki version: | ≥ 1.44 |
SHOW INDEX IN collation;
+-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | collation | 0 | PRIMARY | 1 | collation_id | A | 0 | NULL | NULL | | BTREE | | | | collation | 0 | collation_name | 1 | collation_name | A | 0 | NULL | NULL | | BTREE | | | +-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+