id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
7950	Syncdb generated indices should have a consistent name	flytwokites	nobody	"This model:
{{{
class User(models.Model):
    live_space = models.IntegerField()
    name = models.CharField(max_length=30, unique=True)
    email = models.EmailField(max_length=50, unique=True)

    class Meta:
        unique_together = ('live_space', 'name')
}}}
In mysql, the generated indices have a mysql internal name like 'name_2', 'email_3'.
If i want to maintains indices later, i must known the index name, so i must dump db structure to determine it.
So it's better to generate a consistent name like 'ruby on rails' does.
For example the above model will generate these index names:
{{{
user__name
user__email
user__livespace_name
}}}
"		closed	Database layer (models, ORM)	dev		wontfix			Design decision needed	0	0	0	0	0	0