Add some notes so mysql users can use ForeignKey fields

[chmod]

ForeignKey fields will not work on 4.0.x version of mysql unless the default the table engine is InnoDB. And mysql will
silently let django-admin's create table queries run. You just won't get any nice relational methods in your app.

This causes the Poll, Choice example to make polls and choices fine, however, a Poll doesn't have the methods add_choice(),
get_choice(), etc...

Please add a note to the following page that explains to MySQL users that their default table type must be Innodb for ForeignKeys
to work properly.

Also can I just beg that we somehow have an option to django-admin or the meta.Model class that explicitly sets the engine type?
After all, explicit is better than implicit :)

​http://www.djangoproject.com/documentation/model_api/

[eugene@…]

I ran my app for months with MyISAM (the default engine of MySQL) with plenty of ForeignKeys in models. Are you sure it's not your setup problem?

[James Bennett]

Ditto Eugene's comment; I've used Django with MySQL 4.x versions and MyISAM tables on a couple different servers, and it's worked fine, including the poll app as written up in the tutorial.

[Adrian Holovaty]

Looks like this isn't a problem, judging from the comments.