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
1820	Autogenerated ManyToMany fields can generate too long identifiers for mysql to handle	remco@…	nobody	"Having a model as part of an application called: front_booking:
{{{
class AccomodationUnit(Model):
    Facility = ManyToManyField(Facility, verbose_name = 'faciliteiten')
}}}
Generates an ""Identifier name is too long"" exception when doing a syncdb on mysql 5.0.x. Mysql is only able to store identifiers of 64 bytes max.
{{{
_mysql_exceptions.OperationalError: (1059, ""Identifier name 'AccomodationUnit_id_referencing_front_booking_accomodationunit_id' is too long"")
}}}
Possible solution would be to allow a user to somehow influence the naming of these identifiers or use identifier names of 64 bytes max. in size"	defect	new	Database layer (models, ORM)	SVN	normal		mysql	remco@… crucialfelix@… bronger@… nabucosound@… ville@…	Accepted	0	0	0	0	0	0