Extension:CheckUser/cuci temp edit table

MediaWiki version:

≥ 1.43

A table for the CheckUser extension used find the temporary accounts editing on a given IP address or range over all wikis.

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. Additionally, this table is unused for wikis which do not have temporary accounts enabled.

Fields

cite_ip_hex

The IP address associated with this row in hexadecimal form. Used in the composite primary key.

cite_ciwm_id

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

cite_timestamp

The most recent timestamp associated with temporary account edits made on the given wiki and IP address.

Schema

DESCRIBE cuci_temp_edit;

+----------------+----------------------+------+-----+---------+-------+
| Field          | Type                 | Null | Key | Default | Extra |
+----------------+----------------------+------+-----+---------+-------+
| cite_ip_hex    | varbinary(255)       | NO   | PRI | NULL    |       |
| cite_ciwm_id   | smallint(5) unsigned | NO   | PRI | NULL    |       |
| cite_timestamp | binary(14)           | NO   | MUL | NULL    |       |
+----------------+----------------------+------+-----+---------+-------+

Indexes

SHOW INDEX IN cuci_temp_edit;

+----------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table          | Non_unique | Key_name              | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+----------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| cuci_temp_edit |          0 | PRIMARY               |            1 | cite_ip_hex    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_temp_edit |          0 | PRIMARY               |            2 | cite_ciwm_id   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_temp_edit |          1 | cite_timestamp        |            1 | cite_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_temp_edit |          1 | cite_ip_hex_timestamp |            1 | cite_ip_hex    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| cuci_temp_edit |          1 | cite_ip_hex_timestamp |            2 | cite_timestamp | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+----------------+------------+-----------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+