# ########################################################################
# 2moodle.backup_logs                                                     
# ########################################################################

# backlogs_bac_ix is a left-prefix of backlogs_bacid_uix
# Key definitions:
#   KEY `backlogs_bac_ix` (`backupid`)
#   UNIQUE KEY `backlogs_bacid_uix` (`backupid`,`id`),
# Column types:
#	  `backupid` varchar(32) not null default ''
#	  `id` bigint(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`backup_logs` DROP INDEX `backlogs_bac_ix`;

# Key backlogs_bacid_uix ends with a prefix of the clustered index
# Key definitions:
#   UNIQUE KEY `backlogs_bacid_uix` (`backupid`,`id`),
#   PRIMARY KEY (`id`),
# Column types:
#	  `backupid` varchar(32) not null default ''
#	  `id` bigint(10) not null auto_increment
# To shorten this duplicate clustered index, execute:
ALTER TABLE `2moodle`.`backup_logs` DROP INDEX `backlogs_bacid_uix`, ADD INDEX `backlogs_bacid_uix` (`backupid`);

# ########################################################################
# 2moodle.block_instances                                                 
# ########################################################################

# blocinst_par_ix is a left-prefix of blocinst_parshopagsub_ix
# Key definitions:
#   KEY `blocinst_par_ix` (`parentcontextid`)
#   KEY `blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`),
# Column types:
#	  `parentcontextid` bigint(10) not null
#	  `showinsubcontexts` smallint(4) not null
#	  `pagetypepattern` varchar(64) not null default ''
#	  `subpagepattern` varchar(16) default null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`block_instances` DROP INDEX `blocinst_par_ix`;

# ########################################################################
# 2moodle.block_positions                                                 
# ########################################################################

# blocposi_blo_ix is a left-prefix of blocposi_bloconpagsub_uix
# Key definitions:
#   KEY `blocposi_blo_ix` (`blockinstanceid`),
#   UNIQUE KEY `blocposi_bloconpagsub_uix` (`blockinstanceid`,`contextid`,`pagetype`,`subpage`),
# Column types:
#	  `blockinstanceid` bigint(10) not null
#	  `contextid` bigint(10) not null
#	  `pagetype` varchar(64) not null default ''
#	  `subpage` varchar(16) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`block_positions` DROP INDEX `blocposi_blo_ix`;

# ########################################################################
# 2moodle.cohort_members                                                  
# ########################################################################

# cohomemb_coh_ix is a left-prefix of cohomemb_cohuse_uix
# Key definitions:
#   KEY `cohomemb_coh_ix` (`cohortid`),
#   UNIQUE KEY `cohomemb_cohuse_uix` (`cohortid`,`userid`),
# Column types:
#	  `cohortid` bigint(10) not null default '0'
#	  `userid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`cohort_members` DROP INDEX `cohomemb_coh_ix`;

# ########################################################################
# 2moodle.course_completion_aggr_methd                                    
# ########################################################################

# courcompaggrmeth_cou_ix is a left-prefix of courcompaggrmeth_coucri_uix
# Key definitions:
#   KEY `courcompaggrmeth_cou_ix` (`course`),
#   UNIQUE KEY `courcompaggrmeth_coucri_uix` (`course`,`criteriatype`),
# Column types:
#	  `course` bigint(10) not null default '0'
#	  `criteriatype` bigint(20) default null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`course_completion_aggr_methd` DROP INDEX `courcompaggrmeth_cou_ix`;

# ########################################################################
# 2moodle.course_completion_crit_compl                                    
# ########################################################################

# courcompcritcomp_use_ix is a left-prefix of courcompcritcomp_usecoucri_uix
# Key definitions:
#   KEY `courcompcritcomp_use_ix` (`userid`),
#   UNIQUE KEY `courcompcritcomp_usecoucri_uix` (`userid`,`course`,`criteriaid`),
# Column types:
#	  `userid` bigint(10) not null default '0'
#	  `course` bigint(10) not null default '0'
#	  `criteriaid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`course_completion_crit_compl` DROP INDEX `courcompcritcomp_use_ix`;

