If I try to do a course batch csv import the uploader thinks the shortname for courses should be unique and will proceed to change them as it sees fit. However, according to the schema of the database the unique value is on (category+shortname+idnumber+sortorder) which makes a bunch more sense to me - it's a different course in a different category, so the shortname should be unique for that category, not across everything.
It's entirely feasible that shortnames would be the same for similar courses in different categories: Form 1 -> English and Form 2 -> English : and since the shortname is a field that is visible in the interface, it makes more sense to the end user to use a friendly name rather repeating bits or adding numbers. E.g.
Dashboard > Courses > Form 1 > English > Week 2 > Introduction
makes more sense than either
Dashboard > Courses > Form 1 > F1_English > Week 2 > Introduction
Dashboard > Courses > Form 1 > English_3 > Week 2 > Introduction
I've read discussions in the tracker and years-old forum posts relating to uniqueness and none have led me to solid documentation on whether the shortname field must be unique for any particular reason, or if the schema or interface is the correct way. I can go into my database and edit the shortname and it doesn't seem to be a problem to have multiple courses with the same shortname as long as they are in different categories. Is it?