I've upgraded my lab environment for Moodle 4.1dev (20220812) to Moodle 4.1dev (20220826) and I get these database errors after the upgrade (in Performance report -> database). I see that there were changes on several database tables in this build. Anyone who had the same problem?
Details
course
Missing index 'originalcourseid' (not unique (originalcourseid)).
CREATE INDEX mdl_cour_ori_ix ON mdl_course (originalcourseid);
enrol
Missing index 'roleid' (not unique (roleid)).
CREATE INDEX mdl_enro_rol_ix ON mdl_enrol (roleid);
scale
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_scal_use_ix ON mdl_scale (userid);
scale_history
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_scalhist_use_ix ON mdl_scale_history (userid);
post
Missing index 'courseid' (not unique (courseid)).
CREATE INDEX mdl_post_cou_ix ON mdl_post (courseid);
Missing index 'coursemoduleid' (not unique (coursemoduleid)).
CREATE INDEX mdl_post_cou2_ix ON mdl_post (coursemoduleid);
question_statistics
Missing index 'questionid' (not unique (questionid)).
CREATE INDEX mdl_quesstat_que_ix ON mdl_question_statistics (questionid);
question_response_analysis
Missing index 'questionid' (not unique (questionid)).
CREATE INDEX mdl_quesrespanal_que_ix ON mdl_question_response_analysis (questionid);
mnet_host
Missing index 'last_log_id' (not unique (last_log_id)).
CREATE INDEX mdl_mnethost_las_ix ON mdl_mnet_host (last_log_id);
mnet_session
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_mnetsess_use_ix ON mdl_mnet_session (userid);
Missing index 'mnethostid' (not unique (mnethostid)).
CREATE INDEX mdl_mnetsess_mne_ix ON mdl_mnet_session (mnethostid);
grade_import_values
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_gradimpovalu_use_ix ON mdl_grade_import_values (userid);
portfolio_log
Missing index 'tempdataid' (not unique (tempdataid)).
CREATE INDEX mdl_portlog_tem_ix ON mdl_portfolio_log (tempdataid);
file_conversion
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_fileconv_use_ix ON mdl_file_conversion (usermodified);
repository_instances
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_repoinst_use_ix ON mdl_repository_instances (userid);
Missing index 'contextid' (not unique (contextid)).
CREATE INDEX mdl_repoinst_con_ix ON mdl_repository_instances (contextid);
rating
Missing index 'scaleid' (not unique (scaleid)).
CREATE INDEX mdl_rati_sca_ix ON mdl_rating (scaleid);
course_published
Missing index 'courseid' (not unique (courseid)).
CREATE INDEX mdl_courpubl_cou_ix ON mdl_course_published (courseid);
Missing index 'hubcourseid' (not unique (hubcourseid)).
CREATE INDEX mdl_courpubl_hub_ix ON mdl_course_published (hubcourseid);
event_subscriptions
Missing index 'courseid' (not unique (courseid)).
CREATE INDEX mdl_evensubs_cou_ix ON mdl_event_subscriptions (courseid);
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_evensubs_use_ix ON mdl_event_subscriptions (userid);
task_log
Missing index 'userid' (not unique (userid)).
CREATE INDEX mdl_tasklog_use_ix ON mdl_task_log (userid);
competency
Missing index 'scaleid' (not unique (scaleid)).
CREATE INDEX mdl_comp_sca_ix ON mdl_competency (scaleid);
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_comp_use_ix ON mdl_competency (usermodified);
competency_coursecompsetting
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compcour_use_ix ON mdl_competency_coursecompsetting (usermodified);
competency_framework
Missing index 'contextid' (not unique (contextid)).
CREATE INDEX mdl_compfram_con_ix ON mdl_competency_framework (contextid);
Missing index 'scaleid' (not unique (scaleid)).
CREATE INDEX mdl_compfram_sca_ix ON mdl_competency_framework (scaleid);
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compfram_use_ix ON mdl_competency_framework (usermodified);
competency_coursecomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compcour_use2_ix ON mdl_competency_coursecomp (usermodified);
competency_plan
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compplan_use_ix ON mdl_competency_plan (usermodified);
competency_template
Missing index 'contextid' (not unique (contextid)).
CREATE INDEX mdl_comptemp_con_ix ON mdl_competency_template (contextid);
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_comptemp_use_ix ON mdl_competency_template (usermodified);
competency_templatecomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_comptemp_use2_ix ON mdl_competency_templatecomp (usermodified);
competency_templatecohort
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_comptemp_use3_ix ON mdl_competency_templatecohort (usermodified);
competency_relatedcomp
Missing index 'competencyid' (not unique (competencyid)).
CREATE INDEX mdl_comprela_com_ix ON mdl_competency_relatedcomp (competencyid);
Missing index 'relatedcompetencyid' (not unique (relatedcompetencyid)).
CREATE INDEX mdl_comprela_rel_ix ON mdl_competency_relatedcomp (relatedcompetencyid);
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_comprela_use_ix ON mdl_competency_relatedcomp (usermodified);
competency_usercomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compuser_use_ix ON mdl_competency_usercomp (usermodified);
competency_usercompcourse
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compuser_use2_ix ON mdl_competency_usercompcourse (usermodified);
competency_usercompplan
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compuser_use3_ix ON mdl_competency_usercompplan (usermodified);
competency_plancomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compplan_use2_ix ON mdl_competency_plancomp (usermodified);
competency_evidence
Missing index 'contextid' (not unique (contextid)).
CREATE INDEX mdl_compevid_con_ix ON mdl_competency_evidence (contextid);
Missing index 'actionuserid' (not unique (actionuserid)).
CREATE INDEX mdl_compevid_act_ix ON mdl_competency_evidence (actionuserid);
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compevid_use2_ix ON mdl_competency_evidence (usermodified);
competency_userevidence
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compuser_use4_ix ON mdl_competency_userevidence (usermodified);
competency_userevidencecomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compuser_use5_ix ON mdl_competency_userevidencecomp (usermodified);
competency_modulecomp
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_compmodu_use_ix ON mdl_competency_modulecomp (usermodified);
oauth2_endpoint
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_oautendp_use_ix ON mdl_oauth2_endpoint (usermodified);
oauth2_system_account
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_oautsystacco_use_ix ON mdl_oauth2_system_account (usermodified);
oauth2_user_field_mapping
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_oautuserfielmapp_use_ix ON mdl_oauth2_user_field_mapping (usermodified);
analytics_models
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_analmode_use_ix ON mdl_analytics_models (usermodified);
analytics_models_log
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_analmodelog_use_ix ON mdl_analytics_models_log (usermodified);
oauth2_access_token
Missing index 'usermodified' (not unique (usermodified)).
CREATE INDEX mdl_oautaccetoke_use_ix ON mdl_oauth2_access_token (usermodified);
payment_accounts
Missing index 'contextid' (not unique (contextid)).
CREATE INDEX mdl_paymacco_con_ix ON mdl_payment_accounts (contextid);
questionnaire_survey
column 'name' length is 191, expected 255 (C)