== Summary
The #checkuser tables are not needed on `closed` wikis, because we disabled the extension on those wikis
== Technical details
* The wikis in `checkuser-disabled.dblist` have the #checkuser DB tables
** Several weeks ago the extension was disabled on those wikis and the disable appears stable
** Most of the tables still have data, but the only table that has non-purged data is the `cu_log` table.
*** I confirmed that the `cu_log` table is empty in all the wikis in `checkuser-disabled.dblist`
*** The other tables that have entries are not automatically purging their data because the extension was uninstalled (so dropping or at least truncation of these tables would ideally be done soon to ensure the data is purged within 3 months)
== Schema change template
# **ALTERs to run:**
## `RENAME TABLE cu_changes TO cu_changes_temp; RENAME TABLE cu_log_event TO cu_log_event_temp; RENAME TABLE cu_private_event TO cu_private_event_temp; RENAME TABLE cu_log TO cu_log_temp; RENAME TABLE cu_useragent TO cu_useragent_temp; RENAME TABLE cu_useragent_clienthints TO cu_useragent_clienthints_temp; RENAME TABLE cu_useragent_clienthints_map TO cu_useragent_clienthints_map_temp;`
## `DROP TABLE cu_changes_temp; DROP TABLE cu_log_event_temp; DROP TABLE cu_private_event_temp; DROP TABLE cu_log_temp; DROP TABLE cu_useragent_temp; DROP TABLE cu_useragent_clienthints_temp; DROP TABLE cu_useragent_clienthints_map_temp;`
# **Where to run those changes:** `checkuser-disabled.dblist`
# **When to run those changes:** Ideally dropping all rows on `cu_changes`, `cu_log_event`, `cu_private_event`, and `cu_useragent_clienthints_map` soon per the above, but dropping the tables is not high priority
# **If the schema change is backwards compatible:** No, suggest renaming tables first and then dropping. However, the tables should not be accessed
# **If the schema change has been tested already on some of the test/beta wikis:** N/A
# **If the data should be made available on the labs replicas and/or dumps:** N/A