Re: Inconsistent SQL generated for ForeignKey fields

2007-05-23 Thread Malcolm Tredinnick
On Wed, 2007-05-23 at 16:29 -0700, Fay wrote: > Hi, > > > I encountered a situation that foreign key constraints were generated > differently for the same data model. > > Below is my test model that has 2 identical sets of 1-to-many tables. > When I run django sqlall command, however the foreig

Re: Inconsistent SQL generated for ForeignKey fields

2007-05-23 Thread Fay
Forgot to mention, I use MySQL 5.1. On May 23, 4:29 pm, Fay <[EMAIL PROTECTED]> wrote: > Hi, > > I encountered a situation that foreign key constraints were generated > differently for the same data model. > > Below is my test model that has 2 identical sets of 1-to-many tables. > When I run dj

Inconsistent SQL generated for ForeignKey fields

2007-05-23 Thread Fay
Hi, I encountered a situation that foreign key constraints were generated differently for the same data model. Below is my test model that has 2 identical sets of 1-to-many tables. When I run django sqlall command, however the foreign key constraints were built differently, one used column cons