# ########################################################################
# 2moodle.course_completions                                              
# ########################################################################

# courcomp_use_ix is a left-prefix of courcomp_usecou_uix
# Key definitions:
#   KEY `courcomp_use_ix` (`userid`),
#   UNIQUE KEY `courcomp_usecou_uix` (`userid`,`course`),
# Column types:
#	  `userid` bigint(10) not null default '0'
#	  `course` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`course_completions` DROP INDEX `courcomp_use_ix`;

# ########################################################################
# 2moodle.files_reference                                                 
# ########################################################################

# filerefe_rep_ix is a left-prefix of filerefe_repref_uix
# Key definitions:
#   KEY `filerefe_rep_ix` (`repositoryid`)
#   UNIQUE KEY `filerefe_repref_uix` (`repositoryid`,`referencehash`),
# Column types:
#	  `repositoryid` bigint(10) not null
#	  `referencehash` varchar(40) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`files_reference` DROP INDEX `filerefe_rep_ix`;

# ########################################################################
# 2moodle.filter_active                                                   
# ########################################################################

# filtacti_con_ix is a left-prefix of filtacti_confil_uix
# Key definitions:
#   KEY `filtacti_con_ix` (`contextid`)
#   UNIQUE KEY `filtacti_confil_uix` (`contextid`,`filter`),
# Column types:
#	  `contextid` bigint(10) not null
#	  `filter` varchar(32) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`filter_active` DROP INDEX `filtacti_con_ix`;

# ########################################################################
# 2moodle.filter_config                                                   
# ########################################################################

# filtconf_con_ix is a left-prefix of filtconf_confilnam_uix
# Key definitions:
#   KEY `filtconf_con_ix` (`contextid`)
#   UNIQUE KEY `filtconf_confilnam_uix` (`contextid`,`filter`,`name`),
# Column types:
#	  `contextid` bigint(10) not null
#	  `filter` varchar(32) not null default ''
#	  `name` varchar(255) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`filter_config` DROP INDEX `filtconf_con_ix`;

# ########################################################################
# 2moodle.grade_grades                                                    
# ########################################################################

# gradgrad_use_ix is a left-prefix of gradgrad_useite_uix
# Key definitions:
#   KEY `gradgrad_use_ix` (`userid`),
#   UNIQUE KEY `gradgrad_useite_uix` (`userid`,`itemid`),
# Column types:
#	  `userid` bigint(10) not null
#	  `itemid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grade_grades` DROP INDEX `gradgrad_use_ix`;

# ########################################################################
# 2moodle.grade_outcomes                                                  
# ########################################################################

# gradoutc_cou_ix is a left-prefix of gradoutc_cousho_uix
# Key definitions:
#   KEY `gradoutc_cou_ix` (`courseid`),
#   UNIQUE KEY `gradoutc_cousho_uix` (`courseid`,`shortname`),
# Column types:
#	  `courseid` bigint(10) default null
#	  `shortname` varchar(255) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grade_outcomes` DROP INDEX `gradoutc_cou_ix`;

# ########################################################################
# 2moodle.grade_outcomes_courses                                          
# ########################################################################

# gradoutccour_cou_ix is a left-prefix of gradoutccour_couout_uix
# Key definitions:
#   KEY `gradoutccour_cou_ix` (`courseid`),
#   UNIQUE KEY `gradoutccour_couout_uix` (`courseid`,`outcomeid`),
# Column types:
#	  `courseid` bigint(10) not null
#	  `outcomeid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grade_outcomes_courses` DROP INDEX `gradoutccour_cou_ix`;

# ########################################################################
# 2moodle.grade_settings                                                  
# ########################################################################

