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... 2011/6/9 Anthony <abasta...@gmail.com> > On Thursday, June 9, 2011 2:14:59 PM UTC-4, Thiago wrote: >> >> I'm new to web2py, but familiar to similar frameworks. I have a system >> that uses web2py builtin auth_user table. The problem is that I wanna use >> ondelete='NO ACTION' in my app (it is CASCADE by default), and I don't >> know how to put it in the model file. Anyone can help? >> > > Are you saying you want to specify ondelete='NO ACTION' for one of the > fields in the builtin auth_user table? It's only relevant for upload and > reference fields, and I don't think the auth_user table includes any such > fields. > > Anthony >