Extension:CheckUser/cuci user table

MediaWiki version:
1.43

A table for the CheckUser extension used find the wikis that a given account has edited on.

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

edit

ciu_central_id

edit

The central ID associated with this row. Used in the composite primary key.

ciu_ciwm_id

edit

The wiki ID associated with this row. The ID for a row in the cuci_wiki_map table. Used in the composite primary key.

ciu_timestamp

edit

The most recent timestamp for actions associated with this central ID and IP.

Schema

edit

DESCRIBE cuci_user;

+----------------+----------------------+------+-----+---------+-------+
| Field          | Type                 | Null | Key | Default | Extra |
+----------------+----------------------+------+-----+---------+-------+
| ciu_central_id | int(10) unsigned     | NO   | PRI | NULL    |       |
| ciu_ciwm_id    | smallint(5) unsigned | NO   | PRI | NULL    |       |
| ciu_timestamp  | binary(14)           | NO   | MUL | NULL    |       |
+----------------+----------------------+------+-----+---------+-------+

Indexes

edit

SHOW INDEX IN cuci_user;

+-----------+------------+--------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table     | Non_unique | Key_name                 | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-----------+------------+--------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| cuci_user |          0 | PRIMARY                  |            1 | ciu_central_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_user |          0 | PRIMARY                  |            2 | ciu_ciwm_id    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_user |          1 | ciu_timestamp            |            1 | ciu_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_user |          1 | ciu_central_id_timestamp |            1 | ciu_central_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_user |          1 | ciu_central_id_timestamp |            2 | ciu_timestamp  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+-----------+------------+--------------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+