Extension:CheckUser/cuci wiki map table

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.

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.

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

DESCRIBEcuci_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 | |
+-----------+----------------------+------+-----+---------+----------------+

SHOWINDEXINcuci_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 |
+---------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

• Wikimedia extension database tables