Hi, The table was created fine with only a small problem and it's the foreign key. I have my application listed on settings.py, code my model on models.py, then perform manage.py syncdb my_app as I am aware that if the table exist it wont recreate it. I did a number of times of deleting my tables and do manage.py syncdb my_app.
As I stated the django_admin_log table should also have foreign key which also doesn't have it since it has a relation to auth_user table. I am doing this in winxp , mysql 5 , python 2.5 , latest mysql driver for python. Hope I've provided enough info. Thanks james On Jul 21, 10:38 am, "Russell Keith-Magee" <[EMAIL PROTECTED]> wrote: > On 7/21/07, james_027 <[EMAIL PROTECTED]> wrote: > > > > > When the relationship is within the same namespace (am I using the > > right term, pls correct me) the manage.py syncdb create the tables > > without a problem if all the tables are create on the same time, but > > if the tables weren't created the same time it also fail to create the > > foreign keys. > > I think you need to be a little bit more clear on what you have done - > and I mean precise instructions. _EXACTLY_ what steps have you taken, > and how have you come to the conclusion that the foreign key hasn't > been created? > > Creating tables is an operation that gets done every day by many > people, without difficulty. I have tried the models file you provide, > in various orders of creation, and have had no problems. Without > knowing exactly what you have done, it is impossible to know what has > gone wrong. > > Yours, > Russ Magee %-) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---