Re: intermediate table in manytomany relationship not created

2010-08-06 Thread bksfu
Thanks, Carlos! Brian On Aug 5, 12:59 pm, Carlos Daniel Ruvalcaba Valenzuela wrote: > There is an option to default to InnoDB tables on the configuration: > > http://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables > > Regards, > Carlos Daniel Ruvalcaba

Re: intermediate table in manytomany relationship not created

2010-08-05 Thread Carlos Daniel Ruvalcaba Valenzuela
There is an option to default to InnoDB tables on the configuration: http://docs.djangoproject.com/en/dev/ref/databases/#creating-your-tables Regards, Carlos Daniel Ruvalcaba Valenzuela On Thu, Aug 5, 2010 at 12:48 PM, bksfu wrote: > When Django created the above

Re: intermediate table in manytomany relationship not created

2010-08-05 Thread bksfu
When Django created the above tables, they were created with the MyISAM engine. If the intermediate table has to have foreign keys back to the Phone and Room tables, this would be illegal from MySQL's perspective, which can apparently only form foreign key constraints between InnoDB tables. If

intermediate table in manytomany relationship not created

2010-08-05 Thread bksfu
Hi, I have the following model: -- from django.db import models class Phone(models.Model): id = models.AutoField(primary_key=True, db_column='id') type = models.CharField(max_length=1, db_column='Type', null=False, blank=False) status = models.CharField(max_length=1,