# gradsett_cou_ix is a left-prefix of gradsett_counam_uix
# Key definitions:
#   KEY `gradsett_cou_ix` (`courseid`)
#   UNIQUE KEY `gradsett_counam_uix` (`courseid`,`name`),
# Column types:
#	  `courseid` bigint(10) not null
#	  `name` varchar(255) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grade_settings` DROP INDEX `gradsett_cou_ix`;

# ########################################################################
# 2moodle.grading_areas                                                   
# ########################################################################

# gradarea_con_ix is a left-prefix of gradarea_concomare_uix
# Key definitions:
#   KEY `gradarea_con_ix` (`contextid`)
#   UNIQUE KEY `gradarea_concomare_uix` (`contextid`,`component`,`areaname`),
# Column types:
#	  `contextid` bigint(10) not null
#	  `component` varchar(100) not null default ''
#	  `areaname` varchar(100) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grading_areas` DROP INDEX `gradarea_con_ix`;

# ########################################################################
# 2moodle.grading_definitions                                             
# ########################################################################

# graddefi_are_ix is a left-prefix of graddefi_aremet_uix
# Key definitions:
#   KEY `graddefi_are_ix` (`areaid`),
#   UNIQUE KEY `graddefi_aremet_uix` (`areaid`,`method`),
# Column types:
#	  `areaid` bigint(10) not null
#	  `method` varchar(100) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`grading_definitions` DROP INDEX `graddefi_are_ix`;

# ########################################################################
# 2moodle.gradingform_guide_fillings                                      
# ########################################################################

# gradguidfill_ins_ix is a left-prefix of gradguidfill_inscri_uix
# Key definitions:
#   KEY `gradguidfill_ins_ix` (`instanceid`),
#   UNIQUE KEY `gradguidfill_inscri_uix` (`instanceid`,`criterionid`),
# Column types:
#	  `instanceid` bigint(10) not null
#	  `criterionid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`gradingform_guide_fillings` DROP INDEX `gradguidfill_ins_ix`;

# ########################################################################
# 2moodle.gradingform_rubric_fillings                                     
# ########################################################################

# gradrubrfill_ins_ix is a left-prefix of gradrubrfill_inscri_uix
# Key definitions:
#   KEY `gradrubrfill_ins_ix` (`instanceid`),
#   UNIQUE KEY `gradrubrfill_inscri_uix` (`instanceid`,`criterionid`),
# Column types:
#	  `instanceid` bigint(10) not null
#	  `criterionid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`gradingform_rubric_fillings` DROP INDEX `gradrubrfill_ins_ix`;

# ########################################################################
# 2moodle.question_attempt_step_data                                      
# ########################################################################

# quesattestepdata_att_ix is a left-prefix of quesattestepdata_attnam_uix
# Key definitions:
#   KEY `quesattestepdata_att_ix` (`attemptstepid`)
#   UNIQUE KEY `quesattestepdata_attnam_uix` (`attemptstepid`,`name`),
# Column types:
#	  `attemptstepid` bigint(10) not null
#	  `name` varchar(32) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_attempt_step_data` DROP INDEX `quesattestepdata_att_ix`;

# ########################################################################
# 2moodle.question_attempt_steps                                          
# ########################################################################

# quesattestep_que_ix is a left-prefix of quesattestep_queseq_uix
# Key definitions:
#   KEY `quesattestep_que_ix` (`questionattemptid`),
#   UNIQUE KEY `quesattestep_queseq_uix` (`questionattemptid`,`sequencenumber`),
# Column types:
#	  `questionattemptid` bigint(10) not null
#	  `sequencenumber` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_attempt_steps` DROP INDEX `quesattestep_que_ix`;

# ########################################################################
# 2moodle.question_attempts                                               
# ########################################################################

# quesatte_que2_ix is a left-prefix of quesatte_queslo_uix
# Key definitions:
#   KEY `quesatte_que2_ix` (`questionusageid`)
#   UNIQUE KEY `quesatte_queslo_uix` (`questionusageid`,`slot`),
# Column types:
#	  `questionusageid` bigint(10) not null
#	  `slot` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_attempts` DROP INDEX `quesatte_que2_ix`;

