ALTER TABLE mdl_config ADD CONSTRAINT mdl_conf_nam_uk UNIQUE (name)
ALTER TABLE mdl_config_plugins ADD CONSTRAINT mdl_confplug_plunam_uk UNIQUE (plugin, name)
ALTER TABLE mdl_config_log ADD CONSTRAINT mdl_conflog_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_upgrade_log ADD CONSTRAINT mdl_upgrlog_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_course_categories ADD CONSTRAINT mdl_courcate_par_fk FOREIGN KEY (parent) REFERENCES mdl_course_categories (id)
ALTER TABLE mdl_enrol ADD CONSTRAINT mdl_enro_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_user_enrolments ADD CONSTRAINT mdl_userenro_enr_fk FOREIGN KEY (enrolid) REFERENCES mdl_enrol (id)
ALTER TABLE mdl_user_enrolments ADD CONSTRAINT mdl_userenro_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_user_enrolments ADD CONSTRAINT mdl_userenro_mod_fk FOREIGN KEY (modifierid) REFERENCES mdl_user (id)
ALTER TABLE mdl_course_modules ADD CONSTRAINT mdl_courmodu_gro_fk FOREIGN KEY (groupingid) REFERENCES mdl_groupings (id)
ALTER TABLE mdl_course_format_options ADD CONSTRAINT mdl_courformopti_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_filter_active ADD CONSTRAINT mdl_filtacti_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_filter_config ADD CONSTRAINT mdl_filtconf_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_sessions ADD CONSTRAINT mdl_sess_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_scale_history ADD CONSTRAINT mdl_scalhist_old_fk FOREIGN KEY (oldid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_scale_history ADD CONSTRAINT mdl_scalhist_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_scale_history ADD CONSTRAINT mdl_scalhist_log_fk FOREIGN KEY (loggeduser) REFERENCES mdl_user (id)
ALTER TABLE mdl_post ADD CONSTRAINT mdl_post_use_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_capabilities ADD CONSTRAINT mdl_capa_nam_uk UNIQUE (name)
ALTER TABLE mdl_role_allow_assign ADD CONSTRAINT mdl_rolealloassi_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_allow_assign ADD CONSTRAINT mdl_rolealloassi_all_fk FOREIGN KEY (allowassign) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_allow_override ADD CONSTRAINT mdl_rolealloover_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_allow_override ADD CONSTRAINT mdl_rolealloover_all_fk FOREIGN KEY (allowoverride) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_allow_switch ADD CONSTRAINT mdl_rolealloswit_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_allow_switch ADD CONSTRAINT mdl_rolealloswit_all_fk FOREIGN KEY (allowswitch) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_assignments ADD CONSTRAINT mdl_roleassi_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_assignments ADD CONSTRAINT mdl_roleassi_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_role_assignments ADD CONSTRAINT mdl_roleassi_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_role_capabilities ADD CONSTRAINT mdl_rolecapa_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_capabilities ADD CONSTRAINT mdl_rolecapa_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_role_capabilities ADD CONSTRAINT mdl_rolecapa_mod_fk FOREIGN KEY (modifierid) REFERENCES mdl_user (id)
ALTER TABLE mdl_role_capabilities ADD CONSTRAINT mdl_rolecapa_cap_fk FOREIGN KEY (capability) REFERENCES mdl_capabilities (name)
ALTER TABLE mdl_role_names ADD CONSTRAINT mdl_rolename_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_names ADD CONSTRAINT mdl_rolename_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_role_sortorder ADD CONSTRAINT mdl_rolesort_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_role_sortorder ADD CONSTRAINT mdl_rolesort_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_role_sortorder ADD CONSTRAINT mdl_rolesort_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_role_context_levels ADD CONSTRAINT mdl_rolecontleve_conrol_uk UNIQUE (contextlevel, roleid)
ALTER TABLE mdl_role_context_levels ADD CONSTRAINT mdl_rolecontleve_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_question_categories ADD CONSTRAINT mdl_quescate_par_fk FOREIGN KEY (parent) REFERENCES mdl_question_categories (id)
ALTER TABLE mdl_question ADD CONSTRAINT mdl_ques_cat_fk FOREIGN KEY (category) REFERENCES mdl_question_categories (id)
ALTER TABLE mdl_question ADD CONSTRAINT mdl_ques_par_fk FOREIGN KEY (parent) REFERENCES mdl_question (id)
ALTER TABLE mdl_question ADD CONSTRAINT mdl_ques_cre_fk FOREIGN KEY (createdby) REFERENCES mdl_user (id)
ALTER TABLE mdl_question ADD CONSTRAINT mdl_ques_mod_fk FOREIGN KEY (modifiedby) REFERENCES mdl_user (id)
ALTER TABLE mdl_question_answers ADD CONSTRAINT mdl_quesansw_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_hints ADD CONSTRAINT mdl_queshint_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_usages ADD CONSTRAINT mdl_quesusag_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_question_attempts ADD CONSTRAINT mdl_quesatte_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_attempts ADD CONSTRAINT mdl_quesatte_que2_fk FOREIGN KEY (questionusageid) REFERENCES mdl_question_usages (id)
ALTER TABLE mdl_question_attempt_steps ADD CONSTRAINT mdl_quesattestep_que_fk FOREIGN KEY (questionattemptid) REFERENCES mdl_question_attempts (id)
ALTER TABLE mdl_question_attempt_steps ADD CONSTRAINT mdl_quesattestep_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_question_attempt_step_data ADD CONSTRAINT mdl_quesattestepdata_att_fk FOREIGN KEY (attemptstepid) REFERENCES mdl_question_attempt_steps (id)
ALTER TABLE mdl_question_response_count ADD CONSTRAINT mdl_quesrespcoun_ana_fk FOREIGN KEY (analysisid) REFERENCES mdl_question_response_analysis (id)
ALTER TABLE mdl_mnet_host ADD CONSTRAINT mdl_mnethost_app_fk FOREIGN KEY (applicationid) REFERENCES mdl_mnet_application (id)
ALTER TABLE mdl_events_queue ADD CONSTRAINT mdl_evenqueu_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_events_queue_handlers ADD CONSTRAINT mdl_evenqueuhand_que_fk FOREIGN KEY (queuedeventid) REFERENCES mdl_events_queue (id)
ALTER TABLE mdl_events_queue_handlers ADD CONSTRAINT mdl_evenqueuhand_han_fk FOREIGN KEY (handlerid) REFERENCES mdl_events_handlers (id)
ALTER TABLE mdl_grade_outcomes ADD CONSTRAINT mdl_gradoutc_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_outcomes ADD CONSTRAINT mdl_gradoutc_sca_fk FOREIGN KEY (scaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_outcomes ADD CONSTRAINT mdl_gradoutc_use_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_outcomes ADD CONSTRAINT mdl_gradoutc_cousho_uk UNIQUE (courseid, shortname)
ALTER TABLE mdl_grade_outcomes_courses ADD CONSTRAINT mdl_gradoutccour_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_outcomes_courses ADD CONSTRAINT mdl_gradoutccour_out_fk FOREIGN KEY (outcomeid) REFERENCES mdl_grade_outcomes (id)
ALTER TABLE mdl_grade_outcomes_courses ADD CONSTRAINT mdl_gradoutccour_couout_uk UNIQUE (courseid, outcomeid)
ALTER TABLE mdl_grade_categories ADD CONSTRAINT mdl_gradcate_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_categories ADD CONSTRAINT mdl_gradcate_par_fk FOREIGN KEY (parent) REFERENCES mdl_grade_categories (id)
ALTER TABLE mdl_grade_items ADD CONSTRAINT mdl_graditem_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_items ADD CONSTRAINT mdl_graditem_cat_fk FOREIGN KEY (categoryid) REFERENCES mdl_grade_categories (id)
ALTER TABLE mdl_grade_items ADD CONSTRAINT mdl_graditem_sca_fk FOREIGN KEY (scaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_items ADD CONSTRAINT mdl_graditem_out_fk FOREIGN KEY (outcomeid) REFERENCES mdl_grade_outcomes (id)
ALTER TABLE mdl_grade_grades ADD CONSTRAINT mdl_gradgrad_ite_fk FOREIGN KEY (itemid) REFERENCES mdl_grade_items (id)
ALTER TABLE mdl_grade_grades ADD CONSTRAINT mdl_gradgrad_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_grades ADD CONSTRAINT mdl_gradgrad_raw_fk FOREIGN KEY (rawscaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_grades ADD CONSTRAINT mdl_gradgrad_use2_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_grades ADD CONSTRAINT mdl_gradgrad_useite_uk UNIQUE (userid, itemid)
ALTER TABLE mdl_grade_outcomes_history ADD CONSTRAINT mdl_gradoutchist_old_fk FOREIGN KEY (oldid) REFERENCES mdl_grade_outcomes (id)
ALTER TABLE mdl_grade_outcomes_history ADD CONSTRAINT mdl_gradoutchist_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_outcomes_history ADD CONSTRAINT mdl_gradoutchist_sca_fk FOREIGN KEY (scaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_outcomes_history ADD CONSTRAINT mdl_gradoutchist_log_fk FOREIGN KEY (loggeduser) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_categories_history ADD CONSTRAINT mdl_gradcatehist_old_fk FOREIGN KEY (oldid) REFERENCES mdl_grade_categories (id)
ALTER TABLE mdl_grade_categories_history ADD CONSTRAINT mdl_gradcatehist_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_categories_history ADD CONSTRAINT mdl_gradcatehist_par_fk FOREIGN KEY (parent) REFERENCES mdl_grade_categories (id)
ALTER TABLE mdl_grade_categories_history ADD CONSTRAINT mdl_gradcatehist_log_fk FOREIGN KEY (loggeduser) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_old_fk FOREIGN KEY (oldid) REFERENCES mdl_grade_items (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_cat_fk FOREIGN KEY (categoryid) REFERENCES mdl_grade_categories (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_sca_fk FOREIGN KEY (scaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_out_fk FOREIGN KEY (outcomeid) REFERENCES mdl_grade_outcomes (id)
ALTER TABLE mdl_grade_items_history ADD CONSTRAINT mdl_graditemhist_log_fk FOREIGN KEY (loggeduser) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_old_fk FOREIGN KEY (oldid) REFERENCES mdl_grade_grades (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_ite_fk FOREIGN KEY (itemid) REFERENCES mdl_grade_items (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_raw_fk FOREIGN KEY (rawscaleid) REFERENCES mdl_scale (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_use2_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_grades_history ADD CONSTRAINT mdl_gradgradhist_log_fk FOREIGN KEY (loggeduser) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_import_newitem ADD CONSTRAINT mdl_gradimponewi_imp_fk FOREIGN KEY (importer) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_import_values ADD CONSTRAINT mdl_gradimpovalu_ite_fk FOREIGN KEY (itemid) REFERENCES mdl_grade_items (id)
ALTER TABLE mdl_grade_import_values ADD CONSTRAINT mdl_gradimpovalu_new_fk FOREIGN KEY (newgradeitem) REFERENCES mdl_grade_import_newitem (id)
ALTER TABLE mdl_grade_import_values ADD CONSTRAINT mdl_gradimpovalu_imp_fk FOREIGN KEY (importer) REFERENCES mdl_user (id)
ALTER TABLE mdl_tag ADD CONSTRAINT mdl_tag_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_tag_correlation ADD CONSTRAINT mdl_tagcorr_tag_fk FOREIGN KEY (tagid) REFERENCES mdl_tag (id)
ALTER TABLE mdl_tag_instance ADD CONSTRAINT mdl_taginst_tag_fk FOREIGN KEY (tagid) REFERENCES mdl_tag (id)
ALTER TABLE mdl_tag_instance ADD CONSTRAINT mdl_taginst_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_groups ADD CONSTRAINT mdl_grou_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_groupings ADD CONSTRAINT mdl_grou_cou2_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_groups_members ADD CONSTRAINT mdl_groumemb_gro_fk FOREIGN KEY (groupid) REFERENCES mdl_groups (id)
ALTER TABLE mdl_groups_members ADD CONSTRAINT mdl_groumemb_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_groupings_groups ADD CONSTRAINT mdl_grougrou_gro_fk FOREIGN KEY (groupingid) REFERENCES mdl_groupings (id)
ALTER TABLE mdl_groupings_groups ADD CONSTRAINT mdl_grougrou_gro2_fk FOREIGN KEY (groupid) REFERENCES mdl_groups (id)
ALTER TABLE mdl_cohort ADD CONSTRAINT mdl_coho_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_cohort_members ADD CONSTRAINT mdl_cohomemb_coh_fk FOREIGN KEY (cohortid) REFERENCES mdl_cohort (id)
ALTER TABLE mdl_cohort_members ADD CONSTRAINT mdl_cohomemb_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_user_private_key ADD CONSTRAINT mdl_userprivkey_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_grade_settings ADD CONSTRAINT mdl_gradsett_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_webdav_locks ADD CONSTRAINT mdl_webdlock_tok_uk UNIQUE (token)
ALTER TABLE mdl_portfolio_instance_config ADD CONSTRAINT mdl_portinstconf_ins_fk FOREIGN KEY (instance) REFERENCES mdl_portfolio_instance (id)
ALTER TABLE mdl_portfolio_instance_user ADD CONSTRAINT mdl_portinstuser_ins_fk FOREIGN KEY (instance) REFERENCES mdl_portfolio_instance (id)
ALTER TABLE mdl_portfolio_instance_user ADD CONSTRAINT mdl_portinstuser_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_portfolio_log ADD CONSTRAINT mdl_portlog_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_portfolio_log ADD CONSTRAINT mdl_portlog_por_fk FOREIGN KEY (portfolio) REFERENCES mdl_portfolio_instance (id)
ALTER TABLE mdl_portfolio_tempdata ADD CONSTRAINT mdl_porttemp_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_portfolio_tempdata ADD CONSTRAINT mdl_porttemp_ins_fk FOREIGN KEY (instance) REFERENCES mdl_portfolio_instance (id)
ALTER TABLE mdl_files ADD CONSTRAINT mdl_file_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_files ADD CONSTRAINT mdl_file_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_files ADD CONSTRAINT mdl_file_ref_fk FOREIGN KEY (referencefileid) REFERENCES mdl_files_reference (id)
ALTER TABLE mdl_files_reference ADD CONSTRAINT mdl_filerefe_rep_fk FOREIGN KEY (repositoryid) REFERENCES mdl_repository_instances (id)
ALTER TABLE mdl_backup_courses ADD CONSTRAINT mdl_backcour_cou_uk UNIQUE (courseid)
ALTER TABLE mdl_block_instances ADD CONSTRAINT mdl_blocinst_par_fk FOREIGN KEY (parentcontextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_block_positions ADD CONSTRAINT mdl_blocposi_blo_fk FOREIGN KEY (blockinstanceid) REFERENCES mdl_block_instances (id)
ALTER TABLE mdl_block_positions ADD CONSTRAINT mdl_blocposi_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_external_services_functions ADD CONSTRAINT mdl_exteservfunc_ext_fk FOREIGN KEY (externalserviceid) REFERENCES mdl_external_services (id)
ALTER TABLE mdl_external_services_users ADD CONSTRAINT mdl_exteservuser_ext_fk FOREIGN KEY (externalserviceid) REFERENCES mdl_external_services (id)
ALTER TABLE mdl_external_services_users ADD CONSTRAINT mdl_exteservuser_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_external_tokens ADD CONSTRAINT mdl_extetoke_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_external_tokens ADD CONSTRAINT mdl_extetoke_ext_fk FOREIGN KEY (externalserviceid) REFERENCES mdl_external_services (id)
ALTER TABLE mdl_external_tokens ADD CONSTRAINT mdl_extetoke_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_external_tokens ADD CONSTRAINT mdl_extetoke_cre_fk FOREIGN KEY (creatorid) REFERENCES mdl_user (id)
ALTER TABLE mdl_blog_association ADD CONSTRAINT mdl_blogasso_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_blog_association ADD CONSTRAINT mdl_blogasso_blo_fk FOREIGN KEY (blogid) REFERENCES mdl_post (id)
ALTER TABLE mdl_blog_external ADD CONSTRAINT mdl_blogexte_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_rating ADD CONSTRAINT mdl_rati_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_rating ADD CONSTRAINT mdl_rati_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_backup_controllers ADD CONSTRAINT mdl_backcont_bac_uk UNIQUE (backupid)
ALTER TABLE mdl_backup_controllers ADD CONSTRAINT mdl_backcont_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_backup_logs ADD CONSTRAINT mdl_backlogs_bac_fk FOREIGN KEY (backupid) REFERENCES mdl_backup_controllers (backupid)
ALTER TABLE mdl_profiling ADD CONSTRAINT mdl_prof_run_uk UNIQUE (runid)
ALTER TABLE mdl_grading_areas ADD CONSTRAINT mdl_gradarea_concomare_uk UNIQUE (contextid, component, areaname)
ALTER TABLE mdl_grading_areas ADD CONSTRAINT mdl_gradarea_con_fk FOREIGN KEY (contextid) REFERENCES mdl_context (id)
ALTER TABLE mdl_grading_definitions ADD CONSTRAINT mdl_graddefi_are_fk FOREIGN KEY (areaid) REFERENCES mdl_grading_areas (id)
ALTER TABLE mdl_grading_definitions ADD CONSTRAINT mdl_graddefi_use_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_grading_definitions ADD CONSTRAINT mdl_graddefi_aremet_uk UNIQUE (areaid, method)
ALTER TABLE mdl_grading_definitions ADD CONSTRAINT mdl_graddefi_use2_fk FOREIGN KEY (usercreated) REFERENCES mdl_user (id)
ALTER TABLE mdl_grading_instances ADD CONSTRAINT mdl_gradinst_def_fk FOREIGN KEY (definitionid) REFERENCES mdl_grading_definitions (id)
ALTER TABLE mdl_grading_instances ADD CONSTRAINT mdl_gradinst_rat_fk FOREIGN KEY (raterid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge ADD CONSTRAINT mdl_badg_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_badge ADD CONSTRAINT mdl_badg_use_fk FOREIGN KEY (usermodified) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge ADD CONSTRAINT mdl_badg_use2_fk FOREIGN KEY (usercreated) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_criteria ADD CONSTRAINT mdl_badgcrit_bad_fk FOREIGN KEY (badgeid) REFERENCES mdl_badge (id)
ALTER TABLE mdl_badge_criteria_param ADD CONSTRAINT mdl_badgcritpara_cri_fk FOREIGN KEY (critid) REFERENCES mdl_badge_criteria (id)
ALTER TABLE mdl_badge_issued ADD CONSTRAINT mdl_badgissu_bad_fk FOREIGN KEY (badgeid) REFERENCES mdl_badge (id)
ALTER TABLE mdl_badge_issued ADD CONSTRAINT mdl_badgissu_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_criteria_met ADD CONSTRAINT mdl_badgcritmet_cri_fk FOREIGN KEY (critid) REFERENCES mdl_badge_criteria (id)
ALTER TABLE mdl_badge_criteria_met ADD CONSTRAINT mdl_badgcritmet_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_criteria_met ADD CONSTRAINT mdl_badgcritmet_iss_fk FOREIGN KEY (issuedid) REFERENCES mdl_badge_issued (id)
ALTER TABLE mdl_badge_manual_award ADD CONSTRAINT mdl_badgmanuawar_bad_fk FOREIGN KEY (badgeid) REFERENCES mdl_badge (id)
ALTER TABLE mdl_badge_manual_award ADD CONSTRAINT mdl_badgmanuawar_rec_fk FOREIGN KEY (recipientid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_manual_award ADD CONSTRAINT mdl_badgmanuawar_iss_fk FOREIGN KEY (issuerid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_manual_award ADD CONSTRAINT mdl_badgmanuawar_iss2_fk FOREIGN KEY (issuerrole) REFERENCES mdl_role (id)
ALTER TABLE mdl_badge_backpack ADD CONSTRAINT mdl_badgback_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_badge_external ADD CONSTRAINT mdl_badgexte_bac_fk FOREIGN KEY (backpackid) REFERENCES mdl_badge_backpack (id)
ALTER TABLE mdl_user_devices ADD CONSTRAINT mdl_userdevi_pususe_uk UNIQUE (pushid, userid)
ALTER TABLE mdl_user_devices ADD CONSTRAINT mdl_userdevi_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_user_password_resets ADD CONSTRAINT mdl_userpassrese_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_messageinbound_handlers ADD CONSTRAINT mdl_messhand_cla_uk UNIQUE (classname)
ALTER TABLE mdl_messageinbound_datakeys ADD CONSTRAINT mdl_messdata_handat_uk UNIQUE (handler, datavalue)
ALTER TABLE mdl_messageinbound_datakeys ADD CONSTRAINT mdl_messdata_han_fk FOREIGN KEY (handler) REFERENCES mdl_messageinbound_handlers (id)
ALTER TABLE mdl_messageinbound_messagelist ADD CONSTRAINT mdl_messmess_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_question_calculated ADD CONSTRAINT mdl_quescalc_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_calculated_options ADD CONSTRAINT mdl_quescalcopti_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_dataset_definitions ADD CONSTRAINT mdl_quesdatadefi_cat_fk FOREIGN KEY (category) REFERENCES mdl_question_categories (id)
ALTER TABLE mdl_question_datasets ADD CONSTRAINT mdl_quesdata_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_datasets ADD CONSTRAINT mdl_quesdata_dat_fk FOREIGN KEY (datasetdefinition) REFERENCES mdl_question_dataset_definitions (id)
ALTER TABLE mdl_qtype_essay_options ADD CONSTRAINT mdl_qtypessaopti_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_qtype_match_options ADD CONSTRAINT mdl_qtypmatcopti_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_qtype_match_subquestions ADD CONSTRAINT mdl_qtypmatcsubq_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_multianswer ADD CONSTRAINT mdl_quesmult_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_qtype_multichoice_options ADD CONSTRAINT mdl_qtypmultopti_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_numerical ADD CONSTRAINT mdl_quesnume_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_numerical_options ADD CONSTRAINT mdl_quesnumeopti_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_numerical_units ADD CONSTRAINT mdl_quesnumeunit_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_qtype_randomsamatch_options ADD CONSTRAINT mdl_qtyprandopti_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_qtype_shortanswer_options ADD CONSTRAINT mdl_qtypshoropti_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_question_truefalse ADD CONSTRAINT mdl_questrue_que_fk FOREIGN KEY (question) REFERENCES mdl_question (id)
ALTER TABLE mdl_assign_submission ADD CONSTRAINT mdl_assisubm_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assign_grades ADD CONSTRAINT mdl_assigrad_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assign_plugin_config ADD CONSTRAINT mdl_assiplugconf_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assign_user_mapping ADD CONSTRAINT mdl_assiusermapp_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assign_user_mapping ADD CONSTRAINT mdl_assiusermapp_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_assign_user_flags ADD CONSTRAINT mdl_assiuserflag_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_assign_user_flags ADD CONSTRAINT mdl_assiuserflag_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assignment_submissions ADD CONSTRAINT mdl_assisubm_ass2_fk FOREIGN KEY (assignment) REFERENCES mdl_assignment (id)
ALTER TABLE mdl_chat_messages ADD CONSTRAINT mdl_chatmess_cha_fk FOREIGN KEY (chatid) REFERENCES mdl_chat (id)
ALTER TABLE mdl_chat_messages_current ADD CONSTRAINT mdl_chatmesscurr_cha_fk FOREIGN KEY (chatid) REFERENCES mdl_chat (id)
ALTER TABLE mdl_chat_users ADD CONSTRAINT mdl_chatuser_cha_fk FOREIGN KEY (chatid) REFERENCES mdl_chat (id)
ALTER TABLE mdl_choice_options ADD CONSTRAINT mdl_choiopti_cho_fk FOREIGN KEY (choiceid) REFERENCES mdl_choice (id)
ALTER TABLE mdl_choice_answers ADD CONSTRAINT mdl_choiansw_cho_fk FOREIGN KEY (choiceid) REFERENCES mdl_choice (id)
ALTER TABLE mdl_choice_answers ADD CONSTRAINT mdl_choiansw_opt_fk FOREIGN KEY (optionid) REFERENCES mdl_choice_options (id)
ALTER TABLE mdl_data_fields ADD CONSTRAINT mdl_datafiel_dat_fk FOREIGN KEY (dataid) REFERENCES mdl_data (id)
ALTER TABLE mdl_data_records ADD CONSTRAINT mdl_datareco_dat_fk FOREIGN KEY (dataid) REFERENCES mdl_data (id)
ALTER TABLE mdl_data_content ADD CONSTRAINT mdl_datacont_rec_fk FOREIGN KEY (recordid) REFERENCES mdl_data_records (id)
ALTER TABLE mdl_data_content ADD CONSTRAINT mdl_datacont_fie_fk FOREIGN KEY (fieldid) REFERENCES mdl_data_fields (id)
ALTER TABLE mdl_feedback_item ADD CONSTRAINT mdl_feeditem_fee_fk FOREIGN KEY (feedback) REFERENCES mdl_feedback (id)
ALTER TABLE mdl_feedback_item ADD CONSTRAINT mdl_feeditem_tem_fk FOREIGN KEY (template) REFERENCES mdl_feedback_template (id)
ALTER TABLE mdl_feedback_completed ADD CONSTRAINT mdl_feedcomp_fee_fk FOREIGN KEY (feedback) REFERENCES mdl_feedback (id)
ALTER TABLE mdl_feedback_completedtmp ADD CONSTRAINT mdl_feedcomp_fee2_fk FOREIGN KEY (feedback) REFERENCES mdl_feedback (id)
ALTER TABLE mdl_feedback_value ADD CONSTRAINT mdl_feedvalu_ite_fk FOREIGN KEY (item) REFERENCES mdl_feedback_item (id)
ALTER TABLE mdl_feedback_valuetmp ADD CONSTRAINT mdl_feedvalu_ite2_fk FOREIGN KEY (item) REFERENCES mdl_feedback_item (id)
ALTER TABLE mdl_feedback_tracking ADD CONSTRAINT mdl_feedtrac_fee_fk FOREIGN KEY (feedback) REFERENCES mdl_feedback (id)
ALTER TABLE mdl_feedback_tracking ADD CONSTRAINT mdl_feedtrac_com_fk FOREIGN KEY (completed) REFERENCES mdl_feedback_completed (id)
ALTER TABLE mdl_feedback_sitecourse_map ADD CONSTRAINT mdl_feedsitemap_fee_fk FOREIGN KEY (feedbackid) REFERENCES mdl_feedback (id)
ALTER TABLE mdl_forum_discussions ADD CONSTRAINT mdl_forudisc_for_fk FOREIGN KEY (forum) REFERENCES mdl_forum (id)
ALTER TABLE mdl_forum_posts ADD CONSTRAINT mdl_forupost_dis_fk FOREIGN KEY (discussion) REFERENCES mdl_forum_discussions (id)
ALTER TABLE mdl_forum_posts ADD CONSTRAINT mdl_forupost_par_fk FOREIGN KEY (parent) REFERENCES mdl_forum_posts (id)
ALTER TABLE mdl_forum_queue ADD CONSTRAINT mdl_foruqueu_dis_fk FOREIGN KEY (discussionid) REFERENCES mdl_forum_discussions (id)
ALTER TABLE mdl_forum_queue ADD CONSTRAINT mdl_foruqueu_pos_fk FOREIGN KEY (postid) REFERENCES mdl_forum_posts (id)
ALTER TABLE mdl_forum_subscriptions ADD CONSTRAINT mdl_forusubs_for_fk FOREIGN KEY (forum) REFERENCES mdl_forum (id)
ALTER TABLE mdl_forum_digests ADD CONSTRAINT mdl_forudige_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_forum_digests ADD CONSTRAINT mdl_forudige_for_fk FOREIGN KEY (forum) REFERENCES mdl_forum (id)
ALTER TABLE mdl_forum_digests ADD CONSTRAINT mdl_forudige_forusemai_uk UNIQUE (forum, userid, maildigest)
ALTER TABLE mdl_forum_discussion_subs ADD CONSTRAINT mdl_forudiscsubs_for_fk FOREIGN KEY (forum) REFERENCES mdl_forum (id)
ALTER TABLE mdl_forum_discussion_subs ADD CONSTRAINT mdl_forudiscsubs_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_forum_discussion_subs ADD CONSTRAINT mdl_forudiscsubs_dis_fk FOREIGN KEY (discussion) REFERENCES mdl_forum_discussions (id)
ALTER TABLE mdl_forum_discussion_subs ADD CONSTRAINT mdl_forudiscsubs_usedis_uk UNIQUE (userid, discussion)
ALTER TABLE mdl_glossary_entries ADD CONSTRAINT mdl_glosentr_glo_fk FOREIGN KEY (glossaryid) REFERENCES mdl_glossary (id)
ALTER TABLE mdl_glossary_alias ADD CONSTRAINT mdl_glosalia_ent_fk FOREIGN KEY (entryid) REFERENCES mdl_glossary_entries (id)
ALTER TABLE mdl_glossary_categories ADD CONSTRAINT mdl_gloscate_glo_fk FOREIGN KEY (glossaryid) REFERENCES mdl_glossary (id)
ALTER TABLE mdl_glossary_entries_categories ADD CONSTRAINT mdl_glosentrcate_cat_fk FOREIGN KEY (categoryid) REFERENCES mdl_glossary_categories (id)
ALTER TABLE mdl_glossary_entries_categories ADD CONSTRAINT mdl_glosentrcate_ent_fk FOREIGN KEY (entryid) REFERENCES mdl_glossary_entries (id)
ALTER TABLE mdl_lesson_pages ADD CONSTRAINT mdl_lesspage_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_answers ADD CONSTRAINT mdl_lessansw_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_answers ADD CONSTRAINT mdl_lessansw_pag_fk FOREIGN KEY (pageid) REFERENCES mdl_lesson_pages (id)
ALTER TABLE mdl_lesson_attempts ADD CONSTRAINT mdl_lessatte_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_attempts ADD CONSTRAINT mdl_lessatte_pag_fk FOREIGN KEY (pageid) REFERENCES mdl_lesson_pages (id)
ALTER TABLE mdl_lesson_attempts ADD CONSTRAINT mdl_lessatte_ans_fk FOREIGN KEY (answerid) REFERENCES mdl_lesson_answers (id)
ALTER TABLE mdl_lesson_grades ADD CONSTRAINT mdl_lessgrad_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_timer ADD CONSTRAINT mdl_lesstime_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_branch ADD CONSTRAINT mdl_lessbran_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lesson_branch ADD CONSTRAINT mdl_lessbran_pag_fk FOREIGN KEY (pageid) REFERENCES mdl_lesson_pages (id)
ALTER TABLE mdl_lesson_high_scores ADD CONSTRAINT mdl_lesshighscor_les_fk FOREIGN KEY (lessonid) REFERENCES mdl_lesson (id)
ALTER TABLE mdl_lti_tool_settings ADD CONSTRAINT mdl_ltitoolsett_too_fk FOREIGN KEY (toolproxyid) REFERENCES mdl_lti_tool_proxies (id)
ALTER TABLE mdl_lti_tool_settings ADD CONSTRAINT mdl_ltitoolsett_cou_fk FOREIGN KEY (course) REFERENCES mdl_course (id)
ALTER TABLE mdl_lti_tool_settings ADD CONSTRAINT mdl_ltitoolsett_cou2_fk FOREIGN KEY (coursemoduleid) REFERENCES mdl_lti (id)
ALTER TABLE mdl_quiz_slots ADD CONSTRAINT mdl_quizslot_qui_fk FOREIGN KEY (quizid) REFERENCES mdl_quiz (id)
ALTER TABLE mdl_quiz_slots ADD CONSTRAINT mdl_quizslot_que_fk FOREIGN KEY (questionid) REFERENCES mdl_question (id)
ALTER TABLE mdl_quiz_feedback ADD CONSTRAINT mdl_quizfeed_qui_fk FOREIGN KEY (quizid) REFERENCES mdl_quiz (id)
ALTER TABLE mdl_quiz_overrides ADD CONSTRAINT mdl_quizover_qui_fk FOREIGN KEY (quiz) REFERENCES mdl_quiz (id)
ALTER TABLE mdl_quiz_overrides ADD CONSTRAINT mdl_quizover_gro_fk FOREIGN KEY (groupid) REFERENCES mdl_groups (id)
ALTER TABLE mdl_quiz_overrides ADD CONSTRAINT mdl_quizover_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_quiz_attempts ADD CONSTRAINT mdl_quizatte_qui_fk FOREIGN KEY (quiz) REFERENCES mdl_quiz (id)
ALTER TABLE mdl_quiz_attempts ADD CONSTRAINT mdl_quizatte_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_quiz_attempts ADD CONSTRAINT mdl_quizatte_uni_fk FOREIGN KEY (uniqueid) REFERENCES mdl_question_usages (id)
ALTER TABLE mdl_quiz_grades ADD CONSTRAINT mdl_quizgrad_qui_fk FOREIGN KEY (quiz) REFERENCES mdl_quiz (id)
ALTER TABLE mdl_scorm_scoes ADD CONSTRAINT mdl_scorscoe_sco_fk FOREIGN KEY (scorm) REFERENCES mdl_scorm (id)
ALTER TABLE mdl_scorm_scoes_data ADD CONSTRAINT mdl_scorscoedata_sco_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_scoes_track ADD CONSTRAINT mdl_scorscoetrac_sco_fk FOREIGN KEY (scormid) REFERENCES mdl_scorm (id)
ALTER TABLE mdl_scorm_scoes_track ADD CONSTRAINT mdl_scorscoetrac_sco2_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_objective ADD CONSTRAINT mdl_scorseqobje_scoid_uk UNIQUE (scoid, id)
ALTER TABLE mdl_scorm_seq_objective ADD CONSTRAINT mdl_scorseqobje_sco_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_mapinfo ADD CONSTRAINT mdl_scorseqmapi_scoidobj_uk UNIQUE (scoid, id, objectiveid)
ALTER TABLE mdl_scorm_seq_mapinfo ADD CONSTRAINT mdl_scorseqmapi_sco_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_mapinfo ADD CONSTRAINT mdl_scorseqmapi_obj_fk FOREIGN KEY (objectiveid) REFERENCES mdl_scorm_seq_objective (id)
ALTER TABLE mdl_scorm_seq_ruleconds ADD CONSTRAINT mdl_scorseqrule_scoid_uk UNIQUE (scoid, id)
ALTER TABLE mdl_scorm_seq_ruleconds ADD CONSTRAINT mdl_scorseqrule_sco_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_rulecond ADD CONSTRAINT mdl_scorseqrule_idscorul_uk UNIQUE (id, scoid, ruleconditionsid)
ALTER TABLE mdl_scorm_seq_rulecond ADD CONSTRAINT mdl_scorseqrule_sco2_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_rulecond ADD CONSTRAINT mdl_scorseqrule_rul_fk FOREIGN KEY (ruleconditionsid) REFERENCES mdl_scorm_seq_ruleconds (id)
ALTER TABLE mdl_scorm_seq_rolluprule ADD CONSTRAINT mdl_scorseqroll_scoid_uk UNIQUE (scoid, id)
ALTER TABLE mdl_scorm_seq_rolluprule ADD CONSTRAINT mdl_scorseqroll_sco_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_rolluprulecond ADD CONSTRAINT mdl_scorseqroll_scorolid_uk UNIQUE (scoid, rollupruleid, id)
ALTER TABLE mdl_scorm_seq_rolluprulecond ADD CONSTRAINT mdl_scorseqroll_sco2_fk FOREIGN KEY (scoid) REFERENCES mdl_scorm_scoes (id)
ALTER TABLE mdl_scorm_seq_rolluprulecond ADD CONSTRAINT mdl_scorseqroll_rol_fk FOREIGN KEY (rollupruleid) REFERENCES mdl_scorm_seq_rolluprule (id)
ALTER TABLE mdl_scorm_aicc_session ADD CONSTRAINT mdl_scoraiccsess_sco_fk FOREIGN KEY (scormid) REFERENCES mdl_scorm (id)
ALTER TABLE mdl_scorm_aicc_session ADD CONSTRAINT mdl_scoraiccsess_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_survey_answers ADD CONSTRAINT mdl_survansw_sur_fk FOREIGN KEY (survey) REFERENCES mdl_survey (id)
ALTER TABLE mdl_survey_answers ADD CONSTRAINT mdl_survansw_que_fk FOREIGN KEY (question) REFERENCES mdl_survey_questions (id)
ALTER TABLE mdl_survey_analysis ADD CONSTRAINT mdl_survanal_sur_fk FOREIGN KEY (survey) REFERENCES mdl_survey (id)
ALTER TABLE mdl_wiki_subwikis ADD CONSTRAINT mdl_wikisubw_wik_fk FOREIGN KEY (wikiid) REFERENCES mdl_wiki (id)
ALTER TABLE mdl_wiki_subwikis ADD CONSTRAINT mdl_wikisubw_wikgrouse_uk UNIQUE (wikiid, groupid, userid)
ALTER TABLE mdl_wiki_pages ADD CONSTRAINT mdl_wikipage_subtituse_uk UNIQUE (subwikiid, title, userid)
ALTER TABLE mdl_wiki_pages ADD CONSTRAINT mdl_wikipage_sub_fk FOREIGN KEY (subwikiid) REFERENCES mdl_wiki_subwikis (id)
ALTER TABLE mdl_wiki_versions ADD CONSTRAINT mdl_wikivers_pag_fk FOREIGN KEY (pageid) REFERENCES mdl_wiki_pages (id)
ALTER TABLE mdl_wiki_synonyms ADD CONSTRAINT mdl_wikisyno_pagpag_uk UNIQUE (pageid, pagesynonym)
ALTER TABLE mdl_wiki_links ADD CONSTRAINT mdl_wikilink_fro_fk FOREIGN KEY (frompageid) REFERENCES mdl_wiki_pages (id)
ALTER TABLE mdl_wiki_links ADD CONSTRAINT mdl_wikilink_sub_fk FOREIGN KEY (subwikiid) REFERENCES mdl_wiki_subwikis (id)
ALTER TABLE mdl_workshop ADD CONSTRAINT mdl_work_cou_fk FOREIGN KEY (course) REFERENCES mdl_course (id)
ALTER TABLE mdl_workshop_submissions ADD CONSTRAINT mdl_worksubm_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_submissions ADD CONSTRAINT mdl_worksubm_gra_fk FOREIGN KEY (gradeoverby) REFERENCES mdl_user (id)
ALTER TABLE mdl_workshop_submissions ADD CONSTRAINT mdl_worksubm_aut_fk FOREIGN KEY (authorid) REFERENCES mdl_user (id)
ALTER TABLE mdl_workshop_assessments ADD CONSTRAINT mdl_workasse_sub_fk FOREIGN KEY (submissionid) REFERENCES mdl_workshop_submissions (id)
ALTER TABLE mdl_workshop_assessments ADD CONSTRAINT mdl_workasse_gra_fk FOREIGN KEY (gradinggradeoverby) REFERENCES mdl_user (id)
ALTER TABLE mdl_workshop_assessments ADD CONSTRAINT mdl_workasse_rev_fk FOREIGN KEY (reviewerid) REFERENCES mdl_user (id)
ALTER TABLE mdl_workshop_grades ADD CONSTRAINT mdl_workgrad_ass_fk FOREIGN KEY (assessmentid) REFERENCES mdl_workshop_assessments (id)
ALTER TABLE mdl_workshop_grades ADD CONSTRAINT mdl_workgrad_assstrdim_uk UNIQUE (assessmentid, strategy, dimensionid)
ALTER TABLE mdl_workshop_aggregations ADD CONSTRAINT mdl_workaggr_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_aggregations ADD CONSTRAINT mdl_workaggr_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_workshop_aggregations ADD CONSTRAINT mdl_workaggr_woruse_uk UNIQUE (workshopid, userid)
ALTER TABLE mdl_workshop_elements_old ADD CONSTRAINT mdl_workelemold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_rubrics_old ADD CONSTRAINT mdl_workrubrold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_submissions_old ADD CONSTRAINT mdl_worksubmold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_assessments_old ADD CONSTRAINT mdl_workasseold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_assessments_old ADD CONSTRAINT mdl_workasseold_sub_fk FOREIGN KEY (submissionid) REFERENCES mdl_workshop_submissions (id)
ALTER TABLE mdl_workshop_grades_old ADD CONSTRAINT mdl_workgradold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_grades_old ADD CONSTRAINT mdl_workgradold_ass_fk FOREIGN KEY (assessmentid) REFERENCES mdl_workshop_assessments (id)
ALTER TABLE mdl_workshop_stockcomments_old ADD CONSTRAINT mdl_workstocold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_comments_old ADD CONSTRAINT mdl_workcommold_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshop_comments_old ADD CONSTRAINT mdl_workcommold_ass_fk FOREIGN KEY (assessmentid) REFERENCES mdl_workshop_assessments (id)
ALTER TABLE mdl_enrol_flatfile ADD CONSTRAINT mdl_enroflat_cou_fk FOREIGN KEY (courseid) REFERENCES mdl_course (id)
ALTER TABLE mdl_enrol_flatfile ADD CONSTRAINT mdl_enroflat_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_enrol_flatfile ADD CONSTRAINT mdl_enroflat_rol_fk FOREIGN KEY (roleid) REFERENCES mdl_role (id)
ALTER TABLE mdl_message_airnotifier_devices ADD CONSTRAINT mdl_messairndevi_use_fk FOREIGN KEY (userdeviceid) REFERENCES mdl_user_devices (id)
ALTER TABLE mdl_editor_atto_autosave ADD CONSTRAINT mdl_editattoauto_eleconusep_uk UNIQUE (elementid, contextid, userid, pagehash)
ALTER TABLE mdl_gradingform_guide_criteria ADD CONSTRAINT mdl_gradguidcrit_def_fk FOREIGN KEY (definitionid) REFERENCES mdl_grading_definitions (id)
ALTER TABLE mdl_gradingform_guide_fillings ADD CONSTRAINT mdl_gradguidfill_ins_fk FOREIGN KEY (instanceid) REFERENCES mdl_grading_instances (id)
ALTER TABLE mdl_gradingform_guide_fillings ADD CONSTRAINT mdl_gradguidfill_cri_fk FOREIGN KEY (criterionid) REFERENCES mdl_gradingform_guide_criteria (id)
ALTER TABLE mdl_gradingform_guide_fillings ADD CONSTRAINT mdl_gradguidfill_inscri_uk UNIQUE (instanceid, criterionid)
ALTER TABLE mdl_gradingform_guide_comments ADD CONSTRAINT mdl_gradguidcomm_def_fk FOREIGN KEY (definitionid) REFERENCES mdl_grading_definitions (id)
ALTER TABLE mdl_gradingform_rubric_criteria ADD CONSTRAINT mdl_gradrubrcrit_def_fk FOREIGN KEY (definitionid) REFERENCES mdl_grading_definitions (id)
ALTER TABLE mdl_gradingform_rubric_levels ADD CONSTRAINT mdl_gradrubrleve_cri_fk FOREIGN KEY (criterionid) REFERENCES mdl_gradingform_rubric_criteria (id)
ALTER TABLE mdl_gradingform_rubric_fillings ADD CONSTRAINT mdl_gradrubrfill_ins_fk FOREIGN KEY (instanceid) REFERENCES mdl_grading_instances (id)
ALTER TABLE mdl_gradingform_rubric_fillings ADD CONSTRAINT mdl_gradrubrfill_cri_fk FOREIGN KEY (criterionid) REFERENCES mdl_gradingform_rubric_criteria (id)
ALTER TABLE mdl_gradingform_rubric_fillings ADD CONSTRAINT mdl_gradrubrfill_inscri_uk UNIQUE (instanceid, criterionid)
ALTER TABLE mdl_mnetservice_enrol_enrolments ADD CONSTRAINT mdl_mnetenroenro_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_mnetservice_enrol_enrolments ADD CONSTRAINT mdl_mnetenroenro_hos_fk FOREIGN KEY (hostid) REFERENCES mdl_mnet_host (id)
ALTER TABLE mdl_portfolio_mahara_queue ADD CONSTRAINT mdl_portmahaqueu_tra_fk FOREIGN KEY (transferid) REFERENCES mdl_portfolio_tempdata (id)
ALTER TABLE mdl_tool_customlang ADD CONSTRAINT mdl_toolcust_com_fk FOREIGN KEY (componentid) REFERENCES mdl_tool_customlang_components (id)
ALTER TABLE mdl_tool_monitor_subscriptions ADD CONSTRAINT mdl_toolmonisubs_rul_fk FOREIGN KEY (ruleid) REFERENCES mdl_tool_monitor_rules (id)
ALTER TABLE mdl_tool_monitor_history ADD CONSTRAINT mdl_toolmonihist_sid_fk FOREIGN KEY (sid) REFERENCES mdl_tool_monitor_subscriptions (id)
ALTER TABLE mdl_assignsubmission_file ADD CONSTRAINT mdl_assifile_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assignsubmission_file ADD CONSTRAINT mdl_assifile_sub_fk FOREIGN KEY (submission) REFERENCES mdl_assign_submission (id)
ALTER TABLE mdl_assignsubmission_onlinetext ADD CONSTRAINT mdl_assionli_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assignsubmission_onlinetext ADD CONSTRAINT mdl_assionli_sub_fk FOREIGN KEY (submission) REFERENCES mdl_assign_submission (id)
ALTER TABLE mdl_assignfeedback_comments ADD CONSTRAINT mdl_assicomm_ass_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assignfeedback_comments ADD CONSTRAINT mdl_assicomm_gra_fk FOREIGN KEY (grade) REFERENCES mdl_assign_grades (id)
ALTER TABLE mdl_assignfeedback_editpdf_cmnt ADD CONSTRAINT mdl_assieditcmnt_gra_fk FOREIGN KEY (gradeid) REFERENCES mdl_assign_grades (id)
ALTER TABLE mdl_assignfeedback_editpdf_annot ADD CONSTRAINT mdl_assieditanno_gra_fk FOREIGN KEY (gradeid) REFERENCES mdl_assign_grades (id)
ALTER TABLE mdl_assignfeedback_editpdf_quick ADD CONSTRAINT mdl_assieditquic_use_fk FOREIGN KEY (userid) REFERENCES mdl_user (id)
ALTER TABLE mdl_assignfeedback_file ADD CONSTRAINT mdl_assifile_ass2_fk FOREIGN KEY (assignment) REFERENCES mdl_assign (id)
ALTER TABLE mdl_assignfeedback_file ADD CONSTRAINT mdl_assifile_gra_fk FOREIGN KEY (grade) REFERENCES mdl_assign_grades (id)
ALTER TABLE mdl_workshopform_accumulative ADD CONSTRAINT mdl_workaccu_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopform_comments ADD CONSTRAINT mdl_workcomm_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopform_numerrors ADD CONSTRAINT mdl_worknume_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopform_numerrors_map ADD CONSTRAINT mdl_worknumemap_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopform_numerrors_map ADD CONSTRAINT mdl_worknumemap_wornon_uk UNIQUE (workshopid, nonegative)
ALTER TABLE mdl_workshopform_rubric ADD CONSTRAINT mdl_workrubr_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopform_rubric_levels ADD CONSTRAINT mdl_workrubrleve_dim_fk FOREIGN KEY (dimensionid) REFERENCES mdl_workshopform_rubric (id)
ALTER TABLE mdl_workshopform_rubric_config ADD CONSTRAINT mdl_workrubrconf_wor_uk UNIQUE (workshopid)
ALTER TABLE mdl_workshopallocation_scheduled ADD CONSTRAINT mdl_worksche_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)
ALTER TABLE mdl_workshopeval_best_settings ADD CONSTRAINT mdl_workbestsett_wor_fk FOREIGN KEY (workshopid) REFERENCES mdl_workshop (id)