And if I comment out the staff_id line in the model class, my test in the
console works fine (Restaurant.objects.all()).
On Thu, Sep 11, 2008 at 4:20 PM, Chris Stromberger <
[EMAIL PROTECTED]> wrote:
> Oh, thanks. Ok, I just tried taking that out (so model now says "staff_id
> = models.ForeignKey(User)"), but that gave this error:
> OperationalError: (1054, "Unknown column 'restaurant.staff_id_id' in 'field
> list'")
>
> ?
>
>
> On Thu, Sep 11, 2008 at 4:09 PM, Malcolm Tredinnick <
> [EMAIL PROTECTED]> wrote:
>
>>
>>
>> On Thu, 2008-09-11 at 16:01 -0500, Chris Stromberger wrote:
>> > I would like to include a foreign key in a table that links to a user
>> > in Django's auth_user table. Or maybe this is a dumb idea--if so,
>> > interested in hearing why.
>> >
>> >
>> > So the table ("restaurant") with the foreign key includes (mysql):
>> >
>> >
>> > staff_id int(11) NOT NULL,
>> > foreign key(staff_id) references auth_user(id) on delete no action on
>> > update cascade,
>> >
>> >
>> >
>> > If I include this in my model:
>> >
>> >
>> >
>> > from django.contrib.auth.models import User
>> >
>> > staff_id = models.ForeignKey(User, db_column = 'id')
>>
>> This probably isn't what you inteded to write. The db_column attribute
>> specifies what the name of the database column in *this* table will be
>> called. The name of the column in the table it refers to is worked out
>> automatically (since it's almost always the primary key of that table
>> and for other cases, Django has the to_field attribute).
>>
>> Regards,
>> Malcolm
>>
>> >
>>
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