# ########################################################################
# 2moodle.question_datasets                                               
# ########################################################################

# quesdata_que_ix is a left-prefix of quesdata_quedat_ix
# Key definitions:
#   KEY `quesdata_que_ix` (`question`),
#   KEY `quesdata_quedat_ix` (`question`,`datasetdefinition`),
# Column types:
#	  `question` bigint(10) not null default '0'
#	  `datasetdefinition` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_datasets` DROP INDEX `quesdata_que_ix`;

# ########################################################################
# 2moodle.question_numerical_units                                        
# ########################################################################

# quesnumeunit_que_ix is a left-prefix of quesnumeunit_queuni_uix
# Key definitions:
#   KEY `quesnumeunit_que_ix` (`question`)
#   UNIQUE KEY `quesnumeunit_queuni_uix` (`question`,`unit`),
# Column types:
#	  `question` bigint(10) not null default '0'
#	  `unit` varchar(50) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_numerical_units` DROP INDEX `quesnumeunit_que_ix`;

# ########################################################################
# 2moodle.question_sessions                                               
# ########################################################################

# quessess_att_ix is a left-prefix of quessess_attque_uix
# Key definitions:
#   KEY `quessess_att_ix` (`attemptid`),
#   UNIQUE KEY `quessess_attque_uix` (`attemptid`,`questionid`),
# Column types:
#	  `attemptid` bigint(10) not null default '0'
#	  `questionid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`question_sessions` DROP INDEX `quessess_att_ix`;

# ########################################################################
# 2moodle.quiz_attempts                                                   
# ########################################################################

# quizatte_qui_ix is a left-prefix of quizatte_quiuseatt_uix
# Key definitions:
#   KEY `quizatte_qui_ix` (`quiz`),
#   UNIQUE KEY `quizatte_quiuseatt_uix` (`quiz`,`userid`,`attempt`),
# Column types:
#	  `quiz` bigint(10) not null default '0'
#	  `userid` bigint(10) not null default '0'
#	  `attempt` mediumint(6) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`quiz_attempts` DROP INDEX `quizatte_qui_ix`;

# ########################################################################
# 2moodle.role_allow_assign                                               
# ########################################################################

# rolealloassi_rol_ix is a left-prefix of rolealloassi_rolall_uix
# Key definitions:
#   KEY `rolealloassi_rol_ix` (`roleid`),
#   UNIQUE KEY `rolealloassi_rolall_uix` (`roleid`,`allowassign`),
# Column types:
#	  `roleid` bigint(10) not null default '0'
#	  `allowassign` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_allow_assign` DROP INDEX `rolealloassi_rol_ix`;

# ########################################################################
# 2moodle.role_allow_override                                             
# ########################################################################

# rolealloover_rol_ix is a left-prefix of rolealloover_rolall_uix
# Key definitions:
#   KEY `rolealloover_rol_ix` (`roleid`),
#   UNIQUE KEY `rolealloover_rolall_uix` (`roleid`,`allowoverride`),
# Column types:
#	  `roleid` bigint(10) not null default '0'
#	  `allowoverride` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_allow_override` DROP INDEX `rolealloover_rol_ix`;

# ########################################################################
# 2moodle.role_allow_switch                                               
# ########################################################################

# rolealloswit_rol_ix is a left-prefix of rolealloswit_rolall_uix
# Key definitions:
#   KEY `rolealloswit_rol_ix` (`roleid`),
#   UNIQUE KEY `rolealloswit_rolall_uix` (`roleid`,`allowswitch`),
# Column types:
#	  `roleid` bigint(10) not null
#	  `allowswitch` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_allow_switch` DROP INDEX `rolealloswit_rol_ix`;

# ########################################################################
# 2moodle.role_assignments                                                
# ########################################################################

