Extension:CheckUser/cuci wiki map table

MediaWiki version:

≥ 1.43

A table for the CheckUser extension used to map wiki IDs (otherwise known as wiki DB name) to an integer ID. The rows in this table are referenced by the cite_ciwm_id and ciu_ciwm_id columns.

This table is in a set of tables that begin with the cuci_ prefix which are used to index the CheckUser result tables on multiple wikis. For single wiki installs, these tables are unused but are still created as there is not an easy way to determine if a wiki is in a multi-wiki install.

Fields

ciwm_id

Unique ID to identify each wiki ID. The primary key can be a smallint as the number of rows matches the number of wikis in an install, therefore ~65,000 is IDs is enough.

ciwm_wiki

The wiki ID as a string. This is indexed by a unique index to ensure that only one row exists for each wiki ID.

Schema

DESCRIBE cuci_wiki_map;

+-----------+----------------------+------+-----+---------+----------------+
| Field     | Type                 | Null | Key | Default | Extra          |
+-----------+----------------------+------+-----+---------+----------------+
| ciwm_id   | smallint(5) unsigned | NO   | PRI | NULL    | auto_increment |
| ciwm_wiki | varbinary(255)       | NO   | UNI | NULL    |                |
+-----------+----------------------+------+-----+---------+----------------+

Indexes

SHOW INDEX IN cuci_wiki_map;

+---------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table         | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+---------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| cuci_wiki_map |          0 | PRIMARY   |            1 | ciwm_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_wiki_map |          0 | ciwm_wiki |            1 | ciwm_wiki   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+---------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+