It worked out, thanks! Thread closed. 2011/6/9 Anthony <[email protected]>
> On Thursday, June 9, 2011 6:59:34 PM UTC-4, Thiago wrote: >> >> I have this auth_user table, and another table called activities. This >> activities have 2 fields that are foreing keys to user (created by and >> modified by). If I delete any user that created or modified one activity, >> the activity is deleted. >> >> Do I have to put NO ACTION in all fields that is foreign key to user? I >> don't see how NO ACTION in the ondelete of activity solves my problem... >> >> Sorry I'm very confused. I just got one system made by some other people >> (with no documentation =( ) and I am trying to understand to maintain it... >> > > I think you would specify ondelete='NO ACTION' in the reference fields in > the 'activities' table. > >