# roleassi_use_ix is a left-prefix of roleassi_useconrol_ix
# Key definitions:
#   KEY `roleassi_use_ix` (`userid`),
#   KEY `roleassi_useconrol_ix` (`userid`,`contextid`,`roleid`),
# Column types:
#	  `userid` bigint(10) not null default '0'
#	  `contextid` bigint(10) not null default '0'
#	  `roleid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_assignments` DROP INDEX `roleassi_use_ix`;

# roleassi_rol_ix is a left-prefix of roleassi_rolcon_ix
# Key definitions:
#   KEY `roleassi_rol_ix` (`roleid`),
#   KEY `roleassi_rolcon_ix` (`roleid`,`contextid`),
# Column types:
#	  `roleid` bigint(10) not null default '0'
#	  `contextid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_assignments` DROP INDEX `roleassi_rol_ix`;

# ########################################################################
# 2moodle.role_capabilities                                               
# ########################################################################

# rolecapa_rol_ix is a left-prefix of rolecapa_rolconcap_uix
# Key definitions:
#   KEY `rolecapa_rol_ix` (`roleid`),
#   UNIQUE KEY `rolecapa_rolconcap_uix` (`roleid`,`contextid`,`capability`),
# Column types:
#	  `roleid` bigint(10) not null default '0'
#	  `contextid` bigint(10) not null default '0'
#	  `capability` varchar(255) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_capabilities` DROP INDEX `rolecapa_rol_ix`;

# ########################################################################
# 2moodle.role_names                                                      
# ########################################################################

# rolename_rol_ix is a left-prefix of rolename_rolcon_uix
# Key definitions:
#   KEY `rolename_rol_ix` (`roleid`),
#   UNIQUE KEY `rolename_rolcon_uix` (`roleid`,`contextid`),
# Column types:
#	  `roleid` bigint(10) not null default '0'
#	  `contextid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_names` DROP INDEX `rolename_rol_ix`;

# ########################################################################
# 2moodle.role_sortorder                                                  
# ########################################################################

# rolesort_use_ix is a left-prefix of rolesort_userolcon_uix
# Key definitions:
#   KEY `rolesort_use_ix` (`userid`),
#   UNIQUE KEY `rolesort_userolcon_uix` (`userid`,`roleid`,`contextid`),
# Column types:
#	  `userid` bigint(10) not null
#	  `roleid` bigint(10) not null
#	  `contextid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`role_sortorder` DROP INDEX `rolesort_use_ix`;

# ########################################################################
# 2moodle.scorm_scoes_track                                               
# ########################################################################

# scorscoetrac_use_ix is a left-prefix of scorscoetrac_usescoscoatte_uix
# Key definitions:
#   KEY `scorscoetrac_use_ix` (`userid`),
#   UNIQUE KEY `scorscoetrac_usescoscoatte_uix` (`userid`,`scormid`,`scoid`,`attempt`,`element`),
# Column types:
#	  `userid` bigint(10) not null default '0'
#	  `scormid` bigint(10) not null default '0'
#	  `scoid` bigint(10) not null default '0'
#	  `attempt` bigint(10) not null default '1'
#	  `element` varchar(255) not null default ''
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_scoes_track` DROP INDEX `scorscoetrac_use_ix`;

# ########################################################################
# 2moodle.scorm_seq_mapinfo                                               
# ########################################################################

# scorseqmapi_sco_ix is a left-prefix of scorseqmapi_scoidobj_uix
# Key definitions:
#   KEY `scorseqmapi_sco_ix` (`scoid`),
#   UNIQUE KEY `scorseqmapi_scoidobj_uix` (`scoid`,`id`,`objectiveid`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
#	  `objectiveid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_seq_mapinfo` DROP INDEX `scorseqmapi_sco_ix`;

# ########################################################################
# 2moodle.scorm_seq_objective                                             
# ########################################################################

# scorseqobje_sco_ix is a left-prefix of scorseqobje_scoid_uix
# Key definitions:
#   KEY `scorseqobje_sco_ix` (`scoid`)
#   UNIQUE KEY `scorseqobje_scoid_uix` (`scoid`,`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_seq_objective` DROP INDEX `scorseqobje_sco_ix`;

# Key scorseqobje_scoid_uix ends with a prefix of the clustered index
# Key definitions:
#   UNIQUE KEY `scorseqobje_scoid_uix` (`scoid`,`id`),
#   PRIMARY KEY (`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To shorten this duplicate clustered index, execute:
ALTER TABLE `2moodle`.`scorm_seq_objective` DROP INDEX `scorseqobje_scoid_uix`, ADD INDEX `scorseqobje_scoid_uix` (`scoid`);

