Extension:CheckUser/cusi user table

MediaWiki version:

≥ 1.45

A table for the CheckUser extension stored on the checkuser-virtual database domain.

This table is in a set of tables that begin with the cusi_ prefix which are used by the Suggested Investigations feature.

Fields

siu_sic_id

The ID of a row in the cusi_case table that this row is associated with. Part of the composite primary key.

siu_user_id

The user ID of a user associated with the case. Part of the composite primary key.

siu_info

MediaWiki version:

≥ 1.46

A bitfield column storing information about the user for the case. Set by signal logic which may be in private code.

Schema

MediaWiki version:

≥ 1.46

DESCRIBE cusi_signal;

+-------------+------------------+------+-----+---------+-------+
| Field       | Type             | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| siu_user_id | int(10) unsigned | NO   | PRI | NULL    |       |
| siu_sic_id  | int(10) unsigned | NO   | PRI | NULL    |       |
| siu_info    | int(10) unsigned | NO   |     | 0       |       |
+-------------+------------------+------+-----+---------+-------+

MediaWiki version:

1.45

DESCRIBE cusi_signal;

+-------------+------------------+------+-----+---------+-------+
| Field       | Type             | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+-------+
| siu_user_id | int(10) unsigned | NO   | PRI | NULL    |       |
| siu_sic_id  | int(10) unsigned | NO   | PRI | NULL    |       |
+-------------+------------------+------+-----+---------+-------+

Indexes

SHOW INDEX IN cusi_user;

+-----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table     | Non_unique | Key_name    | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| cusi_user |          0 | PRIMARY     |            1 | siu_sic_id  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cusi_user |          0 | PRIMARY     |            2 | siu_user_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cusi_user |          1 | siu_user_id |            1 | siu_user_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+-----------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+