CREATE INDEX mdl_backlog_cou_ix ON mdl_backup_log (courseid); CREATE INDEX mdl_blocinst_blo_ix ON mdl_block_instance (blockid); CREATE INDEX mdl_blocpinn_blo_ix ON mdl_block_pinned (blockid); CREATE INDEX mdl_choiansw_opt_ix ON mdl_choice_answers (optionid); CREATE INDEX mdl_courcate_par_ix ON mdl_course_categories (parent); CREATE INDEX mdl_datacomm_rec_ix ON mdl_data_comments (recordid); CREATE INDEX mdl_datacont_rec_ix ON mdl_data_content (recordid); CREATE INDEX mdl_datacont_fie_ix ON mdl_data_content (fieldid); CREATE INDEX mdl_datafiel_dat_ix ON mdl_data_fields (dataid); CREATE INDEX mdl_datarati_rec_ix ON mdl_data_ratings (recordid); CREATE INDEX mdl_datareco_dat_ix ON mdl_data_records (dataid); CREATE INDEX mdl_foruqueu_dis_ix ON mdl_forum_queue (discussionid); CREATE INDEX mdl_lessatte_ans_ix ON mdl_lesson_attempts (answerid); CREATE INDEX mdl_lessbran_use_ix ON mdl_lesson_branch (userid); CREATE INDEX mdl_lessbran_les_ix ON mdl_lesson_branch (lessonid); CREATE INDEX mdl_lessbran_pag_ix ON mdl_lesson_branch (pageid); CREATE INDEX mdl_lesshighscor_use_ix ON mdl_lesson_high_scores (userid); CREATE INDEX mdl_lesshighscor_les_ix ON mdl_lesson_high_scores (lessonid); CREATE INDEX mdl_lesstime_use_ix ON mdl_lesson_timer (userid); CREATE INDEX mdl_lesstime_les_ix ON mdl_lesson_timer (lessonid); CREATE INDEX mdl_ques_par_ix ON mdl_question (parent); CREATE INDEX mdl_quescate_par_ix ON mdl_question_categories (parent); CREATE INDEX mdl_quesdata_que_ix ON mdl_question_datasets (question); CREATE INDEX mdl_quesdata_dat_ix ON mdl_question_datasets (datasetdefinition); CREATE INDEX mdl_quesrqpserv_typ_ix ON mdl_question_rqp_servers (typeid); CREATE INDEX mdl_quessess_att_ix ON mdl_question_sessions (attemptid); CREATE INDEX mdl_quessess_que_ix ON mdl_question_sessions (questionid); CREATE INDEX mdl_quessess_new_ix ON mdl_question_sessions (newest); CREATE INDEX mdl_quessess_new2_ix ON mdl_question_sessions (newgraded); CREATE INDEX mdl_quizquesvers_qui_ix ON mdl_quiz_question_versions (quiz); CREATE INDEX mdl_quizquesvers_old_ix ON mdl_quiz_question_versions (oldquestion); CREATE INDEX mdl_quizquesvers_new_ix ON mdl_quiz_question_versions (newquestion); CREATE INDEX mdl_quizquesvers_ori_ix ON mdl_quiz_question_versions (originalquestion); CREATE INDEX mdl_rolecapa_cap_ix ON mdl_role_capabilities (capability); CREATE INDEX mdl_wikilock_wik_ix ON mdl_wiki_locks (wikiid); CREATE INDEX mdl_wikipage_wik_ix ON mdl_wiki_pages (wiki); CREATE INDEX mdl_workrubr_wor_ix ON mdl_workshop_rubrics (workshopid); CREATE INDEX mdl_workstoc_wor_ix ON mdl_workshop_stockcomments (workshopid);