# ########################################################################
# 2moodle.scorm_seq_rolluprule                                            
# ########################################################################

# scorseqroll_sco_ix is a left-prefix of scorseqroll_scoid_uix
# Key definitions:
#   KEY `scorseqroll_sco_ix` (`scoid`)
#   UNIQUE KEY `scorseqroll_scoid_uix` (`scoid`,`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_seq_rolluprule` DROP INDEX `scorseqroll_sco_ix`;

# Key scorseqroll_scoid_uix ends with a prefix of the clustered index
# Key definitions:
#   UNIQUE KEY `scorseqroll_scoid_uix` (`scoid`,`id`),
#   PRIMARY KEY (`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To shorten this duplicate clustered index, execute:
ALTER TABLE `2moodle`.`scorm_seq_rolluprule` DROP INDEX `scorseqroll_scoid_uix`, ADD INDEX `scorseqroll_scoid_uix` (`scoid`);

# ########################################################################
# 2moodle.scorm_seq_rolluprulecond                                        
# ########################################################################

# scorseqroll_sco2_ix is a left-prefix of scorseqroll_scorolid_uix
# Key definitions:
#   KEY `scorseqroll_sco2_ix` (`scoid`),
#   UNIQUE KEY `scorseqroll_scorolid_uix` (`scoid`,`rollupruleid`,`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `rollupruleid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_seq_rolluprulecond` DROP INDEX `scorseqroll_sco2_ix`;

# Key scorseqroll_scorolid_uix ends with a prefix of the clustered index
# Key definitions:
#   UNIQUE KEY `scorseqroll_scorolid_uix` (`scoid`,`rollupruleid`,`id`),
#   PRIMARY KEY (`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `rollupruleid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To shorten this duplicate clustered index, execute:
ALTER TABLE `2moodle`.`scorm_seq_rolluprulecond` DROP INDEX `scorseqroll_scorolid_uix`, ADD INDEX `scorseqroll_scorolid_uix` (`scoid`,`rollupruleid`);

# ########################################################################
# 2moodle.scorm_seq_ruleconds                                             
# ########################################################################

# scorseqrule_sco_ix is a left-prefix of scorseqrule_scoid_uix
# Key definitions:
#   KEY `scorseqrule_sco_ix` (`scoid`)
#   UNIQUE KEY `scorseqrule_scoid_uix` (`scoid`,`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`scorm_seq_ruleconds` DROP INDEX `scorseqrule_sco_ix`;

# Key scorseqrule_scoid_uix ends with a prefix of the clustered index
# Key definitions:
#   UNIQUE KEY `scorseqrule_scoid_uix` (`scoid`,`id`),
#   PRIMARY KEY (`id`),
# Column types:
#	  `scoid` bigint(10) not null default '0'
#	  `id` bigint(10) not null auto_increment
# To shorten this duplicate clustered index, execute:
ALTER TABLE `2moodle`.`scorm_seq_ruleconds` DROP INDEX `scorseqrule_scoid_uix`, ADD INDEX `scorseqrule_scoid_uix` (`scoid`);

# ########################################################################
# 2moodle.user_enrolments                                                 
# ########################################################################

