[#MDL-13278] 'courseid' field is used in both UNIQUE and INDEX keys - Moodle Tracker

Details

Type: Improvement
Status: Open
Priority: Minor
Resolution: Unresolved
Affects Version/s: 1.9
Fix Version/s: STABLE backlog
Component/s: Gradebook
Labels:
None

Database:

Any
Affected Branches:
MOODLE_19_STABLE

Description

In tables grade_outcomes and grade_outcomes_courses, field courseid is used in both a UNIQUE key and an INDEX key, which is redundant.

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Samuli Karevaara added a comment - 01/Feb/08 5:15 PM

We had several more of these, mostly due to index names changing between updates and the old ones not being removed. There is a tool to check for missing indexes, maybe a similar one for duplicate ones would be nice too (producing the SQL needed to clear the extra ones, now I had to double check not to remove the current index and leave the old one: otherwise the extra index might re-appear in a later update as a "missing" index).

Show

Samuli Karevaara added a comment - 01/Feb/08 5:15 PM We had several more of these, mostly due to index names changing between updates and the old ones not being removed. There is a tool to check for missing indexes, maybe a similar one for duplicate ones would be nice too (producing the SQL needed to clear the extra ones, now I had to double check not to remove the current index and leave the old one: otherwise the extra index might re-appear in a later update as a "missing" index).

Hide

Permalink

Nicolas Connault added a comment - 07/May/09 10:14 PM

Makes sense, will do in 1.9.6

Show

Nicolas Connault added a comment - 07/May/09 10:14 PM Makes sense, will do in 1.9.6

People

Assignee:

moodle.com

Reporter:

Mathieu Petit-Clair

Participants:

Mathieu Petit-Clair, moodle.com, Nicolas Connault, Samuli Karevaara

Vote (0)

Watch (1)

Dates

Created:

01/Feb/08 4:42 PM

Updated:

10/May/11 9:46 PM