Missing index 'usermodified' on upgraded installations

[abias]

Hi @timhunt ,

looking at a recent result of the admin/cli/check_database_schema.php tool on our Moodle instance which says

-------------------------------------------------------------------------------
report_customsql_queries
 * Missing index 'usermodified' (not unique (usermodified)). 
CREATE INDEX mdl_repocustquer_use_ix ON mdl_report_customsql_queries (usermodified);
-----------------------------------------------------------------------------

I assume that in 0ba0d70, you have added the new database fields within db/upgrade.php, but haven't added the index as well.

I can fix this locally in our DB, but I think it would make sense if you still would add this to db/upgrade.php and publish a new version.

Thanks in advance,
Alex

[TomoTsuyuki]

Hi @timhunt ,

I made a PR for fixing this issue.
Could you review the PR and merge to fix the issue?

Kind regards,
Tomo