# userenro_enr_ix is a left-prefix of userenro_enruse_uix
# Key definitions:
#   KEY `userenro_enr_ix` (`enrolid`),
#   UNIQUE KEY `userenro_enruse_uix` (`enrolid`,`userid`),
# Column types:
#	  `enrolid` bigint(10) not null
#	  `userid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`user_enrolments` DROP INDEX `userenro_enr_ix`;

# ########################################################################
# 2moodle.user_lastaccess                                                 
# ########################################################################

# userlast_use_ix is a left-prefix of userlast_usecou_uix
# Key definitions:
#   KEY `userlast_use_ix` (`userid`),
#   UNIQUE KEY `userlast_usecou_uix` (`userid`,`courseid`),
# Column types:
#	  `userid` bigint(10) not null default '0'
#	  `courseid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`user_lastaccess` DROP INDEX `userlast_use_ix`;

# ########################################################################
# 2moodle.wiki_pages                                                      
# ########################################################################

# wikipage_sub_ix is a left-prefix of wikipage_subtituse_uix
# Key definitions:
#   KEY `wikipage_sub_ix` (`subwikiid`)
#   UNIQUE KEY `wikipage_subtituse_uix` (`subwikiid`,`title`,`userid`),
# Column types:
#	  `subwikiid` bigint(10) not null default '0'
#	  `title` varchar(255) not null default 'title'
#	  `userid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`wiki_pages` DROP INDEX `wikipage_sub_ix`;

# ########################################################################
# 2moodle.wiki_subwikis                                                   
# ########################################################################

# wikisubw_wik_ix is a left-prefix of wikisubw_wikgrouse_uix
# Key definitions:
#   KEY `wikisubw_wik_ix` (`wikiid`)
#   UNIQUE KEY `wikisubw_wikgrouse_uix` (`wikiid`,`groupid`,`userid`),
# Column types:
#	  `wikiid` bigint(10) not null default '0'
#	  `groupid` bigint(10) not null default '0'
#	  `userid` bigint(10) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`wiki_subwikis` DROP INDEX `wikisubw_wik_ix`;

# ########################################################################
# 2moodle.workshop_aggregations                                           
# ########################################################################

# workaggr_wor_ix is a left-prefix of workaggr_woruse_uix
# Key definitions:
#   KEY `workaggr_wor_ix` (`workshopid`),
#   UNIQUE KEY `workaggr_woruse_uix` (`workshopid`,`userid`),
# Column types:
#	  `workshopid` bigint(10) not null
#	  `userid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`workshop_aggregations` DROP INDEX `workaggr_wor_ix`;

# ########################################################################
# 2moodle.workshop_grades                                                 
# ########################################################################

# workgrad_ass_ix is a left-prefix of workgrad_assstrdim_uix
# Key definitions:
#   KEY `workgrad_ass_ix` (`assessmentid`)
#   UNIQUE KEY `workgrad_assstrdim_uix` (`assessmentid`,`strategy`,`dimensionid`),
# Column types:
#	  `assessmentid` bigint(10) not null
#	  `strategy` varchar(30) not null default ''
#	  `dimensionid` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`workshop_grades` DROP INDEX `workgrad_ass_ix`;

# ########################################################################
# 2moodle.workshopform_numerrors_map                                      
# ########################################################################

# worknumemap_wor_ix is a left-prefix of worknumemap_wornon_uix
# Key definitions:
#   KEY `worknumemap_wor_ix` (`workshopid`)
#   UNIQUE KEY `worknumemap_wornon_uix` (`workshopid`,`nonegative`),
# Column types:
#	  `workshopid` bigint(10) not null
#	  `nonegative` bigint(10) not null
# To remove this duplicate index, execute:
ALTER TABLE `2moodle`.`workshopform_numerrors_map` DROP INDEX `worknumemap_wor_ix`;

# ########################################################################
# Summary of indexes                                                      
# ########################################################################

# Size Duplicate Indexes   581
# Total Duplicate Indexes  51
# Total Indexes            981